XF 1.4 Batch / Bulk update user state?

[cjwinternet]

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

 

[Paul B]

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

 

[cjwinternet]

Thanks. I just read somewhere that this function is now available in Batch Update Users in a newer version than 1.4?

 

[Paul B]

You can't use that function to change the state.

These are the available options:

 

[cjwinternet]

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

 

[Paul B]

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.

 

[cjwinternet]

 

[cjwinternet]

Worked perfectly when I ran the query from the SQL tab

 

[Paul B]

Worked perfectly when I ran the query from the SQL tab

Where did you run it from originally?

 

[cjwinternet]

Where did you run it from originally?

the 'Query' tab.

 

[viper357]

@Brogan, Would you be able to assist with a query to batch update all users that have not logged in for a certain period and change their state to Awaiting Email Confirmation?