How to fix the Drupal error Can't open file: 'node_revisions.MYI'

Submitted by Patrick Grote on Sat, 05/19/2007 - 1:43pm.

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 cPanelMySQL icon from cPanel

 

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

 

phpMyAdmin selection from the MySQL optionsphpMyAdmin 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 phpMyAdminHow 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 errorRunning SQL command to fix Drupal error

 

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


add new comment | 882 reads