Oracle 8 and RT 3.2.1

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)

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.

RT supports Oracle 9iR2 and newer. Oracle 8 didn’t have all the bits we
need.

Jesse