Edgewall Software

Opened 18 years ago

Closed 17 years ago

#1027 closed defect (fixed)

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

Reported by: anonymous Owned by: daniel
Priority: high Milestone: 0.9
Component: report system Version: 0.8
Severity: major Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


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
  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
  File "/usr/lib/python2.3/site-packages/trac/Module.py", line 44, in run
  File "/usr/lib/python2.3/site-packages/trac/Report.py", line 429, in render
  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…

Attachments (0)

Change History (2)

comment:1 by Christopher Lenz, 17 years ago

Component: search systemreport system
Owner: changed from Jonas Borgström to daniel
Priority: normalhigh
Severity: normalmajor

comment:2 by Christopher Lenz, 17 years ago

Milestone: 0.9
Resolution: fixed
Status: newclosed

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

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain daniel.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from daniel to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.