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

XF 1.5 Index xf_post is corrupt

Discussion in 'Troubleshooting and Problems' started by jellytoe, Aug 2, 2016.

  1. jellytoe

    jellytoe Member

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

    Brogan XenForo Moderator Staff Member

    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?
     
  3. jellytoe

    jellytoe Member

    #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) {
    }
    }
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    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.
     

Share This Page