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
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.
-jOn 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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users
http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.