Report "SELECT * FROM ticket t" does not work and cannot be deleted.

[anonymous]

I was adding a new report and I put "SELECT * FROM ticket t"

I got this traceback:

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

And now I cannot delete the report...

[cmlenz]

This has been fixed some time ago (not sure which rev). It works now, and the report can be deleted.