Hi

I just started getting these errors whenever I make most admin actions:

Warning: Can't open file: 'watchdog.MYI' (errno: 145) query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Can't open file: 'watchdog.MYI' (errno: 145)\nquery: SELECT DISTINCT(type) FROM watchdog ORDER BY type in /home/MYDOMAIN/public_html/includes/database.mysql.inc on line 120.', 2, '', 'http://www.MYDOMAIN.com/?q=admin', 'http://www.MYDOMAIN.com/update.php?op=finished', '87.221.8.50', 1175607806) in /home/MYDOMAIN/public_html/includes/database.mysql.inc on line 120

Warning: Can't open file: 'watchdog.MYI' (errno: 145) query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Can't open file: 'watchdog.MYI' (errno: 145)\nquery: SELECT COUNT(*) FROM watchdog w INNER JOIN users u ON w.uid = u.uid in /home/MYDOMAIN/public_html/includes/database.mysql.inc on line 120.', 2, '', 'http://www.MYDOMAIN.com/?q=admin', 'http://www.MYDOMAIN.com/update.php?op=finished', '87.221.8.50', 1175607806) in /home/MYDOMAIN/public_html/includes/database.mysql.inc on line 120

Warning: Can't open file: 'watchdog.MYI' (errno: 145) query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Can't open file: 'watchdog.MYI' (errno: 145)\nquery: SELECT w.*, u.name, u.uid FROM watchdog w INNER JOIN users u ON w.uid = u.uid ORDER BY w.wid DESC LIMIT 0, 50 in /home/MYDOMAIN/public_html/includes/database.mysql.inc on line 120.', 2, '', 'http://www.MYDOMAIN.com/?q=admin', 'http://www.MYDOMAIN.com/update.php?op=finished', '87.221.8.50', 1175607806) in /home/MYDOMAIN/public_html/includes/database.mysql.inc on line 120

Can somebody help me in this?

Thank you in advance for any assistance
--
Albert

Comments

quickshare’s picture

It seems like your watchdog table is corrupt.

Login and try and repair the table with:

REPAIR TABLE watchdog;
albertc’s picture

Thank you, quickshare. Your suggestion did the trick. It's good to have knowledgeable people around.
--
Albert

raj47i’s picture

I had the same problem.
And yes the table corruption was the reason.

thanks alot for the post

cosmoty’s picture

I had the same problem. Thanks.