Opened 4 years ago

Closed 4 years ago

Last modified 4 years ago

#10191 closed defect (duplicate)

integer = boolean

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

Description (last modified by rjollos)

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 4 years ago by anonymous

  • Cc scottso@… added; brunzaphoto@… removed

comment:2 Changed 4 years ago by bas

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 follow-up: Changed 4 years ago by rjollos

bas: Are you also running PostgreSQL?

comment:4 Changed 4 years ago by rjollos

  • 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 rjollos

  • Resolution set to duplicate
  • Status changed from new to closed

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.

Add Comment

Modify Ticket

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

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

Note: See TracTickets for help on using tickets.