Social groups user count wrong
Rejected - Abandoned
In campus.chamilo.org, the group "PHP Español" shown 2202 members, although the groups_rel_user table only contains 134 entries for that group.
This is apparently due to something wrong in the join between the groups and the groups_rel_user tables in the query :
SELECT DISTINCT count(user_id) as count, g.picture_uri, g.name, g.description, g.id FROM `chamilo_main`.`groups` g INNER JOIN `chamilo_main`.`group_rel_user` gu ON gu.group_id = g.id WHERE gu.relation_type IN ('1' , '2') ORDER BY created_on desc LIMIT 1
as it returns 2202 although there are 134 rows.
- Assignee set to Julio Montoya
I believe this was already fixed, wait, I just see that you updated campus.chamilo to 184.108.40.206 great!
I will fix that ...
Ah I just see that campus.chamilo only has the version number 220.127.116.11 but there are not the final files (course catalog/course management)
So this bug should be fixed in 18.104.22.168 I remember that I fixed a count problem in groups ...
- Status changed from New to Needs more info
- Assignee deleted (
- Target version changed from 1.9 Stable to 1.9 Beta
- Status changed from Needs more info to Rejected - Abandoned
Let's imagine this has been fixed. I'm pretty sure there was something fishy about this, but I'll reopen if I spot anything wrong.
Also available in: Atom