corrupted mos_session table

Thursday, 03 August 2006 23:33

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')
SQL =
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`)
) TYPE=MyISAM;

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