I see, how can i correct this error ? can i edit the SQL for that report somehow ? how come it came wrong ?
Hope they are not too many questions ! On Feb 17, 12:03 pm, "Matt Caron" <[email protected]> wrote: > > 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.8346www.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.
