ProgrammingError: column "modified" does not exist

[Ryan J Ollos]

2015-06-04 09:31:24,642 Trac[report] WARNING: Exception caught while executing report: u"SELECT COUNT(*) FROM (\nSELECT p.value AS __color__,\r\n   t.milestone AS __group__,\r\n   (CASE status \r\n      WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;'\r\n      ELSE \r\n        (CASE owner WHEN ''||%s||'' THEN 'font-weight: bold' END)\r\n    END) AS __style__,\r\n   id AS ticket, summary, component, status, \r\n   resolution,version, t.type AS type, severity, priority, owner,\r\n   changetime AS modified,\r\n   time AS _time,reporter AS _reporter\r\n  FROM ticket t,enum p\r\n  WHERE p.name=t.priority AND p.type='priority'\r\n  ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'), \r\n        (CASE status WHEN 'closed' THEN modified ELSE -p.value END) DESC\r\n\n) AS tab", args ['anonymous']
Traceback (most recent call last):
  File "/srv/trac-hacks.org/pve/lib/python2.6/site-packages/Trac-1.0.6post2-py2.6.egg/trac/ticket/report.py", line 683, in execute_paginated_report
    cursor.execute(count_sql, args)
  File "/srv/trac-hacks.org/pve/lib/python2.6/site-packages/Trac-1.0.6post2-py2.6.egg/trac/db/util.py", line 72, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: column "modified" does not exist
LINE 16:         (CASE status WHEN 'closed' THEN modified ELSE -p.val...
                                                 ^
ProgrammingError: column "modified" does not exist
LINE 16:         (CASE status WHEN 'closed' THEN modified ELSE -p.val...
                                                 ^

[Ryan J Ollos]

This is due to report {6}.

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, severity, 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 -p.value END) DESC

Modified to:

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, severity, 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 changetime ELSE -CAST(p.value AS int) END) DESC