Grouper Users - Open Discussion List

[Colin Hudler <>]

Chris Hyzer wrote:
> Shilen, can you respond about "bad memberships"?
> Also, Im curious if that method FindByOwnerAndMemberAndFieldAndType should 
> not throw an error if there are dupes... if could just return one of them and 
> delete the other?  Something like that to make things more graceful?  With 
> the membership table changes in 1.5 can we add another unique index so this 
> cant happen?

<snip lots of stuff>

> > mysql>  select owner_id,mship_type,via_id from grouper_memberships
> > where
> > member_id = '4208396d-9b34-4e51-92c2-759b9fa9bb60';
> > +--------------------------------------+------------+------------------
> > --------------------+
> > | owner_id                             | mship_type | via_id
> >                     |
> > +--------------------------------------+------------+------------------
> > --------------------+
> > | 62b9c697-1af2-47a6-b7ac-90a23602c2ac | immediate  | NULL
> >                     |
> > | 20bd10d2-2766-4342-9fd6-c0c5f472603e | composite  |
> > 1fb43f92-7457-46e7-906c-ddfc8b0f4129 |
> > | 41f8d440-e715-4f9f-809f-2c491165ea62 | immediate  | NULL
> >                     |
> > | 41f8d440-e715-4f9f-809f-2c491165ea62 | immediate  | NULL
> >                     |
> > | 49fe6f6f-7a03-4e69-9ad1-912212407af7 | composite  |
> > f7c157d5-9eb6-4bd7-a82a-d41ba1499e96 |
> > +--------------------------------------+------------+------------------
> > --------------------+
> > 5 rows in set (0.00 sec)
> >
> >
> > Finally, what could I do to fix this?  Unfortunately, I have not found
> > the cause yet.

I used SQL to remove the first row that was a duplicate immediate 
membership, and things /seem/ okay after that.  At least I was able to 
delete the group and the groups that it was a factor in so I can start over.