Fight wordpress spammer

Posted by admin on May 16, 2008 under Step By Step |

“3546 comments waiting for moderation”

Wow, all of them already in akismet handle. But I still looking more information why that spam can enter my blog. After see the pattern I think my old post get most of spam target.

The only way to prevent that spam is simple : closing comment

To edit each post just for deactivate comment is useless. I need rapid solution.

Step by step :

1. login to cpanel and click phpmyadmin

2. Pick one database to deal with.

3. Click on ‘Query’ link.

4. type this command :

That command mean :

update all posting where date posted less than January 10 2008 and posting status equal to publish.

Click ‘Submit Query’ and see the result. Your old post that meet the criteria no longer open for spammer.