XF 1.2 Mysqli statement execute error

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.

mysqli error.jpg
How do i track down what this is ? Everything has been running fine till now !
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 ?


XenForo developer
Staff member
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...)
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.