[rt-users] blank OrderBy entries causing query to fail - 3.6.3

[Ryan Fox]

On my rt 3.6.3 install, I'm experiencing a problem where when performing 
a ticket search, if all 4 OrderBy fields are not filled in, and the 'Add 
and Search' button is pressed (submitting it to Build.html), the count 
of tickets displays correctly but no tickets are displayed in the list.

The rt.log confirms that the query passed to mysql is invalid.

Fri Feb  9 15:54:45 2007] [warning]: DBD::mysql::st execute failed: You 
have an error in your SQL syntax.  Check the manual that corresponds to 
your MySQL server version for the right syntax to use near '| ASC, 
main.id DESC  LIMIT 50' at line 1 at 
/usr/local/libdata/perl5/site_perl/DBIx/SearchBuilder/Handle.pm line 50
5. (/usr/local/libdata/perl5/site_perl/DBIx/SearchBuilder/Handle.pm:505)
[Fri Feb  9 15:54:45 2007] [warning]: RT::Handle=HASH(0x863734e4) 
couldn't execute the query 'SELECT main.* FROM Tickets main   WHERE 
((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND 
((main.Type = 'ticket')) AND ((main.Queue = '7') AND  ( (main.Status != 
'rejected') AND (main.Status != 'deleted') AND (main.Status != 
'resolved') ) )  ORDER BY main.id||| ASC, main.id DESC  LIMIT 50' at 
/usr/local/libdata/perl5/site_perl/DBIx/SearchBuilder/Handle.pm line 518

The same query works fine from the 'Show Results' link at the top that 
submits to Results.html, as do Results.tsv and rdf.

Can anyone else confirm this is happening to them?

Thanks,
Ryan
-------------- next part --------------
A non-text attachment was scrubbed...
Name: rfox.vcf
Type: text/x-vcard
Size: 276 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070209/c96ec3e2/attachment.vcf>