Error in SQL during install.

[inetbiz]

The tracker link to the SQL bug in the install can be found here

[David M. Graham]

Thanks Ivar.  Added this to the tracker.

[Ivar]

Hello

We are considering migrating from CRE, and I decided to try EOS cart. (eos_51alpha)

During install i got 2 errors when installing database.
I corrected 2 things in the sql files:
eostestdata.sql:
INSERT INTO zones_to_geo_zones VALUES (1, US, NY, 1, now(), now());
To
INSERT INTO zones_to_geo_zones VALUES (1, 'US', 'NY', 1, now(), now());

eos.sql:
DROP TABLE IF EXISTS zones_to_geo_zones;
CREATE TABLE IF NOT EXISTS zones_to_geo_zones (
  association_id int(11) NOT NULL auto_increment,
  zone_country_id varchar(3) NOT NULL default '0',
  zone_id varchar(16) default NULL,
  geo_zone_id int(11) default NULL,
  last_modified datetime NOT NULL default '0000-00-00 00:00:00',
  date_added datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY (association_id)
) TYPE=MyISAM ;

To

DROP TABLE IF EXISTS zones_to_geo_zones;
CREATE TABLE IF NOT EXISTS zones_to_geo_zones (
  association_id int(11) NOT NULL auto_increment,
  zone_country_id varchar(3) NOT NULL default '0',
  zone_id varchar(16) default NULL,
  geo_zone_id int(11) default NULL,
  last_modified datetime NOT NULL default '0000-00-00 00:00:00',
  date_added datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY (association_id)
) ENGINE=MyISAM ;


Best regards
Ivar
Norway