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;]
Re: errors when trying to run install
Where are the server details?
Re: errors when trying to run install
Quote:
Originally Posted by
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