Forums
Forums / Fixing WordPress / WordPress database error
(@fredsilva)
17 years, 8 months ago
Can anyone help me? I’ve just recently been receiving the following messages:
WordPress database error: [Can’t open file: ‘wp_comments.MYI’ (errno: 144)] SELECT COUNT(*) FROM wp_comments WHERE comment_approved = ‘0’
WordPress database error: [Can’t open file: ‘wp_comments.MYI’ (errno: 144)] SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_approved = ‘spam’
And now no comments are posted and old comments can’t be viewed.
(@whooami)
thats a corrupt table. With whatever your host makes available for accessing your MySQL databse(s) you will need to repair that table.
Any ideas on how to go about repairing that table?
(@tsukiyono)
If you have the WP-DBManager plug-in installed, you can repair and back-up databases with it.
I have WP-Database Backup activated. Is that the same as: WP-DBManager?
The topic ‘WordPress database error’ is closed to new replies.
(@fredsilva)
17 years, 8 months ago
Can anyone help me? I’ve just recently been receiving the following messages:
WordPress database error: [Can’t open file: ‘wp_comments.MYI’ (errno: 144)]
SELECT COUNT(*) FROM wp_comments WHERE comment_approved = ‘0’
WordPress database error: [Can’t open file: ‘wp_comments.MYI’ (errno: 144)]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_approved = ‘spam’
And now no comments are posted and old comments can’t be viewed.