Issues after server outage.

[Dean Hamer]

Afternoon,

 

I am having a few issues after a server outage, when looking at online users we get the following error:

SELECT COUNT(*) FROM `core_sessions` WHERE ( core_sessions.id IN('SELECT MAX(id) FROM `core_sessions` AS `s` WHERE s.running_time>'SELECT MAX(id) FROM `core_sessions` AS `s` WHERE s.running_time>? AND s.login_type!=? AND (s.login_type!=? OR s.member_id=?) AND s.member_id IS NULL GROUP BY `ip_address`' AND s.login_type!=? AND (s.login_type!=? OR s.member_id=?) AND s.member_id IS NOT NULL GROUP BY `member_id`') OR core_sessions.id IN(?) )
IPS\Db\Exception: Table 'core_sessions' is marked as crashed and should be repaired (1194)
#0 /home/footbal9/public_html/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#1 /home/footbal9/public_html/system/Db/Select.php(370): IPS\Db\_Select->rewind()
#2 /home/footbal9/public_html/system/Session/Store/Database.php(250): IPS\Db\_Select->first()
#3 /home/footbal9/public_html/applications/core/widgets/stats.php(94): IPS\Session\Store\_Database->getOnlineUsers(7)
#4 /home/footbal9/public_html/system/Widget/Widget.php(833): IPS\core\widgets\_stats->render()
#5 /home/footbal9/public_html/system/Widget/Widget.php(888): IPS\_Widget->_render()
#6 /home/footbal9/public_html/system/Theme/Theme.php(885) : eval()'d code(171): IPS\_Widget->__toString()
#7 /home/footbal9/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_cms_front_pages->widgetContainer('col1', Array, 'horizontal')
#8 /home/footbal9/public_html/applications/cms/sources/Theme/Theme.php(610) : eval()'d code(12): IPS\Theme\_SandboxedTemplate->__call('widgetContainer', Array)
#9 /home/footbal9/public_html/applications/cms/sources/Pages/Page.php(2269): IPS\Theme\class_cms_page_page_builder->single_column(Object(IPS\cms\Pages\Page), Array)
#10 /home/footbal9/public_html/applications/cms/modules/front/pages/page.php(116): IPS\cms\Pages\_Page->output()
#11 /home/footbal9/public_html/applications/cms/modules/front/pages/page.php(43): IPS\cms\modules\front\pages\_page->view()
#12 /home/footbal9/public_html/system/Dispatcher/Controller.php(118): IPS\cms\modules\front\pages\_page->manage()
#13 /home/footbal9/public_html/applications/cms/modules/front/pages/page.php(33): IPS\Dispatcher\_Controller->execute()
#14 /home/footbal9/public_html/system/Dispatcher/Dispatcher.php(153): IPS\cms\modules\front\pages\_page->execute()
#15 /home/footbal9/public_html/index.php(13): IPS\_Dispatcher->run()
#16 {main}

Logging in to admin shows that:

Locked Task: userAgentStatistics

Locked Task: onlineusers

Locked Task: clearsessions

Are all unable to run, clicking run brings up the following error message:

Quote

2C124/2 The task is already running and cannot be ran until it has finished or the lock is removed.

 

Logging in to the dashboard shows this:

SELECT * FROM `core_sessions` WHERE ( core_sessions.id IN('SELECT MAX(id) FROM `core_sessions` AS `s` WHERE s.running_time>'SELECT MAX(id) FROM `core_sessions` AS `s` WHERE s.running_time>? AND s.login_type!=? AND (s.login_type!=? OR s.member_id=?) AND s.member_id IS NULL GROUP BY `ip_address`' AND s.login_type!=? AND (s.login_type!=? OR s.member_id=?) AND s.member_id IS NOT NULL GROUP BY `member_id`') OR core_sessions.id IN(?) ) ORDER BY core_sessions.running_time desc
IPS\Db\Exception: Table 'core_sessions' is marked as crashed and should be repaired (1194)
#0 /home/footbal9/public_html/system/Db/Select.php(286): IPS\Db\_Select->runQuery()
#1 /home/footbal9/public_html/system/Session/Store/Database.php(253): IPS\Db\_Select->setKeyField('id')
#2 /home/footbal9/public_html/applications/core/extensions/core/Dashboard/OnlineUsers.php(52): IPS\Session\Store\_Database->getOnlineUsers(6, 'desc')
#3 /home/footbal9/public_html/applications/core/modules/admin/overview/dashboard.php(64): IPS\core\extensions\core\Dashboard\_OnlineUsers->getBlock()
#4 /home/footbal9/public_html/system/Dispatcher/Controller.php(118): IPS\core\modules\admin\overview\_dashboard->manage()
#5 /home/footbal9/public_html/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#6 /home/footbal9/public_html/admin/index.php(13): IPS\_Dispatcher->run()
#7 {main}

 

Anyone have any ideas?

[teraßyte]

Your core_sessions table crashed, most likely caused by the server outage you mentioned:

Quote

IPS\Db\Exception: Table 'core_sessions' is marked as crashed and should be repaired (1194)

You can repair the table from phpMyAdmin or a similar tool. If you are unsure on how to do it it's probably best if you ask your hosting for assistance instead.

Edited July 19, 2022 by teraßyte