I use a PostgreSQL 1.8.3 backend to trac-0.9.4 running under Apache
2.0.52 over https. I have one closed ticket on the system. When I
try and run the sample closed ticket report: {6} All Tickets By
Milestone (Including closed), I get the following error:
"Report execution failed: column "modified" does not exist"
The SQL provided by trac for this query is:
> SELECT p.value AS __color__,
> t.milestone AS __group__,
> (CASE status
> WHEN 'closed' THEN 'color: #777; background: #ddd;
> border-color: #ccc;' ELSE
> (CASE owner WHEN '$USER' THEN 'font-weight: bold' END)
> END) AS __style__,
> id AS ticket, summary, component, status,
> resolution,version, t.type AS type, priority, owner,
> changetime AS modified,
> time AS _time,reporter AS _reporter
> FROM ticket t,enum p
> WHERE p.name=t.priority AND p.type='priority'
> ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'),
>
> (CASE status WHEN 'closed' THEN modified ELSE (-1)*p.value
> END) DESC
'changetime' is defined in the PostgreSQL schema as an integer.
What needs to be fixed?
Regards,
Jim
--
*** e-mail is not a secure channel ***
mailto:byrnejb.<token>@harte-lyne.ca
James B. Byrne Harte & Lyne Limited
vox: +1 905 561 1241 9 Brockley Drive
fax: +1 905 561 0757 Hamilton, Ontario
<token> = hal Canada L8E 3C3
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
