ProgrammingError: operator does not exist: text = integerLINE 1: ...mment',null,description,0 FROM attachment WHERE id=327 ORDER... ^HINT: No operator matches the given name and argument type(s)

Issue #332 resolved
Former user created an issue

==== How to Reproduce ====

While doing a GET operation on /ticket/327, Trac issued an internal error.

''(please provide additional details here)''

Request parameters:
{{{
{'id': u'327'}
}}}

==== System Information ====

'''Trac''' 0.11dev-r6122
'''setuptools''' 0.6c5
'''psycopg2''' 2.0.6
'''Genshi''' 0.4.3
'''Pygments''' None
'''Mercurial''' 0.9.5

==== Python Traceback ====
{{{
Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r6122-py2.5.egg/trac/web/main.py", line 381, in dispatch_request
dispatcher.dispatch(req)
File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r6122-py2.5.egg/trac/web/main.py", line 191, in dispatch
resp = chosen_handler.process_request(req)
File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r6122-py2.5.egg/trac/ticket/web_ui.py", line 154, in process_request
return self._process_ticket_request(req)
File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r6122-py2.5.egg/trac/ticket/web_ui.py", line 452, in _process_ticket_request
field_changes)
File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r6122-py2.5.egg/trac/ticket/web_ui.py", line 1004, in _insert_ticket_data
for change in self.rendered_changelog_entries(context):
File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r6122-py2.5.egg/trac/ticket/web_ui.py", line 1099, in rendered_changelog_entries
when):
File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r6122-py2.5.egg/trac/ticket/web_ui.py", line 1163, in grouped_changelog_entries
changelog = ticket.get_changelog(when=when, db=db)
File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r6122-py2.5.egg/trac/ticket/model.py", line 305, in get_changelog
"ORDER BY time", (self.id, str(self.id), self.id))
File "/usr/lib/python2.5/site-packages/Trac-0.11dev_r6122-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.11dev_r6122-py2.5.egg/trac/db/util.py", line 50, in execute
return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: operator does not exist: text = integer
LINE 1: ...mment',null,description,0 FROM attachment WHERE id=327 ORDER...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

}}}

Reported by mpech

Comments (2)

  1. Log in to comment