openerp-india team mailing list archive

["Grzegorz Grzelak \(OpenGLOBE.pl\)" <grzegorz@xxxxxxxxxxxx>]

Public bug reported:

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

** Affects: openobject-addons
     Importance: Undecided
         Status: New

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

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