On Mon, Oct 16, 2006 at 03:55:11PM -0400, Jesse Vincent wrote: > > In further investigation we found a line in the DBIx::SearchBuilder > > Changes file from earlier this year that says: > > * Allow ORs on left joins > > It's conceivable that that was upgraded with mysql - is it possible that > > this change might have made the old 3.2.2 query work differently? > It's possible, but I couldn't say for sure. Try backing down and see if > it's better?
Reverting SearchBuilder fixed our problem. Looks like 3.2.2 constructed queries on custom fields badly, but as SB couldn't cope with them, then it wasn't really a problem! :) Looks like we just need to be careful not to upgrade SearchBuilder until we can upgrade RT as well... Thanks, Tony _______________________________________________ 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
