DB Error when seeing tickets by milestone with Postgresql

[Martin <martin@…>]

When trying to see tickets by milestone I get:

Report execution failed: no existe la columna «modified» LINE 16: (CASE status WHEN 'closed' THEN modified ELSE (-1)*p…

Checking postgresql logs I see this:

LOG:  sentencia:
        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 'martin' 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
          LEFT JOIN enum p ON 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

ERROR:  no existe la columna «modified» en carácter 614

[Christian Boos]

Duplicate of #5543.