digitalFAQ.com Forum

digitalFAQ.com Forum (http://www.digitalfaq.com/forum/)
-   Website and Server Troubleshooting (http://www.digitalfaq.com/forum/web-tech/)
-   -   MySQL query to disable comments on WordPress posts/pages (http://www.digitalfaq.com/forum/web-tech/3559-mysql-query-disable.html)

admin 10-02-2011 06:07 PM

MySQL query to disable comments on WordPress posts/pages
 
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. :thumb:


All times are GMT -5. The time now is 02:42 AM

Site design, images and content © 2002-2020 The Digital FAQ, www.digitalFAQ.com
Forum Software by vBulletin · Copyright © 2020 Jelsoft Enterprises Ltd.