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

XF 1.4 Server Error

#1
Were having problem with xenforo, can't access the dashboard and the site is down. Were getting a server error after we deleted some spam user. Can anyone help us how to repair?


Mysqli prepare error: Table './kurat_xenforoDB/xf_user' is marked as crashed and should be repaired
  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
  5. Zend_Db_Adapter_Abstract->fetchRow() in XenForo/Model/User.php at line 427
  6. XenForo_Model_User->getUserById() in XenForo/ControllerAdmin/Login.php at line 10
  7. XenForo_ControllerAdmin_Login->actionForm() in XenForo/FrontController.php at line 347
  8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  9. XenForo_FrontController->run() in /home/kurat/public_html/community/admin.php at line 13
 

oman

Well-known member
#2
Were having problem with xenforo, can't access the dashboard and the site is down. Were getting a server error after we deleted some spam user. Can anyone help us how to repair?


Mysqli prepare error: Table './kurat_xenforoDB/xf_user' is marked as crashed and should be repaired
  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
  5. Zend_Db_Adapter_Abstract->fetchRow() in XenForo/Model/User.php at line 427
  6. XenForo_Model_User->getUserById() in XenForo/ControllerAdmin/Login.php at line 10
  7. XenForo_ControllerAdmin_Login->actionForm() in XenForo/FrontController.php at line 347
  8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  9. XenForo_FrontController->run() in /home/kurat/public_html/community/admin.php at line 13
If you log in to your CPANEL and go to PhpMyAdmin.

Find the table, and there should be a link you can click to 'Repair' the table.
 
#4
I just solved the' Repair issue' :) thanks for the guide @oman. I just went through to the main Xenforo Database Table then look for the xf_user, checked it and choose from the drop down With Selected: 'Repair table'.
 

Mike

XenForo developer
Staff member
#6
It is. It's likely that his server didn't/doesn't support InnoDB (which means that MySQL will silently switch to the default table type).