Title: Root out hidden comments?
Last modified: August 31, 2016

---

# Root out hidden comments?

 *  [darrell_rushhour](https://wordpress.org/support/users/darrell_rushhour/)
 * (@darrell_rushhour)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/root-out-hidden-comments/)
 * I have a site that has been blacklisted by google due to some supposed links 
   to malicious sites. After a pretty thorough update of WP, plugins, theme, and
   scrubbing of the the database all security scans are coming back clean. However
   google still says the the like are there.
 * Something odd is in the Comments tab of the admin panel, All show (10) but Approved,
   Pending, Spam, and Trash all show (0).
 * See here: [https://www.evernote.com/l/AAr1EuF3nd9DM70dJTRtiv_RN7Bb0AedtEoB/image.png](https://www.evernote.com/l/AAr1EuF3nd9DM70dJTRtiv_RN7Bb0AedtEoB/image.png)
 * How can I root out these hidden 10 comments.
 * I’m running WP 4.4.2 with Canvas theme.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Joms](https://wordpress.org/support/users/jomsky/)
 * (@jomsky)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/root-out-hidden-comments/#post-7127116)
 * For your Google problem, you can request for a malware review. Follow this guide:
   [https://support.google.com/webmasters/answer/168328?hl=en](https://support.google.com/webmasters/answer/168328?hl=en)
 * As for the wrong comment count it’s probably caused by a comment plugin that 
   messed with the total amount of comments in your database. Try the fix here: 
   [http://beerpla.net/2010/03/21/how-to-diagnose-and-fix-incorrect-post-comment-counts-in-wordpress/](http://beerpla.net/2010/03/21/how-to-diagnose-and-fix-incorrect-post-comment-counts-in-wordpress/)
 * The SQL query that you’d want to run (where ‘wordpress’ is your database name):
 *     ```
       UPDATE wordpress.wp_posts wpp
       LEFT JOIN
       (SELECT comment_post_id AS c_post_id, count(*) AS cnt FROM wordpress.wp_comments
        WHERE comment_approved = 1 GROUP BY comment_post_id) wpc
       ON wpp.id=wpc.c_post_id
       SET wpp.comment_count=wpc.cnt
       WHERE wpp.post_type IN ('post', 'page')
             AND (wpp.comment_count!=wpc.cnt OR (wpp.comment_count != 0 AND wpc.cnt IS NULL))
       ```
   
 *  Thread Starter [darrell_rushhour](https://wordpress.org/support/users/darrell_rushhour/)
 * (@darrell_rushhour)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/root-out-hidden-comments/#post-7127219)
 * Thanks. I’ll try the SQL query.
 * I did have Disable Comments plugin and manually cleared out old ones via myPHP
   admin. Most likely that is not the issue with google.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Root out hidden comments?’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [darrell_rushhour](https://wordpress.org/support/users/darrell_rushhour/)
 * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/root-out-hidden-comments/#post-7127219)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics