14th April 2007 is a very special day for my website 100rupees.com. Today it was finally indexed by google after the long delay of 5 and half months. While I was celebrating this grand occasion I saw a series of errors when I logged into my admin account.

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

It was real shocking moment for me as it was probably the first error I encountered with this drupal powered website. Suddenly I got an idea, I started checking the table of watchdog through phpmyadmin. And there I got the answer. The table was corrupted, now the solution was simple I run “REPAIR TABLE watchdog;” in the query window of phpmyadmin. This command did the trick and watchdog table was restored. Now there was not any error on my site.  :-)