Title: wp_comments table, comments missing
Last modified: August 19, 2016

---

# wp_comments table, comments missing

 *  [checktherhime](https://wordpress.org/support/users/checktherhime/)
 * (@checktherhime)
 * [16 years, 8 months ago](https://wordpress.org/support/topic/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-php](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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [checktherhime](https://wordpress.org/support/users/checktherhime/)
 * Last activity: [16 years, 8 months ago](https://wordpress.org/support/topic/wp_comments-table-comments-missing/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics