ProgrammingError: operator does not exist: text = integer LINE 1: SELECT dest FROM mastertickets WHERE source=1732 ORDER BY de... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

[software@…]

It seems the MasterTicketsPlugin does not like being on PostgreSQL. The following type error is proof:

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'id': u'1732'}

User Agent was: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.4pre) Gecko/20090929 Ubuntu/8.04 (hardy) Shiretoko/3.5.4pre

System Information

Trac	0.11.1
Python	2.5.2 (r252:60911, Jan 4 2009, 21:59:32) [GCC 4.3.2]
setuptools	0.6c8
psycopg2	2.0.7
Genshi	0.5.1
Pygments	0.10
Subversion	1.5.1 (r32289)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 423, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 209, in dispatch
    self._post_process_request(req, *resp)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 299, in _post_process_request
    resp = f.post_process_request(req, *resp)
  File "build/bdist.linux-x86_64/egg/mastertickets/web_ui.py", line 45, in post_process_request
    links = TicketLinks(self.env, tkt)
  File "build/bdist.linux-x86_64/egg/mastertickets/model.py", line 22, in __init__
    cursor.execute('SELECT dest FROM mastertickets WHERE source=%s ORDER BY dest', (self.tkt.id,))
  File "/usr/lib/python2.5/site-packages/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/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: SELECT dest FROM mastertickets WHERE source=1732 ORDER BY de...
                                                   ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

[Felix Schwarz <felix.schwarz@…>]

WrongTrac - ​please use trac-hacks