id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,branch,changelog,apichanges,internalchanges 8704,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) ` [[br]] `[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. }}} ",defect,closed,normal,,ticket system,0.11.1,major,invalid,"plugins, MasterTicketsPlugin, SQL, error, PostgreSQL, postgresql",,,,,