XF 1.2 Mysqli statement execute error

[CasNerd]

Just got this: Mysqli statement execute error, I have seen these in the logs before but never been able to work out what it was. This time I couldn't access the forum as the error stopped anything else loading.


How do i track down what this is ? Everything has been running fine till now !

 

[Paul B]

See this thread: http://xenforo.com/community/threads/error-on-install.17901/#post-232741

Try restarting MySQL to see if that resolves it.

 

[CasNerd]

Unfortunately that's not possible on shared hosting.

I can contact my host but the response time can be slow, and they'll probably just blame the script. Is there anything I can do on my end to prevent this happening again ?

 

[Mike]

Unfortunately no. It appears to be a MySQL bug as it seems to happen in very specific circumstances and is sometimes triggered by high load. Updating MySQL has generally fixed it.

If your XenForo seems fairly slow, it could be the load issue so if you can get switched to a different server in their batch, that may help. (Obviously if your host is slow to respond to tickets, you wouldn't be wrong in looking for a new host...)

 

[CasNerd]

A new host is on the cards for that exact reason. Unfortunately their low prices are matched by their service.

I'll see how they respond first though, might be an easy fix.

 

[CasNerd]

Turns out my host cares...

Updated from MySQL 5.1 to 5.5, hopefully everything runs smoothly now.

Thanks all for help !