• pave
  • New member
  • Offline
  • Registered: 02/27/2011
  • Posts: 2

Topic: error in SQL syntax during installation

Hi,
please, help me.
I installed xampp-win32-1.7.4-VC6 on my W7 32b, setup OpenSSL and tried to install FA 2.3.2 in EN, nothing extra. But allways I got message

SQL script execution failed in line 21: 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=MyISAM AUTO_INCREMENT=2' at line 7

on Step 5. So, I deleted FA and install 2.3.1 version. But result is still the same. I tried various users of MySQL db, including root, it is on localhost. I wasted one day with attempts and Forum readings, now I have no idea, what to do else. May by I can try to use some other configuration (like IIS, not Apache) but if somebody can help me with some smart thing, I will be really happy.
In errors.loq is:  0::current_user.inc:486: Invalid argument supplied for foreach()

Thank you in advance
Pavel

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: error in SQL syntax during installation

If you have searched the installation forum regarding sql error, you would have found your solution.
The solution is to replace TYPE= with ENGiNE= in the sql script file used for creating the company. This can be done with a text editor.
The newest versions of MySql is not backward compatible.

/Joe

  • pave
  • New member
  • Offline
  • Registered: 02/27/2011
  • Posts: 2

Re: error in SQL syntax during installation

Thank you, problem solved.