Custom Query (332 matches)
Results (244 - 246 of 332)
Ticket | Resolution | Summary | Owner | Reporter |
---|---|---|---|---|
#257 | fixed | email2trac : OperationalError: SQL logic error or missing database | bas | anonymous |
Description |
Hi, installed email2trac: ./configure -with-trac_user=apache --with-mta_user=nobody in to /etc/alias file I put: msupport: "|/usr/local/bin/run_email2trac --project=margusja" [14:52:53 root@arendus bin :/usr/local/bin]# /usr/local/bin/email2trac < /tmp/msg.txt saving email to /tmp/tmppyJ_Ff.email2trac writing body to /tmp/tmpNSvy4Q.email2trac [14:53:21 root@arendus bin :/usr/local/bin] And a new ticket appears into database. And the typical case - I can't create ticket via e-mail. here is my email2trac.conf: [DEFAULT] project: /var/www/trac/margusja debug: 99 log_type: file log_file: /tmp/email2trac.log log_level: DEBUG umask: 022 spam_level: 5 reply_all : 0 mailto_link: 0 umask: 022 email_header: 0 trac_version: 0.12 enable_syslog : 1 alternate_notify_template : alternate_notify_template_update : drop_spam : 0 verbatim_format: 1 strip_signature: 0 email_quote: > strip_quotes: 0 ignore_trac_user_settings: 0 lack_list: MAILER-DAEMON@ drop_alternative_html_version: 1 python_egg_cache: /tmp [margusja] project: /var/www/trac/margusja/ spam_level: 5 [okia] project: /var/www/trac/okia/ spam_level: 5 in maillog: 2011-07-29T14:32:08.816598+03:00 arendus postfix/local[12388]: 4E942398018: to=<msupport@arendus.okia.ee>, relay=local, delay=0.5, delays=0.01/0.01/0/0.48, dsn=5.3.0, status=bounced (Command died with status 1: "/usr/local/bin/run_email2trac --project=margusja". Command output: saving email to /tmp/tmpUSSSI_.email2trac writing body to /tmp/tmphDAvFH.email2trac saving email to /tmp/tmpRcebZ9.email2trac writing body to /tmp/tmpZH0dUJ.email2trac )}}} debug: {{{ 2011-07-29 14:57:52,378 email2trac : Found trac version: 0.12 2011-07-29 14:57:52,515 email2trac : Loading environment /var/www/trac/margusja/ 2011-07-29 14:57:52,616 email2trac : Main function parse 2011-07-29 14:57:52,626 email2trac : function get_message_parts() 2011-07-29 14:57:52,626 email2trac : Message part: Main-Type: text 2011-07-29 14:57:52,626 email2trac : Message part: Content-Type: text/plain 2011-07-29 14:57:52,626 email2trac : function inline_part() 2011-07-29 14:57:52,627 email2trac : function unique_attachment_names() 2011-07-29 14:57:52,627 email2trac : function get_body_text() 2011-07-29 14:57:52,628 email2trac : function debug_attachments 2011-07-29 14:57:52,630 email2trac : function email_to_unicode 2011-07-29 14:57:52,630 email2trac : function email_to_unicode 2011-07-29 14:57:52,632 email2trac : function email_header_acl: white_list 2011-07-29 14:57:52,632 email2trac : white_list not defined, all messages are allowed. 2011-07-29 14:57:52,632 email2trac : function email_header_acl: black_list 2011-07-29 14:57:52,632 email2trac : black_list not defined, all messages are allowed. 2011-07-29 14:57:52,633 email2trac : function email_header_acl: recipient_list 2011-07-29 14:57:52,633 email2trac : recipient_list not defined, all messages are allowed. 2011-07-29 14:57:52,633 email2trac : function email_to_unicode 2011-07-29 14:57:52,633 email2trac : subject: test 2011-07-29 14:57:52,634 email2trac : function ticket_update_by_subject 2011-07-29 14:57:52,634 email2trac : function new_ticket 2011-07-29 14:57:52,643 email2trac : function set_reply_fields 2011-07-29 14:57:52,643 email2trac : function set_ticket_fields 2011-07-29 14:57:52,643 email2trac : trac[summary] = 2011-07-29 14:57:52,643 email2trac : trac[reporter] = 2011-07-29 14:57:52,644 email2trac : trac[owner] = 2011-07-29 14:57:52,644 email2trac : trac[description] = 2011-07-29 14:57:52,644 email2trac : trac[type] = defect 2011-07-29 14:57:52,644 email2trac : used type = defect 2011-07-29 14:57:52,644 email2trac : trac[status] = 2011-07-29 14:57:52,644 email2trac : trac[priority] = major 2011-07-29 14:57:52,644 email2trac : used priority = major 2011-07-29 14:57:52,645 email2trac : trac[milestone] = 2011-07-29 14:57:52,645 email2trac : trac[component] = 2011-07-29 14:57:52,645 email2trac : trac[resolution] = None 2011-07-29 14:57:52,645 email2trac : trac[keywords] = 2011-07-29 14:57:52,645 email2trac : trac[cc] = 2011-07-29 14:57:52,645 email2trac : trac[time] = 2011-07-29 14:57:52,645 email2trac : trac[changetime] = 2011-07-29 14:57:52,646 email2trac : trac[estimatedhours] = 0 2011-07-29 14:57:52,646 email2trac : used estimatedhours = 0 2011-07-29 14:57:52,646 email2trac : trac[hours] = 0 2011-07-29 14:57:52,646 email2trac : used hours = 0 2011-07-29 14:57:52,646 email2trac : trac[billable] = 1 2011-07-29 14:57:52,646 email2trac : used billable = 1 2011-07-29 14:57:52,646 email2trac : trac[totalhours] = 0 2011-07-29 14:57:52,647 email2trac : used totalhours = 0 2011-07-29 14:57:52,647 email2trac : function update_ticket_fields 2011-07-29 14:57:52,647 email2trac : user_field totalhours = 0 2011-07-29 14:57:52,647 email2trac : ticket_field totalhours = 0 2011-07-29 14:57:52,647 email2trac : user_field hours = 0 2011-07-29 14:57:52,647 email2trac : ticket_field hours = 0 2011-07-29 14:57:52,647 email2trac : user_field priority = major 2011-07-29 14:57:52,647 email2trac : ticket_field priority = major 2011-07-29 14:57:52,648 email2trac : user_field billable = 1 2011-07-29 14:57:52,648 email2trac : ticket_field billable = 1 2011-07-29 14:57:52,648 email2trac : user_field estimatedhours = 0 2011-07-29 14:57:52,648 email2trac : ticket_field estimatedhours = 0 2011-07-29 14:57:52,648 email2trac : user_field type = defect 2011-07-29 14:57:52,648 email2trac : ticket_field type = defect 2011-07-29 14:57:52,648 email2trac : function get_message_parts() 2011-07-29 14:57:52,649 email2trac : Message part: Main-Type: text 2011-07-29 14:57:52,649 email2trac : Message part: Content-Type: text/plain 2011-07-29 14:57:52,649 email2trac : function inline_part() 2011-07-29 14:57:52,649 email2trac : function unique_attachment_names() 2011-07-29 14:57:52,649 email2trac : function get_body_text() 2011-07-29 14:57:52,655 email2trac : Traceback (most recent call last): 2011-07-29 14:57:52,655 email2trac : File "/usr/local/bin/email2trac", line 2467, in <module> tktparser.parse(sys.stdin) 2011-07-29 14:57:52,655 email2trac : File "/usr/local/bin/email2trac", line 1660, in parse self.new_ticket(m, subject, spam_msg) 2011-07-29 14:57:52,655 email2trac : File "/usr/local/bin/email2trac", line 1125, in new_ticket self.id = tkt.insert() 2011-07-29 14:57:52,655 email2trac : File "/usr/lib/python2.5/site-packages/trac/ticket/model.py", line 226, in insert @self.env.with_transaction(db) 2011-07-29 14:57:52,655 email2trac : File "/usr/lib/python2.5/site-packages/trac/db/api.py", line 82, in transaction_wrapper ldb.rollback() 2011-07-29 14:57:52,655 email2trac : File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 286, in rollback self.cnx.rollback() 2011-07-29 14:57:52,656 email2trac : OperationalError: SQL logic error or missing database 2011-07-29 14:57:52,657 email2trac : function get_message_parts() 2011-07-29 14:57:52,657 email2trac : Message part: Main-Type: text 2011-07-29 14:57:52,658 email2trac : Message part: Content-Type: text/plain 2011-07-29 14:57:52,658 email2trac : function inline_part() 2011-07-29 14:57:52,658 email2trac : function unique_attachment_names() 2011-07-29 14:57:52,658 email2trac : function get_body_text() 2011-07-29 14:57:52,659 email2trac : function debug_attachments }}} |
|||
#258 | duplicate | email2trac : OperationalError: SQL logic error or missing database | bas | margus@… |
Description |
email2trac : OperationalError?: SQL logic error or missing database |
|||
#259 | invalid | Help getting Email2Trac to send HTML emails. | bas | kofal002@… |
Description |
I have performed a slight modification to Trac's source to send HTML notification emails. Really, I just added this line: headers['Content-Type'] = 'text/html; charset=utf-8' to NotifyEmail's send() function in trac\notification.py and it works fine. Whenever I respond to a ticket via Trac's webUI, Trac's notification email is sent using my custom templates\ticket_notify_email.txt, and the content-type is correctly flagged as HTML. It would appear that Email2Trac uses the same code paths to send email: def notify(self, tkt, new=True, modtime=0): ... tn = TicketNotifyEmail(self.env) ... tn.notify(tkt, new, modtime) However, despite my best efforts to figure out why, Email2Trac-triggered emails are sent text/plain content-type. This is bad, since it's using the same custom (HTML) email template, but sending as raw text, and the HTML will not render. I've been digging through the code in both Email2Trac and in Trac's source, and I cannot find why this is the case. This may not be in Email2Trac's main feature set, but I was hoping you could lend some insight on how to do this. |