Bug #16671


Group member count off

Added by Matt Gold over 1 year ago. Updated about 1 year ago.

Priority name:
Category name:
Groups (misc)
Target version:
Start date:
Due date:
% Done:


Estimated time:
Deployment actions:


I'm not sure why, but the group side menu for this group shows that it has 75 members, when it really has 29

Related issues

Related to CUNY Academic Commons - Bug #15757: Members # do not match due to multiple last_activity entriesResolvedBoone Gorges2022-03-30

Actions #1

Updated by Raymond Hoh over 1 year ago

  • Related to Bug #15757: Members # do not match due to multiple last_activity entries added
Actions #2

Updated by Raymond Hoh over 1 year ago

This is the same as #15757.

To summarize, the issue is two-fold. First, sometimes a user's last activity timestamp can be saved multiple times into the database. Second, the group member count checks all group member last activity timestamps for the count. However, the count doesn't do a unique check for the user's last activity entries, so for groups that have users with multiple last activity entries, the group member count will be wrong.

Back in #15757, I removed all duplicate user last activity entries from the database, so this should address group member counts for new groups. However, for older groups that haven't added or removed any members such as the DHUM 7000 group, the group member count can still be wrong if users in the group had multiple last activity entries in the past.

For now, I have manually refreshed the group member count for the DHUM 7000 group; I can probably write a script to run through all ~2300 groups to fix the group member count tomorrow.

Actions #3

Updated by Matt Gold over 1 year ago

Thank you, Ray!

Actions #4

Updated by Boone Gorges about 1 year ago

  • Category name set to Groups (misc)
  • Assignee changed from Boone Gorges to Raymond Hoh
  • Target version set to Not tracked
Actions #5

Updated by Raymond Hoh about 1 year ago

  • Status changed from New to Resolved

I ran a script on Thursday night to sync the group member counts, so we should be good now.


Also available in: Atom PDF