UK Counties sql

I have tried to load this to my cart, however it is not working for all counties during installation it say;

ERROR: Cannot execute because table zen_zones does not exist. CHECK PREFIXES!

Any ideas?

What is the DB_PREFIX in your configure.php files?

Be sure to replace the "zen_" in "zen_zones" with whatever Your DB_PREFIX is defined to.

DrByte:

What is the DB_PREFIX in your configure.php files?

Be sure to replace the "zen_" in "zen_zones" with whatever Your DB_PREFIX is defined to.

Is this DB-prefix of the database?

Looking at config.php there is

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_CHARSET', 'utf8');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'brideand_zencecs');
define('DB_SERVER_PASSWORD', '*********');
define('DB_DATABASE', 'brideand_zencecs');

So what should ; INSERT INTO zen_zones VALUES (182, 222, 'Bedfordshire', 'Bedfordshire'); say?

Since the ZC tablename is "zones" and the DB_PREFIX is set to "zen_", then the sql query would read INSERT INTO zen_zones ...

So, back to your very first post, it would seem that you had the wrong database selected in order to get an error about that table not existing.

I have taken advice from my service provider a copy of their reply is

I have checked the table, zen_zones of the database brideand_zencecs. From your update, I understood that you are trying to insert an additional row into the table zen_zones.

The error you got since the zone_id 182 already exists in the table:

--
mysql> select * from zen_zones where zone_id=182;
+---------+-----------------+-----------+------------------------------+
| zone_id | zone_country_id | zone_code | zone_name |
+---------+-----------------+-----------+------------------------------+
| 182 | 13 | ACT | Australian Capital Territory |
+---------+-----------------+-----------+------------------------------+

To insert one row into the table you have to use the following query:

INSERT INTO zen_zones VALUES ('zone_id', 'zone_country_id', 'zone_code', 'zone_name');

The last entry's zone id in the table is 519. If you wanted to add new entry, then the zone id value should be 520. Then the query should be:

INSERT INTO zen_zones VALUES (520, 222, 'Bedfordshire', 'Bedfordshire');

I have made no changes my database to zen_zones so do you know why there is a conflict with Australian Capital? Could it be a conflict with another plugin that I have used?

adb34:

I have taken advice from my service provider a copy of their reply is

I have checked the table, zen_zones of the database brideand_zencecs. From your update, I understood that you are trying to insert an additional row into the table zen_zones.

The error you got since the zone_id 182 already exists in the table:

--
mysql> select * from zen_zones where zone_id=182;
+---------+-----------------+-----------+------------------------------+
| zone_id | zone_country_id | zone_code | zone_name |
+---------+-----------------+-----------+------------------------------+
| 182 | 13 | ACT | Australian Capital Territory |
+---------+-----------------+-----------+------------------------------+

To insert one row into the table you have to use the following query:

INSERT INTO zen_zones VALUES ('zone_id', 'zone_country_id', 'zone_code', 'zone_name');

The last entry's zone id in the table is 519. If you wanted to add new entry, then the zone id value should be 520. Then the query should be:

INSERT INTO zen_zones VALUES (520, 222, 'Bedfordshire', 'Bedfordshire');

I have made no changes my database to zen_zones so do you know why there is a conflict with Australian Capital? Could it be a conflict with another plugin that I have used?

Using this still came back with an error as

Error Failed: 1
Error ERROR: Cannot execute because table zen_zones does not exist. CHECK PREFIXES!
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

I am still having problems with this. Since the last post I have changed ISPs and done a completely fresh install. I have several shops that I am trying to put this in to and no of them will accept it. Still giving me the error that I have written above. Is there any other questions on this plugin?

I have found answer to this, with the help from another forum question. Remove the word 'zen_' from 'zen_zones' to leave 'zones' and it works with no problems. I need to check the counties list as some are out-of-date and then I will upload that data base list.

I have somehow loaded counties twice and have ended up with two of every county. Is there an easy way to edit the database or not?

Yes. Look at the .sql you loaded. And for every line in that .sql file, note the table it's inserting into. Find that table, and remove the specified record. Be sure to delete the newest record ONLY. Because if you delete the older (smaller id number) record then you'll break customer/order records that link to that older record, causing you messes all over the place.
This is the sort of thing a skilled db administrator should do.

ALWAYS MAKE COMPLETE TESTED BACKUPS BEFORE DOING ANY DIRECT DATABASE MANIPULATION!!!!!!!!!

... You DO make backups, right?

DrByte:

ALWAYS MAKE COMPLETE TESTED BACKUPS BEFORE DOING ANY DIRECT DATABASE MANIPULATION!!!!!!!!!

... You DO make backups, right?

OHHHHHHH yyyyyyeeeeeessssss

When installing this on 1.5.3 I get
"WARNING: An Error occurred, please refresh the page and try again."
And when I go back to the main admin, my zone's no longer work at all.

How can I uninstall the sql :\

kezerb:

When installing this on 1.5.3 I get
"WARNING: An Error occurred, please refresh the page and try again."
And when I go back to the main admin, my zone's no longer work at all.

How can I uninstall the sql :
The way to "uninstall" something like that is to use the backup you made of your database before running the script in the first place.