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

XF 1.5 Duplicate entry for key 'expiry_date'

Discussion in 'Troubleshooting and Problems' started by daimpa, Apr 20, 2016.

  1. daimpa

    daimpa Member

    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)

    Code:
    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
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

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

    daimpa Member

    Thanks, it worked :)
     

Share This Page