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

XF 1.4 Mysqli statement execute error : Incorrect key file for table

Discussion in 'Troubleshooting and Problems' started by onelife69, Jan 14, 2015.

  1. onelife69

    onelife69 Member

    Hi there,

    Recently upgraded to XF 1.4.3 and started getting server errors like the one below. Any idea what is causing this and hopefully a simple remedy?

    Many thanks in advance.


    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect key file for table './tilingfo_newforu60/xf_session.MYI'; try to repair it - library/Zend/Db/Statement/Mysqli.php:214

     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    The errors appear to be related to the session table.

    You can try repairing or truncating the xf_session table using phpMyAdmin.
     
  3. onelife69

    onelife69 Member

    Thanks Brogan, you're the man(y)
     
  4. reddy ink

    reddy ink Active Member

    I had the same issue twice and fixed it by repairing the table.

    Do you know why this error happens?
    Thank you!
     
  5. Brogan

    Brogan XenForo Moderator Staff Member

    Typically it is due to server issues, such as MySQL restarting unexpectedly or not being shut down and restarted correctly.

    Your sysadmin or host should be able to investigate.
     
  6. Xon

    Xon Well-Known Member

    The table type 'MyISAM' is not crash safe, meaning if anything vaguely goes wrong the table contents (or even the definition) can be lost.
     

Share This Page