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

Confirmation Email Problems / SQL command?

Discussion in 'XenForo Questions and Support' started by RobParker, May 31, 2012.

  1. RobParker

    RobParker Well-Known Member

    We've had quite a few users complain about not getting confirmation emails. Whilst we sort it out, is there a simple SQL command that will change their status from "awaiting email confirmation" to "valid"?

    It looks like we had quite a lot of users from before our import from VB which were in that state which is confusing matters so getting everyone "valid" seems like the best course so we can investigate it more.

    Jake? ;-)
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    UPDATE xf_user
    SET user_state = 'valid'
    WHERE user_state = 'email_confirm';
    Junior and RobParker like this.

Share This Page