Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Well, I had been facing the same problem of 1062 Duplicate entry for few days. I struggled a lot finding the fix to this but to my dismay neither could I find the correct fix in this forum nor elsewhere. To all you Zenners who are facing this problem, here's the solution:
Most of these errors are caused when we accidentally try to delete or update an invalid entry. Or say if there's nothing in the database yet and we are trying to delete something off it, so be careful from next time. An invalidated update and upgrade could be the trouble-maker too!
You should go to your Zen Database and check for your tables, you can do so either from going to your Database Control Panel (if your current Host supports this) or through phpMyAdmin. You have to check what is causing this error 1062 for example, if you get something like this:
1062 Duplicate entry '1-1' for key 1
in:
[insert into zen_products_options_values (products_options_values_id, language_id,.............
then you should check zen_products_options_values table and the associated fields. If your Zen Cart is fairly new or is in the production phase then you can check one of these associated fields and truncate its values. Once you are done - this error should be gone.
In my case, I was just testing a new cart and didn't mind truncating values. PLEASE BACKUP YOUR DATABASE BEFORE YOU DO ANY MODIFICATIONS WITH YOUR TABLES/FIELDS AND ITS VALUES.
Good Luck!
Well, I had been facing the same problem of 1062 Duplicate entry for few days. I struggled a lot finding the fix to this but to my dismay neither could I find the correct fix in this forum nor elsewhere. To all you Zenners who are facing this problem, here's the solution:
Most of these errors are caused when we accidentally try to delete or update an invalid entry. Or say if there's nothing in the database yet and we are trying to delete something off it, so be careful from next time. An invalidated update and upgrade could be the trouble-maker too!
You should go to your Zen Database and check for your tables, you can do so either from going to your Database Control Panel (if your current Host supports this) or through phpMyAdmin. You have to check what is causing this error 1062 for example, if you get something like this:
1062 Duplicate entry '1-1' for key 1
in:
[insert into zen_products_options_values (products_options_values_id, language_id,.............
then you should check zen_products_options_values table and the associated fields. If your Zen Cart is fairly new or is in the production phase then you can check one of these associated fields and truncate its values. Once you are done - this error should be gone.
In my case, I was just testing a new cart and didn't mind truncating values. PLEASE BACKUP YOUR DATABASE BEFORE YOU DO ANY MODIFICATIONS WITH YOUR TABLES/FIELDS AND ITS VALUES.
Good Luck!