Frank Boehme wrote:
> 
> Emiliano wrote:
> 
> > What did you think happened, in what order?
> 
> I believe, I just tried to create one new sitegroup (jim) and then the
> situation went as shown.

I have overinstalled all database tables, including the mysql grant
tables. I am still using asgard from cvs since repligard (needed to
install a more recent asgard) segfaults. The same thing happens: After
some time, the tables become inconsistent:

mysql> select id,username,sitegroup from person;
+----+----------+-----------+
| id | username | sitegroup |
+----+----------+-----------+
|  1 | admin    |         0 |
|  3 |          |         2 |
+----+----------+-----------+
2 rows in set (0.00 sec)

mysql> select * from member;
+----+-----+-----+-------+------+-----------+
| id | uid | gid | extra | info | sitegroup |
+----+-----+-----+-------+------+-----------+
|  1 |   1 |   0 |       |      |         0 |
|  2 |   2 |   1 |       |      |         1 |
+----+-----+-----+-------+------+-----------+
2 rows in set (0.00 sec)

uid in member points to person records, ain't so? But there is no person
with id=2, for heaven's sake!! Also, there is no sitegroup 1. It seems
that in the 2nd row of members uid and sitegroup are SWAPPED.

I am contrite. I need a midgard system with sitegroups and
sitegroup-aware admin interface NOW. Any idea's? ... Downgrading? 


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