Zen Cart Logo
Forums / General Questions / 1062 Duplicate entry 'zc_xxxxxxxxxx' for key 1 in: [db_cache table]

1062 Duplicate entry 'zc_xxxxxxxxxx' for key 1 in: [db_cache table]

Locked

Views: 3,007

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
4 Nov 2008, 10:00 PM
#1
yelow avatar

yelow

Zen Follower

Join Date:
Sep 2008
Posts:
115
Plugin Contributions:
0

1062 Duplicate entry 'zc_xxxxxxxxxx' for key 1 in: [db_cache table]

1062 Duplicate entry 'zc_6ec65decb95a7741ada473af0fde76e1' for key 1
in:
[db_cache table]

So, I don't know what it is that causes this, but is there a way to get rid of it?

The pages load slow, and once a user gets frustrated and clicks again, s/he gets this error.

What's a sysadmin to do?

-Tim

9 Nov 2008, 2:37 AM
#2
preman avatar

preman

New Zenner

Join Date:
Nov 2008
Posts:
22
Plugin Contributions:
0

Re: 1062 Duplicate entry 'zc_xxxxxxxxxx' for key 1 in: [db_cache table]

I faced the same problem,wait a great answer..

12 Nov 2008, 6:57 PM
#3
yelow avatar

yelow

Zen Follower

Join Date:
Sep 2008
Posts:
115
Plugin Contributions:
0

Re: 1062 Duplicate entry 'zc_xxxxxxxxxx' for key 1 in: [db_cache table]

What kind of system are you running zencart on?

Is it possible for me to see the cart?

-Tim

19 Dec 2008, 6:46 PM
#4
yelow avatar

yelow

Zen Follower

Join Date:
Sep 2008
Posts:
115
Plugin Contributions:
0

Re: 1062 Duplicate entry 'zc_xxxxxxxxxx' for key 1 in: [db_cache table]

Preman, have you ever received an answer / solution for this?

-Tim

19 Dec 2008, 7:32 PM
#5
tony_sar avatar

tony_sar

Totally Zenned

Join Date:
Jul 2006
Location:
Montreal, Canada
Posts:
2,276
Plugin Contributions:
0

Re: 1062 Duplicate entry 'zc_xxxxxxxxxx' for key 1 in: [db_cache table]

I don't know about this error for db_catche table . this is usually caused by not auto incrementing but db_catche has no auto increment filed to begin with ..

you may want to turn off the pars time , query time and number of queries from your site , that might help to speed up your site a bit .

I checked the site on your http://store.persite.com
was not able to reproduce the error you mentioned.

29 Dec 2008, 10:57 PM
#6
yelow avatar

yelow

Zen Follower

Join Date:
Sep 2008
Posts:
115
Plugin Contributions:
0

Re: 1062 Duplicate entry 'zc_xxxxxxxxxx' for key 1 in: [db_cache table]

thanks for checking. I get it very rarely anymore (I feel like some of my shared hosting neighbours moved out!) but it comes up at the worst times like when I'm trying to show something to my boss and inevitabley it comes up right then and there. /wrists

I have a feeling that all my issues can safely be addressed as "I'm on Fasthosts" the more I read every day. :(

29 Dec 2008, 11:49 PM
#7
tony_sar avatar

tony_sar

Totally Zenned

Join Date:
Jul 2006
Location:
Montreal, Canada
Posts:
2,276
Plugin Contributions:
0

Re: 1062 Duplicate entry 'zc_xxxxxxxxxx' for key 1 in: [db_cache table]

I got the same error today . my problem was , mysql server was offline .. once i told me host about the problem , they fixed it , but i was keep clicking on refresh button.
once mysql fully started , i got this error .. but then everything back to normal .

it chances are that ,your mysql server is haveally loaded and there is delay in response and clicking on links multiple time might generate duplicates.. other then that , it shouldn't be a problem.