watchdog error?
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"
Watchdog error
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
mmm... well thx for the effor
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!
command line fix
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.
MySQL version of "myisamchk"
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