Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted June 22, 20231 yr I'm getting this error message logging into the forums. Is this easily repairable? Quote SELECT * FROM `core_sessions` WHERE ( core_sessions.id IN(SELECT MAX(id) FROM `core_sessions` AS `s` WHERE s.running_time>1687411697 AND s.login_type!=3 AND (s.login_type!=1 OR s.member_id=1) AND s.member_id IS NOT NULL GROUP BY `member_id`) OR core_sessions.id IN(SELECT MAX(id) FROM `core_sessions` AS `s` WHERE s.running_time>1687411697 AND s.login_type!=3 AND (s.login_type!=1 OR s.member_id=1) AND s.member_id IS NULL GROUP BY `ip_address`) ) ORDER BY core_sessions.running_time desc IPS\Db\Exception: Table './admin_ipb/core_sessions' is marked as crashed and should be repaired (145) #0 /home/admin/web/unofficialmills.co.uk/public_html/forums/system/Db/Select.php(388): IPS\_Db->preparedQuery() #1 /home/admin/web/unofficialmills.co.uk/public_html/forums/system/Db/Select.php(286): IPS\Db\_Select->runQuery() #2 /home/admin/web/unofficialmills.co.uk/public_html/forums/system/Session/Store/Database.php(253): IPS\Db\_Select->setKeyField() #3 /home/admin/web/unofficialmills.co.uk/public_html/forums/applications/core/extensions/core/Dashboard/OnlineUsers.php(52): IPS\Session\Store\_Database->getOnlineUsers() #4 /home/admin/web/unofficialmills.co.uk/public_html/forums/applications/core/modules/admin/overview/dashboard.php(64): IPS\core\extensions\core\Dashboard\_OnlineUsers->getBlock() #5 /home/admin/web/unofficialmills.co.uk/public_html/forums/system/Dispatcher/Controller.php(118): IPS\core\modules\admin\overview\_dashboard->manage() #6 /home/admin/web/unofficialmills.co.uk/public_html/forums/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 /home/admin/web/unofficialmills.co.uk/public_html/forums/admin/index.php(13): IPS\_Dispatcher->run() #8 {main}
June 22, 20231 yr You would need to contact your hosting company to ask that question. Usually you can just repair these with tools like phpmyadmin, but I would contact your host if you are unsure
June 22, 20231 yr Author 4 minutes ago, Marc Stridgen said: You would need to contact your hosting company to ask that question. Usually you can just repair these with tools like phpmyadmin, but I would contact your host if you are unsure Thank you.