FrontAccounting forum — SQL script execution failure

Re: SQL script execution failure

2011-09-10T05:41:16Z

Thanks Joe! Works brilliantly.

Re: SQL script execution failure

2011-03-23T14:19:11Z

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

2011-03-23T12:59:51Z

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

Re: SQL script execution failure

2011-03-23T07:13:34Z

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

2011-03-23T01:47:49Z

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?