[rt-users] Oracle 8 and RT 3.2.1

[Carlos Mateo]

I get the following error whenever I try to do anything that includes
displaying groups.  I can add groups. but they do not show up, though
I can go into the database and show them.  Any help/patch would be
appreciated.

[Thu Sep  9 14:22:49 2004] [warning]: DBD::Oracle::db prepare failed:
ORA-00928: missing SELECT keyword (DBD ERROR: error possibly near <*>
indicator at char 51 in 'SELECT main.* FROM ( SELECT DISTINCT main.id
FROM (<*>Groups main  LEFT JOIN Principals Principals_1  ON ( main.id
= Principals_1.id))   WHERE ((Principals_1.Disabled = '0')) AND
((main.Domain = 'UserDefined'))  ) distinctquery, Groups main WHERE
(main.id = distinctquery.id) ORDER BY main.Name ASC') [for Statement
"SELECT main.* FROM ( SELECT DISTINCT main.id FROM (Groups main  LEFT
JOIN Principals Principals_1  ON ( main.id = Principals_1.id))   WHERE
((Principals_1.Disabled = '0')) AND ((main.Domain = 'UserDefined'))  )
distinctquery, Groups main WHERE (main.id = distinctquery.id) ORDER BY
main.Name ASC"] at
/usr/local/lib/perl5/site_perl/5.8.4/DBIx/SearchBuilder.pm line 139.
 (/apps/rt3/lib/RT.pm:250)