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

[Ruslan Zakirov]

I've checked 3.6.HEAD and there is no way to select [none] in the
first order by select box.

On 2/9/07, Ryan Fox <rfox at findlay.edu> wrote:
> 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
>
> _______________________________________________
> 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
>
>


-- 
Best regards, Ruslan.