XF 1.5 Duplicate entry for key 'expiry_date'

[daimpa]

Hello,

servers shutted down and now I've this error. Is it fine to just "repair" the XF_session table?
Note: in phpmyadmin, XF_session table is marked as "under use" (literally translated from my language)

Mysqli prepare error: Table './forum_xf/xf_session' is marked as crashed and should be repaired

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
Zend_Db_Adapter_Abstract->insert() in XenForo/Session.php at line 855
XenForo_Session->saveSessionToSource() in XenForo/Session.php at line 573
XenForo_Session->save() in XenForo/Controller.php at line 414
XenForo_Controller->updateSession() in XenForo/Controller.php at line 358
XenForo_Controller->postDispatch() in XenForo/FrontController.php at line 358
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/webmgm/forum/index.php at line 13

 

[Paul B]

Yes, you can either just repair it or truncate it.

 

[daimpa]

Yes, you can either just repair it or truncate it.

Thanks, it worked

 

[Surendra.S]

Thank You @Brogan & @daimpa

I just had exact same error message, and REPAIR xf_session table through phpMyAdmin worked perfectly.

Do you guys have any idea how can I see all corrupted table list in my database (phpMyAdmin) ?