Re: [Trac] Report execution failed: OperationalError: near "AS": syntax error

2017-07-05 Thread toto200891
Oh yes! Thank you so much. Regards, SF On Wednesday, July 5, 2017 at 9:59:38 AM UTC+2, Jun Omae wrote: > > Hi, > > On Wed, Jul 5, 2017 at 4:42 PM, toto200891 > wrote: > > > > SELECT COUNT(*) FROM ( > > > > SELECT p.value AS __color__, > >id AS ticket, summary, component, version, mile

Re: [Trac] Report execution failed: OperationalError: near "AS": syntax error

2017-07-05 Thread Jun Omae
Hi, On Wed, Jul 5, 2017 at 4:42 PM, toto200891 wrote: > > 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, >r

[Trac] Report execution failed: OperationalError: near "AS": syntax error

2017-07-05 Thread toto200891
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: Rep