[rt-users] RT2.0.8 on Oracle 8.1.7

[Jesse Vincent]

There are actually a couple of more subtle, nasty issues with 
DBIx::SearchBuilder and oracle.  I wouldn't run RT on oracle in 
production without some major DBIx::SearchBuilder work.

	-j

On Fri, Oct 26, 2001 at 12:00:38PM +0000, Ralph Hoppe wrote:
> Hi all,
> 
> I've successfully installed RT2 on Oracle 8.1.7. I'm using RedHat 6.2, 
> perl 5.6.1, apache 1.3.22, DBD-Oracle-1.12, libapreq-0.31 (0.33 can not 
> be compiled).
> 
> But ATTENTION: In SearchBuilder.pm you'll find in _DoSearch 
> 
>  $QueryString = "SELECT DISTINCT main.* ....
> 
> This is WRONG for tables with CLOB columns and other columns of new 
> types. Delete the DISTINCT clause! Then it will work.
> 
> RALPH HOPPE
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.