[rt-users] Query builder losing the query

[Matthew Watson]

This is a followup on issues I was having with Query Builder losing the
query, After a lot of testing and playing around, turned out it wasn't
just the query that was vanishing, but the entire session wasn't being
relocated/saved correctly.

After a lot of playing around, it seems the sessions where getting
truncated when being retrieved from the database when using
Apache::Session::Oracle

In SearchBuilder/Handle/Oracle.pm

$self->dbh->{LongTruncOk}=1;
$self->dbh->{LongReadLen}= 8000;

Seems the session is getting larger than this, which of course gives
problems when the session is retrieved.

Also, Apache::Session::Oracle seems to want you to set this in its
arguments, even if it is already set on the database handle.

So, locally I've changed
SearchBuilder/Handle/Oracle.pm to

$self->dbh->{LongReadLen}= 10485760

And in ~rt/local/html/Elements/SetupSessionCookie

I have added 

Commit      => 0,
LongReadLen => 10485760

To the session setups.

Hope this helps anyone having these issues :)

Regards,
Matt.


> -----Original Message-----
> From: Jesse Vincent [mailto:jesse at bestpractical.com]
> Sent: Wednesday, January 05, 2005 11:56 AM
> To: Matthew Watson
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Query builder losing the query
> 
> 
> 
> On Wed, Jan 05, 2005 at 02:39:27PM +1100, Matthew Watson wrote:
> > Hi,
> >
> >
> >
> >  I seem to recalled seeing this before, but I couldn't find it in my
> > history. So I apologise if this has been over.
> >
> >
> >
> > I am running RT 3.2.2
> >
> >
> Try the 3.2.3 prerelease?
> >
> > I notice, when you build a search, then click on a ticket, then go
back
> > to the Query Builder, the query is gone.
> >
> >
> >
> > Now, firstly I'm unclear if this is a problem, or if this is how rt3
is
> > meant to work (it doesn't work like this is rt2). And
> >
> > Secondly, if it is an issue, is there a fix floating around for it?
> >
> >
> >
> > Cheers.
> >
> >
> >
> >
> >
> > Regards
> >
> >
> >
> > --
> >
> > Matthew Watson
> >
> > Netspace Online Systems
> >
> > (03) 98110010
> >
> >
> >
> 
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Be sure to check out the RT wiki at http://wiki.bestpractical.com
> 
> --

This email and any files transmitted with it are confidential and intended solely for the 
use of the individual or entity to whom they are addressed. Please notify the sender 
immediately by email if you have received this email by mistake and delete this email 
from your system. Please note that any views or opinions presented in this email are solely
 those of the author and do not necessarily represent those of the organisation. 
Finally, the recipient should check this email and any attachments for the presence of 
viruses. The organisation accepts no liability for any damage caused by any virus 
transmitted by this email.