Root out hidden comments?

  • darrell_rushhour

    (@darrell_rushhour)


    10 years, 2 months ago

    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

    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

    (@jomsky)

    10 years, 2 months ago

    For your Google problem, you can request for a malware review. Follow this guide: 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/

    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

    (@darrell_rushhour)

    10 years, 2 months ago

    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.