The following issue has been set as RELATED TO issue 0000265. ====================================================================== http://www.dbmail.org/mantis/view.php?id=426 ====================================================================== Reported By: yuen Assigned To: paul ====================================================================== Project: DBMail Issue ID: 426 Category: Database layer Reproducibility: sometimes Severity: minor Priority: low Status: resolved target: 2.3.0 Resolution: fixed Fixed in Version: 2.2.3 ====================================================================== Date Submitted: 08-Oct-06 23:52 CEST Last Modified: 26-Feb-07 10:03 CET ====================================================================== Summary: invalid byte sequence for encoding "UTF8" for evelope table Description: There are still errors on inserting to evelope table, so I'm creating this separate bug report. ====================================================================== Relationships ID Summary ---------------------------------------------------------------------- has duplicate 0000499 incorrect envelope related to 0000265 Non US-ASCII character in mail header b... ======================================================================
---------------------------------------------------------------------- aaron - 09-Oct-06 01:38 ---------------------------------------------------------------------- Please provide data that causes this error message. ---------------------------------------------------------------------- yuen - 11-Oct-06 15:33 ---------------------------------------------------------------------- I have sent some errors in file attachment, if you would more I can send full log (1Mb) ---------------------------------------------------------------------- paul - 11-Oct-06 16:22 ---------------------------------------------------------------------- Plz don't send 1mb logs. But do include a message that is causing this. ---------------------------------------------------------------------- paul - 27-Oct-06 14:51 ---------------------------------------------------------------------- yuen, I've committed a change in dbmail_2_2_branch that should fix this. Please let me know if it works. ---------------------------------------------------------------------- yuen - 30-Oct-06 21:05 ---------------------------------------------------------------------- I have tried 2333, but there are still same errors ---------------------------------------------------------------------- paul - 30-Oct-06 22:50 ---------------------------------------------------------------------- Yuen, Please provide us with a raw message so we can reproduce this more exactly. It can't be the exact same error. Please add some logs from current svn. ---------------------------------------------------------------------- paul - 31-Oct-06 14:38 ---------------------------------------------------------------------- Forget about my last message. I've changed the code so that now values are converted to utf8 before insertion into the database. My previous change did utf7 encoding to avoid pgsql breakage, but storing values like subjectfield as utf7 would break the SORT capability. Please test the lastest (rev 2346) and post some logs if it still breaks for you. This actually means that utf8 encoding will be required for dbmail-2.2+ which is probably not a bad thing. ---------------------------------------------------------------------- paul - 04-Nov-06 11:18 ---------------------------------------------------------------------- I'm suspending this for now since it requires schema changes (bytea) on all related columns. Target set to 2.3.0 ---------------------------------------------------------------------- paul - 26-Feb-07 10:03 ---------------------------------------------------------------------- It would seem this problem is fixed by recent changes. Please check bug http://www.dbmail.org/mantis/view.php?id=499 for more details. Issue History Date Modified Username Field Change ====================================================================== 08-Oct-06 23:52 yuen New Issue 09-Oct-06 01:38 aaron Note Added: 0001484 09-Oct-06 11:54 yuen File Added: envelope.err 11-Oct-06 15:33 yuen Note Added: 0001498 11-Oct-06 16:22 paul Note Added: 0001499 27-Oct-06 14:51 paul Note Added: 0001510 30-Oct-06 21:05 yuen Note Added: 0001513 30-Oct-06 22:50 paul Note Added: 0001514 31-Oct-06 14:38 paul Note Added: 0001515 04-Nov-06 11:18 paul target => 2.3.0 04-Nov-06 11:18 paul Note Added: 0001528 04-Nov-06 11:18 paul Assigned To => paul 04-Nov-06 11:18 paul Priority normal => low 04-Nov-06 11:18 paul Status new => assigned 04-Nov-06 11:18 paul Resolution open => suspended 04-Nov-06 11:18 paul Projection none => major rework 04-Nov-06 11:18 paul ETA none => > 1 month 30-Jan-07 21:26 paul Relationship added has duplicate 0000499 26-Feb-07 10:03 paul Note Added: 0001843 26-Feb-07 10:03 paul Status assigned => resolved 26-Feb-07 10:03 paul Resolution suspended => fixed 26-Feb-07 10:03 paul Fixed in Version => 2.2.3 06-Mar-07 22:56 paul Relationship added related to 0000265 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
