Wordpress errors
Recently i could not see my comments in my wordpress blog.All that i got was this error below
[Can't open file: 'wp_comments.MYI' (errno: 144)]
SELECT * FROM wp_comments WHERE comment_post_ID = ‘917′ AND ( comment_approved = ‘1′ OR ( comment_author = ‘Idyllopus’ AND comment_author_email = ‘myemailaddresshere’ AND comment_approved = ‘0′ ) ) ORDER BY comment_date
it was quite ugly and i even thought about reinstallation until i got a solution
Follow these steps and trust me it works .
ssh user@wordpresshost
mysql -u musqluser -h mysqlhost -p
enter your passwd (mysql passwd)
and change to db by
use wordpress ;
then just type in
mysql> REPAIR TABLE wp_comments ;
Technorati Tags: mysql, wordpress
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.
Iam Theyagarajan S ( 'taggy') . to know more ,head out to
In US it is wow goldpossible… but not in India where less than 10% of the population have access to the computers.
In my own experience, users that switch from MT to WP find their RSS feeds are more often than not invalid, whereas MT was almost always valid RSS. Don’t use any non-standard characters. Also, you’ll have to stay on top of the security upgrades of WP as it has lots of security holes, whereas upgrades to MT are very rare. Hope this helps!