Index: openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql,v diff -u -r1.14 -r1.14.2.1 --- openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql 4 Mar 2004 14:52:40 -0000 1.14 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-create.sql 20 Sep 2004 20:18:15 -0000 1.14.2.1 @@ -193,13 +193,12 @@ pe.person_id, pe.first_names, pe.last_name, u.user_id,u.authority_id,username,u.password,u.salt,u.screen_name,u.priv_name,u.priv_email,u.email_verified_p,u.email_bouncing_p,u.no_alerts_until,u.last_visit,u.second_to_last_visit,u.n_sessions,u.password_question,u.password_answer,password_changed_date, mr.member_state, mr.rel_id -from acs_objects o, parties pa, persons pe, users u, group_member_map m, membership_rels mr, acs_magic_objects mo +from acs_objects o, parties pa, persons pe, users u, group_member_map m, membership_rels mr where o.object_id = pa.party_id and pa.party_id = pe.person_id and pe.person_id = u.user_id and u.user_id = m.member_id -and m.group_id = mo.object_id -and mo.name = 'registered_users' +and m.group_id = (select acs.magic_object_id('registered_users') from dual) and m.rel_id = mr.rel_id and m.container_id = m.group_id and m.rel_type = 'membership_rel'; Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.1.2d2-5.1.2d3.sql'. Fisheye: No comparison available. Pass `N' to diff?