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

Comments

• 18 Comments sorted by Votes Date Added
• ildrugo

  January 2011 Vote Up0Vote Down

  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.
• tavares

  January 2011 Vote Up0Vote Down

  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.
• ildrugo

  January 2011 Vote Up0Vote Down

  "tavares&quot wrote:

  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
• ildrugo

  January 2011 Vote Up0Vote Down

  "tavares&quot wrote:

  ...only one file was created: vtiger_asterisk incomingevents with 10 fields.

  
  same for me.
• ildrugo

  January 2011 Vote Up0Vote Down

  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
• tavares

  January 2011 Vote Up0Vote Down

  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
• erniel

  January 2011 Vote Up0Vote Down

  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.
• prasad.a

  January 2011 Vote Up0Vote Down

  please post the issue on <!-- m --><a class="postlink" href="http://trac.vtiger.com">http://trac.vtiger.com</a><!-- m -->
• ildrugo

  January 2011 Vote Up0Vote Down

  "erniel&quot wrote:

  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...
• erniel

  January 2011 Vote Up0Vote Down

  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