wordpress Blank page after posting a comment (wp-comment-post.php)

Blogging, Tips and Tricks, TroubleShoot, Wordpress

• If you try to back up your database, you’ll be thrown with this error message – wp_comments is marked as crashed and should be repaired when using LOCK TABLES
• Recent comments widget appears blank.
• Top commenter widget appears blank.
• Comment posted will not be written into DB, therefore will not be shown.
• Comments section in WP Admin appears to have zero records.

After searching the Internet high and low in hoping to find similar cases to help me identify and fix the problem, I end up with nothing. I found this solution finally on hongkiat website. Thanx a ton to him. Below is the cause and solution to the problem. Plz Leave Comment If you Like the post…

The fix / Solution

2. Click ‘databases’

3. Tick the check box against the table wp_comments

4. Scroll all the way down and look for ‘With selected‘ drop-down box. Select Repair table and things should be alright.

Now you have repaired your table and your comment should work fine now.

Plz do Leave Comment If your problem is solved… If not follow instructions below…

In case your storage engine does not support repair table then go through following steps:

Before going further ahead, Please take a backup of your database. Beacause you may loose all the comments posted till now on your blog.

After following first two steps from above procedure,

3. Click on SQL on top of Table List

4. You will get the window similar to this6

5. On the text window type following query and click on ‘go’ button.

DROP TABLE IF EXISTS `wp_comments`;
CREATE TABLE `wp_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL auto_increment,
  `comment_post_ID` int(11) NOT NULL default '0',
  `comment_author` tinytext NOT NULL,
  `comment_author_email` varchar(100) NOT NULL default '',
  `comment_author_url` varchar(200) NOT NULL default '',
  `comment_author_IP` varchar(100) NOT NULL default '',
  `comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
  `comment_content` text NOT NULL,
  `comment_karma` int(11) NOT NULL default '0',
  `comment_approved` varchar(20) NOT NULL default '1',
  `comment_agent` varchar(255) NOT NULL default '',
  `comment_type` varchar(20) NOT NULL default '',
  `comment_parent` bigint(20) NOT NULL default '0',
  `user_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`comment_ID`),
  KEY `comment_approved` (`comment_approved`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
 

6. You will receive message that the query was successful.

Your comments should be working fine now.

If this does not work for you, try this: (thanks to Matthew Ogston for this)

Plz Leave Comment If you Like the post…