XF 1.4 Server Error

xhuzen

Member
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
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.
 

xhuzen

Member
Thanks for your reply oman, but i cannot seem to find the 'Repair' link. It just show a dialog popup.
 

Attachments

xhuzen

Member
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'.
 

Tracy Perry

Well-known member
That's weird.. I thought the xf_user table was an InnoDB one and that repair would not work on InnoDB, only MyISAM. :unsure:
 

Mike

XenForo developer
Staff member
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).
 
Top