XF 1.2 Phantom "1 user awaiting approval"

[Nudaii]

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?

 

[Paul B]

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.

 

[Nudaii]

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

 

[xf_phantom]

Running the query won't have any effect, because this is a cached value.

You'll have to call rebuildUserModerationQueueCache inside of the usermodel or delete userModerationCounts from the dataRegistry.

That's why i suggested http://xenforo.com/community/threads/registry-cache-rebuild-manager.56873/

 

[Nudaii]

http://xenforo.com/community/threads/users-awaiting-approval-not-counting-down.47036/
@Mike and @Brogan thats the bug