Hello Eric, I have checked your scenario at my end and it is completely working fine.
According to your comment #6, In the mail, I have changed the date formate according to your specification(ex,Wednesday 03 August 2011 10:04:39 IST) but working normally. If problem is still harassing you, then please let us know with more information. It would be great if you provide screenshots.It will help us to solve the problem faster. Thanks. -- 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/812072 Title: Invalid Mail Message Date format makes fetchmail crash permanently Status in OpenERP Modules (addons): Incomplete Bug description: A date format causes the cron job to crash and cannot recover. [2011-07-18 08:22:40,863][company] INFO:imap:fetchmail start checking for new emails on [email protected] [2011-07-18 08:22:41,245][company] DEBUG:tools:tools.misc.html2plaintext: cannot use BeautifulSoup, fallback to lxml.etree.HTMLParser [2011-07-18 08:22:41,273][company] DEBUG:translate:no translation language detected, skipping translation for "'receive'" [2011-07-18 08:22:41,280][company] 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 (2714,E' ×ð¾´µÄÓû§ÄúºÃ: ½üÆÚÒòÃÜÂë¼òµ¥¶øÔì³ÉÓÊÏäÕ˺ű»µÁÇé¿öƵ·¢£¬ÎªÁË·ÀÖ¹ÄúÕý³£µÄÓÊÏäÕ˺ű»ÓÃÓÚ·Ç·¨À¬»øÓʼþ·¢ËÍ£¬ÎÒÃǶÔϵͳÔö¼ÓÁËÈõÃÜÂë¼ì²â¹æÔò£¬ ¾ÏµÍ³¼ì²âÄúµÄÃÜÂë¹ýÓÚ¼òµ¥,¼«Ò×±»·Ç·¨·Ö×Ó½øÐÐÃÜÂëÆƽ⣬µ«ÊÇÓÉÓÚÄúµÄÃÜÂëÊôÓÚ¼ÓÃÜÐÅÏ¢£¬ÎÒÃÇÎÞ·¨²é¿´£¬ËùÒÔÇëÄú×ÔÐм°Ê±ÊÖ¶¯ÐÞ¸ÄÃÜ Â룬·ñÔòϵͳ½«ÏÞÖÆÄúÿÈÕÍâ·¢ÓʼþµÄÊýÁ¿Îª20·â£¬ÐÞ¸ÄÍêÃÜÂëºóϵͳ½«×Ô¶¯È¡Ïû¶ÔÄúµÄÓÊÏäÏÞÖÆ! *ÃÜÂëÉèÖÃСÌùÊ¿* ÇëÄú²ÉÄÉÎÒÃÇÌṩ¸øÄúµÄÒÔϹØÓÚÃÜÂëÉèÖõÄС½¨Ò飺 1. ÃÜÂ볤¶È±ØÐëÔÚ6-20λ 2. ±ØÐë²ÉÓÃÎÞÐòµÄ¡°×Öĸ+Êý×Ö¡±µÄ×éºÏ·½Ê½£»¸ñʽÈ磺c1h2i3n4a5 3. ²»Òª²ÉÓõÝÔö»òÕߵݼõµÄÄÚÈÝ£¬È磺¡°ABCD1234¡±¡¢¡°4321DCBA¡±£¬ÒòΪÕâÑùµÄÃÜÂëºÜÈÝÒ×±»ÃÜÂë¼ÆË㹤¾ßËùÆƽ⣻ 4. ÃÜÂëÖв»Òª°üº¬ÓʼþÕ˺ż°ÓʼþÓòÃû 5. Èç¹ûÄúʹÓÿͻ§¶ËÈí¼þ£¨foxmail,outlookµÈ£©ÊÕ·¢Óʼþ£¬ÔÚwebmailÉÏÐÞ¸ÄÃÜÂëºó£¬ÇëÁ¢¼´½øÈë¿Í»§¶Ëͬ²½½øÐÐÃÜÂëÉèÖ㬷ñÔò¿Í»§¶Ë½«ÎÞ·¨Õý³£ÊÕ·¢Óʼþ¡£ ±£»¤ÄúµÄÓÊÏäÃÜÂ룬¾ÍÊDZ£»¤ÄúÆóÒµµÄÎÞÐÎ×ʲú£¬¸ÐлÄú¶ÔÖйúÍòÍø¡°ÈõÃÜÂëÓÅ»¯¡±¹¤×÷С×éµÄÖ§³Ö£¡ ',E'imap',NULL,E'[email protected]',NULL,E'Date: Tue, 12 Jul 2011 01:29:56 +0800',NULL,6,10,E'ÄúµÄÃÜÂë¹ýÓÚ¼òµ¥, Ç뾡¿ìÐÞ¸Ä!',E'[email protected];',NULL,E'crm.lead',698,E'<1310405396$19244$22878693@[email protected]>',E'True',10,now()) Traceback (most recent call last): File "/usr/local/lib/python2.6/dist-packages/openerp- server_9040/sql_db.py", line 131, in execute res = self._obj.execute(query, params) DataError: invalid input syntax for type timestamp: "Date: Tue, 12 Jul 2011 01:29:56 +0800" LINE 23: ',E'imap',NULL,E'[email protected]',NULL,E'Date: Tue, 12 J... ^ [2011-07-18 08:22:41,281][company] WARNING:imap:[01]: invalid input syntax for type timestamp: "Date: Tue, 12 Jul 2011 01:29:56 +0800" [2011-07-18 08:22:41,281][company] WARNING:imap:[02]: LINE 23: ',E'imap',NULL,E'[email protected]',NULL,E'Date: Tue, 12 J... [2011-07-18 08:22:41,281][company] WARNING:imap:[03]: ^ [2011-07-18 08:22:41,282][company] ERROR:db.cursor:bad query: SELECT email_server.active,email_server.user,email_server.date,email_server.password,email_server.port,email_server.note,email_server.user_id,email_server.name,email_server.is_ssl,email_server.object_id,email_server.server,email_server.priority,email_server.attach,email_server.state,email_server.type,email_server.action_id,email_server.id FROM "email_server" WHERE email_server.id IN (7) ORDER BY id Traceback (most recent call last): File "/usr/local/lib/python2.6/dist-packages/openerp- server_9040/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 [2011-07-18 08:22:41,283][company] WARNING:imap:current transaction is aborted, commands ignored until end of transaction block [2011-07-18 08:22:41,284][company] ERROR:db.cursor:bad query: SELECT email_server.active,email_server.user,email_server.date,email_server.password,email_server.port,email_server.note,email_server.user_id,email_server.name,email_server.is_ssl,email_server.object_id,email_server.server,email_server.priority,email_server.attach,email_server.state,email_server.type,email_server.action_id,email_server.id FROM "email_server" WHERE email_server.id IN (8) ORDER BY id Traceback (most recent call last): File "/usr/local/lib/python2.6/dist-packages/openerp- server_9040/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 I temporarily changed the mail_gateway/History function around line 162 as followed: # 'date': email_date or time.strftime('%Y-%m-%d %H:%M:%S'), 'date': time.strftime('%Y-%m-%d %H:%M:%S'),#EC To manage notifications about this bug go to: https://bugs.launchpad.net/openobject-addons/+bug/812072/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
