Beginning this morning, my site was loading with the following error message at the top:
Database error: [Can't open file: 'wp_comments.MYI'. (errno: 145)] SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (799,798,795,794,793,792,791,790,788,787) GROUP BY ID
And the following error messages after each post:
Database error: [Can't open file: 'wp_comments.MYI'. (errno: 145)] SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 798 AND comment_approved = '1';
Database error: [Can't open file: 'wp_comments.MYI'. (errno: 145)] SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = 798 AND comment_approved = '1'
with all the comment counts set to zero. I get the same error messages when I attempt to leave a comment, view comments, or go to the WP comment maintenance panel.
I'm not sure how to access the wp_comments.MYI file or, once I do, how to fix it.
