1. Lines 2043-48 of zen-cart-v150-full-release-20111230\zc_install\sql\mysql_zencart.sql
Code:
INSERT INTO address_format VALUES (1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country');
INSERT INTO address_format VALUES (2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country','$city, $state / $country');
INSERT INTO address_format VALUES (3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$state / $country');
INSERT INTO address_format VALUES (4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country');
INSERT INTO address_format VALUES (5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country','$city / $country');
INSERT INTO address_format VALUES (6, '$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country','$postcode / $country');
Are the above incidences of the word " comma " OK, or should they be replaced by " ',' " in sql code, or unquoted "," in the address_format table.
2. Line 2044 of zen-cart-v150-full-release-20111230\zc_install\sql\mysql_zencart.sql
Code:
INSERT INTO address_format VALUES (2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country','$city, $state / $country');
Australia only needs a space or two, but not AFAIK a comma, after $city.
3. Also Line 31 of zen-cart-v150-full-release-20111230\zc_install\sql\mysql_utf8.sql and
Line 28 of zen-cart-v150-full-release-20111230\zc_install\sql\mysql_latin1.sql
Code:
INSERT INTO countries VALUES (13,'Australia','AU','AUS','1');
Should be
Code:
INSERT INTO countries VALUES (13,'Australia','AU','AUS','2');
Thanks
Bookmarks