What’s going on with WordPress?
Tuesday, December 19th, 2006 | Life
I logged on to my blog to post today to find I got some error about my database.
WordPress database error: [Can’t open file: ‘blog_comments.MYI’ (errno: 144)]
SELECT COUNT(*) FROM blog_comments WHERE comment_approved = ‘0’
Corrupt table but I couldn’t go into phpMyAdmin to repair it and it errored out. So I had to go in to the command line and repair it that way.
mysql -u dbuname -h dbhost -p dbname;
repair table blog_comments;
Which sorted it and I could finally log in. To find 148 comments had got past Akismet in the past few days. Awesome.
I logged on to my blog to post today to find I got some error about my database.
WordPress database error: [Can’t open file: ‘blog_comments.MYI’ (errno: 144)]
SELECT COUNT(*) FROM blog_comments WHERE comment_approved = ‘0’
Corrupt table but I couldn’t go into phpMyAdmin to repair it and it errored out. So I had to go in to the command line and repair it that way.
mysql -u dbuname -h dbhost -p dbname; repair table blog_comments;
Which sorted it and I could finally log in. To find 148 comments had got past Akismet in the past few days. Awesome.