Hi, my site has been fine for 2 years and now I just noticed the site has this error:

Warning: Can't open file: 'users.MYI'. (errno: 145) query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = 'cb43d7e7a054ed39ddc38f7f489de03b' in /home/ig2gcom/public_html/bartrage/includes/database.mysql.inc on line 172

my site url is:
http://www.bartrage.com

Anyone know the fix for this? I am holding off on restoring db's and such in case this is a simple fix.

Comments

Crell’s picture

Crell commented
Project: Drupal.org site moderators » Drupal core
Version: » 5.2
Component: Other » other
Status: Active » Fixed

This is a Drupal support issue. The Drupal webmasters project is for issues with Drupal.org itself only. Refiling.

The error you're seeing is a problem with MySQL. It cannot open the file on disk that holds the indexes for the users table, so Drupal is dying as a result. It sounds like you need to do a repair command on the table from the MySQL command line. ("REPAIR users" is the command, I believe.)

For more information, please consult a MySQL forum. They'd know more about how to resurrect a b0rked MySQL table. I can recommend the #MySQL channel on Freenode as a generally helpful place.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)
goldencow’s picture

goldencow commented

REPAIR TABLE TableName_sessions

can fixed