Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
SJ77 Posted August 31, 2023 Posted August 31, 2023 Search the community for all members Use widget to get total member count Which is correct? Why are they different?
Jim M Posted August 31, 2023 Posted August 31, 2023 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 Posted August 31, 2023 Author Posted August 31, 2023 (edited) 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 Posted August 31, 2023 Posted August 31, 2023 (edited) 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 1
SJ77 Posted August 31, 2023 Author Posted August 31, 2023 I just go to this page directlyhttps://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.
Recommended Posts