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 <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> >> > > > > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
