13 {{ upvoteCount | shortNum }}
13 {{ upvoteCount | shortNum }}

Blog Spammed! How to Remove Massive amounts of comments

by IsaacWendt
10 replies
Hi Guys

Just wondering if anyone knows how to remove allot of spam comments I have about 12k and 20 at a time is just not happening for me lol. It's a word press blog is there a plugins or something that would be able to help me out?

All the comments have not been posted they are just waiting for approval, if that means anything???

Thanks Allot

Isaac
#amounts #blog #comments #massive #remove #spammed
  • Profile picture of the author ARVolund
    Originally Posted by IsaacWendt View Post

    Hi Guys

    Just wondering if anyone knows how to remove allot of spam comments I have about 12k and 20 at a time is just not happening for me lol. It's a word press blog is there a plugins or something that would be able to help me out?

    All the comments have not been posted they are just waiting for approval, if that means anything???

    Thanks Allot

    Isaac
    Easy peasy just access your database via phpmyadmin or if you do not have cpanel whatever interface your hosting company provides.

    Click on the databse, then click on the comments table , then go to the top and click on empty and then yes when it asks if you are sure.

    This will completely remove all your comments in one fell swoop.......
    {{ DiscussionBoard.errors[4209212].message }}
  • Profile picture of the author ARVolund
    Also if you have that many comments you need to readjust your settings some and close those comments quicker.
    {{ DiscussionBoard.errors[4209222].message }}
  • Profile picture of the author tpw
    You have a choice:
    • Remove all pending comments; or
    • Remove the spammers and leave the honest comments in place.

    Both require different solutions.

    If you are comfortable with PHP MyAdmin, then the following will remove all pending comments:

    Code:
    DELETE FROM `wp_comments` WHERE `comment_approved` = '0'
    Signature
    Bill Platt, Oklahoma USA, PlattPublishing.com
    Publish Coloring Books for Profit (WSOTD 7-30-2015)
    {{ DiscussionBoard.errors[4209401].message }}
  • Profile picture of the author Adam Roy
    First of all, go into your discussion settings and require all comments to be held for moderation before they go live.

    Second, use the askimet plug-in, it works really good. You won't even have to moderate 99% of the spam that comes through with this plug-in activated.
    Signature
    {{ DiscussionBoard.errors[4209436].message }}
  • Profile picture of the author Rich Struck
    Sorry for your trouble. Around here that is called "back linking" and it's perfectly acceptable to countless people on this board.
    Signature

    {{ DiscussionBoard.errors[4209462].message }}
    • Profile picture of the author tpw
      Originally Posted by Rich Struck View Post

      Sorry for your trouble. Around here that is called "back linking" and it's perfectly acceptable to countless people on this board.

      Haha!!! You are going to tee off some of those "professional" back linkers with talk like that!!! :rolleyes:

      I have a blog with 6 pages on it, that used to have 20k pending comments.

      Imagine what my site would have looked like if I had instead clicked, "Approve All"...
      Signature
      Bill Platt, Oklahoma USA, PlattPublishing.com
      Publish Coloring Books for Profit (WSOTD 7-30-2015)
      {{ DiscussionBoard.errors[4209484].message }}
  • Profile picture of the author webapex
    Relevant comments from actual readers can be good for ranking, fattens your content and update frequency rating.

    Robot generated flatter-span that makes no actual mention of the article content can harm your ranking, in some cases you can find a page starting to rank for fashion purses and viagra.
    Signature

    “An expert is a person who has made all the mistakes that can be made in a very narrow field” Niels Bohr

    {{ DiscussionBoard.errors[4209731].message }}
  • Profile picture of the author mijagi
    You cna also put captcha on comments to prevent future spam.
    Signature

    {{ DiscussionBoard.errors[4210909].message }}
  • Profile picture of the author Claire Sharp
    I have the same problem too. I hate when every time i checked my blog, a lot of spam comments i've seen.
    {{ DiscussionBoard.errors[4211691].message }}

Trending Topics