WordPress.org

Ready to get started?Download WordPress

Forums

comments
Comment count remains even after all comments deleted via SQL (2 posts)

  1. frommartawithlove
    Member
    Posted 1 year ago #

    I used the SQL command

    DELETE FROM wp_comments;

    to delete all comments from my friend's blog (I'm helping her switch from Blogger to WordPress and have set up her new site in a database on my domain until we're ready to launch).

    Though the comments have all been successfully deleted, if you view any of the posts, they still show the pre-deletion comment count (both on the site itself and in the Comments interface inside WordPress admin).

    How do I delete the comment count and start "fresh" with zero comments and zero showing for all comment counts?

    Thanks in advance for your help. I'm pulling my hair out.

    Here's an example of a post that has no comments but is showing a comment count of 37. They're all like this:

    http://frommartawithlove.com/ABGDatabase/woeful-wips/

  2. vtxyzzy
    Member
    Posted 1 year ago #

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic