1064 Error - Installation problem

[Terry111]

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.

[DrByte]

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:

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.

[Terry111]

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