id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
10131	ProgrammingError: operator does not exist: text = integerLINE 1: DELETE FROM testcaseinplan WHERE id = 398                                            ^HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.	eric@lincware.com	seccanj	==== How to Reproduce ====\r\n\r\nWhile doing a POST operation on `/wiki/TC_TT36_TT42_TT154_TC398`, Trac issued an internal error.\r\n\r\n''Please let me know what other info you need to debug this... basically was just trying to delete a test case. [mailto:eric@lincware.com]''\r\n\r\nRequest parameters:\r\n{{{\r\n{'__FORM_TOKEN': u'e1c5260b79502c4db55a8ea9',\r\n 'action': u'delete',\r\n 'page': u'TC_TT36_TT42_TT154_TC398'}\r\n}}}\r\n\r\nUser agent: `Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.79 Safari/535.11`\r\n\r\n==== System Information ====\r\n|| '''`Trac`''' || `0.12.2` ||\r\n|| '''`Babel`''' || `0.9.6 (translations unavailable)` ||\r\n|| '''`Docutils`''' || `0.8.1` ||\r\n|| '''`Genshi`''' || `0.6` ||\r\n|| '''`mod_python`''' || `3.3.1` ||\r\n|| '''`psycopg2`''' || `2.4.5` ||\r\n|| '''`Pygments`''' || `1.4` ||\r\n|| '''`Python`''' || `2.7.3 (default, Apr 20 2012, 23:04:22) ` [[br]] `[GCC 4.6.3]` ||\r\n|| '''`pytz`''' || `2011k` ||\r\n|| '''`setuptools`''' || `0.6` ||\r\n|| '''`Subversion`''' || `1.6.17 (r1128011)` ||\r\n|| '''`jQuery`''' || `1.4.2` ||\r\n\r\n==== Enabled Plugins ====\r\n|| '''`TestManager`''' || `1.4.11` ||\r\n|| '''`TracGenericClass`''' || `1.1.3` ||\r\n|| '''`TracGenericWorkflow`''' || `1.0.3` ||\r\n\r\n==== Python Traceback ====\r\n{{{\r\nTraceback (most recent call last):\r\n  File "/usr/lib/python2.7/dist-packages/trac/web/main.py", line 511, in _dispatch_request\r\n    dispatcher.dispatch(req)\r\n  File "/usr/lib/python2.7/dist-packages/trac/web/main.py", line 237, in dispatch\r\n    resp = chosen_handler.process_request(req)\r\n  File "/usr/lib/python2.7/dist-packages/trac/wiki/web_ui.py", line 147, in process_request\r\n    self._do_delete(req, versioned_page)\r\n  File "/usr/lib/python2.7/dist-packages/trac/wiki/web_ui.py", line 254, in _do_delete\r\n    @self.env.with_transaction()\r\n  File "/usr/lib/python2.7/dist-packages/trac/db/api.py", line 77, in transaction_wrapper\r\n    fn(ldb)\r\n  File "/usr/lib/python2.7/dist-packages/trac/wiki/web_ui.py", line 262, in do_delete\r\n    page.delete(version, db)\r\n  File "/usr/lib/python2.7/dist-packages/trac/wiki/model.py", line 114, in delete\r\n    listener.wiki_page_deleted(self)\r\n  File "/var/lib/trac/plugins/TestManager-1.4.11-py2.7.egg/testmanager/wiki.py", line 98, in wiki_page_deleted\r\n    tc.delete(del_wiki_page=False)\r\n  File "/var/lib/trac/plugins/TracGenericClass-1.1.3-py2.7.egg/tracgenericclass/model.py", line 980, in delete\r\n    AbstractVariableFieldsObject.delete(self, db)\r\n  File "/var/lib/trac/plugins/TracGenericClass-1.1.3-py2.7.egg/tracgenericclass/model.py", line 675, in delete\r\n    self.post_delete(db)\r\n  File "/var/lib/trac/plugins/TestManager-1.4.11-py2.7.egg/testmanager/model.py", line 336, in post_delete\r\n    cursor.execute('DELETE FROM testcaseinplan WHERE id = %s' % self['id'])\r\n  File "/usr/lib/python2.7/dist-packages/trac/db/util.py", line 66, in execute\r\n    return self.cursor.execute(sql)\r\nProgrammingError: operator does not exist: text = integer\r\nLINE 1: DELETE FROM testcaseinplan WHERE id = 398\r\n                                            ^\r\nHINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.\r\n\r\n}}}	defect	closed	normal	TestManagerForTracPlugin	normal	fixed			0.12