Modify

Opened 6 years ago

Closed 6 years ago

#3447 closed defect (fixed)

DatabaseError: no such column: True

Reported by: shahbaz_khalid@… Owned by: doki_pen
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 doki_pen 6 years ago.

Download all attachments as: .zip

Change History (6)

comment:1 Changed 6 years ago by shahbaz_khalid@…

forgot to add:

using Python 2.4.3

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

Try the patch

Changed 6 years ago by doki_pen

comment:4 Changed 6 years ago by anonymous

RESOLVED Patch worked fine for me! Thanks!

comment:5 Changed 6 years ago by anonymous

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

ok, checked in r4061

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.