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

2400 Users Awaiting Approval

Jake Bunce

XenForo moderator
Staff member
Run this query on your database to approve all users who are currently awaiting approval:

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


XenForo moderator
Staff member
I believe this is related to your other thread, which I responded to.

However, the possible states are: 'valid','email_confirm','email_confirm_edit','moderated','email_bounce'


Well-known member
Interesting to know.

Just because I can't add tags here and I want to be able to find this back.

Update user state :)