• Registered: 03/23/2011
  • Posts: 7

Topic: SQL script execution failure

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?

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

Re: SQL script execution failure

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

  • Registered: 03/23/2011
  • Posts: 7

Re: SQL script execution failure

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

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

Re: SQL script execution failure

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

/Joe

  • Registered: 09/10/2011
  • Posts: 1

Re: SQL script execution failure

Thanks Joe! Works brilliantly.