]]>
COUNT(gm.member) AS membercount, COUNT(gmr.member), but the problem is probably in one of JOIN's in that query.
I could change this so the number of pending members wouldn't be shown on the "My Groups" page (since it is OK in the group view) but I would like to be sure that this is bug in the current release and not in the upgrade process from 1.06.
Bug:
On My Groups page I am seeing message: "There are 448 pending membership requests for this group" which is obviously wrong as in group view page is displayed correct "There are 2 pending membership requests for this group".
So the number of pending members is multiplied with current members (some left / inner join mistake??)
Function that fill the necessary data is group_get_associated_groups (lib(group.php). I have made print_r of $groups on line 1083 and I get the following:
Array
(
[34] => stdClass Object
(
[name] => OPM_09
[description] => My group
[jointype] => request
[grouptype] => standard
[membershiptype] => admin
[reason] =>
[role] => admin
[membercount] => 428
[requests] => 428
[id] => 34
)
)
But If I go and click on the group everything is OK…that is I see 214 members and 2 membership requests, so wrong number is only visible under main "My Group" page.