I am sorry for so late answer. It seems that my cooperation with that customer has finished. Also because of strange behaviour of fetchmail module. Before that customer used in ver5.0 module mail_gateway with fetchmail set in command line. And it worked fine for him.
In 6.0.2 we have switched to module fetchmail with settings of POP server in graphical user interface. And this way worked much worse. First of all when arrive an email with something not recognised (as in this bug) it stopped to fetch any other mails. It seems that it should simply omit wrong mail and fetch next in queue. But it stopped at wrong mail and next time repeated the same procedure not fetching anything until you manually remove unrecognised mail from mailbox. In that case above I seem that customer used time settings for Poland. But I don't think it is a problem with time settings. The mail arrived with some text %AMS_MESSAGE_DATE% in date field instead of date and this text should be replaced to some date (probably current) by mail fetcher. It seems that fetchmail module doesn't do that. Anyway it should omit not parsed mail and go to next one to clean up the queue. By now I have no contact with the customer and I am not able to generate such strange mails to provide more information. Please close the bug. I will reopen it when it is something new. I apologize to take your time. -- 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'[email protected]',NULL,E'%AMS_MESSAGE_DATE%',NULL,6,1,E'[SPAM] Salon International de l''hotellerie et de la Restauration SIHER 2012',E'<[email protected]>',NULL,E'crm.lead',16099,E'"Groupe sogefoires" <[email protected]>',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'[email protected]',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'[email protected]',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 _______________________________________________ Mailing list: https://launchpad.net/~openerp-india Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-india More help : https://help.launchpad.net/ListHelp
