Continuing the discussion from Edit a user setting for all Discourse users : [image] Edit a user preference for everyone or a subset of users So you want to edit user setting for all Discourse users? Great! So, I did this in my forum - I sent a nice email explaining what’s up, and just did it. …

I don’t know how risky it is to change the default values in the DB. It doesn’t seem terribly dangerous to me, but I’m not sure. Any comment on this @sam ?

Well, at that point, anything else that @watchmanmonitor could have possibly done would break too, so I think this is a good solution :slight_smile:

Ha ha ha ha ha. So true. I’m just doing what i have to til this cow comes home: [image] Default email settings for a new user @sam I agree with this, can you add a system setting to make “mailing list mode” on for all users if the admin wants it that way?

[image] watchmanmonitor: alter table only users alter column email_always set default true; Is there a reason I wouldn’t include this in an exec custom command in app.yml? - exec: sudo -u postgres psql -d discourse -c "alter table only users alter column email_private_messages set default fa…

[image] iolo: Is there a reason I wouldn’t include this in an exec custom command in app.yml? There are two: I didn’t know you could do that. This is a one time, ever, action, so I wouldn’t want it to be done on every rebuild (or whatever docker process which might call that command)

Well, you might, if the rebuild changed it back..

That was my thinking, that and that automating it will make my life easier.

I wonder, as we move another database from self hosted to Discourse hosted, what is the best plan to ensure our users start out in Mailing list mode?

The problem there is that the ability to do low level things like this is taken away when you move to external hosting. Internal and external hosting both come with pros and cons but to sum it up, its an inverse relationship between your ability to do things vs your potential to break things.

Setting defaults to enable mailing list mode-Temporary Solution

Product Support

sam (Sam Saffron) Février 25, 2015, 1:58 3

It should be fine, does not sound terribly risky but may eventually break if we refactor schema.

Sujet		Réponses	Vues
Default email settings for a new user Feature email	42	11987	Août 21, 2015
Tutorial for using Discourse over Email? Self-hosting	3	1880	Mars 12, 2019
"mailing list mode" mysteriously deactivated Product Support	13	2174	Mars 17, 2021
Bulk change user settings Product Support	1	1667	Mars 31, 2017
Completely disable mailing list mode? Feature	20	6208	Janvier 2, 2017

Setting defaults to enable mailing list mode-Temporary Solution

Sujets connexes