Custom Query (332 matches)

With ticket update there is no check if this is a SPAM message. I will build in the check, bas

Trac 0.10.4 using apache, email2trac 0.9.5

restrict_owner=true in trac.ini, component Support has valid owner, get_known_users query shows all users with fully specified names.

---

cat msg.txt|email2trac --component=Support Traceback (most recent call last):

File "/usr/local/bin/email2trac", line 974, in ?

tktparser.parse(sys.stdin)

File "/usr/local/bin/email2trac", line 560, in parse

self.new_ticket(m)

File "/usr/local/bin/email2trac", line 432, in new_ticket

tkt = Ticket(self.env)

File "/usr/lib/python2.4/site-packages/trac/ticket/model.py", line 37, in init

self.fields = TicketSystem?(self.env).get_ticket_fields()

File "/usr/lib/python2.4/site-packages/trac/ticket/api.py", line 104, in get_ticket_fields

for username, name, email in self.env.get_known_users(db):

File "/usr/lib/python2.4/site-packages/trac/env.py", line 320, in get_known_users

for username,name,email in cursor:

File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 40, in iter

row = self.cursor.fetchone()

File "/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 3158, in fetchone

raise Error, \

Error: fetchone() failed - cursor does not contain a result. TD: saving email to /tmp/tmpT0AepR.email2trac ---

In order to avoid closed tickets being reopened by email2trac, I configured 'workflow: leave', but that didn't work at first. The following patch was needed.

--- email2trac-1.0.0/email2trac.py.in.orig	2009-09-02 10:57:42.000000000 +0200
+++ email2trac-1.0.0/email2trac.py.in	2009-10-21 15:40:53.000000000 +0200
@@ -660,7 +660,7 @@ class TicketEmailParser(object):
 			#b = controller.get_ticket_changes(req, tkt, 'reopen')
 			#print 'get_ticket_changes :', b
 
-			if self.WORKFLOW and (self.VERSION in ['0.11']) :
+			if self.WORKFLOW and self.VERSION == 0.11:
 				from trac.ticket.default_workflow import ConfigurableTicketWorkflow
 				from trac.test import Mock, MockPerm
 

In the long run, it might be a better idea to turn self.VERSION into a string.