c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #29850
Re: [Bug 812072] Re: Invalid Mail Message Date format makes fetchmail crash permanently
Sorry, but you still dont understand my meaning (or I cant express
myself clearly enough which is the same ;)).
It is not a question of format it is question that before the date,
there are the words "date :" which make crash OE because OE expects a
date and receives a string.
This is a problem of the email server sending a wrong information.
I hope this is clear enough.
Eric CAUDAL
eric.caudal@xxxxxxxxxxxxxx <mailto:caudaleric@xxxxxxxxxxxxxx>
Cell phone: + 86 186 2136 1670
Elico Corp, Shanghai
OpenERP Ready Partner
http://www.elico-corp.com
On 03/08/2011 15:04, Dhruti Shastri(OpenERP) wrote:
> 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 contact@xxxxxxxxxxxxxx
[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'contact@xxxxxxxxxxxxxx',NULL,E'Date: Tue, 12 Jul 2011
01:29:56 +0800',NULL,6,10,E'ÄúµÄÃÜÂë¹ýÓÚ¼òµ¥,
Ç뾡¿ìÐÞ¸Ä!',E'do_not_reply@xxxxxxxxxxx;',NULL,E'crm.lead',698,E'<1310405396$19244$22878693@do_not_reply@xxxxxxxxxxx>',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'contact@xxxxxxxxxxxxxx',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'contact@xxxxxxxxxxxxxx',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
References
