• 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???

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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.

    Deleted rows: 10622 (Query took 2.0352 sec)

    Thank you!!!!!!!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘9k posts’ is closed to new replies.