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

XF 1.5 Mass update users with Email Invalid (Bounced)

Skylined

Active member
#1
I have about 300 users with an Email invalid (bounced) state and I would like it to Valid.

I've taken a look at Batch Update but I don't see the option to change that state.


How may I change that for all of them without having to do it one by one?
 

Jake Bunce

XenForo moderator
Staff member
#2
Run this query on your database using a program like phpmyadmin:

Code:
UPDATE xf_user
SET user_state = 'valid'
WHERE user_state = 'email_bounce';