openerp-india team mailing list archive

["Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>]

Hello Grzegorz,

Thanks for your good explanation!

Regarding to your comment#2, you did not face the same problem again, So
Currently I am closing this issue. If you again faced the same problem
or reproduced the same then you can reopen this with precious producible
steps.

Thanks again!

** Changed in: openobject-addons
       Status: Incomplete => Invalid

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/927556

Title:
  [6-stab] fetchmail crashs when AMS_MESSAGE_DATE

Status in OpenERP Addons (modules):
  Invalid

Bug description:
  It is part of log when strange SPAM message arrives. And it locks
  message receiving. Addresses in log are edited to not disclosure
  customer data.

  I see that fetchmail tries to enter some agregated date
  %AMS_MESSAGE_DATE% to field date. It seems that it should be replaced
  before INSERT command.

  [2012-02-05 11:28:18,851][ipl] ERROR:db.cursor:bad query: insert into "mailgate_message"
  (id,"description","server_type","email_bcc","email_to","references","date","partner_id","server_id","user_id","name","message_id","email_cc","model","res_id","email_from","history",create_uid,create_date)
  values (75936,E' * Ne manquez pas l''evenement ,toute l''equipe commerciale d''Horizons expo (groupe SOGEFOIRES) est à votre disposition pour vous
  informer et préparer avec vous votre participation à INPACK 2012. Pour plus d''information veuillez contacter: Mr CHAOUACHI ASSILA:GSM 26838111
  ',E'pop',NULL,E'info@xxxxxxx',NULL,E'%AMS_MESSAGE_DATE%',NULL,6,1,E'[SPAM] Salon International de l''hotellerie et de la Restauration SIHER
  2012',E'<auto-000545479634@xxxxxxxxxxxxxxxxxx>',NULL,E'crm.lead',16099,E'"Groupe sogefoires" <contact@xxxxxxxxxxxxxxxx>',E'True',1,now())
  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  DataError: invalid input syntax for type timestamp: "%AMS_MESSAGE_DATE%"
  LINE 3: ',E'pop',NULL,E'info@xxxxxxx',NULL,E'%AMS_MESSAGE_DATE%'...
                                                 ^

  [2012-02-05 11:28:18,852][ipl] WARNING:pop:[01]: invalid input syntax for type timestamp: "%AMS_MESSAGE_DATE%"
  [2012-02-05 11:28:18,852][ipl] WARNING:pop:[02]: LINE 3: ',E'pop',NULL,E'info@xxxxxxx',NULL,E'%AMS_MESSAGE_DATE%'...
  [2012-02-05 11:28:18,852][ipl] WARNING:pop:[03]:                                                ^
  [2012-02-05 11:28:18,866][ipl] ERROR:db.cursor:bad query: update ir_cron set nextcall=E'2012-02-05 11:33:13', numbercall=-1 where id=6
  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  InternalError: current transaction is aborted, commands ignored until end of transaction block

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/927556/+subscriptions