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

XF 1.4 Duplicate entry '1448197687' for key 'expiry_date

Discussion in 'Troubleshooting and Problems' started by drvagax, Nov 22, 2015.

  1. drvagax

    drvagax Member

    I'm the administrator of forums.keenswh.com and i am looking for help regarding this issue, today i woke up to this error.


    I have to request proper access to the SQL database but for now i first need to figure out what is exactly causing this issue.
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Try repairing the xf_session table using phpMyadmin.

    Table crashes can be caused by various things such as server instability, MySQL shutting down/restarting unexpectedly, etc.
    drvagax and Robust like this.
  3. drvagax

    drvagax Member

    After requesting what happened i have got notice that the server has been DDoS'd which could mean the server got taken down (aka the SQL went also down).
    My knowledge to SQL is limited, would this be easy to repair? Those duplicates i would assume i just need to delete the duplicate entries or just the exact entry it is referring to.
  4. Brogan

    Brogan XenForo Moderator Staff Member

    The xf_session table doesn't contain any data which is vital, so it can just be repaired or truncated (emptied).

    You can do it using phpMyAdmin, or your host should be able to assist if you aren't sure how to.

Share This Page