Opened 4 years ago
Closed 2 years ago
#9267 closed defect (fixed)
"My reported tickets" query not working
Reported by: | Elliott | Owned by: | |
---|---|---|---|
Priority: | normal | Component: | trac |
Version: | unspecified | Keywords: | |
Cc: | Blocked By: | ||
Blocking: | Reproduced by developer: | no | |
Analyzed by developer: | no |
Description
I am unable to see a list of my reported tickets at this URL: https://trac.ffmpeg.org/report/10
It shows this error:
Report execution failed: OperationalError: ambiguous column name: description SELECT COUNT(*) FROM ( SELECT p.value AS __color__, (CASE status WHEN 'accepted' THEN 'Accepted' ELSE 'Owned' END) AS __group__, id AS ticket, summary, component, version, milestone, t.type AS type, priority, time AS created, changetime AS _changetime, description AS _description, reporter AS _reporter FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' WHERE t.status <> 'closed' AND reporter = %s ORDER BY (status = 'accepted') DESC, CAST(p.value AS integer), milestone, t.type, time ) AS tab
Note:
See TracTickets
for help on using tickets.
Yes, I also saw that and https://trac.ffmpeg.org/report/11 too.