Opened 5 years ago

Closed 4 years ago

Last modified 4 years ago

#10191 closed defect (duplicate)

integer = boolean

Reported by: anonymous Owned by: Robert Corsaro
Priority: normal Component: AnnouncerPlugin
Severity: normal Keywords:
Cc: scottso@… Trac Release: 0.12

Description (last modified by Ryan J Ollos)

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/", line 522, in _dispatch_request
File "/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/web/", 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/", 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/", 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/", line 147, in find_by_sid_and_distributor
File "/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/", line 77, in transaction_wrapper
File "/usr/local/lib/python2.7/site-packages/TracAnnouncer-0.12.1dev-py2.7.egg/announcer/", 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/", 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 	/usr/local/lib/python2.7/site-packages/!TracGit-

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.

Attachments (0)

Change History (6)

comment:1 Changed 5 years ago by anonymous

Cc: scottso@… added; brunzaphoto@… removed

comment:2 Changed 4 years ago by Bas van der Vlies

I have the same problem. Just installed the trunk version in Trac 0.12.1 environment. I jsut wanted to test the setup in combo with email2trac

comment:3 Changed 4 years ago by Ryan J Ollos

bas: Are you also running PostgreSQL?

comment:4 Changed 4 years ago by Ryan J Ollos

Description: modified (diff)

#10384 is a duplicate, but that ticket has a patch, so I'll close this one.

comment:5 Changed 4 years ago by Ryan J Ollos

Resolution: duplicate
Status: newclosed

comment:6 in reply to:  3 Changed 4 years ago by anonymous

Replying to rjollos:

bas: Are you also running PostgreSQL?

Yes. Version 8.3.18 from SLES 11.

Modify Ticket

as closed The owner will remain Robert Corsaro.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.