XF 1.4 Batch / Bulk update user state?

cjwinternet

Active member
For the last 24 hours our mailer IP has been on a Microsoft / Hotmail blacklist. Lots of members have seen their accounts being restricted as their emails have bounced and their account has been flagged as 'Email invalid (bounced)'.

I've had to turn off the bounced email handler, now I need to reset all the accounts back to valid.

Could someone tell me what the SQL query would be please?

Regards

Chris
 
Just tried running the update, didn't work...

sLB6ZId.png
 
What didn't work?
The query is valid - I tested it.

Perhaps the existing state isn't 'email_bounce'.
In which case you will need to check and update the query as required.
 
Top Bottom