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
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: errors when trying to run install

    Where are the server details?
    Zen-Venom Get Bitten

  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 https://www.zen-cart.com/tutorials/index.php?article=6

 

 

Similar Threads

  1. v139h 1064 You have an error in your SQL syntax;
    By alwaysanirudh in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 11 Oct 2012, 04:13 PM
  2. 1064 You have an error in your SQL syntax;
    By larryr99 in forum General Questions
    Replies: 1
    Last Post: 14 Apr 2011, 07:11 AM
  3. Replies: 7
    Last Post: 23 Jul 2009, 06:53 AM
  4. Replies: 2
    Last Post: 3 Jul 2007, 06:39 PM
  5. 1064 You have an error in your SQL syntax
    By yd29999 in forum Installing on a Windows Server
    Replies: 8
    Last Post: 2 Mar 2007, 05:47 AM

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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR