Modify

Opened 9 years ago

Closed 9 years ago

#3447 closed defect (fixed)

DatabaseError: no such column: True

Reported by: shahbaz_khalid@… Owned by: Robert Corsaro
Priority: normal Component: AnnouncerPlugin
Severity: normal Keywords: announcerplugin
Cc: Trac Release: 0.11

Description

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.

Attachments (1)

email_dist.patch (553 bytes) - added by Robert Corsaro 9 years ago.

Download all attachments as: .zip

Change History (6)

comment:1 Changed 9 years ago by shahbaz_khalid@…

forgot to add:

using Python 2.4.3

comment:2 Changed 9 years ago by 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

comment:3 Changed 9 years ago by Robert Corsaro

Try the patch

Changed 9 years ago by Robert Corsaro

Attachment: email_dist.patch added

comment:4 Changed 9 years ago by anonymous

RESOLVED Patch worked fine for me! Thanks!

comment:5 Changed 9 years ago by anonymous

Resolution: fixed
Status: newclosed

ok, checked in r4061

Modify Ticket

Action
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.