digitalFAQ.com Forum - MySQL query to disable comments on WordPress posts/pages

digitalFAQ.com Forum (https://www.digitalfaq.com/forum/)

- Website and Server Troubleshooting (https://www.digitalfaq.com/forum/web-tech/)

- - MySQL query to disable comments on WordPress posts/pages (https://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 05:46 AM