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.

Wordpress spam comments deletion regarding

Discussion in 'Content Management' started by bcdxer, Dec 27, 2009.

  1. #1
    My wordpress blog have around 50000 spam comments waiting for moderation.
    How can i delete them in one go?
    These are due to before akimsat installation.
     
    bcdxer, Dec 27, 2009 IP
  2. internetmarketingiq

    internetmarketingiq Well-Known Member

    Messages:
    3,552
    Likes Received:
    70
    Best Answers:
    0
    Trophy Points:
    165
    #2
    Get WP Spam free and use it. You won't need askimet. Change your admin approval settings. Then get a free plug in called Admin Per Page. this lets you get around the default limits in WordPress.

    If you have a slow shared hosting account I'd suggest you not try to delete more than 200-400 at a time as your server might "hang".

    Good luck.
     
    internetmarketingiq, Dec 28, 2009 IP
  3. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #3
    is this with your own hosting or with wordpress.com ?

    if it with your own hostng just empty the wp_comments table :p ( all comments will be deleted)
     
    chandan123, Dec 29, 2009 IP
  4. BabBarDeL

    BabBarDeL Peon

    Messages:
    84
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Run the Following SQL command on your database DELETE FROM wp_comments WHERE comment_approved = '0' .
     
    BabBarDeL, Dec 29, 2009 IP