Opened 3 years ago

Closed 14 months ago

#9267 closed defect (fixed)

"My reported tickets" query not working

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

Description

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

Change History (2)

comment:1 by Balling, 3 years ago

Yes, I also saw that and https://trac.ffmpeg.org/report/11 too.

comment:2 by Michael Niedermayer, 14 months ago

Resolution: fixed
Status: newclosed

All trac reports fixed

Note: See TracTickets for help on using tickets.