1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.2 Mysqli statement execute error

Discussion in 'Troubleshooting and Problems' started by CasNerd, Oct 2, 2013.

  1. CasNerd

    CasNerd New Member

    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 !
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

  3. CasNerd

    CasNerd New Member

    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 ?
     
  4. Mike

    Mike 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...)
     
  5. CasNerd

    CasNerd New Member

    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.
     
    Adam Howard likes this.
  6. CasNerd

    CasNerd New Member

    Turns out my host cares...

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

    Thanks all for help !
     
    Mike likes this.

Share This Page