Select Page

corrupted mos_session table

corrupted mos_session table


 10 minutes ago, I got a strange error message:

DB function failed with error number 1016
Can’t open file: ‘mos_session.MYI’. (errno: 145) SQL=SELECT session_id FROM mos_session WHERE session_id=MD5(‘e20eafcf277b7bc0dd125357b4a1b223’)
SELECT session_id FROM mos_session WHERE session_id=MD5(‘e20eafcf277b7bc0dd125357b4a1b223’

I was not able to access the frontend or admin panel of my homepage. I tried to look in PHPMyAdmin the table mos_session but was getting the same error message. The only solution was to recreate the table with the following code:

DROP TABLE IF EXISTS `mos_session`;
CREATE TABLE `mos_session` (
`username` varchar(50) default '',
`time` varchar(14) default '',
`session_id` varchar(200) NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`)

Why my table has crashed is still unknow but I am looking further in logs files…

About The Author

Cédric Walter

I worked with various Insurances companies across Switzerland on online applications handling billion premium volumes. I love to continuously spark my creativity in many different and challenging open-source projects fueled by my great passion for innovation and blockchain technology.In my technical role as a senior software engineer and Blockchain consultant, I help to define and implement innovative solutions in the scope of both blockchain and traditional products, solutions, and services. I can support the full spectrum of software development activities, starting from analyzing ideas and business cases and up to the production deployment of the solutions.I'm the Founder and CEO of Disruptr GmbH.