A BUGNOTE has been added to this bug.
======================================================================
http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000218
======================================================================
Reported By: mrbarletta
Assigned To:
======================================================================
Project: DBMail
Bug ID: 218
Category: Database layer
Reproducibility: always
Severity: major
Priority: normal
Status: new
======================================================================
Date Submitted: 13-Jun-05 00:12 CEST
Last Modified: 17-Jun-05 19:18 CEST
======================================================================
Summary: invalid byte sequence for encoding "UNICODE"
Description:
When dbmail-lmtpd try to store messages sent from yahoo, it fails. Yahoo
adds at the end of the email some ads with spanish characters..
======================================================================
----------------------------------------------------------------------
mrbarletta - 17-Jun-05 19:18 CEST
----------------------------------------------------------------------
Look this error message, You can see that Yahoo adds an advertisement afert
the </html> tag. With PostgreSQL this ends in an error message, but with
mysql it succeed and the email is stored completly. Has this something to
do with it? I would like to make a patch.. but not a postgres
master...thanks!
dbmail/lmtpd[988]: dbpgsql.c, db_query: Error executing query [INSERT INTO
dbmail_messageblks (is_header, messageblk, blocksize, physmessage_id)
VALUES ('0','This is a multi-part message in MIME format.
--------------090404020602070309000802 Content-Type: text/plain;
charset=ISO-8859-1 Content-Transfer-Encoding: 7bit aaaaa
--------------090404020602070309000802 Content-Type: text/html;
charset=ISO-8859-1 Content-Transfer-Encoding: 7bit <!DOCTYPE html PUBLIC
"-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta
content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title> </head> <body bgcolor="#ffffff"
text="http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0333333";>
<font
face="Verdana">aaaaa</font> </body> </html>
--------------090404020602070309000802--
___________________________________ A tu celular no le falta algo?
Us&http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0065533;Yahoo!
Messenger y Correo Yahoo! en tu
tel&http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0065533;ono
celular.
M&http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0065533;
informaci&http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0065533;
en http://movil.yahoo.com.ar ', '776',
'1405')] : [ERROR: invalid byte sequence for encoding "UN
Jun 17 11:06:19 paloma dbmail/lmtpd[988]:
db.c,db_insert_message_block_physmessage: dbquery failed
Bug History
Date Modified Username Field Change
======================================================================
13-Jun-05 00:12mrbarletta New Bug
17-Jun-05 19:18mrbarletta Bugnote Added: 0000746
======================================================================
