id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
10191,integer = boolean,anonymous,doki_pen,While trying to configure the AnnouncerPlugin_ I get the following:\r\n\r\n{{{\r\nTrac detected an internal error:\r\n\r\nProgrammingError: operator does not exist: integer = boolean\r\nLINE 6:                  AND authenticated=true\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\r\n{{{\r\nMost recent call last:\r\n\r\nFile "/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/web/main.py"_ line 522_ in _dispatch_request\r\n  dispatcher.dispatch(req)\r\nFile "/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/web/main.py"_ line 243_ in dispatch\r\n  resp = chosen_handler.process_request(req)\r\nFile "/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/prefs/web_ui.py"_ line 77_ in process_request\r\n  template_ data = chosen_provider.render_preference_panel(req_ panel_id)\r\nFile "/usr/local/lib/python2.7/site-packages/TracAnnouncer-0.12.1dev-py2.7.egg/announcer/pref.py"_ line 170_ in render_preference_panel\r\n  req.session.sid_ req.session.authenticated_ j):\r\nFile "/usr/local/lib/python2.7/site-packages/TracAnnouncer-0.12.1dev-py2.7.egg/announcer/model.py"_ line 147_ in find_by_sid_and_distributor\r\n  @env.with_transaction(db)\r\nFile "/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/api.py"_ line 77_ in transaction_wrapper\r\n  fn(ldb)\r\nFile "/usr/local/lib/python2.7/site-packages/TracAnnouncer-0.12.1dev-py2.7.egg/announcer/model.py"_ line 158_ in do_select\r\n  """_ (sid_authenticated_distributor))\r\nFile "/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/util.py"_ line 65_ in execute\r\n  return self.cursor.execute(sql_escape_percent(sql)_ args)\r\n}}}\r\n\r\n\r\n'''System Information:'''\r\n{{{\r\nUser Agent: Mozilla/5.0 (X11; Linux x86_64; rv:14.0) Gecko/20100101 Firefox/14.0.1\r\nTrac 	0.12.3\r\nTrac 	0.12.3\r\nBabel 	0.9.6\r\nDocutils 	0.8.1\r\nGenshi 	0.6\r\nGIT 	1.7.7\r\npsycopg2 	2.4.2\r\nPygments 	1.5\r\nPython 	2.7.2 (default_ Aug 19 2011_ 20:41:43) [GCC]\r\nPython 	2.7.2 (default_ Aug 19 2011_ 20:41:43) [GCC]\r\npytz 	2012b\r\npytz 	2012b\r\nsetuptools 	0.6\r\nsetuptools 	0.6\r\nSubversion 	1.6.18 (!r1303927)\r\njQuery	1.4.4\r\n}}}\r\n\r\n'''Enabled Plugins:'''\r\n{{{\r\nTracAnnouncer 	0.12.1dev 	/usr/local/lib/python2.7/site-packages/!TracAnnouncer-0.12.1dev-py2.7.egg\r\nTracGit 	0.12.0.5dev 	/usr/local/lib/python2.7/site-packages/!TracGit-0.12.0.5dev-py2.7.egg\r\n}}}\r\n\r\nOriginally_ I enabled most of the plugin's options_ and got this error on all but the admin and view tickets tabs; !WatchSubscriber caused this when added to the mix.  With only the !AllTicketsSubscriber subscriber selected_ I everything works except for the subscripts tab under the user's preferences.\r\n\r\nI found another mention of this error_ ticket:8065_ but didn't grok its resolution_ and would have assumed that the 0.12dev version from this morning (revision 11799) would contain any related fix.\r\n\r\nThere seems to be a disconnect between the way the query is being submitted_ boolean_ vice what the (postgres) database schema expects_ integer.,defect,closed,normal,AnnouncerPlugin,normal,duplicate,,scottso@sonalysts.com,0.12