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

XF 1.3 Total Members != xf_user row count

Mouth

Well-known member
#1
Looking at Total Members count in ACP /admin.php it doesn't match with xf_user rows ("select count(*) from xf_user;") and a difference between the two values of 12%

Should counts be different? What would cause me to have a difference?
 

Chris D

XenForo developer
Staff member
#2
The count in the Admin CP is the total number of users in xf_user who are of user_state valid and not banned.

This is the actual query:

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