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
Meztli
Sweden
Member
sp_UserOfflineSmall Offline
Jul 31, 2014 - 10:11 am

Hello guys,

I got an error today that i never encountered before:

 

2014/07/31 12:01 f m | spaErrError | 1 | database


file: /problem-with-post-edit-buttonome/friskytt/public_html/wp-content/plugins/simple-press/forum/content/classes/sp-group-view-class.php

line: 249

function: sp_add_cache

error: Duplicate entry '5*group' for key 'PRIMARY'

INSERT INTO wp_sfcache(cache_id, cache_out, cache) VALUES ('5*group',

 

I did cut the error message since it included several pages with code after the last line above. But if you want to see it, i will ofcourse post if for you. Is this something serious?

Cheers

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 31, 2014 - 10:22 am

It's a little issue we have seen once or twice bit been unable to track down. Actually - the code is very simple and there is no way it should be able to happen which is probably why it is rare and probably some sort of deep rooted glitch. Maybe a timing issue between a couple of database writes. We are still looking for the cause.

It is really harmless. But for peace of mind then you could go to the forum admin > toolbox > housekeeping and click on the 'Flush General Cache' task.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Meztli
Sweden
Member
sp_UserOfflineSmall Offline
Jul 31, 2014 - 10:30 am

Thanks Andy.

I noticed that no forum topics where shown in group view until you logged in. Not for all forums, just one particular. But after the cache flush it´s all working again.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jul 31, 2014 - 10:32 am

Ah yes. Hopefully we will get to the bottom of it soon.

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

Yellow Swordfish said
Ah yes. Hopefully we will get to the bottom of it soon.

Hi Guys,

Any progress in this matter?

This issue is happing more and more frequent at my forum.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Sep 4, 2014 - 6:14 am

I have to say that there was no logical reason for the error and it remains a mystery but yes - it has been changed to avoid such an error in the next release (5.5.1) which, if the WordPress team get 4,0 out today as planned, will follow immediately after that.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Meztli
Sweden
Member
sp_UserOfflineSmall Offline
Sep 4, 2014 - 2:58 pm

Yellow Swordfish said
I have to say that there was no logical reason for the error and it remains a mystery but yes - it has been changed to avoid such an error in the next release (5.5.1) which, if the WordPress team get 4,0 out today as planned, will follow immediately after that.

Great news! smile

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

And indeed - now available for update...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Meztli
Sweden
Member
sp_UserOfflineSmall Offline
Sep 11, 2014 - 2:58 am

Yellow Swordfish said

And indeed - now available for update...

Thanks for a great update Andy, but the error remain:

file: /problem-with-post-edit-buttonome/friskytt/public_html/wp-content/plugins/simple-press/forum/content/classes/sp-group-view-class.php

line: 248

function: sp_add_cache

error: Duplicate entry '260*group' for key 'PRIMARY'

[Error record dump removed by admin]

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Sep 11, 2014 - 4:26 am

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.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625