id summary reporter owner description type status priority component severity resolution keywords cc release 11309 ProgrammingError: operator does not exist: text = integerLINE 1: SELECT dest FROM mastertickets WHERE source=2 ORDER BY dest ^HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. jerry "==== How to Reproduce ==== While doing a GET operation on `/ticket/2`, Trac issued an internal error. ''(please provide additional details here)'' Request parameters: {{{ {'id': u'2'} }}} User agent: `Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.65 Safari/537.36` ==== System Information ==== || '''`Trac`''' || `1.0` || || '''`Agilo`''' || `1.3.10-PRO` || || '''`Genshi`''' || `0.7 (without speedups)` || || '''`psycopg2`''' || `2.0.14` || || '''`Pygments`''' || `1.4` || || '''`Python`''' || `2.6.8 (unknown, Mar 14 2013, 09:31:22) ` [[br]] `[GCC 4.6.2 20111027 (Red Hat 4.6.2-2)]` || || '''`setuptools`''' || `0.8` || || '''`Subversion`''' || `1.7.10 (r1485443)` || || '''`jQuery`''' || `1.7.2` || ==== Enabled Plugins ==== || '''`binary-agilo`''' || `1.3.10-PRO` || || '''`TestManager`''' || `1.7.1` || || '''`TracAccountManager`''' || `0.4.3` || || '''`TracGenericClass`''' || `1.1.5` || || '''`TracGenericWorkflow`''' || `1.0.4` || || '''`TracMasterTickets`''' || `2.1.3` || || '''`TracPermRedirect`''' || `3.0` || || '''`TracSQL`''' || `0.3` || || '''`TracStats`''' || `0.5` || || '''`TracXMLRPC`''' || `0.1` || ==== Python Traceback ==== {{{ Traceback (most recent call last): File ""build/bdist.linux-x86_64/egg/trac/web/main.py"", line 497, in _dispatch_request dispatcher.dispatch(req) File ""build/bdist.linux-x86_64/egg/trac/web/main.py"", line 224, in dispatch self._post_process_request(req, *resp) File ""build/bdist.linux-x86_64/egg/trac/web/main.py"", line 338, 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 ""build/bdist.linux-x86_64/egg/trac/db/util.py"", line 65, 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=2 ORDER BY dest ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. }}}" defect closed normal MasterTicketsPlugin normal worksforme 1.0