DatabaseError: no such column: True

[shahbaz_khalid@…]

Here is the log from trac.log - using latest version of trac 0.11, mysql-python from sourceforge, clearsilver-0.10.4-1.el5.rf.i386.rpm , python-clearsilver-0.10.4-1.el5.rf.i386.rpm etc. using sql lite e.g. the default file based database of trac - Basically followed guide here: ​http://www.daniel-skinner.co.uk/setup-subversion-and-trac-on-centos-5/06/01/2008 . Also have an inherited trac.ini for my project enviroment ini - the root ini contains the announcer plugin in the components section, and I've changed the notification section to announcer in my project ini. Then upgraded env database without any problems. Also have problem with setting my preferences in trac, no email is sent for validation in trac when I add a new email for a new user (this is when the announcer plugin is active).

2008-07-24 10:04:16,268 Trac[main] DEBUG: 283 unreachable objects found. 2008-07-24 10:04:40,702 Trac[main] DEBUG: Dispatching <Request "POST u'/newticket'"> 2008-07-24 10:04:40,704 Trac[session] DEBUG: Retrieving session for ID u'zeshan' 2008-07-24 10:04:40,791 Trac[api] DEBUG: AnnouncementSystem found the following subscribers capable of handling 'ticket, created': LegacyTicketSubscriber, CarbonCopySubscriber, JoinableGroupSubscriber, WatchSubscriber 2008-07-24 10:04:40,792 Trac[ticket_compat] DEBUG: LegacyTicketSubscriber added 'somebody' because of rule: component owner 2008-07-24 10:04:40,793 Trac[api] DEBUG: AnnouncementSystem has found the following subscriptions: [somebody(authenticated) via email] 2008-07-24 10:04:40,795 Trac[email_distributor] DEBUG: EmailDistributor has found the following formats capable of handling 'email' of 'ticket': text/html, text/plain 2008-07-24 10:04:40,795 Trac[api] ERROR: AnnouncementSystem failed. Traceback (most recent call last):

File "build/bdist.linux-i686/egg/announcerplugin/api.py", line 377, in _real_send File "build/bdist.linux-i686/egg/announcerplugin/distributors/email_distributor.py", line 161, in distribute File "build/bdist.linux-i686/egg/announcerplugin/distributors/email_distributor.py", line 203, in _get_preferred_format File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/db/util.py", line 50, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "/usr/lib/python2.4/site-packages/sqlite/main.py", line 255, in execute

self.rs = self.con.db.execute(SQL % parms)

DatabaseError: no such column: True 2008-07-24 10:04:40,825 Trac[api] DEBUG: AnnouncementSystem sent event in 0.04 seconds.

[shahbaz_khalid@…]

forgot to add:

using Python 2.4.3

[jstarkey@…]

I see the same thing with the sqlite backend using Python 2.4, Trac 0.11:

ERROR: AnnouncementSystem failed. Traceback (most recent call last):   File "build/bdist.linux-i686/egg/announcerplugin/api.py", line 377, in _real_send   File "build/bdist.linux-i686/egg/announcerplugin/distributors/email_distributor.py", line 161, in distribute   File "build/bdist.linux-i686/egg/announcerplugin/distributors/email_distributor.py", line 203, in _get_preferred_format   File "/usr/lib/python2.4/site-packages/Trac-0.11-py2.4.egg/trac/db/util.py", line 50, in execute     return self.cursor.execute(sql_escape_percent(sql), args)   File "/usr/lib/python2.4/site-packages/sqlite/main.py", line 255, in execute     self.rs = self.con.db.execute(SQL % parms) DatabaseError: no such column: True

[Robert Corsaro]

Try the patch

[anonymous]

RESOLVED Patch worked fine for me! Thanks!

[anonymous]

ok, checked in r4061