error number 1016

[speed-addiction]

I have mambo running for about a month with no problems, yesterday I uploaded some content, nothing weird at all, just an article as usual logged out... today

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'


This message appears when i wanna login or view my page!!!

Is there a repair utility, anyone with this similar problem?

HELP PLEASE!

[Sanca]

I got this ERROR code today!! Ahh. Don't know how to solve it! Couldnt make any sense out of the Mysql Documentation on the web about troubleshooting and error reporting.

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('7765ccb5192ae4175b41cf8eeabbe691')
SQL =

SELECT session_id FROM mos_session WHERE session_id=MD5('7765ccb5192ae4175b41cf8eeabbe691')




ALL Tips and Suggestions are welcomed
My website where you can see this code is: http://www.dalajarna.se/

[speed-addiction]

Here you go, I really freaked out when it happenned to me, I still don´t know the reason it appeared, however I would like someone to help me at the time...

replace de mos_session entry in the database

#
# 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`
#


and it should work allright....

[Sanca]

How can i do this? I'm not into Mysql that much even if I managed to install it on my own server.
A small hint from you Speedaddiction would be nice please or anyone else.

[simes]

This just happened to me, THANKYOU THANKYOU THANKYOU THANKYOU for making this code available

[speed-addiction]

Originally Posted by simes

This just happened to me, THANKYOU THANKYOU THANKYOU THANKYOU for making this code available

no problem... I posted it because when it happenned to me I had a very hard time finding it... hope its useful

[Sanca]

Here is how I solved my problem:

As fortune as I am my backup contained the mysql database directory (on my own server) so I could locate the database files in my backup. You know the *.MYI files (or what they were called, I mentioned those in one of my other messages).

I used these old backup files to overwrite my crashed files. And the problem solved.

[manuman]

A little late night reading if your interested.

http://dev.mysql.com/doc/mysql/en/repair.html

Cheers
manuman

[Sanca]

I tried to repair the tables in mysql administrator but the table wouldn't show in the list so I had to investigate if the files with the table really excisted. Thats how I found out that I could just replace the files, and why I didn't repair the table.

[martintbird]

just had same problem (after server had some trouble), and found this thread via google search

Looked very scary.
I ran speed-addiction's code lines as a mysql query, using phpmyadmin from cPanel (maybe many folk know all about such things; but pretty new to me - I'd only once used phpmyadmin before, to upgrade mambo)

- worked fine; so thanks very much

[rpersonius]

Wow, very scary is right. I just noticed the same error on one of my sites. With the use of your SQL I was able to fix it in no time. Now all I have to do is figure out what caused this error in the first place.

[marian]

Originally Posted by speed-addiction

Here you go, I really freaked out when it happenned to me, I still don´t know the reason it appeared, however I would like someone to help me at the time...

replace de mos_session entry in the database

#
# 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`
#


and it should work allright....

Having posted a new thread about this very topic, I've been searching and searching and found several threads about the same prob.
Your solution was the only one that produced a cure. So a million thanks to you.
It would be nice if someone could make this a sticky as i'm sure there are others out there who are going to tear their hair out in the future and this fix will save them a lot of grief.
The only other thing I'd like to know are the precise steps for running this script myself in phpadmin, as I had to get our host to do it.
Thanks a lot again.

[RSGracey]

Thanks!--Stored this code in a query in Navicat, and if it ever happens again, *knock wood* I'll be able to run it again. It worked!

Stephen

[ensonix]

Hi

I'm actually getting this error every day, sometimes together with corrupt mos_content, mos_rsgallery, mos_rsgalleryfiles and mos_statsagent tables.

I have tried rebuilding the mos_sessions tables using the sql code above, but the error just keeps happening. Is it worth just deleting the database and restoring from a backup?

[ensonix]

Anybody got a solution for preventing this? Our site is down for the fifth day this week. I can't monitor it every minute of the day, and it seems to be a problem with the way the sessions table is being written to by Mambo

[asmar]

Anyone from the Mambo team with a solution to this serious bug?
It happened to me as well more than a couple of times during last week.

Thanks

[mack]

I had this error:
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'

How to solve this:

The fast and easy way:

1. Stop the MySQL Server, with some like this: /etc/init.d/mysql stop
2. Go to the DB storage directory "/var/lib/mysql/{your_db}/"
3. Backup the data file wwwm_session.MYI
4. Run this: myisamchk ./wwwm_session.MYI
5. Read the messages, if no have critical error try with: myisamchk -r ./wwwm_session.MYI
6. Read the messages, if no have critical error congratulations! your data file was recovered, just start the MySQL Server, with some like this: /etc/init.d/mysql start

If you have a critical errors or if you want to learn more about this error go to:
http://dev.mysql.com/doc/refman/5.0/en/repair.html

Enjoy!

[RockLee]

I've tried speed-addiction's fix and it works fine. However about a week later, the same error occured again.

Does anyone know what's causing this? I check the server's error log and found nothing. Does this happens only to those who upgraded to 4.5.3?

How can I fix this problem at its root to prevent it from re-occuring? Any suggestions would be appreciated. TIA!


P/S: Can't try Mack's suggestion as I do not have shell access.

[RSGracey]

I've since discovered that Navicat has a "repair tables" function. I now make it a regular practice to run the function, just to keep things neat, and the "session" issue doesn't happen anymore.

Stephen

[RockLee]

Navicat is too expensive for me, besides it doesn't solve the problem at the root if I have to repair tables on a regular basis. I didn't need to do this in the past.

My web hoster says the problem lies with Mambo, but I have a few other sites using mambo that doesn't have this problem at all.

Does anyone know what's causing the error number 1016 for mos_session table?