FrontAccounting forum — SQL script execution failure

Re: SQL script execution failure

null@example.com (darstin21) — Sat, 10 Sep 2011 05:41:16 +0000

Thanks Joe! Works brilliantly.

Re: SQL script execution failure

null@example.com (joe) — Wed, 23 Mar 2011 14:19:11 +0000

Depending on if you selected demo data, the file is /sql/en_US-demo.sql, otherwise, en_US-new.sql.

/Joe

Re: SQL script execution failure

null@example.com (nofear) — Wed, 23 Mar 2011 12:59:51 +0000

I'm not very experienced with MySQL. Could you tell me where I'd find the script? Thanks!

Re: SQL script execution failure

null@example.com (joe) — Wed, 23 Mar 2011 07:13:34 +0000

I guess you are using a new MySQL database version. Open the SQL script in a text editor and replace 'TYPE=' with 'ENGINE='

MySql is no longer backwards compatible in newer versions.

/Joe

SQL script execution failure

null@example.com (nofear) — Wed, 23 Mar 2011 01:47:49 +0000

I've made it to step 5 in the installation, Company Settings, but I keep getting an error message that says:

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

Any ideas what I should do from here?