• 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-php

    I’m certain this particular part was the source of the current issue.

    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;

The topic ‘wp_comments table, comments missing’ is closed to new replies.