Hi again,

I think I am getting to the bottom of all this weirdness. For one thing,
midgard does not seem to delete membership records. Look what I have
got:

mysql -pmidgard -umidgard midgard

mysql> select id,username,sitegroup from person;
+----+----------+-----------+
| id | username | sitegroup |
+----+----------+-----------+
|  1 | admin    |         0 |
+----+----------+-----------+


mysql> select * from member;
+----+-----+-----+-------+------+-----------+
| id | uid | gid | extra | info | sitegroup |
+----+-----+-----+-------+------+-----------+
|  1 |   1 |   0 |       |      |         0 |
|  2 |   2 |   1 |       |      |         1 |
|  3 |   7 |   7 |       |      |         3 |
+----+-----+-----+-------+------+-----------+

Note, that there are no persons with id 2 and 7! Also:

mysql> select * from sitegroup;
Empty set (0.00 sec)

No sitegroups at all! And:

mysql> select * from grp;
Empty set (0.00 sec)

No groups with id 1 and 7!.


Frank

-- 
Dr Frank Boehme                      | Email: [EMAIL PROTECTED]
National University of Ireland, Cork | phone: +353-21-4903163
Dept of Computer Science             |   fax: +353-21-4903113
Cork, Ireland                        |

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to