• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Default email notification

Temery

Active member
#1
I run two board that get a greta deal of traffic. Many of the posters post a couple dozen messages a day. They are complaining about the number of email notifications they get.

How can I turn off email notification for messages and alerts as the default?

Thank you.
 

faeronsayn

Well-known member
#2
I am new to this as well, I am not sure how to change it for "Existing users"

but for the new registered users you can change the default values like this

Options > User Registrations

You can set it up there.
 

Jake Bunce

XenForo moderator
Staff member
#3
I am not sure how to change it for "Existing users"
You have to run queries on the database to update the prefs of existing users. Here they are...

Run this query on your database to disable automatic email notifications:

Code:
UPDATE xf_user_option
SET default_watch_state = 'watch_no_email'
WHERE default_watch_state = 'watch_email';
Run this query to disable email notifications for all currently watched threads:

Code:
UPDATE xf_thread_watch
SET email_subscribe = 0;
For alerts you can either disable alerts for watched threads:

Code:
UPDATE xf_user_option
SET alert_optout = 'post_insert';
...or disable automatic watching of threads:

Code:
UPDATE xf_user_option
SET default_watch_state = '';
 
#6
You have to run queries on the database to update the prefs of existing users. Here they are...

Run this query on your database to disable automatic email notifications:

Code:
UPDATE xf_user_option
SET default_watch_state = 'watch_no_email'
WHERE default_watch_state = 'watch_email';
Run this query to disable email notifications for all currently watched threads:

Code:
UPDATE xf_thread_watch
SET email_subscribe = 0;
For alerts you can either disable alerts for watched threads:

Code:
UPDATE xf_user_option
SET alert_optout = 'post_insert';
...or disable automatic watching of threads:

Code:
UPDATE xf_user_option
SET default_watch_state = '';

Any idea how I could do this with the XenMedio settings in preferences Jake, thanks
  • Automatically watch media that you create or when you reply...
    • and receive email notifications of replies
 
#7
Is there somewhere in the admin section that I can change the default notification for:

Watch this thread
and
Receive email communications

So they are NOT checked by default?
 
#10
On the flip side for this, if I had an underperforming website that I just converted to XF and I want to boost traffic now ... how can I turn on email notifications for all threads for all users who have ever posted to that thread? That way, old users who posted a year or two ago will get notified that the site is active once again?
 

melbo

Well-known member
#11
Is there a query to delete all watched threads from all users?
We had 'watch threads' checked by default but now we'd like to clear that and let people choose to watch threads after running the above queries

Thanks
 
#13
I know this is an old thread but it took me a good 30 mins to find it. So a little bump for people wanting to turn off email alerts via sql for pre-existing set email alerts.
 
#14
You have to run queries on the database to update the prefs of existing users. Here they are...

Run this query on your database to disable automatic email notifications:

Code:
UPDATE xf_user_option
SET default_watch_state = 'watch_no_email'
WHERE default_watch_state = 'watch_email';
Run this query to disable email notifications for all currently watched threads:

Code:
UPDATE xf_thread_watch
SET email_subscribe = 0;
For alerts you can either disable alerts for watched threads:

Code:
UPDATE xf_user_option
SET alert_optout = 'post_insert';
...or disable automatic watching of threads:

Code:
UPDATE xf_user_option
SET default_watch_state = '';

Sorry this is a very basic question, but how do I run these queries on my database?
 
#16
Is there another way to do this?

How do I turn them off by default for new users? Not for watched threads, but for any thread that have replied to.
 
#17
Is there any chance for an update that allows for the complete turn off of thread update emails without going in the DB? Or is there a plugin that does this?
 

Mike

XenForo developer
Staff member
#18
If you're referring to an individual user, this can be controlled by editing the user in the control panel. There is a "manage watched threads" action (and you can change their default watch status).
 

Rigo

Active member
#19
How do you "undo" a query?
I ran the query to disable automatic email notification but does this disable it even if a member marks a thread as "watch this thread" @Jake Bunce ?
 

Brogan

XenForo moderator
Staff member
#20
You can't 'undo' a query.

You can revert from a backup or run another query to change fields again.
It won't be possible to restore each individual user record to what it was prior to running the query though.