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?
Printable View
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.
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?
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?