Using version 4.10. I only tried to update a book page, and pressed Preview, then made a few changes and pressed Submit when everything went awry with the following error messages:

On the home page:
user error: Can't open file: 'node.MYI'. (errno: 145)
query: SELECT n.nid FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE b.parent = 0 AND n.status = 1 AND (n.moderate = 0 OR n.revisions != '') ORDER BY b.weight, n.title in /usr/www/users/photojpn/notes/includes/database.mysql.inc on line 69.

user error: Can't open file: 'node.MYI'. (errno: 145)
query: SELECT MAX(created) FROM node WHERE type = 'poll' AND status = '1' AND moderate = '0' in /usr/www/users/photojpn/notes/includes/database.mysql.inc on line 69.

On the Administration page:
user error: Can't open file: 'node.MYI'. (errno: 145)
query: SELECT n.nid FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE b.parent = 0 AND n.status = 1 AND (n.moderate = 0 OR n.revisions != '') ORDER BY b.weight, n.title in /usr/www/users/photojpn/notes/includes/database.mysql.inc on line 69.

user error: Can't open file: 'node.MYI'. (errno: 145)
query: SELECT MAX(created) FROM node WHERE type = 'poll' AND status = '1' AND moderate = '0' in /usr/www/users/photojpn/notes/includes/database.mysql.inc on line 69.

What do I do? Should I upgrade to 4.2? I'm not a PHP programmer.

phil

Comments

killes@www.drop.org’s picture

Seems to me that your MySQL installation went foobar. node.MYI would be a file where MySQl stores data for the node table.

phil1011’s picture

Thanks for the reply. I don't operate my own server. Both MySQL and PHP are on my Web host's (pair.com) server.

What should I do?

phil

killes@www.drop.org’s picture

Ask the tech support. They are supposed to know what is going on on their machines.

phil1011’s picture

Thanks for the quick advice. They fixed it for me.

Pascal’s picture

If the problem in future comes again, just login with with phpMyAdmin (version 2.5 or higher).
Select your DB, mark the corrupted table, scroll down and select the option "repair table".
That's all.

(Sorry for my bad english)

Anonymous’s picture

Thank you Pascal, I also had a corrupt Table recently, and that fixed it for me, your a life saver!!
Mike

Anonymous’s picture

Hey hey, I just wanted to add this: if you have shell access you can simply use the command REPAIR TABLE tablname .. This worked fine for the broken table at Aftergrass.com cheers... -e

Anonymous’s picture

mySQL query error: DELETE FROM ibf_sessions WHERE running_time < 1066015113 or ip_address='24.228.4.46'

mySQL error: Can't open file: 'ibf_sessions.MYI'. (errno: 145)
mySQL error code: 1016
Date: Sunday 12th of October 2003 09:18:33 PM

how do i know which table to repair? this is completely new for me and my hosting service has left me out to dry, so screw em! if i can i will fix it my self, help?

thanks!

Anonymous’s picture

plus i dont have the option to repair, i am looking for it but i dont see it. what a bummer man.

Anonymous’s picture

who ever gave the advice about using the repair tool in php my admin, thank you very much, i could not believe how easy it was 2 seconds, done. the forum was down for a week, and if it was that easy it would have never been down in the first place, i am glad i found this board, good information.

sirius60’s picture

Your advice has helped me too.
I felt sick when i crashed our site cause I opened the site in another tab while i was working on it.
The site is back fine after following your advice but the (i'm gonna get the language wrong) menu is still crashing.
I'll try and find away round that but if i can't i'll just create another menu and attach all the nodes to that.
Thank you so much i really did feel very sick, i'm off now to back up the site and the the databases :)

psynaptic’s picture

The server this happened to me on was running an older version of PHPMyAdmin so the repair command was not available.

You can run the repair from the command line:

$ repair table [table-name]

Drupal Contributions API
Web Design Middlesbrough