Spam Comments on Wordpress

c213253

c213253

Newbie
Joined
May 10, 2014
Messages
35
Reaction score
2
I have been seeing that lot of spam comments are added in wordpress site. These are comments on blogposts with certain kind of backlinks in them.

How can i get rid of them?

Also, how do i delete them, especially if i have lakhs of comments over the time.
 
Advertise on BHW
You just select and delete them.

In Discussion section there is a checkbox "users must be registered to comment". Tick that and comment boxes will be gone from whole website, unless visitor registers.
 
You can either choose to moderate them beforehand or completely turn off the comment section
 
Akismet plugin works well for anti-spam for me
 
Aksimet isn't free i guess. I know that lot of these comments (in 1000s) have website URL in them, so i can delete them using the searching the URL. But, i need a plugin which helps me in finding such comments with rules, and helping me deleting them manually in bulk.
 
You should delete them one by one and maybe put commenting off
 
c213253 said:
Aksimet isn't free i guess. I know that lot of these comments (in 1000s) have website URL in them, so i can delete them using the searching the URL. But, i need a plugin which helps me in finding such comments with rules, and helping me deleting them manually in bulk.
Click to expand...
Thousands you can easily delete, millions of comments and you don't want to buy aksimet the most likely the site itself is spam site making no money. Just turn off comments and be done with them.
Or get a nulled copy of a anti spam plugin (I hate to suggest this but here it is).
 
Thanks for the inputs. Will find a workaround for this.

smiley-face.jpg
 
The easiest way to do this is to truncate the comments table directly from db. Takes less than 5 seconds.
 
BlurryBit said:
The easiest way to do this is to truncate the comments table directly from db. Takes less than 5 seconds.
Click to expand...
How can i do this?

There are actually thousands of comments spread over hundreds of pages.
 
c213253 said:
How can i do this?

There are actually thousands of comments spread over hundreds of pages.
Click to expand...
Login to phpmyadmin (you use cpanel? search for phpmyadmin in it).

Then select the db from the left sidebar.
Look for the query textarea.

Type something like:

TRUNCATE TABLE wp_comments;


Hit the query button (forgot the text of the button lol sorry, but it will be obvious when you see the textarea), and wait for a few seconds. That will do it, and show you the count of comments deleted.

If you have a different db prefix, change wp to that prefix, e.g. abcd_comments.

Also, be sure to not play with phpmyadmin other than doing this. It can seriously fuck things up if you run a wrong command.

The command I gave you is safe for the comments table only.


Edit: Oh btw, I assumed that you don’t need any of the comments. If you need some of them, the query will be different. This query will delete ALL comments from that table and reset the auto id.
 
Last edited:
To get rid of spam comments in WordPress, install an anti-spam plugin, enable comment moderation, and use CAPTCHA or reCAPTCHA. To delete a large number of comments, install a bulk delete plugin and configure it to delete comments based on specific criteria.
 
BlurryBit said:
Login to phpmyadmin (you use cpanel? search for phpmyadmin in it).

Then select the db from the left sidebar.
Look for the query textarea.

Type something like:

TRUNCATE TABLE wp_comments;


Hit the query button (forgot the text of the button lol sorry, but it will be obvious when you see the textarea), and wait for a few seconds. That will do it, and show you the count of comments deleted.

If you have a different db prefix, change wp to that prefix, e.g. abcd_comments.

Also, be sure to not play with phpmyadmin other than doing this. It can seriously fuck things up if you run a wrong command.

The command I gave you is safe for the comments table only.


Edit: Oh btw, I assumed that you don’t need any of the comments. If you need some of them, the query will be different. This query will delete ALL comments from that table and reset the auto id.
Click to expand...
This worked. Only that i had to spend hours together to delete 2,00,000+ comments with 500 at a time. That was the limitation from phpadmin, unless i deleted the complete database.
 
c213253 said:
This worked. Only that i had to spend hours together to delete 2,00,000+ comments with 500 at a time. That was the limitation from phpadmin, unless i deleted the complete database.
Click to expand...
You could simply execute
Code: 
TRUNCATE TABLE wp_comments;
Code: 
https://www.javatpoint.com/mysql-truncate-table
 
c213253 said:
Aksimet isn't free i guess. I know that lot of these comments (in 1000s) have website URL in them, so i can delete them using the searching the URL. But, i need a plugin which helps me in finding such comments with rules, and helping me deleting them manually in bulk.
Click to expand...
You can make one by hiring a dev.
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top