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

Default email notification

Discussion in 'XenForo Questions and Support' started by Temery, Aug 16, 2011.

  1. Temery

    Temery Active Member

    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.
  2. faeronsayn

    faeronsayn Well-Known Member

    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.
  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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:

    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:

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

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

    UPDATE xf_user_option
    SET default_watch_state = '';
  4. Brogan

    Brogan XenForo Moderator Staff Member

    faeronsayn likes this.
  5. Big Dan

    Big Dan Active Member

  6. davespanzer

    davespanzer Active Member

    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. cbertozz

    cbertozz Member

    Is there somewhere in the admin section that I can change the default notification for:

    Watch this thread
    Receive email communications

    So they are NOT checked by default?
  8. cbertozz

    cbertozz Member

    Sorry I found it in the Options under User Registration (would have been better elsewhere but at least I found it!)
  9. Deepmartini

    Deepmartini Well-Known Member

    How about a daily digest once a day option? Combine all alerts into one?
    Breixo and thedude like this.
  10. StonePilot

    StonePilot Member

    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?
  11. melbo

    melbo Well-Known Member

    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

  12. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    FROM xf_thread_watch
    melbo likes this.
  13. Will mangles

    Will mangles Member

    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. Adam Elliott

    Adam Elliott Member

    Sorry this is a very basic question, but how do I run these queries on my database?
  15. Brogan

    Brogan XenForo Moderator Staff Member

    Use phpMyAdmin.
    Will mangles likes this.
  16. ShawnT

    ShawnT New Member

    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. Ogreman

    Ogreman New Member

    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?
  18. Mike

    Mike XenForo Developer Staff Member

    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).
  19. Rigo

    Rigo Active Member

    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 ?
  20. Brogan

    Brogan XenForo Moderator Staff Member

    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.

Share This Page