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

XF 1.1 Query to turn off alerts for imported members


Well-known member
will be importing a large forum on sunday, after having been on vb since ..well forever basically

beta feedback reports that members would prefer all their alerts set to off, and then they can manually go in and select those they wish to enable

is there a query to default Off alerts?


XenForo moderator
Staff member
Take a backup first.

UPDATE xf_user_option
SET alert_optout = 'post_insert,post_insert_attachment,post_like,post_quote,profile_post_comment_other_commenter,profile_post_comment_your_post,profile_post_comment_your_profile,profile_post_insert,profile_post_like,user_following,user_trophy';