[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:
 It shows this error:

 Report execution failed:
 OperationalError: ambiguous column name: description

 SELECT p.value AS __color__,
    (CASE status WHEN 'accepted' THEN 'Accepted' ELSE 'Owned' END) AS
    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