1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Mass Deleting Pending Comments

Discussion in 'WordPress' started by Ajeet, Mar 7, 2010.

  1. #1
    Hi,

    I have hundreds of comments in WP that are awaiting moderation. And I believe that they are all trash. How do I delete them all in one go. If I go through the dashboard, I can delete 20 of them at a time!

    Thanks
    Ajeet
    SEMrush
     
    Ajeet, Mar 7, 2010 IP
    SEMrush
  2. bob25

    bob25 Well-Known Member

    Messages:
    1,519
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    128
    #2
    If you use the default Askimet plugin that's already uploaded for you you can set it to delete posts older than 30 days. That way you can just check the latest posts and the older ones are automatically deleted.
     
    bob25, Mar 7, 2010 IP
    Ajeet likes this.
  3. digitalworkstation

    digitalworkstation Peon

    Messages:
    11
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Go to your cpanel and open phpmyadmin and run these Query :

    delete from wp_comments where comment_approved = '0'
     
    digitalworkstation, Mar 10, 2010 IP
    Ajeet likes this.
  4. SEO4hire

    SEO4hire Active Member

    Messages:
    976
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    80
    #4
    I found a great plugin awhile back for pending comments that pile up. You can download it HERE.
     
    SEO4hire, Mar 10, 2010 IP
  5. arpitagarwal82

    arpitagarwal82 Notable Member

    Messages:
    2,996
    Likes Received:
    398
    Best Answers:
    0
    Trophy Points:
    230
    #5
    Activate askimet. add askimet API. and then click check for spam button on comment page.
    Askimet will check all pending comments and will delete the spam ones.
     
    arpitagarwal82, Mar 12, 2010 IP
    Ajeet likes this.