Opened 3 years ago

Closed 14 months ago

Last modified 14 months ago

#9472 closed defect (fixed)

Error on clicking Popular voted tickets

Reported by: necros Owned by:
Priority: normal Component: trac
Version: unspecified Keywords:
Cc: Blocked By:
Blocking: Reproduced by developer: no
Analyzed by developer: no

Description

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

Change History (2)

comment:1 by Balling, 3 years ago

That was already reported in #9267. Static resourses are not updated.

comment:2 by Balling, 14 months ago

Resolution: fixed
Status: newclosed
Last edited 14 months ago by Balling (previous) (diff)
Note: See TracTickets for help on using tickets.