[FFmpeg-trac] #9472(trac:new): Error on clicking Popular voted tickets

FFmpeg trac at avcodec.org
Sat Oct 23 16:11:41 EEST 2021


#9472: Error on clicking Popular voted tickets
--------------------------------+---------------------------------------
             Reporter:  necros  |                     Type:  defect
               Status:  new     |                 Priority:  normal
            Component:  trac    |                  Version:  unspecified
             Keywords:          |               Blocked By:
             Blocking:          |  Reproduced by developer:  0
Analyzed by developer:  0       |
--------------------------------+---------------------------------------
 Report execution failed:
 OperationalError: ambiguous column name: version
 SELECT COUNT(*) FROM (
 SELECT p.value AS __color__,
    t.type AS type, id AS ticket, sum(v.vote) as votes, summary, component,
 version,
 milestone,
    time AS created,
    changetime AS _changetime, description AS _description,
    reporter AS _reporter
   FROM ticket t, enum p, votes v
   WHERE status <> 'closed'
 AND p.name = t.priority AND p.type = 'priority'
 AND v.resource = 'ticket/' || id
 GROUP BY id, summary, component, version, t.type, owner,
 time,
   changetime, description, reporter, p.value, status
 HAVING sum(v.vote) > 0
  ORDER BY votes DESC, t.type, time
 ) AS tab
-- 
Ticket URL: <https://trac.ffmpeg.org/ticket/9472>
FFmpeg <https://ffmpeg.org>
FFmpeg issue tracker


More information about the FFmpeg-trac mailing list