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

rdn

Well-known member
#1
I want to have all the alert preferences enabled for all users:
/account/alert-preferences

What is the correct query?
Thanks!
 

Brogan

XenForo moderator
Staff member
#2
I haven't tested this and I would recommend taking a backup before running it.

Code:
UPDATE xf_user_option SET alert_optout = '';
 

rdn

Well-known member
#3
123 rows affected. (Query took 0.4476 seconds.)
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 :)
 
Top