id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
10191,integer = boolean,anonymous,Robert Corsaro,"While trying to configure the AnnouncerPlugin, I get the following:

{{{
 Trac detected an internal error:

ProgrammingError: operator does not exist: integer = boolean
LINE 6:                  AND authenticated=true
                                          ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
}}}

{{{
Most recent call last:

File ""/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/web/main.py"", line 522, in _dispatch_request
  dispatcher.dispatch(req)
File ""/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/web/main.py"", line 243, in dispatch
  resp = chosen_handler.process_request(req)
File ""/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/prefs/web_ui.py"", line 77, in process_request
  template, data = chosen_provider.render_preference_panel(req, panel_id)
File ""/usr/local/lib/python2.7/site-packages/TracAnnouncer-0.12.1dev-py2.7.egg/announcer/pref.py"", line 170, in render_preference_panel
  req.session.sid, req.session.authenticated, j):
File ""/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
  @env.with_transaction(db)
File ""/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/api.py"", line 77, in transaction_wrapper
  fn(ldb)
File ""/usr/local/lib/python2.7/site-packages/TracAnnouncer-0.12.1dev-py2.7.egg/announcer/model.py"", line 158, in do_select
  """""", (sid,authenticated,distributor))
File ""/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/util.py"", line 65, in execute
  return self.cursor.execute(sql_escape_percent(sql), args)
}}}


'''System Information:'''

User Agent: Mozilla/5.0 (X11; Linux x86_64; rv:14.0) Gecko/20100101 Firefox/14.0.1
Trac 	0.12.3[[BR]]
Trac 	0.12.3[[BR]]
Babel 	0.9.6[[BR]]
Docutils 	0.8.1[[BR]]
Genshi 	0.6[[BR]]
GIT 	1.7.7[[BR]]
psycopg2 	2.4.2[[BR]]
Pygments 	1.5[[BR]]
Python 	2.7.2 (default, Aug 19 2011, 20:41:43) [GCC][[BR]]
Python 	2.7.2 (default, Aug 19 2011, 20:41:43) [GCC][[BR]]
pytz 	2012b[[BR]]
pytz 	2012b[[BR]]
setuptools 	0.6[[BR]]
setuptools 	0.6[[BR]]
Subversion 	1.6.18 (!r1303927)[[BR]]
jQuery	1.4.4[[BR]]

'''Enabled Plugins:'''
!TracAnnouncer 	0.12.1dev 	/usr/local/lib/python2.7/site-packages/!TracAnnouncer-0.12.1dev-py2.7.egg[[BR]]
!TracGit 	0.12.0.5dev 	/usr/local/lib/python2.7/site-packages/!TracGit-0.12.0.5dev-py2.7.egg[[BR]]


Originally, 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.

I 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.

There seems to be a disconnect between the way the query is being submitted, boolean, vice what the (postgres) database schema expects, integer.",defect,new,normal,AnnouncerPlugin,normal,,,brunzaphoto@…,0.12