dapurhosting.com Blog for Tech

December 13, 2011

Disable WordPress Spam Comment

Filed under: CMS — Tags: , — dh @ 5:15 am

UPDATE `wp_posts` SET `comment_status` = 'closed', `ping_status` = 'closed';
UPDATE `wp_options` SET `option_value` = 'closed' WHERE `option_name` = 'default_comment_status';
UPDATE `wp_options` SET `option_value` = 'closed' WHERE `option_name` = 'default_ping_status';
UPDATE `wp_options` SET `option_value` = '0' WHERE `option_name` = 'users_can_register';

RENAME TABLE wp_comments To wp_comments_spam;

Powered by WordPress