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

How Do You Remove 174 Pages Of Comments Quickly In WP?

Discussion in 'Blogging' started by James2, Jul 5, 2013.

  1. James2

    James2 Senior Member

    Joined:
    Jun 3, 2011
    Messages:
    1,133
    Likes Received:
    994
    Location:
    London, England
    Some helpful fellow has spammed my WP site with over 3000 comments. I can only see a way to bulk move them to trash a page at a time. Thing is there is 174 pages and that will be a pain in the rectum to deal with.

    Thanks guys,

    James :)
     
  2. warner410

    warner410 Regular Member

    Joined:
    Jul 28, 2012
    Messages:
    376
    Likes Received:
    172
    One option is to directly edit the database.

    That's how I manage spam that my web directory gets.
     
    • Thanks Thanks x 1
  3. James2

    James2 Senior Member

    Joined:
    Jun 3, 2011
    Messages:
    1,133
    Likes Received:
    994
    Location:
    London, England
    Nice one, I shall try that.

    James :)
     
    • Thanks Thanks x 1
  4. warner410

    warner410 Regular Member

    Joined:
    Jul 28, 2012
    Messages:
    376
    Likes Received:
    172
    If you don't have much experience with databases, back up first.
     
    • Thanks Thanks x 1
  5. SmartMan

    SmartMan BANNED BANNED

    Joined:
    Jul 25, 2012
    Messages:
    673
    Likes Received:
    1,244
    You can try any of the following plugins to remove the spammy comments.

    Code:
    http://wordpress.org/plugins/delete-all-comments/
    http://wordpress.org/plugins/delete-pending-comments/
    
    Or by using phpMyAdmin in your control panel.

    Let me know if you're able to clean up the comments with just the plugins. If not, I'll write you the guide on how to do it with phpMyAdmin.
     
    • Thanks Thanks x 3
  6. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,063
    Likes Received:
    2,872
    Gender:
    Male
    Go to your SQL browser and enter this (edit the ID, change the prefix if necessary )
    Code:
    DELETE FROM `wp_comments` WHERE  `comment_post_ID` = YOUR_POST_ID
     
    • Thanks Thanks x 3
    Last edited: Jul 5, 2013
  7. James2

    James2 Senior Member

    Joined:
    Jun 3, 2011
    Messages:
    1,133
    Likes Received:
    994
    Location:
    London, England
    Great answers, thanks everyone. I removed my thanks by mistake gog01, sorry man.

    James :)
     
    • Thanks Thanks x 1
  8. SmartMan

    SmartMan BANNED BANNED

    Joined:
    Jul 25, 2012
    Messages:
    673
    Likes Received:
    1,244
    No worries. I just gave it to him on behalf of you. Cheers :)
     
    • Thanks Thanks x 2
  9. James2

    James2 Senior Member

    Joined:
    Jun 3, 2011
    Messages:
    1,133
    Likes Received:
    994
    Location:
    London, England
    Cheers! now I can't see the thanks button to thank you for thanking him lol WTF!
     
  10. Junkfood00

    Junkfood00 Elite Member

    Joined:
    Sep 13, 2011
    Messages:
    1,949
    Likes Received:
    1,336
    You go to the comments page and drop-down Screen Options, then you write "500" and click Apply. Now select all and delete, repeat 6 times.
     
    • Thanks Thanks x 1
  11. James2

    James2 Senior Member

    Joined:
    Jun 3, 2011
    Messages:
    1,133
    Likes Received:
    994
    Location:
    London, England
    Theres no option to thank you mate, must of used my quota. Soz.

    James :)
     
  12. SpookSEO

    SpookSEO Senior Member

    Joined:
    Dec 15, 2012
    Messages:
    848
    Likes Received:
    180
    Occupation:
    Linkbuilder
    Location:
    London, UK
    Home Page:
    Select all then trash.
     
    • Thanks Thanks x 1
  13. kvmcable

    kvmcable Supreme Member

    Joined:
    Dec 28, 2010
    Messages:
    1,355
    Likes Received:
    2,815
    Occupation:
    24 year business owner - old school dude
    Location:
    KFC - BW3
    Nuke Pig plugin - oink, oink ;)
     
    • Thanks Thanks x 3
    Last edited: Jul 5, 2013
  14. Danny1111

    Danny1111 Elite Member

    Joined:
    Jul 5, 2011
    Messages:
    2,096
    Likes Received:
    2,480
    Just make a Ubot Bot - with an input for Site Access - User/Password and How Many Pages to Delete (Check Box/Delete Check box/Delete - you get the picture)

    So you can use it for any Site you need it done on .. I make these type of Bots all the time for these type of repetitive tasks.
     
    • Thanks Thanks x 1
  15. tresm

    tresm Newbie

    Joined:
    May 19, 2012
    Messages:
    45
    Likes Received:
    23
    Location:
    The Netherlands
    Personally I use the Akismet plugin - it's really great!
     
    • Thanks Thanks x 1
  16. James2

    James2 Senior Member

    Joined:
    Jun 3, 2011
    Messages:
    1,133
    Likes Received:
    994
    Location:
    London, England
    Dank u wel :)
     
  17. metalfreek

    metalfreek Junior Member

    Joined:
    May 21, 2010
    Messages:
    139
    Likes Received:
    58
    This should work.
     
    • Thanks Thanks x 2
  18. back2form

    back2form Jr. VIP Jr. VIP Premium Member

    Joined:
    Jul 15, 2012
    Messages:
    2,682
    Likes Received:
    1,203
    Gender:
    Male
    Location:
    in front of imac
    I guess, all the above information works out.. No need anyone's help.. This what we were using to get all the pending comments removed at once -
    HTML:
    http://wordpress.org/plugins/delete-pending-comments/
    
    
    
    
    
    
     
    • Thanks Thanks x 1
  19. hotguy640

    hotguy640 Senior Member

    Joined:
    Mar 4, 2012
    Messages:
    1,059
    Likes Received:
    189
    Location:
    Nepal, KTM
    What if you don't delete comments.???
    I have some site with more then 500+ spam comments???
     
    • Thanks Thanks x 1
  20. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,063
    Likes Received:
    2,872
    Gender:
    Male
    Very soon, your db gets corrupted due to the comment table getting huge.
     
    • Thanks Thanks x 4