wp_comments table, comments missing
-
My wp_comments is only showing 22 comments when I have over 2,000. When I look at the main page of my blog it’ll show “3 comments” on a post, but when I click the post I see no comments. When I go in my control panel I see only 22 comments. I’ve cleared my cache and cookies, and reverted to an old backup. Is there anyway to fix this? I have an old export file from about a week ago, but I’m under the assumption some changes need to be made to the wp_comments file because the backup (which was made before I began to have this problem) did not work.
I was having an issue where I’d try to view comments and I’d get a blank page so I used this tutorial, but it did not work.
http://www.princeblog.net/index.php/troubleshoot/wordpress-blank-page-after-posting-a-comment-wp-comment-post-phpI’m certain this particular part was the source of the current issue.
DROP TABLE IF EXISTS
wp_comments;
CREATE TABLEwp_comments(
comment_IDbigint(20) unsigned NOT NULL auto_increment,
comment_post_IDint(11) NOT NULL default ‘0’,
comment_authortinytext NOT NULL,
comment_author_emailvarchar(100) NOT NULL default ”,
comment_author_urlvarchar(200) NOT NULL default ”,
comment_author_IPvarchar(100) NOT NULL default ”,
comment_datedatetime NOT NULL default ‘0000-00-00 00:00:00’,
comment_date_gmtdatetime NOT NULL default ‘0000-00-00 00:00:00’,
comment_contenttext NOT NULL,
comment_karmaint(11) NOT NULL default ‘0’,
comment_approvedvarchar(20) NOT NULL default ‘1’,
comment_agentvarchar(255) NOT NULL default ”,
comment_typevarchar(20) NOT NULL default ”,
comment_parentbigint(20) NOT NULL default ‘0’,
user_idbigint(20) NOT NULL default ‘0’,
PRIMARY KEY (comment_ID),
KEYcomment_approved(comment_approved),
KEYcomment_post_ID(comment_post_ID),
KEYcomment_approved_date_gmt(comment_approved,comment_date_gmt),
KEYcomment_date_gmt(comment_date_gmt)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
The topic ‘wp_comments table, comments missing’ is closed to new replies.