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 Trac 0.12.3 Babel 0.9.6 Docutils 0.8.1 Genshi 0.6 GIT 1.7.7 psycopg2 2.4.2 Pygments 1.5 Python 2.7.2 (default, Aug 19 2011, 20:41:43) [GCC] Python 2.7.2 (default, Aug 19 2011, 20:41:43) [GCC] pytz 2012b pytz 2012b setuptools 0.6 setuptools 0.6 Subversion 1.6.18 (!r1303927) jQuery 1.4.4 }}} '''Enabled Plugins:''' {{{ TracAnnouncer 0.12.1dev /usr/local/lib/python2.7/site-packages/!TracAnnouncer-0.12.1dev-py2.7.egg TracGit 0.12.0.5dev /usr/local/lib/python2.7/site-packages/!TracGit-0.12.0.5dev-py2.7.egg }}} 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 closed normal AnnouncerPlugin normal duplicate scottso@… 0.12