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

XF 1.5 Help - some errors I have never seen before - forum down :(

Discussion in 'Troubleshooting and Problems' started by DaiAku, Dec 21, 2015.

  1. DaiAku

    DaiAku Active Member

    Forums went down today and getting tons of errors. Here are a few. Anyone have any idea what is causing this?

    Code:
    Server Error Log
    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect key file for table './queee_forums_new/xf_session.MYI'; try to repair it - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account, A moment ago
    Stack Trace
    #0 /home/queee/public_html/forums/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/queee/public_html/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/queee/public_html/forums/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /home/queee/public_html/forums/library/XenForo/Session.php(855): Zend_Db_Adapter_Abstract->insert('xf_session', Array)
    #4 /home/queee/public_html/forums/library/XenForo/Session.php(573): XenForo_Session->saveSessionToSource('8dab2cda01ecf8a...', false)
    #5 /home/queee/public_html/forums/library/XenForo/Controller.php(414): XenForo_Session->save()
    #6 /home/queee/public_html/forums/library/XenForo/Controller.php(358): XenForo_Controller->updateSession(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Member')
    #7 /home/queee/public_html/forums/library/XenForo/FrontController.php(358): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Member')
    #8 /home/queee/public_html/forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /home/queee/public_html/forums/index.php(13): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
      ["url"] => string(66) "http://precursorgames.com/forums/index.php?members/tat%C3%A1.2130/"
      ["_GET"] => array(1) {
        ["members/tatá_2130/"] => string(0) ""
      }
      ["_POST"] => array(0) {
      }
    }
    
    Code:
    Server Error Log
    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Duplicate entry '1450711689' for key 'expiry_date' - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Unknown Account, 2 minutes ago
    Stack Trace
    #0 /home/queee/public_html/forums/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/queee/public_html/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/queee/public_html/forums/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /home/queee/public_html/forums/library/XenForo/Session.php(855): Zend_Db_Adapter_Abstract->insert('xf_session', Array)
    #4 /home/queee/public_html/forums/library/XenForo/Session.php(573): XenForo_Session->saveSessionToSource('2082c9368d07077...', false)
    #5 /home/queee/public_html/forums/library/XenForo/Controller.php(414): XenForo_Session->save()
    #6 /home/queee/public_html/forums/library/XenForo/Controller.php(358): XenForo_Controller->updateSession(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Trophies')
    #7 /home/queee/public_html/forums/library/XenForo/FrontController.php(358): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_View), 'XenForo_Control...', 'Trophies')
    #8 /home/queee/public_html/forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /home/queee/public_html/forums/index.php(13): XenForo_FrontController->run()
    #10 {main}
    Request State
    array(3) {
      ["url"] => string(63) "http://que-ee.com/forums/index.php?members/sireef.2182/trophies"
      ["_GET"] => array(1) {
        ["members/sireef_2182/trophies"] => string(0) ""
      }
      ["_POST"] => array(0) {
      }
    }
    
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    Log in to PhpMyAdmin or similar and truncate (empty) the xf_session table.
     
  3. Liam W

    Liam W Well-Known Member

    Your session table has crashed. Repair or truncate the xf_session table via the console or phpMyAdmin :)

    Liam
     
  4. DaiAku

    DaiAku Active Member

    Code:
    Server Error
    
    Mysqli statement execute error : Incorrect key file for table './queee_forums_new/xf_session.MYI'; try to repair it
    
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    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/queee/public_html/forums/index.php at line 13
    
    This is what you get when you access the forums :(
     
  5. DaiAku

    DaiAku Active Member

    Ok - thank you - will try to look for that.
     
  6. Chris D

    Chris D XenForo Developer Staff Member

    As Liam says you can also repair the table in PhpMyAdmin. Either should work.
     
  7. DaiAku

    DaiAku Active Member

    @Liam W & @Chris D - we use cpanel - would this be somewhere in cpanel? - Sorry this is not my area - Phil (our admin) is out for the day so trying to figure this out if I can to get forums back up.
     
  8. DaiAku

    DaiAku Active Member

    Oh nvm - Nimbus just did it for me. Wow these guys rock. Thanks for the help guys. They also showed me how to do this in the future.
     
  9. Chris D

    Chris D XenForo Developer Staff Member

    It's good you have the support of your host's and a fellow admin. I would challenge you, however, to learn the basics of some of the tools like PhpMyAdmin - yes, it will likely be accessible from cPanel somewhere. It allows you, among other things, to read data from the database, execute queries, import and export data and perform basic maintenance operations like repairing tables, etc. You don't have to be an expert in it, but knowing the basics will help :)
     
    SneakyDave likes this.
  10. DaiAku

    DaiAku Active Member

    Yes, agreed. I did find it in cpanel and know how to fix this now.
     
    Chris D likes this.

Share This Page