DatabaseError: no such column: True
|Reported by:||shahbaz_khalid@…||Owned by:||doki_pen|
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.