Edgewall Software
Modify

Opened 20 years ago

Closed 19 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:

Description

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…

Attachments (0)

Change History (2)

comment:1 by Christopher Lenz, 20 years ago

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

comment:2 by Christopher Lenz, 19 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
Action
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.