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.
