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

XF 1.5 Alot of errors suddenly (xf_session.MYI incorrect key file)

borgqueenx

Active member
#1
after i restarted my server i suddenly got these errors. anyone have a idea how to fix this?

Stack Trace:
#0 /home/cct/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/cct/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/cct/public_html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Abstract->query('UPDATE `xf_sess...', Array)
#3 /home/cct/public_html/library/XenForo/Session.php(846): Zend_Db_Adapter_Abstract->update('xf_session', Array, 'session_id = 'c...')
#4 /home/cct/public_html/library/XenForo/Session.php(582): XenForo_Session->saveSessionToSource('c52d464cf54a603...', true)
#5 /home/cct/public_html/library/XenForo/Controller.php(414): XenForo_Session->save()
#6 /home/cct/public_html/library/XenForo/Controller.php(358): XenForo_Controller->updateSession(Object(XenForo_ControllerResponse_View), 'Siropu_Chat_Con...', 'Refresh')
#7 /home/cct/public_html/library/XenForo/FrontController.php(358): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_View), 'Siropu_Chat_Con...', 'Refresh')
#8 /home/cct/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/cct/public_html/index.php(13): XenForo_FrontController->run()
#10 {main}
Request State:

array(3) {
["url"] => string(47) "http://cupcakethunder.eu/index.php?chat/refresh"
["_GET"] => array(1) {
["chat/refresh"] => string(0) ""
}
["_POST"] => array(12) {
["room_id"] => string(1) "0"
["last_id"] => string(5) "20423"
["inverse"] => string(1) "0"
["hide_bot"] => string(1) "0"
["no_users"] => string(1) "0"
["show_ignored"] => string(1) "0"
["all_pages"] => string(1) "0"
["embedded"] => string(1) "1"
["_xfRequestUri"] => string(10) "/index.php"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}
Please help!
 

Tracy Perry

Well-known member
#4
if you have SSH access, shutdown -r now for a restart (as root) or sudo shutdown -r now (as user)
to halt the server shutdown -h now (as root) or sudo shutdown -h now (as user)

There should also be an ability from cPanel to shut the server down (don't use it so not sure) and am also not sure if there is if it cleanly shuts the server and it's services down.
 

Jake B.

Well-known member
#5
There should also be an ability from cPanel to shut the server down (don't use it so not sure) and am also not sure if there is if it cleanly shuts the server and it's services down.
The button for this is in WHM. There is both a graceful and forceful reboot option :)
 

borgqueenx

Active member
#6
i always used the restart in virtualiser, no idea how clean that one is. il try "shutdown -r" next time thanks.

I cannot repair anything in phpmyadmin in xf_session since it seems to be an empty table. (no repair button)
however phpmyadmin does say "Table './cct_xenforo/xf_session' is marked as crashed and should be repaired".

I have a recent backup of yesterday of this mysql file. so if nothing else, if someone can explain how to replace this tablewith my backup table it would be cool.
 
Last edited:

Tracy Perry

Well-known member
#7
i always used the restart in virtualiser, no idea how clean that one is. il try "shutdown -r" next time thanks.
I have a recent backup of yesterday of this mysql file. so if nothing else, if someone can explain how to replace this tablewith my backup table it would be cool.
Empty it instead (just go ahead and choose the empty option) in phpmyadmin.