1 Reply by bouncingltd

(3 replies, posted in Version 1.3.*)

Zencart 1.3.5 (and 1.3.02)

CREATE TABLE zones (
  zone_id int(11) NOT NULL auto_increment,
  zone_country_id int(11) NOT NULL default '0',
  zone_code varchar(32) NOT NULL default '',
  zone_name varchar(32) NOT NULL default '',
  PRIMARY KEY  (zone_id),
  KEY idx_zone_country_id_zen (zone_country_id),
  KEY idx_zone_code_zen (zone_code)
) TYPE=MyISAM;


with only 32 characters for the zone name.

and line 241

Inverness-shire (Lewis, Uist, Skye) has 36 characters  in one place, in another for some reason the SQL has a quote before it.

and line 356

INSERT INTO zones (zone_country_id,zone_code,zone_name) VALUES (222, 'Inverness-shire (Lewis, Uist, Skye)', 'Inverness-shire (Lewis, Uist, Skye)');

Go to forum: Version 1.3.*

2 Topic by bouncingltd

(0 replies, posted in Version 1.3.*)

Line 255 from the Beta

INSERT INTO zones (zone_country_id,zone_code,zone_name) VALUES (222, 'Londnderry', 'Londnderry');


whereas in the Northern Ireland section Line 327

INSERT INTO zones (zone_country_id,zone_code,zone_name) VALUES(@t1,'Londonderry','Londonderry');

missing an "o" from 255 in both instances of Londonderry.

Go to forum: Version 1.3.*