Originally Posted by
DrByte
All the data for the "countries" and "zones" tables is in the /zc_install/sql/install/mysql_utf8.sql file.
If you've added records to the geo_zones or zones_to_geo_zones tables that refer to countries or zones that are outside the normal list, or have manually added back any countries to the database that has resulted in those records getting a different countries_id or zone_id then you'll need to manually fix all the conflicts and point the IDs back to the proper original values.
Code:
Ok, when I try to re-insert the SQL I got this:
Error
SQL query:
## SQL Sections Specific to UTF8 character set
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Convert currencies for Text emails', 'CURRENCIES_TRANSLATIONS', '£,£:€,€:®,®:™,™', 'What currency conversions do you need for Text emails?<br />Example = &pound;,£:&euro;,€', 12, 120, NULL, '2003-11-21 00:00:00', NULL, 'zen_cfg_textarea_small(');
MySQL said: Documentation
#1062 - Duplicate entry 'CURRENCIES_TRANSLATIONS' for key 'unq_config_key_zen'
Bookmarks