|
Wed 23 Mar 2005 07:39:49 AM UTC, comment #10:
"Since the solution is to upgrade the database, how about going a bit more clean and creating a truly machine-readable table for such history events? "
Why not. But I think we should probably wait for the next development branch, after the release, for such heavy change (we'll have to deal with many old usage of this table).
|
Tue 22 Mar 2005 10:30:03 PM UTC, comment #9:
Since the solution is to upgrade the database, how about going a bit more clean and creating a truly machine-readable table for such history events?
Also, it should be possible to get all the lines with 1 SQL query even if some history events are missing, using LEFT/RIGHT OUTER JOIN. Given the complexity of the current query, we might want to avoid this anyway.
|
Mon 21 Mar 2005 02:14:58 PM UTC, comment #8:
update/1.0.6/update_group_history.pl should take care of your problem
To restrict influence of future similar problem: now, when building the group list in "My Groups", a check is made to make sure the history is reliable. In doubt, it works without the history and complain in a feedback message, saying the history looks flawed, saying the incident should be reported to site admins.
|
Sun 20 Mar 2005 06:23:51 PM UTC, comment #7:
- Previous versions of Savane didn't add initial user during project creation in the history; in this case the group is not shown (http://savannah.gnu.org/support/?func=detailitem&item_id=104021)
Can you submit a new report for this distinct bug: my opinion is that an update script should be provided so this info is added in the database. Any other solution would implies lowering the number of possibilities we have to show data.
"I think the history information is meant to be used by humans rather than machines. If you still want to use it, I suggest not to trust the results, and only use it in addition to a more machine-readable way. In this case, we could generate the project list using user_group, and then try to gather additional information in the history. "
The purpose of the history information is quite unclear. If it was meant to be used by humans, in many ways it badly designed.
In many case, we only have this. We should make sure the history data is reliable. I'm sure there's a solution for all the problems you reported (a distinct bug report should probably be made for each).
But you have a point when you said that, considering how reliable this table content is, it is a bit risky to use it directly to gather main data.
I'd prefer avoiding using 300 SQL request instead of one. One idea would be to do only 2 SQL: one with the history test, one without. If the number of rows found is not equal, we use the one without history data and we print feedback saying it was not possible to gather some data, incitating to report the issue.
It is good that you brought this point now. I think this issue is blocker item for the 1.0.6 release.
|
Sun 20 Mar 2005 06:09:45 PM UTC, comment #6:
There are still issues:
- Previous versions of Savane didn't add initial user during project creation in the history; in this case the group is not shown (http://savannah.gnu.org/support/?func=detailitem&item_id=104021)
- There is an issue I couldn't find the cause for my account - it does not show the administration group, while the SQL command appear to work:
mysql> SELECT groups.group_name,groups.group_id,groups.unix_group_name,groups.status,user_group.admin_flags,group_history.date FROM groups,user_group,group_history WHERE groups.group_id=user_group.group_id AND user_group.user_id='20998' AND groups.status='A' AND (group_history.field_name='Added User' OR group_history.field_name='Approved User') AND group_history.group_id=user_group.group_id AND group_history.old_value='Beuc' GROUP BY groups.unix_group_name ORDER BY groups.unix_group_name;
+--------------------------------+----------+-----------------+--------+-------------+------------+
| group_name | group_id | unix_group_name | status | admin_flags | date |
+--------------------------------+----------+-----------------+--------+-------------+------------+
| Savannah Administration | 5802 | administration | A | A | 1076859173 |
| FreeDink | 5623 | freedink | A | A | 1077871795 |
| SpécialK | 6858 | specialk | A | A | 1096382366 |
| gnu.org sysadmin documentation | 177 | sysadmin | A | | 1098445585 |
| TestyEight | 6705 | testyeight | A | A | 1093159619 |
| testyten | 6865 | testyten | A | A | 1096557612 |
+--------------------------------+----------+-----------------+--------+-------------+------------+
- Last, there is the case where somebody was removed and then added back to a project, but maybe it is not worth handling it (I tried at a point to remove myself and add myself back to a project using 2 accounts, to test a Savane behavior; now the system says I'm a member since my 2nd addition only, while I created the project)
I think the history information is meant to be used by humans rather than machines. If you still want to use it, I suggest not to trust the results, and only use it in addition to a more machine-readable way. In this case, we could generate the project list using user_group, and then try to gather additional information in the history.
|
Fri 18 Mar 2005 09:02:18 AM UTC, comment #5:
Hello,
I believe the bug you reported was fixed. Please post a comment if you can still reproduce this problem.
Regards,
|
Thu 17 Mar 2005 03:29:21 PM UTC, comment #4:
This item has been reassigned from the project Gna! Administration support tracker to your tracker.
The original report is still available at support #473
Following are the information included in the original report:
[field #0] Item ID: 473
[field #1] Group ID: 101
[field #2] Open/Closed: Closed
[field #3] Severity: B - Ordinary
[field #4] Privacy: Public
[field #5] Category: Other
[field #6] Submitted by: guiguilinux
[field #7] Assigned to: None
[field #8] Submitted on: jeu 17.03.2005 à 15:26
[field #9] Summary: To group Savane, bugs tracker
[field #10] Original Submission: When I go to the section "Mes groupes" of my gna! account,
I can only see "Vous n êtes membre d aucun projet public" in the list.However, I am a registered member of the Nasgaia GNU/Linux project hosted on gna! : These was showned before in this part...
Is there a bug or simply normal ?
[field #11] Closed on: jeu 17.03.2005 à 16:29
[field #12] Item Group: None
[field #13] Status: None
[field #14] Component Version: None
[field #15] Platform Version: Any / Non-Specific
[field #16] Reproducibility: None
[field #17] Size (loc): None
[field #18] Fixed Release: None
[field #19] Planned Release: None
[field #20] Effort: 0.00
[field #24] Priority: 5 - Normal
[field #27] Percent Complete: 0%
[field #29] Release: None
[field #54] Custom Select Box #1: None
[field #55] Custom Select Box #2: None
[field #56] Custom Select Box #3: None
[field #57] Custom Select Box #4: None
[field #58] Custom Select Box #5: None
[field #59] Custom Select Box #6: None
[field #60] Custom Select Box #7: None
[field #61] Custom Select Box #8: None
[field #62] Custom Select Box #9: None
[field #63] Custom Select Box #10: None
|
Thu 17 Mar 2005 03:26:55 PM UTC, comment #3:
I can act too :-)
This is apparently only a cosmetic bug...
|
Thu 17 Mar 2005 03:26:05 PM UTC, comment #2:
It's a bug. I reassigned the item to the bug tracker of the project Savane.
|
Thu 17 Mar 2005 03:11:02 PM UTC, comment #1:
I got the same whith gorfu project.
Nevertheless, I can act on this project and see it into my preferences.
|
Thu 17 Mar 2005 03:29:21 PM UTC, original submission:
When I go to the section "Mes groupes" of my gna! account,
I can only see "Vous n'êtes membre d'aucun projet public" in the list.However, I am a registered member of the Nasgaia GNU/Linux project hosted on gna! : These was showned before in this part...
Is there a bug or simply normal ?
|
Related Recipes:
Savane - Bugs: bug #2107, missing groups in my items