[rt-users] RT 3.0.11 Oracle errors with Groups and owners

[Jesse Vincent]

On Thu, Jun 03, 2004 at 05:06:36PM -0600, Greg Deickman wrote:
> My 3.0.10 RT instance works fine against Oracle, but when I upgraded a
> test instance to 3.0.11,  the -> Configuration -> Groups page shows up
> blank and gives me an oracle error (see below).  Also when trying to
> assign an owner there are none listed other than "nobody".  I believe
> something with the Groups isn't coming up correct causing my queue
> permissions to be messed up.  
>  
> I have lots of errors in my log stating "ORA-00920: invalid relational
> operator" or "ORA-00905: missing keyword".  I have debugged a little bit
> from 3.0.10 to 3.0.11.  It looks like the sql generated by clicking
> "Configuration->Groups" in 3.0.10 used to be this:

Can you try the latest pre-release DBIx::SearchBuilder available on
CPAN? This is an issue we've found and fixed for a customer running
Oracle.