OpenACS

This fixes the following bug for Oracle:

:            select u.user_id,

:                   u.authority_id,

:                   u.username,

:                   u.screen_name,

:                   u.priv_name,

:                   u.priv_email,

:                   u.email_verified_p,

:                   u.email_bouncing_p,

:                   u.no_alerts_until,

:                   u.last_visit,

:                   to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi,

:                   u.second_to_last_visit,

:                   to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi,

:                   u.n_sessions,

:                   u.password,

:                   u.salt,

:                   u.password_question,

:                   u.password_answer,

:                   u.password_changed_date,

:                   extract(day from current_timestamp - password_changed_date) as password_age_days,

:                   u.auth_token,

:                   mm.rel_id,

:                   mr.member_state !>>>!= 'approved' as registered_user_p,

:                   mr.member_state

:            from users u

:                 left join group_member_map mm on mm.member_id = u.user_id

:                                              and mm.group_id  = mm.container_id

:                                              and mm.group_id  = :registered_users_group_id

:                                              and mm.rel_type  = 'membership_rel'

:                 left join membership_rels mr on mr.rel_id = mm.rel_id

:            where u.user_id = :user_id

Show less