Hi Kevin,
Masses of thanks for the new version of the template, I've just started setting up a new site after waiting for the new 1.3.7 release of ZC and your template.
I have noticed a problem with the new template when doing a fresh install though. During the installation process the following error is raised:
Processing Plugin: sql/plugins/mysql_uk_template_base_1.3.6a.sql
1406 Data too long for column 'zone_code' at row 1
in:
[INSERT INTO zones (zone_country_id,zone_code,zone_name) VALUES (222, 'Ross & Cromarty (inc part of Lewis)', 'Ross & Cromarty (inc part of Lewis)');]
Checking the database schema, the zones table is defined as:
| zone_id | int(11) | NO | PRI | NULL | auto_increment |
| zone_country_id | int(11) | NO | MUL | 0 | |
| zone_code | varchar(32) | NO | MUL | | |
| zone_name | varchar(32) | NO | | | |
So the zone_code and zone_name values for Ross... are too long for the fields.
I fixed the problem with a manual alteration to the table definition, the change I made was to the file mysql_zencart.sql and it was just to change zones.zone_code and zones.zone_name to be varchar(40) rather than varchar(32). Does this sound like a sensible change or are there other tables which will need fields altering to match?
Thanks again for all the work.
Oh a very minor other thing, the version number in the readme file is still 1.3.6 :-)