ProgrammingError: current transaction is aborted, commands ignored until end of transaction block

[stodge@…]

Installed Trac 0.11, clicked the button to create a new report.

Entered:

Title = My test report Description = Description! Query for report as shown below. I copied this query from the QueryLanguage page that is linked from the new report page:

[query:?status=new&status=assigned&status=reopened&group=owner Assigned tickets by owner]

I got the following stack dump:

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/api.py", line 339, in send_error
    'text/html')
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/chrome.py", line 708, in render_template
    if not req.session or not int(req.session.get('accesskeys', 0)):
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/api.py", line 168, in __getattr__
    value = self.callbacks[name](self)
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/main.py", line 257, in _get_session
    return Session(self.env, req)
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/session.py", line 142, in __init__
    self.get_session(req.authname, authenticated=True)
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/session.py", line 156, in get_session
    super(Session, self).get_session(sid, authenticated)
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/session.py", line 56, in get_session
    (sid, int(authenticated)))
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: current transaction is aborted, commands ignored until end of transaction block

Refreshing the list of reports shows that this new report is available, but trying to view this report gives the above stack dump.

This report cannot be deleted with manually deleting it from the postgresql table.

[stodge@…]

Sorry, forgot to set the version number - setting to 0.11.

[Jonas Borgström]

If you want to use query-style reports you should use the following syntax:

query:....

and not:

[query:.... label]

0.11 with PostgreSQL has a known problem with deleting invalid reportsl. This was fixed in #7354 and will be included in the upcoming 0.11.1 release. (You can use the 0.11-stable branch if you want)