I've been amiss about updating all my sites. Since I use Drupal as the CMS for 90% of my sites, I was surprised to see a couple of them had major issues. One of the more devastating errors was the Can't open file: 'node_revisions.MYI' error.

I am pretty sure this occurs due to a module not working properly, but I am not sure yet. This error was caused by spammers coming onto the site and getting around the SPAM module.  

Anyway, this one has a very simple fix, which I found on the main Drupal site. 

You need to go into PHPMYADMIN through your cPanel interface. You can get to it by clicking on the MySQL icon and then selecting the  phpMyAdmin option. In the first screenshot you'll see how to select the MySQL icon and in the second you'll see how to open phpMyAdmin:

MySQL icon from cPanel

Once you've select the MySQL option, click on the phpMyAdmin option at the bottom:

phpMyAdmin selection from the MySQL options

Once you are in phpMyAdmin, select your Drupal database on the left. Once that is done you need to select the SQL command option at the top like what follows:

How to enter a SQL command in phpMyAdmin

Now comes the fun part of entering the command. You need to enter the following command in the SQL box and run it. 

repair table node_revisions;

Here is a screenshot of what it looks like:

Running SQL command to fix Drupal error

You are now finished and have repaired the dreaded Can't open file: 'node_revisions.MYI' error.

Bookmark/Search this post with:
delicious | digg | reddit | furl | google | yahoo | technorati | icerocket