By onenationunderdog on

I'm running a Drupal 4.3.2 test site and have been meaning to upgrade to the 4.4.0 release candidate. Anyhow haven't logged in for a few weeks, and when I tried just now I got a bizarre error. I tried searching Drupal.org for related errors but didn't see a match. Anybody have any idea what this is about?

from http://www.mymediachannel.org/drupal/:

"Fatal error: Can't open file: 'watchdog.MYI'. (errno: 145) query: INSERT INTO watchdog (uid, type, message, link, location, hostname, timestamp) VALUES (0, 'error', 'user error: Can\'t open file: \'sessions.MYI\'. (errno: 145) query: SELECT u.*, s.*, r.name AS role FROM users u INNER JOIN role r ON u.rid = r.rid INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = \'6f44356f015cd97b53d99c08f2c677c4\' AND u.status < 3 LIMIT 0, 1 in /home/zaphod/public_html/drupal/includes/database.mysql.inc on line 90.', '', '/drupal/', '69.67.0.146', 1079397060) in /home/zaphod/public_html/drupal/includes/database.mysql.inc on line 90"

Comments

jxs2151’s picture

jxs2151 commented

http://drupal.org/node/view/5258

This bug has been fixed. To fix it manually

change u.nid to u.uid on line 163 in remindme.module

onenationunderdog’s picture

onenationunderdog commented

mmm... well thx for the effort but i'm not using that module -- it's not in my /modules folder.

after a little hunting i realized there is a 'watchdog' table and used cpanel to repair it.

thx!

ron collins’s picture

ron collins commented

i know this thread is a little old but...i just had this problem and fixed it by going to the database directory and running:

myisamchk -r *.MYI

and then restarting mysql.

cyberchucktx’s picture

cyberchucktx commented

If you're like me you don't have shell access via your ISP.

BUT if you have some method of executing SQL statements (such as within phpMyAdmin) you can use the following:

REPAIR TABLE
[QUICK]

(the "QUICK" is optional)

So as an example:

REPAIR TABLE sessions QUICK;

fixed my issue with this. Not sure how the index got corrupted, tho.

Charlie in TX