<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>That worked great, I am no longer seeing any Oracle errors in the logs. </DIV>
<DIV> </DIV>
<DIV>Thank you,</DIV>
<DIV> </DIV>
<DIV>Greg<BR><BR>>>> Jesse Vincent <jesse@bestpractical.com> 6/3/2004 6:09:57 PM >>><BR></DIV>
<DIV style="COLOR: #000000"><BR><BR><BR>On Thu, Jun 03, 2004 at 05:06:36PM -0600, Greg Deickman wrote:<BR>> My 3.0.10 RT instance works fine against Oracle, but when I upgraded a<BR>> test instance to 3.0.11, the -> Configuration -> Groups page shows up<BR>> blank and gives me an oracle error (see below). Also when trying to<BR>> assign an owner there are none listed other than "nobody". I believe<BR>> something with the Groups isn't coming up correct causing my queue<BR>> permissions to be messed up. <BR>> <BR>> I have lots of errors in my log stating "ORA-00920: invalid relational<BR>> operator" or "ORA-00905: missing keyword". I have debugged a little bit<BR>> from 3.0.10 to 3.0.11. It looks like the sql generated by clicking<BR>> "Configuration->Groups" in 3.0.10 used to be this:<BR><BR>Can you try the latest pre-release DBIx::SearchBuilder available on<BR>CPAN? This is an issue we've found and fixed for a customer running<BR>Oracle.<BR><BR>_______________________________________________<BR><A href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR><BR>RT Developer and Administrator training is coming to LA, DC and Frankfurt this spring and summer.<BR><A href="http://bestpractical.com/services/training.html">http://bestpractical.com/services/training.html</A><BR><BR>Sign up early, as class space is limited. <BR></DIV></BODY></HTML>
<p><br>
CONFIDENTIALITY NOTICE: If you are not the intended recipient of this
electronic message, you are hereby notified that any disclosure, copying,
distribution, or action taken in reliance on the contents of this document
is strictly prohibited. If you received this information in error, please
notify the sender immediately and arrange for the return or destruction of
this document.
</p>