Zen Cart Logo
Forums / Installing on a Mac Server / 1064 You have an error in your SQL syntax - errors when trying to run install

1064 You have an error in your SQL syntax - errors when trying to run install

Locked

Views: 4,339

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
03 Jun 2010, 20:48
#1
pauldid avatar

pauldid

New Zenner

Join Date:
Dec 2009
Posts:
10
Plugin Contributions:
0

1064 You have an error in your SQL syntax - errors when trying to run install

I am getting the following error message when running the installer for ZC v1.3.9c. Can someone tell me what this means and how do I fix it to finish the install?

Installation In Progress...

1064 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 'ENGINE=MyISAM' at line 1
in:
[CREATE TABLE zc139c_upgrade_exceptions ( upgrade_exception_id smallint(5) NOT NULL auto_increment, sql_file varchar(50) default NULL, reason varchar(200) default NULL, errordate datetime default '0001-01-01 00:00:00', sqlstatement text, PRIMARY KEY (upgrade_exception_id) ) ENGINE=MyISAM;]

03 Jun 2010, 20:53
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: 1064 You have an error in your SQL syntax - errors when trying to run install

Where are the server details?

04 Jun 2010, 06:01
#3
pauldid avatar

pauldid

New Zenner

Join Date:
Dec 2009
Posts:
10
Plugin Contributions:
0

Re: 1064 You have an error in your SQL syntax - errors when trying to run install

kobra:

Where are the server details?

What do you want to know?

It is a server running several copies of ZC v1.3.8a with no problems.

Server OS: Darwin 8.11.0
Database: MySQL 4.0.12
HTTP Server: 4D_WebSTAR_S/5.4.0 (MacOS X)
PHP Version: 4.3.11 (Zend: 1.3.0)
PHP Safe Mode: Off

I believe the above is well within the requirements for ZC as listed on https://www.zen-cart.com/tutorials/index.php?article=6