MYSQL error (errno: 145)

[padu]

Hello,

I have 2 times an erno: 145 error in mysql withe the mos_session table.
I knaow how to solve it, my question is more if somebody else has the same prob and if anyone knows why ?
Tahnks
Padu

[tonyskyday]

You may be getting this error for a couple of reasons, so we need more information:

What version of MySQL do you have?
What is the cookie lifetime set to in the Mambo configuration?
Do you have phpmyadmin or some similar db interface tool you can use to repair the mos_session table?

-Tony

[james]

Hope you have buckup for every db file, you should delete mos_session from your mysql and upload the new one, if you dont have you can create one yourself in the notepad.
Here is how should looks, then drop the old one upload this one it will works.

#
# Table structure for table `mos_session`
#
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;
#
# Dumping data for table `mos_session`
#

[virstad]

Thanks for your rows. I noticed that my homepage hade these errors, followed your description and everything is OK again!

Cheers - Josef