[rt-users] Upgrade problem.

[J.P. Racine]

I'm using 1.53-1 from sources found at.

http://packages.debian.org/lenny/libdbix-searchbuilder-perl

Jesse Vincent wrote:
> Are you current on DBIX::SearchBuilder?
>
> ------- Original message -------
> From: J.P. Racine <racinejp at vianet.ca>
> Sent: 5-8-'08,  15:51
>
>   
>> Greetings,
>>
>> I've just upgraded an RT installation from 3.4.4 to 3.6.6 and found that 
>> although the schema hasn't changed that there are some SQL queries that 
>> seem to behave strangely.  The database is about 9 gigs in size and is 
>> runing on mysql 5 ( mysql-server-5.0 debian package 5.0.51a-3~bpo40+1 ).
>>
>> After the upgrade we noticed some strange behavior when trying to view a 
>> ticket that was in a resolved state.  The query below was called when 
>> the problem occured and and seem to return *all* resolved tickets and 
>> that was a bit to much for the memory of the system to handle. 
>>
>> http://hostname.domain.com/Ticket/Display.html?id=123456
>>
>> SELECT main.* FROM Tickets main  WHERE (main.Status != 'deleted') AND 
>> (main.Status = 'resolved') AND (main.EffectiveId
>> = main.id) AND (main.Type = 'ticket')  ORDER BY main.id ASC
>>
>> The same database is running fine ( albeit a bit slow ) with a 
>> production 3.4.4 install. Any pointers or suggestions to remedy this 
>> problem would be appreciated.  I just don't see why there is a query 
>> with no limit for no apparent reason returning unlimited results.
>>
>> Thanks,
>>
>> JP
>>
>>
>>
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>> Buy a copy at http://rtbook.bestpractical.com
>>
>>     
>
>
>
>