9k posts (3 posts)

  1. ericgreer
    Posted 8 years ago #

    Okay, basically, above my comments tab is a little 'talk bubble' that says 9690 comments awaiting moderation.

    I want all of those to go away, because I just installed captcha and plan on using my blog again.

    is there a quick way to delete all comments waiting for moderation???

  2. MichaelH
    Posted 8 years ago #

    1. Backup your database.
    2. Make sure your database backup is good.
    3. Issue this SQL command in phpMyAdmin:
    DELETE FROM wp_comments WHERE comment_approved = 0

    If you comments table has different prefix than wp_ change accordingly.

  3. ericgreer
    Posted 8 years ago #

    Deleted rows: 10622 (Query took 2.0352 sec)

    Thank you!!!!!!!

Topic Closed

This topic has been closed to new replies.

About this Topic