Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Posts
    13
    Plugin Contributions
    0

    Default 1064 Error - Installation problem

    Hi there,

    I have checked through all the threads and cannot find anything specific to this error (the NULL part) but I'm trying to install at http://siliconmaps.com/shop/zc_install and it's coming up with this 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 '_ ecimal(7,4) NOT NULL default '0.0000', tax_description varchar(255) NOT N' at line 1
    in:
    [CREATE TABLE tax_rates ( tax_rates_id int(11) NOT NULL auto_increment, tax_zone_id int(11) NOT NULL default '0', tax_class_id int(11) NOT NULL default '0', tax_priority int(5) default '1', ta _ ecimal(7,4) NOT NULL default '0.0000', tax_description varchar(255) NOT NULL default '', last_modified datetime default NULL, date_added datetime NOT NULL default '0001-01-01 00:00:00', PRIMARY KEY (tax_rates_id), KEY idx_tax_zone_id_zen (tax_zone_id), KEY idx_tax_class_id_zen (tax_class_id) ) TYPE=MyISAM;]

    -----------------------------------------------

    This is the latest version of zencart... any help would be so greatly apprciated.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: 1064 Error - Installation problem

    default '1', ta _ ecimal(7,4) NOT
    It appears that your /zc_install/mysql_zencart.sql file is corrupt.

    That portion should say "tax_rate decimal" not "tax _ ecimal".

    The whole portion is:

    Code:
    CREATE TABLE tax_rates (
      tax_rates_id int(11) NOT NULL auto_increment,
      tax_zone_id int(11) NOT NULL default '0',
      tax_class_id int(11) NOT NULL default '0',
      tax_priority int(5) default '1',
      tax_rate decimal(7,4) NOT NULL default '0.0000',
      tax_description varchar(255) NOT NULL default '',
      last_modified datetime default NULL,
      date_added datetime NOT NULL default '0001-01-01 00:00:00',
      PRIMARY KEY  (tax_rates_id),
      KEY idx_tax_zone_id_zen (tax_zone_id),
      KEY idx_tax_class_id_zen (tax_class_id)
    ) TYPE=MyISAM;
    I suggest you re-upload your /zc_install/mysql_zencart.sql file.
    .

    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
    Jul 2006
    Posts
    13
    Plugin Contributions
    0

    Default Re: 1064 Error - Installation problem

    Thank you so much for your quick response. Your answer got me thinking about what might have corrupted the mysql_zencart.sql and figured it might be some of the software I have installed on my computer. So after disabling McAfee, Cybersitter, and Adsubtract Pro it installed perfectly. Thank you so much you were a lifesaver I was fighting this for 2 days.

    Terry

 

 

Similar Threads

  1. Installation error 1064 when creating database
    By tonyprodger in forum Installing on a Windows Server
    Replies: 2
    Last Post: 6 May 2007, 08:07 PM
  2. Installation: 1064 You have an error in your SQL syntax
    By juglesh in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 5 Feb 2007, 12:18 AM
  3. 1064 Error on installation V1.3.7
    By dbunch in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 1 Jan 2007, 07:45 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