> Got this error on my tickets report (got a mysql database) > > Report execution failed: (1064, "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 ' 'admin', ')'\n ORDER BY (status = > 'assigned') DESC, p.value, milestone, t.type,' at line 9")
I do not believe that this is correct: ORDER BY (status = 'assigned') DESC I think you want: ORDER BY status DESC -- SIXNET - Solutions for Your Industrial Networking Challenges 331 Ushers Road, Ballston Lake, NY 12019 Tel: 1.518.877.5173, Fax: 1.518.877.8346 www.sixnet.com -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
