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

XF 1.4 Batch / Bulk update user state?

Discussion in 'XenForo Questions and Support' started by cjwinternet, Sep 2, 2015.

  1. cjwinternet

    cjwinternet 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?


  2. Brogan

    Brogan XenForo Moderator Staff Member

    UPDATE xf_user SET user_state = 'valid' WHERE user_state = 'email_bounce';
  3. cjwinternet

    cjwinternet Member

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

    Brogan XenForo Moderator Staff Member

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

    These are the available options:
  5. cjwinternet

    cjwinternet Member

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

  6. Brogan

    Brogan XenForo Moderator Staff Member

    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.
  7. cjwinternet

    cjwinternet Member

  8. cjwinternet

    cjwinternet Member

    Worked perfectly when I ran the query from the SQL tab

  9. Brogan

    Brogan XenForo Moderator Staff Member

    Where did you run it from originally?
  10. cjwinternet

    cjwinternet Member

    the 'Query' tab.
  11. viper357

    viper357 Active Member

    @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?

Share This Page