Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2009
    Posts
    4
    Plugin Contributions
    0

    Default 1064 You have an error in your SQL syntax ... TYPE=MyISAM

    Here is the full error:
    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 'TYPE=MyISAM' at line 1
    in:
    [CREATE TABLE ccbmx_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) ) TYPE=MyISAM;]

    This happens just after I try to install and click Save Database Settings in the DB Setup step. I have given the all permissions to everything and cannot figure out why it is giving me this error. Any help would be appreciated.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,350
    Blog Entries
    7
    Plugin Contributions
    271

    Default Re: 1064 You have an error in your SQL syntax ... TYPE=MyISAM

    What version of Zen Cart are you trying to install?
    What version of MySQL is on your server?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Jan 2009
    Posts
    4
    Plugin Contributions
    0

    Default Re: 1064 You have an error in your SQL syntax ... TYPE=MyISAM

    1.3.8 - It was the one at the top of the list. I downloaded it about a week or so ago.

    MySQL 5.1

    Thanks.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,350
    Blog Entries
    7
    Plugin Contributions
    271

    Default Re: 1064 You have an error in your SQL syntax ... TYPE=MyISAM

    Your version of MySQL probably requires that you edit the /zc_install/sql/mysql_zencart.sql file and replace every occurrence of
    Code:
    TYPE=MyISAM
    with
    Code:
    ENGINE=MyISAM
    .

    The next version of Zen Cart will already incorporate this MYSQL5-specific change.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    Jan 2009
    Posts
    4
    Plugin Contributions
    0

    Default Re: 1064 You have an error in your SQL syntax ... TYPE=MyISAM

    As luck would have it I finally figured it out last night... You are right though... Changing it from Type to Engine worked and everything is up and running.

    Thanks...

 

 

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 snagroot in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 14 Nov 2010, 01:43 AM
  3. 1064 You have an error in your SQL syntax
    By dealbyethan.com in forum General Questions
    Replies: 3
    Last Post: 14 Apr 2007, 04:34 PM
  4. 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
  5. 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR