Project

General

Profile

Bug #3840

Social groups user count wrong

Added by Yannick Warnier about 8 years ago. Updated over 7 years ago.

Status:
Rejected - Abandoned
Priority:
Low
Assignee:
-
Category:
-
Target version:
Start date:
31/08/2011
Due date:
% Done:

0%

Estimated time:
Complexity:
Normal
SCRUM pts - complexity:
?

Description

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.

History

#1

Updated by Julio Montoya about 8 years ago

  • Assignee set to Julio Montoya

I believe this was already fixed, wait, I just see that you updated campus.chamilo to 1.8.8.4 great!
I will fix that ...

#2

Updated by Julio Montoya about 8 years ago

Ah I just see that campus.chamilo only has the version number 1.8.8.4 but there are not the final files (course catalog/course management)

So this bug should be fixed in 1.8.8.4 I remember that I fixed a count problem in groups ...

#3

Updated by Julio Montoya over 7 years ago

  • Status changed from New to Needs more info
  • Assignee deleted (Julio Montoya)
#4

Updated by Yannick Warnier over 7 years ago

  • Target version changed from 1.9 Stable to 1.9 Beta
#5

Updated by Yannick Warnier over 7 years ago

  • 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 PDF