[Trac] how to solve missing column 'modified' from table track issue?

[Ákos Maróy]

I'm trying to access pre-defined report {6} All Tickets By Milestone
(Including closed) on my track installation, but I get the following error:


Report execution failed: ERROR: column "modified" does not exist 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 'anonymous' 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


for reference, the problematic page can be found here:

http://dev.tilos.hu/projects/ikra/report/6


I'm using postgresql for persistence. how can I resolve the issue?


I was thinking of doing an upgrade in trac-admin, but says my trac
installation is up-to-date.

I was also considering adding the column manually, but I didn't find the
original table definitions anywhere :(


Akos