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 :)