<![CDATA[FrontAccounting forum — error in SQL syntax during installation]]> 2011-02-28T17:39:13Z PunBB https://frontaccounting.com/punbb/viewtopic.php?id=1915 <![CDATA[Re: error in SQL syntax during installation]]> Thank you, problem solved.

]]> https://frontaccounting.com/punbb/profile.php?id=4439 2011-02-28T17:39:13Z https://frontaccounting.com/punbb/viewtopic.php?pid=8403#p8403 <![CDATA[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

]]> https://frontaccounting.com/punbb/profile.php?id=3 2011-02-28T07:57:17Z https://frontaccounting.com/punbb/viewtopic.php?pid=8398#p8398 <![CDATA[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

]]> https://frontaccounting.com/punbb/profile.php?id=4439 2011-02-27T21:16:48Z https://frontaccounting.com/punbb/viewtopic.php?pid=8396#p8396