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

Database Error? Site won't load

Discussion in 'XenForo Questions and Support' started by toodlez, Sep 3, 2011.

  1. toodlez

    toodlez Active Member

    Okay, so recently... On occasion.. I will either get a one line database error that lasts for about 5 to 10 minutes, and sometimes the forums just will take forever to load...

    I have an unlimited space / bandwidth server that I am running on ..

    I have three other websites (one is a vBulletin) running on the same server but they DO NOT share the same database...

    Any ideas why occasionally the xenForo will trick out and give an error (while my other three websites all load up instantly during this period), or there will be times when it is very slow?

    Thank you!
     
  2. ragtek

    ragtek Guest

    what error did you get?
     
  3. toodlez

    toodlez Active Member

    An unexpected database error occurred. Please try again later.

    That's what I believe I have gotten... Has only happened recently within the past couple of days
     
  4. ragtek

    ragtek Guest

    Check your error log

    ACP => Tools => Server Error Log
     
  5. toodlez

    toodlez Active Member

    Weird that it is showing the most recent one as August 18th.. I know it's happened since then as it did just two days ago and yesterday
    Mysqli statement execute error : Query execution was interrupted
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    That can indicate problems with SQL or your server.

    Check how long SQL has been running and does it coincide with the time of the error?
     
  7. toodlez

    toodlez Active Member

    How do I check that in Cpanel?
     
  8. toodlez

    toodlez Active Member

    Also, sometimes I will get the lightbox popup "The server didn't respond in time."

    Is that just a normal thing to deal with for the earlier versions of xF?
     
  9. Brogan

    Brogan XenForo Moderator Staff Member

    If you have phpMyAdmin, click on the Status tab at the main screen.
     
  10. toodlez

    toodlez Active Member

    This MySQL server has been running for 2 days, 18 hours, 6 minutes and 32 seconds. It started up on Aug 31, 2011 at 07:13 PM.

    That's at the top
     
  11. toodlez

    toodlez Active Member

    Keep in mind I have three different databases running forums, two vB and then my xenForo
     
  12. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    It is important to know what the underlying error is. If these most recent errors are not contained in the log then try enabling debug mode by adding this line to your library/config.php file:

    Code:
    $config['debug'] = 1;
    
    That should reveal a more detailed error message when the error is actually happening. But you don't want to leave debug mode enabled on a live forum.

    Ultimately this is a server problem. The server might be having uptime problems as Brogan indicated. Or maybe the query is hitting a timeout or other server limit. Contact your web host or server person.
     

Share This Page