#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'
| 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 , 3 years ago
comment:2 by , 2 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
Version 0, edited 2 years ago by (next)
Note:
See TracTickets
for help on using tickets.
That was already reported in #9267. Static resourses are not updated.