I have something like 10000 comments. They are probably all spam except for one or two.
And they are all waiting for me to approve them. Is there a free solution to this issue?
Thank you!
How to deal with spam comments and distinguish them from non-spam comments?
Delete them all. I donât think a few comments are worth so much of your time.
To clean up the entire table, open a SQL console (the plugin Adminer has an UI for that) and type:
You might have to change the name if you are using an other prefix than
wp_.Or ⦠you could use an existing anit-spam plugin with open source (Antispam Bee and/or T5 Spam Block for example) and run all your comments through their filters. In a secound round, find all IP addresses marked as spam already and delete all comments with matching IP addresses.
That should cover most of the spam.
You can simply delete them all for the first time and make your WordPress spam prof by tweaking the basic settings. WordPress has an advanced configuration for handling comments. Alternatively, you can utilize some plugins like Akismet to automatically detect and destroy spam comments from your WordPress blog.
You can also copy and paste the code below to your .htaccess file:
RewriteEngine On RewriteCond %{REQUEST_METHOD} POST RewriteCond %{REQUEST_URI} /wordpress/wp-comments-post.php RewriteCond %{HTTP_REFERER} !.*mydomain.org.* [OR] RewriteCond %{HTTP_USER_AGENT} ^$ RewriteRule (.*) http://%{REMOTE_ADDR}/$ [R=301,L]This will cover most of the spam comments.