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

table xf_style crashed

Akela

Active member
#1
I just used admincp to to create a new user (it seems to have worked). Now, when going into the Create New User page, I get the following:


Server Error

Mysqli prepare error: Table 'xf_style' 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 734
  5. Zend_Db_Adapter_Abstract->fetchAll() in XenForo/Model/Style.php at line 66
  6. XenForo_Model_Style->getAllStyles() in XenForo/Model/Style.php at line 223
  7. XenForo_Model_Style->getAllStylesAsFlattenedTree() in XenForo/Model/Style.php at line 241
  8. XenForo_Model_Style->getStylesForOptionsTag() in XenForo/ControllerAdmin/User.php at line 289
  9. XenForo_ControllerAdmin_User->_getUserAddEditResponse() in XenForo/ControllerAdmin/User.php at line 333
  10. XenForo_ControllerAdmin_User->actionEdit() in XenForo/FrontController.php at line 310
  11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
  12. XenForo_FrontController->run() in /home/admincov/public_html/_datingfora-xf/admin.php at line 13
I don't know if this is relevant, but my server doesn't support InnoDB, so all my tables are MyISAM.

Trying to repair the table through phpMyAdmin got me the following:

Table Op Msg_type Msg_text
admincov_datingxf.xf_style repair Error Incorrect key file for table './admincov_datingxf/...
admincov_datingxf.xf_style repair Error Incorrect key file for table 'xf_style'; try to re...
admincov_datingxf.xf_style repair error Corrupt
 

AndyB

Well-known member
#4
Try repairing the table several more times. If that doesn't work, email you web hosting provider and ask them to fix the table.