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
MySQL broken
Seems to me that your MySQL installation went foobar. node.MYI would be a file where MySQl stores data for the node table.
--
Drupal services
My Drupal services
Thanks for the reply. I don't
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
Ask your hoster
Ask the tech support. They are supposed to know what is going on on their machines.
--
Drupal services
My Drupal services
Thanks!
Thanks for the quick advice. They fixed it for me.
FYI
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)
FYI
Thank you Pascal, I also had a corrupt Table recently, and that fixed it for me, your a life saver!!
Mike
repair table
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
Repair table
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!
Repair table
plus i dont have the option to repair, i am looking for it but i dont see it. what a bummer man.
who ever gave the advice abou
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.
Thanks
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 :)
The server this happened to
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