• 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

#1
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
 

Mike

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