c2c-oerpscenario team mailing list archive

["Xavier ALT \(Thamini\)" <701067@xxxxxxxxxxxxxxxxxx>]

Hi,

The problem seems to occur inside the mail_gateway module (history()
method). The method doesn't check if the message date follow the RFC
2822 format, it that's the case, the date should be converted to
internal date iso format. (see patch attached)

** Patch added: "convert date to iso if message date is in RFC2822"
   https://bugs.launchpad.net/openobject-addons/+bug/701067/+attachment/1793612/+files/fix-mailgate-date-parsing.patch

** Changed in: openobject-addons
       Status: New => Confirmed

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/701067

Title:
  [6rc2] Fetchmail - Error with Timestamp Syntax

Status in OpenObject Addons Modules:
  Confirmed

Bug description:
  Hello,

  in v6 RC2 i get the following Errors regarding the Timestamp Syntax while using the Fetchmail Services (crm.lead as Model) of the Fetchmail Module.
  Happened on a German Ubuntu 10.10, switching the Systems Timeformat didn't help. The Mailbox is just out of a local Testsystem but i can pull it via Thunderbird, so that should be ok.

  
  [2011-01-10 16:00:53,689][DemoDB01] INFO:imap:fetchmail start checking for new emails on E-Mail 2 Leads
  [2011-01-10 16:00:53,813][DemoDB01] ERROR:db.cursor:bad query: insert into "mailgate_message" (id,"description","server_type","email_bcc","email_to","email_cc","date","partner_id","server_id","user_id","name","email_from","references","model","res_id","message_id","history",create_uid,create_date) values (40,NULL,E'pop',NULL,E'leads@xxxxxxxxxxxxxx',NULL,E'Mon, 10 Jan 2011 15:47:13 +0100 (CET)',NULL,1,1,E'Test der neuen Mailbox',E'root@xxxxxxxxxxxx (root)',NULL,E'crm.lead',25,E'<20110110144713.2833A22FC5@openerp-v6>',E'True',1,now())
  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 129, in execute
      res = self._obj.execute(query, params)
  DataError: FEHLER:  ungültige Eingabesyntax für Typ timestamp: »Mon, 10 Jan 2011 15:47:13 +0100 (CET)«
  ZEILE 1: ...(40,NULL,E'pop',NULL,E'leads@xxxxxxxxxxxxxx',NULL,E'Mon, 10 ...
                                                                ^

  [2011-01-10 16:00:53,814][DemoDB01] WARNING:pop:[01]: FEHLER:  ungültige Eingabesyntax für Typ timestamp: »Mon, 10 Jan 2011 15:47:13 +0100 (CET)«
  [2011-01-10 16:00:53,815][DemoDB01] WARNING:pop:[02]: ZEILE 1: ...(40,NULL,E'pop',NULL,E'leads@xxxxxxxxxxxxxx',NULL,E'Mon, 10 ...
  [2011-01-10 16:00:53,815][DemoDB01] WARNING:pop:[03]:

  with kind regards,