XF 1.5 Index xf_post is corrupt

[jellytoe]

Im getting this error in the server logs. Nothing seems wrong in the forums? Do I need to repair a table?

 

[Paul B]

You can try (the storage type may not support it) repairing the xf_post table using phpMyAdmin.

What are the actual details of the error if you click on one of them?

 

[jellytoe]

#0 /home/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/public_html/library/Zend/Db/Adapter/Abstract.php(734): Zend_Db_Adapter_Abstract->query('select *,xf_pos...', Array)
#3 /home/public_html/library/WdbPopularContent/Model/PopularContent.php(95): Zend_Db_Adapter_Abstract->fetchAll('select *,xf_pos...')
#4 /home/public_html/library/WdbPopularContent/ControllerPublic/Index.php(43): WdbPopularContent_Model_PopularContent->getPopularContent('10', 2, 'threads')
#5 /home/public_html/library/WdbPopularContent/ControllerPublic/Index.php(12): WdbPopularContent_ControllerPublic_Index->_getContent('threads')
#6 /home/public_html/library/XenForo/FrontController.php(351): WdbPopularContent_ControllerPublic_Index->actionThreads()
#7 /home/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#8 /home/public_html/index.php(13): XenForo_FrontController->run()
#9 {main}

array(3) {
["url"] => string(44) "http://gggghghh/find-popular/2/threads"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[Paul B]

Due to the storage type, repair won't work.
You may be able to run OPTIMIZE TABLE, if it's just a broken index, as the indexes will be rebuilt.

It could be indicative of something more serious though, which would require a sysadmin or your host to get involved.