May 162008
- Guarantee Web site malware removal (joomla, drupal, wordpress etc) - don't let your business get down due to virus, malware and blacklist problem.
- Recommended Web Hosting to help you doing business online with high performance. : Support ioncube, zend and all other hosting by default.
- Get free wordpress website transfer : up to 4 domains Find out more .... Click here to see other user testimonial
“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.
Related posts:

Sorry, the comment form is closed at this time.