Continuing the discussion from Edit a user setting for all Discourse users : [immagine] 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 …

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 ?

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

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: [immagine] 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?

[immagine] 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…

[immagine] 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

watchmanmonitor (Allen Hancock) 25 Febbraio 2015, 3:11am 5

Ha ha ha ha ha. So true.

I’m just doing what i have to til this cow comes home:

Argomento		Risposte	Visualizzazioni
Default email settings for a new user Feature email	42	12005	Agosto 21, 2015
Tutorial for using Discourse over Email? Self-hosting	3	1881	Marzo 12, 2019
"mailing list mode" mysteriously deactivated Product Support	13	2177	Marzo 17, 2021
Bulk change user settings Product Support	1	1667	Marzo 31, 2017
Completely disable mailing list mode? Feature	20	6212	Gennaio 2, 2017

Setting defaults to enable mailing list mode-Temporary Solution

Argomenti correlati