in wordpress

Spam comments problem solving in WordPress

1, mass delete the spam comments at the back end of the WordPress.

After setup the WordPress blog for quite a while, there were many spam comments everyday, I needs to delete them manually, but after quite a while since I didn’t log in to the back end system, found there are more than 5000 spam comments, it is impossible to delete it manually, searched on the internet, found the SQL command to delete it at once, log in to PHPmyadin, using the sql command as following,

DELETE FROM sh_comments WHERE  comment_approved = '0'

2, to stop the spam comments, installed the plug-in Fancy Captcha, needs to do some manual work to make the comments, this will stop all the robot comments.

Fancy Captcha

Write a Comment