Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By albertc on
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
It seems like your watchdog
It seems like your watchdog table is corrupt.
Login and try and repair the table with:
Corrupted table, indeed
Thank you, quickshare. Your suggestion did the trick. It's good to have knowledgeable people around.
--
Albert
same prob.
I had the same problem.
And yes the table corruption was the reason.
thanks alot for the post
Thanks four your comment.
I had the same problem. Thanks.