• dfc
  • New member
  • Offline
  • Registered: 11/22/2011
  • Posts: 3

Topic: Cannot create the database

I am trying to install FA but stuck at the second screen -company settings  (Step 5) with the following error 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"

I have installed XAMPP v1.7.7. which comes with the following apps:
    Apache 2.2.21
    MySQL 5.5.16
    PHP 5.3.8
    phpMyAdmin 3.4.5
    FileZilla FTP Server 0.9.39

Anyone with similar experience?

Thanks in advance.

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

Re: Cannot create the database

Newer versions of MySQL seems to not accept 'TYPE=' any more. Please replace 'TYPE=' to 'ENGINE=' in your sql script used for install.

/Joe

  • dfc
  • New member
  • Offline
  • Registered: 11/22/2011
  • Posts: 3

Re: Cannot create the database

Thanks for replying.

Where can i find the scrip file?
What is the name of the file?

TQ

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

Re: Cannot create the database

In the folder /sql there is 2 scripts. en_US-new.sql (for a new company) and en_US-demo.sql (for a demo/drill company).

Use an editor to search and replace the above.

Use phpMyAdmin to import one of these scripts to your created database.

Then you should be able to login (admin - password) and run FA.

/Joe

  • dfc
  • New member
  • Offline
  • Registered: 11/22/2011
  • Posts: 3

Re: Cannot create the database

Ok, I will try it and report back ...