XF 1.2 Database Crashed & Unable to Repair


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

An unexpected error occurred. Please try again later.
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:


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.