Tony_B Posted July 1, 2003 Posted July 1, 2003 Ive got this message in the time of 20 minutes...i have to rebulid that session hole the time. Can't open file: 'mos_session.MYI'. (errno: 145) Whats the problem Regards Tony Quote
TCH-Andy Posted July 1, 2003 Posted July 1, 2003 Tony, It looks as if you have a corrupt database and it needs repairing (it's probably just locked) If you go into cpanel, then into phpMyAdmin select the database, and then the table 'mos_session.MYI' and at the bottom of the page "With Selected", "Repair table". Andy Quote
matman Posted July 1, 2003 Posted July 1, 2003 Are you sure it was "mos_session" and not "mod_session" ? mod_session is the Apache module that allows session variables to work, and I am guessing that the .MYI part has to do with MySQL. Quote
Tony_B Posted July 1, 2003 Author Posted July 1, 2003 Hi...it is coming back all the time.. It looks like this # Table structure for table `mos_session` # DROP TABLE IF EXISTS mos_session; CREATE TABLE `mos_session` ( `username` varchar(50) default NULL, `time` varchar(14) default NULL, `session_id` varchar(200) NOT NULL default '0', `guest` tinyint(4) default '1', `userid` int(11) default NULL, `usertype` varchar(50) default NULL, `gid` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`session_id`), KEY `whosonline` (`guest`,`usertype`) ) TYPE=MyISAM; It has happend 3 times now...i have to put this into the db to make it work again. I have 6 other installations whit the same db and theres no problem. Tony Quote
Tony_B Posted July 2, 2003 Author Posted July 2, 2003 Can i please get some help here. It still coming back.. Andy i cant do as u told me..after i get the message...and hit operation ive got this message Notice: Undefined variable: error_url in /usr/local/cpanel/base/3rdparty/phpMyAdmin/tbl_properties_operations.php on line 42 I have to drop that table hole the time and add a new one. Thanks Tony Quote
TCH-Andy Posted July 2, 2003 Posted July 2, 2003 (edited) Tony, Drop a ticket into the helpdesk (make sure you include passwords etc) and I will have a look at it. Andy Edited July 2, 2003 by AndyB Quote
Tony_B Posted July 2, 2003 Author Posted July 2, 2003 Hi Andy. I have droped a ticket now.. Thanks for your help :-) Regards Tony Quote
TCH-Andy Posted July 2, 2003 Posted July 2, 2003 Hopefully it's all ok now - give it a test and let me know Quote
Tony_B Posted July 2, 2003 Author Posted July 2, 2003 Thanks Andy Thumbs Up Lets hope that is works fine now.... i will tell u if it happens again. Then i will do nothing so u can se the message and so on. Thanks again Regards Tony Quote
TCH-Andy Posted July 2, 2003 Posted July 2, 2003 OK, Glad it's working ok now :-) I'll keep the fingers crossed it doesn't happen again. Andy Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.