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

XF 1.2 Activate all users

Discussion in 'Troubleshooting and Problems' started by vozihcs, Jan 9, 2014.

  1. vozihcs

    vozihcs New Member


    My mail system didnt work for a while and know about 120 users are waiting for theire aproval mail.
    How can I change all to "valid" / ?

    I tried for an hour or so but I cant find it :(
  2. Amaury

    Amaury Well-Known Member

    Batch Update Users.
  3. Brogan

    Brogan XenForo Moderator Staff Member

    The Batch Update Users function does not allow the user state to be changed.

    It will need to to be done manually.
    Amaury likes this.
  4. RoldanLT

    RoldanLT Well-Known Member

    UPDATE xf_user
    SET user_state = 'valid'
    WHERE xf_user.user_state = 'email_confirm';
  5. vozihcs

    vozihcs New Member

    Thank you for ur answers!

    This sounds great, would you please tell me where I have to paste it? :)
  6. RoldanLT

    RoldanLT Well-Known Member

    Phpmyadmin > sql query
    vozihcs likes this.
  7. RoldanLT

    RoldanLT Well-Known Member

    vozihcs likes this.
  8. vozihcs

    vozihcs New Member

    I will download it and try it out, thank you :D

Share This Page