Forum OpenACS Development: Re: Bug in .LRN/openacs group memberships

Collapse
3: Re: Bug in .LRN/openacs group memberships (response to 1)
Posted by Dave Bauer on 09/18/07 08:06 PM
Oracle version of the query that shows this problem

select r.rel_id,m.segment_id,m.group_id,m.* from
(select m.*, s.*
from party_approved_member_map m,
rel_segments s
where s.segment_id = m.party_id
and s.rel_type='dotlrn_admin_rel') m,
acs_rels r
where r.object_id_one(+) = m.group_id
and r.object_id_two(+) = m.member_id
and r.rel_id is null;
Collapse
4: Re: Bug in .LRN/openacs group memberships (response to 3)
Posted by Tom Jackson on 09/18/07 08:46 PM
But this query would never return rows in an OpenACS install, because it relies on the dotlrn_admin_rel, which I hope is not part of OpenACS. So the bug, whatever it is, could still be in the underlying code.

How are the admin rels added/deleted in this case, is it a special pl procedure for dot_lrn? Maybe post them if this might cause the problem.

Also, could you print out the lines showing the results, not just the count, I'm having trouble figuring out your query. How do you select an acs_rel with rel_id null? Is there some magic in this query?