XF 1.5 Mass update users with Email Invalid (Bounced)

[Skylined]

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]

Run this query on your database using a program like phpmyadmin:

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

 

[Skylined]

Thanks!