XF 1.5 User count incorrectly

[Nirjonadda]

We have 16865 user in database and it's show only 16296 in forum home page sidebar FORUM STATISTICS. Please let me know that what happened?

 

[Chris D]

The count on the forum list sidebar will only include valid members who are not banned.

 

[Paul B]

Banned and unconfirmed users are not counted.

 

[Nirjonadda]

The count on the forum list sidebar will only include valid members who are not banned.

I have show 16653 users not banned, So why not count 16653 users?

 

[Nirjonadda]

Banned and unconfirmed users are not counted.

Only have 212 banned user and no unconfirmed user.

 

[Chris D]

What is the result of this query:

SELECT COUNT(*)
FROM xf_user
WHERE user_state = 'valid'
AND is_banned = 0