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

Sudden Database Error! Please Help!

Discussion in 'Troubleshooting and Problems' started by Drae, Apr 13, 2013.

  1. Drae

    Drae Active Member

    This morning my installation of Xenforo at sizaelrpg.com was working fine. However, at 4.20PM today, it's now displaying that it has a database error. I've not done any changes to the site in any way today - just visited it this morning and then later again today to find out it was down.

    (Note that I have yet to update it with the latest patch.)

    I have access to the admin cp and I've gone into the server error logs and this is coming up since the site became inaccessible:

    Error Info:
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Got a packet bigger than 'max_allowed_packet' bytes - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account, Today at 4:20 PM

    Stack Trace:
    #0 /home/sizaelrp/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/sizaelrp/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/sizaelrp/public_html/library/XenForo/Model/DataRegistry.php(164): Zend_Db_Adapter_Abstract->query('?????INSERT INT...', Array)
    #3 /home/sizaelrp/public_html/library/XenForo/Model/Style.php(434): XenForo_Model_DataRegistry->set('styles', Array)
    #4 /home/sizaelrp/public_html/library/XenForo/Dependencies/Public.php(63): XenForo_Model_Style->rebuildStyleCache()
    #5 /home/sizaelrp/public_html/library/XenForo/Dependencies/Abstract.php(178): XenForo_Dependencies_Public->_handleCustomPreloadedData(Array)
    #6 /home/sizaelrp/public_html/library/XenForo/FrontController.php(125): XenForo_Dependencies_Abstract->preLoadData()
    #7 /home/sizaelrp/public_html/index.php(13): XenForo_FrontController->run()
    #8 {main}

    Request State:
    array(3) {
    ["url"] => string(21) "http://sizaelrpg.com/"
    ["_GET"] => array(0) {
    }
    ["_POST"] => array(0) {
    }
    }

    I'm going to see if my hosting providers can restore the whole thing for me back to yesterday, but any ideas what's causing it?
     
  2. Slavik

    Slavik XenForo Moderator Staff Member

    Looks like they've altered the mysql server settings.
     
    Drae likes this.
  3. Drae

    Drae Active Member

    I have access to the cpanel but I know that I haven't touched the mysql stuff for a while. Any idea what they might have done their end? I'm speaking to them now, just waiting to find out what might have happened.
     
  4. Slavik

    Slavik XenForo Moderator Staff Member

    At first glance, theyve reduced the max allowed packet setting.
     
    Drae likes this.
  5. Drae

    Drae Active Member

    Thanks.

    What is the packet setting (if you know)? Is it just how large the MySQL database is allowed to be?
     
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    It limits the size of an individual query. The max_allowed_packet needs to be at least as big as the largest record in your database... probably 2M at least. You can set it much higher without problems though.
     
  7. Drae

    Drae Active Member

    Thanks Jake.

    Unfortunately the server I am on is not owned by me as I rent space on it (shared) - I can't change it's settings :(
     
  8. shadrxninga

    shadrxninga Well-Known Member

    You'll have to put in a support ticket and ask if they can increase that setting for you (remember to include a reason as to why you need the setting changed!). They may do it for free, or they might ask you to change your plan to a higher one. You also have the option of finding a new host (I'd ask first though).
     
    14DH01 and Drae like this.
  9. Drae

    Drae Active Member

    I told them the issue last night about seventeen hours ago (even linked them to this thread) and must have been lumbered with trainees or something. I'm trying to get them to undo what they did (as it made it worse) and have asked about upgrading. I'm looking around for alternative hosts just in case - know anybody who allows MySQL over 30GB without making me pay a huge amount?
     

Share This Page