WordPress Database Error
I’m experiencing an interesting problem on one of my other blogs. The software I use for all my blogs is Wordprsss. I like it’s ease of install and plugin finctionality. It’s also very easy to manage. But when I logged in to check on comments on the other blog I got the following error:
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’
I did some digging around on this issue and learned from someones bad experience that there is a quick and easy way to resolve the issue.
My provider uses cPanel for allowing it’s users control of their domains. If you go into the “MySQL® Databases” section of cPanel you’ll see a list of any databases you have created along with some options and the connection strings your Perl and PHP scripts need to use to connect to the databases. You can ignore most of it. All you need is the name of the database for the blog that is giving you this error. If you don’t know it you can get it out of the wp-config.php file in your WordPress install directory. (Hint: You’re looking for what is said right after you see ‘DB_NAME’.) Look in cPanel for the database you’re having the problem with and then click the link labeled “Repair”. Now wait. Your browser will work for a while. Do not close it or go to another page. Just leave it alone and let it work. When it’s done you should be ok. Do whatever it was that lead you to discover the error and you should see that the error no longer occurs.
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.