{27} Closed with no milestone

This report shows tickets that have been closed as fixed, but never given a milestone.

Report execution failed:
InternalError: (1305, u'FUNCTION trac.strftime does not exist')

SELECT COUNT(*) FROM (
SELECT p.value AS __color__,
       t.version AS __group__,
       id AS ticket,
       summary,
       component,
       status, 
       resolution,
       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'
    AND t.status='closed'
    AND t.resolution='fixed'
    AND (t.milestone='unknown' OR t.milestone='')
    AND (strftime('%s', 'now') - t.changetime/1000000) <= (60 * 60 * 24 * 365)
  ORDER BY version DESC

) AS tab
Note: See TracReports for help on using and creating reports.