PHP Fatal error: 1062 Duplicate entry Error, cannot fix table

[RoboPhung]

Here's my store info:

Zen-Cart 1.5.1
Upgraded from 1.3.9h
Official upgrade procedure

Running:
Super Orders
Edit Orders
Ty Package
Ceon URI
Stock by Attributes
Product Attribute Grid

All the latest versions.

So I'm getting several of those 1062 PHP errors a day, as shown by my zc logs, as well as customers emailing me about my website occasionally crashing. I've search for information about this error in the forums, and most threads indicate that the db_cache table might be corrupted and it can easily be fixed by just truncating the table.

Well the problem is that I've been trying to truncate the table, but within seconds, the same two sql cache entries are recreated in the table (with the same exact cache-entry-name). And these are precisely the offending two cache entries causing my 1062 duplicate errors on my website.

I've even tried dropping the db_cache table entirely and recreating the table with an SQL command, but still, within seconds, those exact same two entries with the same "cache-entry-name" are recreated again! So there appears to be two sql queries that are continually running on my database and causing me PHP fatal errors randomly throughout the day. Can anyone shed any light as to what are triggering these two queries? And a possible fix? Thank!

[DrByte]

Can you post the exact actual error message? Details are always very important.

Also, what version of PHP are you using? What operating system does your server use?

[RoboPhung]

Can you post the exact actual error message? Details are always very important.

Also, what version of PHP are you using? What operating system does your server use?

Of course, sorry for not including all the details:

PHP 5.3.13
Webhost is Apache
Server OS is Linux 2.6.32.45-grsec-2.2.2-r3
Server API set to FastCGI

PHP Fatal error: 1062: Duplicate entry 'zc_6ec65decb95a7741ada473af0fde76e1' for key 'PRIMARY' :: insert into zen_db_cache set cache_entry_name = 'zc_6ec65decb95a7741ada473af0fde76e1', cache_data = xxxxxxxxxxxx
cache_entry_created = '1361513542' in xxxxxxxxx/includes/classes/db/mysql/query_factory.php on line 120


I removed the cache_data and replaced with xxxxx's because it was just a really long data blob.

Please let me know if I forgot to include any other information, thanks.

[DrByte]

When did this problem start happening for you?

[RoboPhung]

When did this problem start happening for you?

Unfortunately I can't say for sure. It was dumb of me but I cleared my admin logs and cached logs several times in the past few weeks while I was upgrading my site, backing it up, and making all the necessary changes to it.

I would say that this problem has been occurring since the upgrade to 1.5.1 from 1.3.9h though, from my best estimate, since I remember going through my website during the initial upgrade and encountering a message saying that my website had crashed and to attempt to reload it.

I'm fairly certain that this was from the 1062 duplicate error, but it's all just conjecture.

[roekoe]

Hello,

I'm wondering if this problem have been solved for someone, since i have the same problem.