id summary reporter owner description type status priority milestone component version severity resolution keywords cc branch changelog apichanges internalchanges 11613 "DataError: invalid input syntax for integer: ""x""LINE 2: ... SELECT title, description, query from report WHERE id='x' ^" ldubox-coding101@… Jun Omae "==== How to reproduce ==== While doing a GET operation on `/ticket/6728`, Trac issued an internal error. ''Just try and browse to the ticket. An excerpt for it appears in the search results, but trying to actually view the ticket fails.'' Request parameters: {{{ {'id': u'6728'} }}} User agent: `Mozilla/5.0 (Windows NT 6.1; WOW64; rv:30.0) Gecko/20100101 Firefox/30.0` ==== Python Traceback ==== {{{ Traceback (most recent call last): File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/web/main.py"", line 517, in _dispatch_request dispatcher.dispatch(req) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/web/main.py"", line 221, in dispatch resp = chosen_handler.process_request(req) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/ticket/web_ui.py"", line 188, in process_request return self._process_ticket_request(req) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/ticket/web_ui.py"", line 658, in _process_ticket_request get_reporter_id(req, 'author'), field_changes) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/ticket/web_ui.py"", line 1628, in _insert_ticket_data fields = self._prepare_fields(req, ticket, field_changes) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/ticket/web_ui.py"", line 1589, in _prepare_fields escape_newlines=self.must_preserve_newlines) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/wiki/formatter.py"", line 1589, in format_to_html return HtmlFormatter(env, context, wikidom).generate(escape_newlines) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/wiki/formatter.py"", line 1544, in generate escape_newlines) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/wiki/formatter.py"", line 1326, in format result = re.sub(self.wikiparser.rules, self.replace, line) File ""/usr/lib/python2.7/re.py"", line 151, in sub return _compile(pattern, flags).sub(repl, string, count) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/wiki/formatter.py"", line 1244, in replace replacement = self.handle_match(fullmatch) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/wiki/formatter.py"", line 1240, in handle_match return internal_handler(match, fullmatch) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/wiki/formatter.py"", line 623, in _shref_formatter return self._make_link(ns, target, match, match, fullmatch) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/wiki/formatter.py"", line 674, in _make_link fullmatch) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/ticket/report.py"", line 913, in _format_link self.get_report(id) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/ticket/report.py"", line 762, in get_report """""", (id,)): File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/db/api.py"", line 122, in execute return db.execute(query, params) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/db/util.py"", line 121, in execute cursor.execute(query, params) File ""/usr/local/virtualenv/1.1dev/lib/python2.7/site-packages/Trac-1.1.2dev_r12592-py2.7.egg/trac/db/util.py"", line 65, in execute return self.cursor.execute(sql_escape_percent(sql), args) DataError: invalid input syntax for integer: ""x"" LINE 2: ... SELECT title, description, query from report WHERE id='x' ^ }}}" defect closed normal 1.0.2 report system 1.0-stable normal fixed postgresql Fix `report:` link with non-digit characters leading `DataError` on PostgreSQL.