Yald Patrick Grote's Blog

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

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:

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

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:

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:

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

Related posts:

1. How to enter a SQL command in phpMyAdmin
2. Red Hat Linux – making money with open source
3. Drupal upload timeout issue and solution fix
4. Free online file storage services
5. Newbie drupal – adsense and templates