I have had several Drupal sites up for a few years now and have never had problems with the DB. Two weeks ago, my hosting service upgraded their MySQL to version 5 from version 4 and now all of my sites, on Drupal versions 5 and 6, are displaying this error message:
user warning: Incorrect key file for table 'node'; try to repair it query: SELECT COUNT(*) FROM node n WHERE n.promote = 1 AND n.status = 1 in /home/public_html/includes/database.mysql.inc on line 172.
and in place of the content, is the default "Welcome to your new Drupal website!" page.
I have tried a google search for this problem, and the results are all Drupal sites with the same problem, including my own. This problem appears to be wide-spread:
http://www.google.ca/#hl=en&source=hp&q=%22user+warning%3A+Incorrect+key...
I only have cpanel access for the sites, so my interaction with the DB has been basic tablespace creation and user creation.
Has anyone seen this error before? Searches on the drupal.org site return similar problems, but none with working solutions for my sites.
Many advanced thank-yous!
Comments
Same problem... any thoughts?
I'm having this same difficulty with a site running 5.x. The host (Lunarpages) recently updated MySQL on the server to 5.1 from 5.0 and has also changed the default version of PHP from 4 to 5. Now no node will display (though blocks and pre-"break" contents of nodes display correctly on the front page of the site).
Looking at the database in phpMyAdmin shows that the "node" table is marked as "in use". I'm attempting to export the DB at the moment - vital, as there appear to be no recent backups.
Does anyone have any idea where to begin in repairing this DB so that it'll run again, either in Drupal 5 or 6?
Thanks in advance! -- D.
Drupal node file problem
We had the same problem following and automatic upgrade on our Cpanel when mysql upgraded from 5.0 to 5.1
If you roll back to 5.0, the problem could/should go away. It fixed every site on our server...