XF 1.2 Phantom "1 user awaiting approval"


Well-known member
its been hanging around for a long time in the mod bar (since the 1.1.4 upgrade i think, i upgraded before the fix was applied to correct it) yet there is no user to approve.

how can i reset it to 0?


XenForo moderator
Staff member
Have you tried running this query?
UPDATE xf_user
SET user_state = 'valid'
WHERE user_state = 'moderated';

Be aware that will affect all users with the moderated state.


Well-known member
yes i had, sadly no effect.

I can't recall the thread but i recall @Mike mentioned it was a glitch in 1.1.4 or 1.1.5 the very first few downloads before patched