• 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 :(

DaiAku

Active member
#1
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) {
  }
}
 

DaiAku

Active member
#4
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 :(
 

DaiAku

Active member
#8
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.
 

Chris D

XenForo developer
Staff member
#9
@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.
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 :)
 

DaiAku

Active member
#10
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 :)
Yes, agreed. I did find it in cpanel and know how to fix this now.