Edgewall Software

Opened 17 years ago

Closed 17 years ago

Last modified 16 years ago

#2113 closed defect (fixed)

Ticket report filter exception if multiple empty criteria given

Reported by: anonymous Owned by: Christopher Lenz
Priority: normal Milestone: 0.9
Component: ticket system Version: 0.9b1
Severity: major Keywords: query
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


Add two filters to your criteria which can be combined with "OR" (I was doing it with adding two "Owner" filters). Leave both values emty and click "Update". I get an exception:

Python traceback

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/trac/web/modpython_frontend.py", line 205, in handler
    dispatch_request(mpr.path_info, mpr, env)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 139, in dispatch_request
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 107, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.3/site-packages/trac/ticket/query.py", line 388, in process_request
    self.display_html(req, query)
  File "/usr/lib/python2.3/site-packages/trac/ticket/query.py", line 502, in display_html
    tickets = query.execute(db)
  File "/usr/lib/python2.3/site-packages/trac/ticket/query.py", line 133, in execute
    sql = self.get_sql()
  File "/usr/lib/python2.3/site-packages/trac/ticket/query.py", line 251, in get_sql
    clauses.append("(" + " OR ".join(constraint_sql) + ")")
TypeError: sequence item 0: expected string, NoneType found

This reproducable on your public site I am writing this ticket on.

Attachments (0)

Change History (2)

comment:1 by Christopher Lenz, 17 years ago

Component: report systemticket system
Keywords: query added
Milestone: 0.9
Owner: changed from daniel to Christopher Lenz
Status: newassigned

comment:2 by Christopher Lenz, 17 years ago

Resolution: fixed
Status: assignedclosed

Fixed in [2292].

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Christopher Lenz.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Christopher Lenz 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.