WordPress Ideas » Topic: Turn comments on/off for multiple posts at once.

heimtrainerkaufen on "Turn comments on/off for multiple posts at once."

heimtrainerkaufen — Sun, 22 Jan 2017 14:28:33 +0000

Wow, Thank you very much Matt!
You really, really helped me.
I was looking for instructions (just like yours now) for hours!
: )

Ipstenu (Mika Epstein) on "Turn comments on/off for multiple posts at once."

Ipstenu (Mika Epstein) — Wed, 26 Oct 2016 16:28:58 +0000

Once you run the plugin (or the SQL command) and then change the settings to disallow comments, you can uninstall the plugin and never use it again.

The point of the plugin is to close all existing posts :)

pavillonkaufenfreak on "Turn comments on/off for multiple posts at once."

pavillonkaufenfreak — Wed, 26 Oct 2016 06:35:42 +0000

dashrath009,

thank you very much for this helpfull information. I have implemented this solution and it fixed my problem. So, if you have access to the database, this is the quickest way to disable the comments globally. You can use also the disable comments plugin samir shah .
But with the plugin, you have one more plugin to update every time. It is your choice. :)

Regards

dashrath009 on "Turn comments on/off for multiple posts at once."

dashrath009 — Tue, 18 Oct 2016 07:16:40 +0000

If someone has access to database and need to enable or disable comments on all posts then executing query is a straight option :

TO enable comments, execute :
UPDATE wp_posts SET comment_status = 'open' WHERE post_type='post'

TO disable comments, execute :
UPDATE wp_posts SET comment_status = 'closed' WHERE post_type='post'

This will enable/disable comments from all posts.

oora on "Turn comments on/off for multiple posts at once."

oora — Thu, 29 Sep 2016 06:08:45 +0000

Thanks this still work great, however if you have hundreds or thousands post that need to be changed you still need do it page by page.
If you have 500 posts and each page displaying 100 posts, then you will need to it 5 times.
Still saving a lot off times, thanks Matt.

cricketoutlook on "Turn comments on/off for multiple posts at once."

cricketoutlook — Fri, 17 Oct 2014 18:17:00 +0000

Nice job @matt thanks you saved my head from blowing up and after a lot of head ache i got here across this plan . This really helped to get rid of comment/pings from spam farms. Thanks

Ipstenu (Mika Epstein) on "Turn comments on/off for multiple posts at once."

Ipstenu (Mika Epstein) — Mon, 01 Sep 2014 17:13:25 +0000

The current default setting option (which there is) turns it off for all future posts. The retroactive stuff is hard, because people's opinion on do we change what's expceted now or not is very touchy.

Paal Joachim Romdahl on "Turn comments on/off for multiple posts at once."

Paal Joachim Romdahl — Mon, 01 Sep 2014 06:20:26 +0000

I am thinking down the road this could also be added to the default Settings options. As it could become more accessible. Doing a bulk edit is not that intuitive.

khalm on "Turn comments on/off for multiple posts at once."

khalm — Thu, 17 Jul 2014 22:30:37 +0000

Respect!
You safed me a lot of time, great job!

andypersons on "Turn comments on/off for multiple posts at once."

andypersons — Tue, 17 Jun 2014 06:12:04 +0000

Thanks Matt! I looked to Turn comments off comments for old posts, but because I didn't find the option I just enables users to submit comments....Thanks!