[rt-users] Query builder losing the query

[Jesse Vincent]

On Mon, Jan 24, 2005 at 09:30:34PM +1100, Matthew Watson wrote:
> 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

So. I see code in RT::Handle that takes care of this. Can you verify
that this code isn't being taken advantage of?


> 
> 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
> > 
> > --
> 

--