WordPress.org

1. ButterflyHerder
   Member
   Posted 2 years ago #

   Hi there -

   I just inherited a client from another web designer. He hadn't updated the client's WP for about 3 years. I just finished doing the updated, but now there are (literally) 38,768 spam comments that I'd like to delete.

   Is there a way to do it quickly?

   So far, I've only been able to delete 20 comments at a time.

   Any ideas?

   Thanks!
   Cynthia

2. mrmist
   Forum Janitor
   Posted 2 years ago #

   Press the "Delete all spam" button?

3. ButterflyHerder
   Member
   Posted 2 years ago #

   Tried that... unfortunately, the spam comments are still in the "pending" category. So it hasn't really classified them as spam yet.

4. mrmist
   Forum Janitor
   Posted 2 years ago #

   If you want to delete all pending comments you can use phymyadmin or the mysql client to run

   delete from wp_comments where comment_approved = 0

Topic Closed

This topic has been closed to new replies.