FrontAccounting forum — Cannot create the database

Re: Cannot create the database

null@example.com (dfc) — Fri, 25 Nov 2011 14:44:55 +0000

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

Re: Cannot create the database

null@example.com (joe) — Wed, 23 Nov 2011 14:28:59 +0000

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

Re: Cannot create the database

null@example.com (dfc) — Wed, 23 Nov 2011 11:17:25 +0000

Thanks for replying.

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

Re: Cannot create the database

null@example.com (joe) — Wed, 23 Nov 2011 08:48:17 +0000

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

/Joe

Cannot create the database

null@example.com (dfc) — Wed, 23 Nov 2011 08:25:14 +0000

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.