Why is member search count different than member widget count? Which is correct?

[SJ77]

Search the community for all members

 

Use widget to get total member count

 

 

Which is correct? Why are they different?

 

[Jim M]

Is "Allow filtering by this group?" disabled on group(s) which are the only group for members? If so, that would be a correct count there.

[SJ77]

4 hours ago, Jim M said:

Is "Allow filtering by this group?" disabled on group(s) which are the only group for members? If so, that would be a correct count there.

I have 1 group of about 400 that are not allowed to be filtered. However, I am missing about 10K members versus widget count.

I think members who are deleted aren't recalculated and deducted from the widget count is my guess

Edited August 31, 2023 by SJ77

[Nathan Explosion]

46 minutes ago, SJ77 said:

I think members who are deleted aren't recalculated and deducted from the widget count is my guess

The widget count is just a SQL query - it's not a figure that is recalculated as and when something is done:

/* fetch only successful registered members ; if this needs to be changed, please review the other areas where we have the name<>? AND email<>? condition */
$where = array( 'completed=?', true );
/* Member count */
$stats['member_count'] = \IPS\Db::i()->select( 'COUNT(*)', 'core_members', $where )->first();

Which is:

SELECT count(*) from core_members WHERE completed = TRUE;

Got a tonne of validating members?

Maybe show what search criteria was used for the search result? (To be clear how you got there)

 

Edited August 31, 2023 by Nathan Explosion

[SJ77]

I just go to this page directly
https://invisioncommunity.com/index.php?/search/&type=core_members
 

only of course on mysite and not here. and it gives me the 187K number while the widget gives me the 197K number.
Maybe members who never finished validating could perhaps be the issue, as you've suggested.