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

XF 1.4 Server Errors

Discussion in 'Troubleshooting and Problems' started by Ark Royal, Oct 27, 2014.

  1. Ark Royal

    Ark Royal Active Member

    Just seen the following in my Server Error Logs

    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Table 'xf_search_index' is marked as crashed and should be repaired - library/Zend/Db/Statement/Mysqli.php:214

    Had the same entry twice at 9:41 and 9:42 this morning.

    I run the Rebuild Search Cache and generated the following error

    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry 'profile_post-66' for key 'PRIMARY' - library/Zend/Db/Statement/Mysqli.php:214

    Any ideas as to what has caused this and how do I correct the issue?

    Many Thanks

    AR
     
  2. Jeremy

    Jeremy XenForo Moderator Staff Member

    You need to repair your xf_search_index by running the following query:
    REPAIR TABLE xf_search_index
     
  3. Ark Royal

    Ark Royal Active Member

    Thanks @Jeremy
    Can I run the query from the admin panel?
     
  4. Jeremy

    Jeremy XenForo Moderator Staff Member

    No, you will need to do it via your host's control panel or through other means. You cannot run queries directly on the database from XF.
     
  5. Ark Royal

    Ark Royal Active Member

    Done, thanks for the help.
     

Share This Page