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.

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.

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

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.

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.

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!

And indeed – now available for update…

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]

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.

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

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!

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.

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.

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