[FFmpeg-trac] #9267(trac:new): "My reported tickets" query not working
FFmpeg
trac at avcodec.org
Thu May 27 22:17:40 EEST 2021
#9267: "My reported tickets" query not working
---------------------------------+---------------------------------------
Reporter: Elliott | Type: defect
Status: new | Priority: normal
Component: trac | Version: unspecified
Keywords: | Blocked By:
Blocking: | Reproduced by developer: 0
Analyzed by developer: 0 |
---------------------------------+---------------------------------------
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
}}}
--
Ticket URL: <https://trac.ffmpeg.org/ticket/9267>
FFmpeg <https://ffmpeg.org>
FFmpeg issue tracker
More information about the FFmpeg-trac
mailing list