I have around 1700 pending comments on my website, the majority of which are spam. I thought about just blocking them by IP (wp-ban plugin) or using the comment blacklist feature. However, all the IPs are different. Email addresses? All different. Author names? All different. Content of the message? All different. Every single message is unidentical to another in every way and I am getting fed up of them coming constantly. I don’t want to have to delete 85 pages worth of pending comments (even through the select all on page checkbox) and I don’t want to accidently delete a legitimate comment.
I have now just activated the Akismet plugin. Will tell you how it does. In the mean time, can anyone suggest on how to delete all the 1700 pending spam comments at once (I have access to phpMyAdmin etc.)
After installing Akismet, go to your edit comments page, at the bottom of the page there should be a “Check for Spam” button. That button will use Akismet to go through all of your pending comments and clean out the spam.
Then after that you should be able to filter your comments to see just spam and get rid of them with the “Delete All Spam”.