[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