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

XF 1.2 lots of server errors logged, what do they mean?

Discussion in 'Troubleshooting and Problems' started by wtgw, Nov 15, 2013.

  1. wtgw

    wtgw Member

    The first one was

    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '1384552553' for key 'expiry_date' - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account

    Duplicate entry '1384552608' for key 'expiry_date' - library/Zend/Db/Statement/Mysqli.php:214

    Then a lot of these:

    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect key file for table './xf_session.MYI'; try to repair it - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account, Today at 3:55 PM


    Then these:

    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table './xf_session' is marked as crashed and should be repaired - library/Zend/Db/Statement/Mysqli.php:77


    I repair the table xf_session and it's working now but what do these mean?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    It means the table had crashed.

    If you have repaired it and the errors have stopped then you don't need to be concerned.
     
    borbole likes this.
  3. wtgw

    wtgw Member

    It happened again, same table crashed. What causes this? Need to fix it so it never happens again or else it'll ruin the forum.

    First error: Mysqli statement execute error : Incorrect key file for table './databasename/xf_session.MYI'; try to repair it Today at 2:12 PM - library/Zend/Db/Statement/Mysqli.php:214

    Second error: Mysqli statement execute error : Duplicate entry '1387311151' for key 'expiry_date' Today at 2:12 PM - library/Zend/Db/Statement/Mysqli.php:214
     
    Last edited: Dec 18, 2013
  4. AndyB

    AndyB Well-Known Member

    Could be a faulty server. Email your web hosting company and explain what is happening.

    The xf_session table should be truncated as none of the data in it is important.
     
  5. Mian Shahid

    Mian Shahid Well-Known Member

    I got the same error, when try to empty table gt
    message, then try to optimized and got everything OK :)

    but the question is that, why this is happening? due to server side problem or XF side issue?

    Anyone please describe it for me and for few others :)
     

Share This Page