XF 1.4 Server Error

[xhuzen]

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]

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]

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

 

[xhuzen]

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

 

[TPerry]

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

 

[Mike]

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