• From: Uganda
  • Registered: 04/23/2019
  • Posts: 2

Topic: Error while installing front accounting to my server

Hello

I'm getting an error while installing front accounting to my server, it passed all the requirements and also the database details but now the error comes from step 5 when i am creating the admin password. below is the error

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

some help please am stuck.
Thanks in advance

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Error while installing front accounting to my server

It appears that you are using an outdated version of some chart of accounts. FA 2.4.6+ uses only InnoDB as the Engine Type and your MySQL seetings too should then be checked.

State your Server Platform and PHP/MySQL/FA versions and which chart you are using. For a start, check your chart of accounts and replace all instances of MyISAM with InnoDB and then try again after dropping / emptying your existing FA DB.

apmuthu's Website

  • From: Uganda
  • Registered: 04/23/2019
  • Posts: 2

Re: Error while installing front accounting to my server

I   had to download the latest version of FA and it worked fine. the problem was using an outdated version.