#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_______________________________________________
FFmpeg-trac mailing list
[email protected]
https://ffmpeg.org/mailman/listinfo/ffmpeg-trac
To unsubscribe, visit link above, or email
[email protected] with subject "unsubscribe".
