Wordpress spam comments deletion regarding

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

0
  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