Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2009
    Posts
    10
    Plugin Contributions
    0

    Default 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;]

  2. #2
    Join Date
    Aug 2005
    Posts
    26,507
    Plugin Contributions
    9

    Default Re: errors when trying to run install

    Where are the server details?
    Zen-Venom Get Bitten
    Get Your Business Found

  3. #3
    Join Date
    Dec 2009
    Posts
    10
    Plugin Contributions
    0

    Default Re: errors when trying to run install

    Quote Originally Posted by kobra View Post
    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 http://tutorials.zen-cart.com/index.php?article=6

 

 

Similar Threads

  1. 1064 You have an error in your SQL syntax;
    By limelites in forum General Questions
    Replies: 6
    Last Post: 10 Jun 2009, 07:35 PM
  2. 1064 You have an error in your SQL syntax;
    By aerosmith in forum General Questions
    Replies: 3
    Last Post: 3 Sep 2008, 06:55 AM
  3. 1064 You have an error in your SQL syntax
    By techie in forum Basic Configuration
    Replies: 1
    Last Post: 13 May 2006, 03:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •