By mb2 on

I posted a new blog entry, and now I get the following error on all nodes:

user warning: Can't open file: 'node_revisions.MYI' (errno: 145) query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 467 in /home/usatec00/domains/proamsportslinks.com/public_html/includes/database.mysql.inc on line 120.
user warning: Can't open file: 'node_revisions.MYI' (errno: 145) query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 467 in /home/usatec00/domains/proamsportslinks.com/public_html/includes/database.mysql.inc on line 120.
user warning: Can't open file: 'node_revisions.MYI' (errno: 145) query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 467 in /home/usatec00/domains/proamsportslinks.com/public_html/includes/database.mysql.inc on line 120.
user warning: Can't open file: 'node_revisions.MYI' (errno: 145) query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 467 in /home/usatec00/domains/proamsportslinks.com/public_html/includes/database.mysql.inc on line 120.
user warning: Can't open file: 'node_revisions.MYI' (errno: 145) query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 467 in /home/usatec00/domains/proamsportslinks.com/public_html/includes/database.mysql.inc on line 120.
user warning: Can't open file: 'node_revisions.MYI' (errno: 145) query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 468 in /home/usatec00/domains/proamsportslinks.com/public_html/includes/database.mysql.inc on line 120.
user warning: Can't open file: 'node_revisions.MYI' (errno: 145) query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = '467' in /home/usatec00/domains/proamsportslinks.com/public_html/includes/database.mysql.inc on line 120.
user warning: Can't open file: 'node_revisions.MYI' (errno: 145) query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.type = 'poll' AND n.created = '1155358404' AND n.moderate = '0' AND n.status = '1' in /home/usatec00/domains/proamsportslinks.com/public_html/includes/database.mysql.inc on line 120.
user warning: Can't open file: 'node_revisions.MYI' (errno: 145) query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = '271' in /home/usatec00/domains/proamsportslinks.com/public_html/includes/database.mysql.inc on line 120.

And the content is now:

n/a

The site is http://www.proamsportslinks.com if you want to take a look yourself.

Obviously, any help would be appreciated!

⋅ Categories: Drupal 4.7.x

Comments

Veggieryan’s picture

Veggieryan commented

at mysql command line

repair table node_revisions;

should do it.

mb2’s picture

mb2 commented

Thanks a lot, that did the trick. Now if only I actually had time to maintain the site in general. . .

MB
ProAmSportsLinks.com

rivena’s picture

rivena commented

Bookmarking for possible troubleshooting faq entry.

Anisa.

-----------------------------------------------------------
Kindness builds stronger bonds than necessity.

www.animecards.org - 18,000 card scans and counting!
-----------------------------------------------------------