1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How can I delete all pending comments at once?

Discussion in 'Blogging' started by billsfan2012, Sep 26, 2012.

  1. billsfan2012

    billsfan2012 Regular Member

    Joined:
    Jan 3, 2012
    Messages:
    254
    Likes Received:
    116
    Occupation:
    Internet Marketer
    Location:
    United States
    Home Page:
    This might be a dumb question so I apologize in advance.

    At the same time, it would be an easy way to get some gratitude and a free Thanks! if you need a little boost for the day ;)

    I have 15,838 pending comments on my blog that i know are all garbage because I have used a comment exporter to fish out all the good ones (there were only 3).

    So I want to delete them all at once, but the only option I see only allows me to delete 1 page at a time.

    How can I do this?

    Thanks
     
  2. judson

    judson Power Member

    Joined:
    Nov 29, 2009
    Messages:
    530
    Likes Received:
    319
    Occupation:
    Fulltime Newbie IM
    Location:
    Sub Ubi
    when you are in yoursite.com/wp-admin/edit-comments.php

    Top right hand corner ... you will see a tab labelled Screen Options.

    Click on that, and you will get the option to change how many 'comments' you are viewing at any point.

    Set that to something high like 500, and then you can bulk delete.

    Pretty much the quickest way without installing any plugins.

    That said, Google for ... wordpress plugin delete pending comments ... you will see a couple of plugins that allow you to do just that.
     
    • Thanks Thanks x 2
  3. BlackxHat

    BlackxHat Power Member

    Joined:
    Oct 6, 2009
    Messages:
    591
    Likes Received:
    78
    wait what did you use extactly to fish out the good comments?
     
  4. billsfan2012

    billsfan2012 Regular Member

    Joined:
    Jan 3, 2012
    Messages:
    254
    Likes Received:
    116
    Occupation:
    Internet Marketer
    Location:
    United States
    Home Page:
    Thanks judson ... I knew the option had to be somewhere and I was looking right past it.

    Blackxhat: Used a plugin called "export comments" from
    wordpress.org/extend/plugins/export-comments/

    Next, exported all pending comments to csv, sorted them, browsed through quickly and when i found legit comments I went back to my WP comments page and search for either the person's e-mail or part of their comment and approved them.
     
    • Thanks Thanks x 1
  5. ber789

    ber789 Junior Member

    Joined:
    Mar 31, 2012
    Messages:
    160
    Likes Received:
    20
    The easiest way is through mysql or phpmyadmin. You can just go in and find the tables for the comments you want to delete and wipe them out. Just be sure to back up your database first.
     
  6. gcleats

    gcleats Junior Member

    Joined:
    Aug 29, 2009
    Messages:
    127
    Likes Received:
    5
    What do you use to filter the good comments!!!
     
  7. billsfan2012

    billsfan2012 Regular Member

    Joined:
    Jan 3, 2012
    Messages:
    254
    Likes Received:
    116
    Occupation:
    Internet Marketer
    Location:
    United States
    Home Page:
    What ber789 suggested OR by using the comment exporter tool that I mentioned:

    wordpress.org/extend/plugins/export-comments/
     
  8. Elamros

    Elamros Registered Member

    Joined:
    Sep 27, 2012
    Messages:
    60
    Likes Received:
    8
    Why do you want to delete the pending comments? Are they spam? You can use the Akismet plugin for wordpress. It's designed to filter spam comments. It comes free with wordpress free hosted site, but has a fee of about $5 per month for own domain with paid hosting sites running on wordpress.
     
  9. thenewguy1

    thenewguy1 Newbie

    Joined:
    Jul 24, 2009
    Messages:
    19
    Likes Received:
    3
    there is a plugin called delete pending comments that can do it real quick. hasn't been updated in a long time but still works.
    i use it on a few sites and love it.
     
  10. Kahoona

    Kahoona Newbie

    Joined:
    Sep 14, 2012
    Messages:
    31
    Likes Received:
    0
    Occupation:
    Director
    Location:
    England, UK
    If you know a little about PHP Myadmin, just one line of code does the trick, make sure you backup your database first however. Just run this command...

    DELETE FROM wp_comments WHERE comment_approved = 0


    but backup your database before doing so.
     
  11. staycoolmen2006

    staycoolmen2006 Regular Member

    Joined:
    Aug 5, 2010
    Messages:
    345
    Likes Received:
    147
    Home Page:
    just install wp-optimizer plugin... its all you need...