Modify

Opened 5 years ago

Last modified 3 years ago

#6369 assigned defect

InternalError during receiving detailed rss feed

Reported by: anonymous Owned by: oneirist
Priority: normal Component: DetailedRssFeedPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12

Description

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

Attachments (0)

Change History (5)

comment:1 Changed 5 years ago by oneirist

  • Status changed from new to assigned

Hey, are you still having this problem?

comment:2 Changed 4 years ago by 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.

comment:3 Changed 4 years ago by oneirist

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

comment:4 follow-up: Changed 3 years ago by isis.binder@…

  • Trac Release changed from 0.11 to 0.12

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")

comment:5 in reply to: ↑ 4 Changed 3 years ago by 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.

Add Comment

Modify Ticket

Action
as assigned .
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.