Hi I am using TRAC 1.0.2, with standalone server and python 2.7.13, till now everything was going great, I am really loving the software. But accidently I messed up with one of my reports.
I tried adding a component into the "ACTIVE TICKETS" report, but I experienced the following error: Report execution failed: OperationalError: near "AS": syntax error ------------------------------ SELECT COUNT(*) FROM ( SELECT p.value AS __color__, id AS ticket, summary, component, version, milestone, t.type AS type, owner, status time AS created, changetime AS _changetime, description AS _description, reporter AS _reporter FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' WHERE status <> 'closed' ORDER BY CAST(p.value AS integer), milestone, t.type, time ) AS tab Later I removed the changes I made, but still could get rid of this error. Please someone help me in this regard. Thanking you & regards, SF -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscr...@googlegroups.com. To post to this group, send email to trac-users@googlegroups.com. Visit this group at https://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.