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

XF 1.4 Please advice the correct SQL Query to enable all ALERTs for all users?

Discussion in 'XenForo Questions and Support' started by RoldanLT, Mar 31, 2015.

  1. RoldanLT

    RoldanLT Well-Known Member

    I want to have all the alert preferences enabled for all users:

    What is the correct query?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    I haven't tested this and I would recommend taking a backup before running it.

    UPDATE xf_user_option SET alert_optout = '';
    RoldanLT likes this.
  3. RoldanLT

    RoldanLT Well-Known Member

    Done :).
    I didn't backup the database though :D
    Seems 100% working as intended, as I tested it first on my test site.

    Thanks a lot Brogan :)

Share This Page