Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Error: Duplicate entry '5*group' for key 'PRIMARY'
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 11, 2014 - 8:52 pm

on top of Andys questions, want to make sure you had cleared the error log and saw it return...

Avatar
Meztli
Sweden
Member
sp_UserOfflineSmall Offline
Sep 15, 2014 - 3:38 pm

Yellow Swordfish said
Removed the large error record as there is nothing to learn from that...

The first, obvious question is... are we definitely talking about version 5.5.1 here? You have upgraded to 5.5.1 - yes?

If that is a yes then can you tell me what version of MySQL you have on your website? And perhaps ask your hosting support if the mySQL implementation does support the 'REPLACE' keyword.

The answers are:

Yes

Yes

And Yes on Steves question in the above post (I am getting this error once a day at the moment and i am clearing the error log every single time).

I will ask my server host about the MySQL version and if it support "replace".

Getting back to you soon!

Cheers!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Sep 15, 2014 - 4:28 pm

The mySQL version should be displayed in the forum admin > toolbox > Environment panel but asking your host is still important to do.
I never encountered this particular error condition but Steve pointed out to me that this site did experience it now and then,. Since the coe change it has not reoccurred.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Meztli
Sweden
Member
sp_UserOfflineSmall Offline
Sep 16, 2014 - 5:48 am

Hi guys,

My server host have:

MySQL version: 5.5.37-cll

And "replace" is working.

Did read my own notes and once a day was not true. It´s more like the error occur once or twice per week.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Sep 16, 2014 - 2:35 pm

We will be discussing this. it makes absolutely no sense whatsoever...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Meztli
Sweden
Member
sp_UserOfflineSmall Offline
Sep 18, 2014 - 7:22 am

Yellow Swordfish said
We will be discussing this. it makes absolutely no sense whatsoever...

Ok, just tell me if you need anything from me.

Cheers

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Sep 18, 2014 - 7:37 am

There is just a lot of head scratching going on at the moment!

andy-signature.png
YELLOW
SWORDFISH
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Sep 18, 2014 - 8:35 pm

kind of hard when its not repeatable and happen soooo infrequently...  especially when it logically cannot happen... but clearly is...

did I understand you to say you can make it happen?  or just that it randomly is?

Avatar
Meztli
Sweden
Member
sp_UserOfflineSmall Offline
Oct 3, 2014 - 9:45 am

Mr Papa said

did I understand you to say you can make it happen?  or just that it randomly is?

It happens randomly Steve, a couple of times every week.

However my observation is that it happen at days with very much activity at the forum. But i cant be sure ofcourse, it´s just a feeling.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 3, 2014 - 2:55 pm

okay, thanks... we are still trying to understand it...  the instruction to mysql says replace so not clear how you can get a duplicate key...  we see it every three or four weeks on our server, but since we cannot make it happen, hard to debug...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 616
Members: 17345
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10117
Posts: 79600