Update of bugs #2107 (project savane):
Status: Fixed => Work in progress
_______________________________________________________
Follow-up 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.
_______________________________________________________
Reply to this item at:
<http://gna.org/bugs/?func=detailitem&item_id=2107>
_______________________________________________
Message sent via/by Gna!
http://gna.org/
_______________________________________________
Savane-dev mailing list
[email protected]
https://mail.gna.org/listinfo/savane-dev
