encounter a bug creating a new report

[mathieu@…]

my sql was

select * from ticket;

I got the following message

 Trac detected an internal error:

'TICKET'


Python traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.4/site-packages/trac/core.py", line 525, in cgi_start
    real_cgi_start()
  File "/usr/local/lib/python2.4/site-packages/trac/core.py", line 520, in real_cgi_start
    dispatch_request(path_info, args, req, env)
  File "/usr/local/lib/python2.4/site-packages/trac/core.py", line 435, in dispatch_request
    module.run()
  File "/usr/local/lib/python2.4/site-packages/trac/Module.py", line 44, in run
    self.render()
  File "/usr/local/lib/python2.4/site-packages/trac/Report.py", line 429, in render
    self.render_report_list(id)
  File "/usr/local/lib/python2.4/site-packages/trac/Report.py", line 353, in render_report_list
    value['ticket_href'] = self.env.href.ticket(row['ticket'])
  File "/usr/local/lib/python2.4/site-packages/sqlite/main.py", line 104, in __getitem__
    key = self.__class__._xlatkey[key.upper()]
KeyError: 'TICKET'

[Matthew Good]

Reports require a selected column called "ticket" which is the ticket's id. So you need to alias the ticket's column "id" as "ticket". See TracReports for more information, or base your report off one of the included reports.