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

XF 1.2 Database Crashed & Unable to Repair

Discussion in 'Troubleshooting and Problems' started by intradox, Nov 22, 2013.

  1. intradox

    intradox Well-Known Member

    I can't seem to fix a crashed table on my database. When accessing the forum it displays:

    and on admin.php it shows:

    Server Error
    Mysqli prepare error: Table './XXXXX/xf_session' is marked as crashed and last (automatic?) repair failed
    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 Zend/Db/Adapter/Abstract.php at line 825
    Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Session.php at line 695
    XenForo_Session->getSessionFromSource() in XenForo/Session.php at line 430
    XenForo_Session->_setup() in XenForo/Session.php at line 414
    XenForo_Session->start() in XenForo/Session.php at line 314
    XenForo_Session::getPublicSession() in XenForo/ControllerAdmin/Login.php at line 7
    XenForo_ControllerAdmin_Login->actionForm() in XenForo/FrontController.php at line 337
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /var/www/indiegamers.com/root/admin.php at line 13
    I can't seem to access phpmyadmin to repair as it shows the first message on there as well?...

    What else can I do to fix the forum? Not sure how to fix o_O
    Last edited: Nov 22, 2013
  2. AndyB

    AndyB Well-Known Member

    Thankfully the xf_session table can be truncated and no important data will be lost.

    Ask your web hosting company to truncate the xf_session table.
    intradox likes this.
  3. intradox

    intradox Well-Known Member

    Thanks! Truncated the table and it did the trick. :)

Share This Page