id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
9971	PostgreSQL 9.1: ProgrammingError: column "ticket_type" does not exist	msudyin@gmail.com	anonymous	Hello,\r\n\r\nOn Trac 0.12.3 with PostgewSQL 9.1 database back-end the following error is observed when try to go Admin > Child Tickets Plugin > Parent Types page:\r\n{{{\r\n2012-04-17 22:11:05,817 Trac[main] ERROR: Internal Server Error:\r\nTraceback (most recent call last):\r\n  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/web/main.py", line 522, in _dispatch_request\r\n    dispatcher.dispatch(req)\r\n  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/web/main.py", line 243, in dispatch\r\n    resp = chosen_handler.process_request(req)\r\n  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/admin/web_ui.py", line 117, in process_request\r\n    path_info)\r\n  File "/usr/local/lib/python2.6/dist-packages/Tracchildtickets-2.5.0-py2.6.egg/childtickets/admin.py", line 43, in render_admin_panel\r\n    for t in self._types():\r\n  File "/usr/local/lib/python2.6/dist-packages/Tracchildtickets-2.5.0-py2.6.egg/childtickets/admin.py", line 133, in _types\r\n    cursor.execute('select name from enum where type="ticket_type"')\r\n  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3-py2.6.egg/trac/db/util.py", line 66, in execute\r\n    return self.cursor.execute(sql)\r\nProgrammingError: column "ticket_type" does not exist\r\nLINE 1: select name from enum where type="ticket_type"\r\n                                         ^\r\nProgrammingError: column "ticket_type" does not exist\r\nLINE 1: select name from enum where type="ticket_type"\r\n                                         ^\r\n\r\n}}}\r\n\r\nIssue is fixed easily:\r\n{{{\r\n--- childtickets/admin.py.orig       2012-04-15 19:48:06.000000000 +0700\r\n+++ childtickets/admin.py            2012-04-17 22:20:32.000000000 +0700\r\n@@ -130,7 +130,7 @@ class ChildTicketsAdminPanel(Component):\r\n         # For trac 0.13 : self.env.db_query('SELECT name FROM enum WHERE type="ticket_type"')\r\n         db = self.env.get_db_cnx()\r\n         cursor = db.cursor()\r\n-        cursor.execute('select name from enum where type="ticket_type"')\r\n+        cursor.execute("select name from enum where type='ticket_type'")\r\n         if not ptype:\r\n             # No parent type supplied, return simple list.\r\n             return [ x for (x,) in cursor.fetchall() ]\r\n\r\n}}}	defect	closed	normal	ChildTicketsPlugin	blocker	fixed			0.12