XF 1.4 Duplicate entry '1448197687' for key 'expiry_date

[drvagax]

Greetings,
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.

 

[Paul B]

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]

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.

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.

 

[Paul B]

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.