Support Forum
on top of Andys questions, want to make sure you had cleared the error log and saw it return...
Visit Cruise Talk Central and Mr Papa's World
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.
YELLOW
SWORDFISH
|
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?
Visit Cruise Talk Central and Mr Papa's World
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.
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...
Visit Cruise Talk Central and Mr Papa's World
1 Guest(s)