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

XF 1.3 Broken forum

Discussion in 'Troubleshooting and Problems' started by Frigeri, Aug 15, 2014.

  1. Frigeri

    Frigeri Member

    I'm receiving constant "MySQL server has gone away" errors, specially when updating addons. According to my webhost FutureHosting, the script is hitting the VPS ram limit (512mb). All addons are disabled, my forum is almost empty (50 posts) and is also closed to the public, thus leading me to believe something is broken.
    Code:
    An exception occurred: Mysqli prepare error: MySQL server has gone away in /home/forumdof/public_html/library/Zend/Db/Statement/Mysqli.php on line 77
    
        Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
        Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
        Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
        Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
        XenForo_Model->fetchAllKeyed() in XenForo/Model/AdminNavigation.php at line 31
        XenForo_Model_AdminNavigation->getAdminNavigationEntries() in XenForo/Model/AdminNavigation.php at line 405
        XenForo_Model_AdminNavigation->getAdminNavigationForDisplay() in XenForo/Dependencies/Admin.php at line 224
        XenForo_Dependencies_Admin->_getNavigationContainerParams() in XenForo/Dependencies/Admin.php at line 202
        XenForo_Dependencies_Admin->getEffectiveContainerParams() in XenForo/FrontController.php at line 616
        XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
        XenForo_FrontController->run() in /home/forumdof/public_html/admin.php at line 13
    
    Should I go for a clean install or something? I'm on Xenforo 1.3.4.

    1. Bb Codes & Buttons Manager 2.8.1
    2. Change Thread Starter 1.0.1
    3. Conversations Access by Waindigo 1.0.2
    4. Digital Point Better Analytics 1.0.4
    5. MetaMirror 1.6.0
    6. Post Ratings 1.6.6
    7. Special Avatar for Banned Members 1.3.6
    8. [bd] Widget Framework 2.5.0d
    9. [RT] Online Status Ribbon 1.3.7
    10. TinyMCE 2.2.2
     
  2. Mike

    Mike XenForo Developer Staff Member

    That error usually indicates that there was a timeout in the connection and it was closed. However, we have seen some DB specific bugs where certain queries would cause a connection closure (I believe in MariaDB).

    This is happening at the end when it tries to display the page, so it could be a timeout. You may need to check/change the wait_timeout setting in MySQL if it's set very low (default is 86400 seconds). If that's not been changed or is quite high, then you're looking at something killing the connection unexpectedly -- being out of RAM would very likely cause that. You may find some details in MySQL's error log.
     

Share This Page