← Back to team overview

openerp-india team mailing list archive

[Bug 927556] Re: [6-stab] fetchmail crashs when AMS_MESSAGE_DATE

 

Hello Grzegorz,

Would you please provide which date format you have been used? because
as per my end it's working fine.

So would you please provide more information on this..

Thanks and waiting for your reply!

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

-- 
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):
  Incomplete

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


References