Index: openacs-4/packages/acs-subsite/www/admin/groups/elements-by-group-type.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/groups/elements-by-group-type.tcl,v diff -u -r1.1.1.1.30.2 -r1.1.1.1.30.3 --- openacs-4/packages/acs-subsite/www/admin/groups/elements-by-group-type.tcl 28 Oct 2015 09:38:35 -0000 1.1.1.1.30.2 +++ openacs-4/packages/acs-subsite/www/admin/groups/elements-by-group-type.tcl 6 Jun 2016 18:29:12 -0000 1.1.1.1.30.3 @@ -37,11 +37,11 @@ # permission on 10 groups). I think the group-types/groups-display page # should tell you total number of groups, and tell you "these are the ones # you have read privilege on", so you don't get confused. + db_foreach select_group_types { - select - t.object_type, t.pretty_name, count(g.group_id) as number_groups - from groups g, acs_objects o, acs_object_types t, - application_group_element_map app_group + select t.object_type, t.pretty_name, count(g.group_id) as number_groups + from groups g, acs_objects o, acs_object_types t, + application_group_element_map app_group where o.object_id = g.group_id and o.object_type = t.object_type and app_group.package_id = :package_id