Continuing the discussion from Edit a user setting for all Discourse users: [תמונה]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. Then, I went ahead and set the defaults as I wanted to be checked by default - and have instructions telling people how they can change them if they want (all I did was set defaults, not lock them in place) It’s been great. Discourse is now the mailing list I’ve wanted since day one, with the most functional web-ui out there. Here’s how I did it, I sure hope I didn’t break anything horribly wrong, and am posting here to ensure that fact. First, ssh in to your host as root. cd /var/discourse/ ./launcher ssh app su postgres psql \c discourse alter table only users alter column email_always set default true; alter table only users alter column mailing_list_mode set default true; \q This error is expected: could not save history to file "/var/lib/postgresql/.psql_history": No such file or directory exit (to get out of the docker image) exit (to get out of the host) Done. At this point, I tell people that this is a mailing list, with the option to go web-only if they want. Thank you discourse, for being awesome.

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: [תמונה]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?

[תמונה] 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 false;"

[תמונה] 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 בפברואר,‏ 2015,‏ 8:02pm 7

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)

נושא		תגובות	צפיות
Default email settings for a new user Feature email	42	12117	21 באוגוסט,‏ 2015
Tutorial for using Discourse over Email? Self-hosting	3	1901	12 במרץ,‏ 2019
"mailing list mode" mysteriously deactivated Product Support	13	2226	17 במרץ,‏ 2021
Bulk change user settings Product Support	1	1676	31 במרץ,‏ 2017
Completely disable mailing list mode? Feature	20	6284	2 בינואר,‏ 2017

Setting defaults to enable mailing list mode-Temporary Solution

נושאים קשורים