Quantcast MySQL query to disable comments on WordPress posts/pages - digitalFAQ Forum
  #1  
10-02-2011, 06:07 PM
admin's Avatar
admin admin is offline
Site Staff | Web Development
 
Join Date: Jul 2003
Posts: 4,363
Thanked 598 Times in 443 Posts
The settings in WordPress to disable comments on posts (and pages) are not retroactive.
Only new posts/pages will have commenting disabled.

To disable comments on all existing pages and posts, run this MySQL query from your database manager.
Code:
UPDATE wp_posts SET comment_status="closed";
Many people use teh free (but lousy) phpMyAdmin, but we suggest the $99 SQLyog Enterprise Manager.
It works better, and it makes like easier.

Hope this helps.

- Did this site help you? Then upgrade to Premium Member and show your support!
- Also: Like Us on Facebook for special DVD/Blu-ray news and deals!
Reply With Quote
Someday, 12:01 PM
admin's Avatar
Ads / Sponsors
 
Join Date: ∞
Posts: 42
Thanks: ∞
Thanked 42 Times in 42 Posts
Reply




Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL query to change thread icons in vBulletin admin Website and Server Troubleshooting 1 05-10-2014 09:27 PM
Remove thread subscription for user via admincp (vBulletin), with SQL query admin Website and Server Troubleshooting 0 06-25-2011 04:02 AM
Block WordPress Spam: How to deny comments to non-referrer traffic kpmedia Website and Server Troubleshooting 0 07-25-2010 10:06 PM
More pages per page in WordPress admin kpmedia Website and Server Troubleshooting 0 01-03-2010 10:39 PM
Comments on new Menu? gwors Author, Make Menus, Slideshows, Burn 2 06-05-2005 09:25 PM

Thread Tools



 
All times are GMT -5. The time now is 04:16 AM