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

“3546 comments waiting for moderation”

sucuri long Fight wordpress spammer

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

oc Fight wordpress spammer

2. Pick one database to deal with.

oc2 Fight wordpress spammer

3. Click on ‘Query’ link.

oc3 Fight wordpress spammer

4. type this command :

oc4 Fight wordpress spammer

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.

hg Fight wordpress spammer

Related posts:

  1. How to delete spam from wordpress
  2. Install wordpress for home development : configure axigen email server part 1
  3. Install wordpress blog : shell way
  4. How to Backup WordPress Database
  5. Test install WordPress 2.7 Beta 2 : step by step

Sorry, the comment form is closed at this time.

   
© 2011 Hosting Formula Suffusion theme by Sayontan Sinha