James B. Byrne wrote:
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?
http://www.dsource.org/forums/viewtopic.php?p=7011#7011
BA
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
