InternalError during receiving detailed rss feed

[anonymous]

After clicking to "Detailed RSS Feed" on the report page I see this:

Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/trac/web/api.py", line 377, in send_error
    'text/html')
  File "/usr/lib/python2.6/site-packages/trac/web/chrome.py", line 733, in render_template
    message = req.session.pop('chrome.%s.%d' % (type_, i))
  File "/usr/lib/python2.6/site-packages/trac/web/api.py", line 195, in __getattr__
    value = self.callbacks[name](self)
  File "/usr/lib/python2.6/site-packages/trac/web/main.py", line 265, in _get_session
    return Session(self.env, req)
  File "/usr/lib/python2.6/site-packages/trac/web/session.py", line 159, in __init__
    self.promote_session(sid)
  File "/usr/lib/python2.6/site-packages/trac/web/session.py", line 217, in promote_session
    "WHERE sid=%s OR sid=%s ", (sid, self.req.authname))
  File "/usr/lib/python2.6/site-packages/trac/db/util.py", line 64, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.6/site-packages/trac/db/util.py", line 64, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
InternalError: current transaction is aborted, commands ignored until end of transaction block

I tested it on 0.11.5 and 0.11.6 versions

[nikolaus]

Hey, are you still having this problem?

[henrik.steensland@…]

I don't know about the original reporter, but I have the same problem. Trac: 0.11.5-2ubuntu1.1 DetailedRssFeedPlugin: SVN head 2010-05-17 Postgresql: 8.4.3-0ubuntu9.10.1

I have not found any workaround, meaning the plugin is currently unusable to me, which is sad, because I would very much like the functionality.

[nikolaus]

I'll see if I can look into this over the weekend.

[isis.binder@…]

I had this Internal Server Error using Trac 0.12:

2011-05-02 13:20:43,225 Trac[report] DEBUG: Request args: {'detailed': u'true', 'id': u'1', 'format': u'rss'}
2011-05-02 13:20:43,233 Trac[ReportToDetailedRSS] DEBUG: Detailed Feed Requested.
2011-05-02 13:20:43,233 Trac[ReportToDetailedRSS] DEBUG: Tickets in Report: set([u'2'])
2011-05-02 13:20:43,241 Trac[main] ERROR: Internal Server Error:
Traceback (most recent call last):
  File "build/bdist.linux-i686/egg/trac/web/main.py", line 511, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.linux-i686/egg/trac/web/main.py", line 248, in dispatch
    self._post_process_request(req, *resp)
  File "build/bdist.linux-i686/egg/trac/web/main.py", line 357, in _post_process_request
    resp = f.post_process_request(req, *resp)
  File "build/bdist.linux-i686/egg/ReportToDetailedRSS/ReportToDetailedRSS.py", line 58, in post_process_request
    return self.intercept_report_rss(req,data)
  File "build/bdist.linux-i686/egg/ReportToDetailedRSS/ReportToDetailedRSS.py", line 118, in intercept_report_rss
    cursor.execute(sql)
  File "build/bdist.linux-i686/egg/trac/db/util.py", line 66, in execute
    return self.cursor.execute(sql)
  File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 20")

[isis.binder@…]

The issue seems to be the LIMIT -1:

#if their limit is set to '0', sqlite will return 0 rows. thus, make it -1 instead limit = self.config.getint('report','items_per_page_rss',-1) or -1

In the [report] section of trac.ini I had items_per_page_rss = 0. When I changed it to 10, it worked like a charm. Then I commented out the setting and the error was back again. Maybe you could append de LIMIT clause if there is a preconfigured integer in trac.ini.