The following issue has been ASSIGNED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=737 ====================================================================== Reported By: niki Assigned To: paul ====================================================================== Project: DBMail Issue ID: 737 Category: Database layer Reproducibility: always Severity: major Priority: normal Status: assigned target: ====================================================================== Date Submitted: 22-Nov-08 03:02 CET Last Modified: 05-Dec-08 10:27 CET ====================================================================== Summary: Old mail from before upgrade to 2.3.4 not shown correctly. Description: When looking through some mails from before the switch to 2.3.4, they don't show in Evo, when looking at the message source in Evo it seems like \r \n is replaced by literal \012 \011 in the message, so Evo can't parse it.
See sample mail received in Nov 2006, also mails received a week ago shows this. Evo has tried to add some headers to the saved mail in the sample. ====================================================================== ---------------------------------------------------------------------- paul - 22-Nov-08 21:09 ---------------------------------------------------------------------- Please include a file_logging_levels=511 for the retrieval of this message. Btw, does thunderbird suffer from this same problem? I have tested this exact scenario ad nauseum in my development setups. Also, the storage layer hasn't changed since 2.3.2 so it must be something in the imap layer or your database setup. ---------------------------------------------------------------------- niki - 22-Nov-08 22:45 ---------------------------------------------------------------------- I have uploaded the log of when I fetch a mail (stripped off all the reconnection bits, and refreshing folders), and uploaded the mail I opened. I have also tried in Thunderbird now, and it shows the message as corrupted just like Evo does. ---------------------------------------------------------------------- paul - 22-Nov-08 23:00 ---------------------------------------------------------------------- Please provide a dump of your schema. If that doesn't show anyting suspicious include an export of the messageblks rows involved in this query: SELECT b.messageblk, b.is_header, TO_CHAR(p.internal_date, 'YYYY-MM-DD HH24:MI:SS' ) FROM dbmail_messageblks b JOIN dbmail_physmessage p ON b.physmessage_id=p.id WHERE b.physmessage_id = 5504 ORDER BY b.messageblk_idnr ---------------------------------------------------------------------- niki - 23-Nov-08 00:11 ---------------------------------------------------------------------- I have uploaded the schema, and the result of the SQL command you posted, both of them run through phppgadmin, can run them in a shell too if you like. ---------------------------------------------------------------------- niki - 23-Nov-08 00:13 ---------------------------------------------------------------------- Btw, forgot to mention that I have edited out some none dbmail tables from the dbmail-schema-1.sql file, just so you know that it's not the complete dump. Issue History Date Modified Username Field Change ====================================================================== 22-Nov-08 03:02 niki New Issue 22-Nov-08 03:02 niki File Added: Re:_PATCH:_Question_about_the_SIZE_extension.txt 22-Nov-08 21:09 paul Note Added: 0002652 22-Nov-08 22:40 niki File Added: dbmail-4.err 22-Nov-08 22:42 niki File Added: Re:_PATCH:_Question_about_the_SIZE_extension-2.txt 22-Nov-08 22:45 niki Note Added: 0002653 22-Nov-08 23:00 paul Note Added: 0002655 23-Nov-08 00:06 niki File Added: dbmail-schema-1.sql 23-Nov-08 00:09 niki File Added: dump.csv 23-Nov-08 00:11 niki Note Added: 0002658 23-Nov-08 00:13 niki Note Added: 0002659 05-Dec-08 10:26 paul File Added: 0001-retrieve-old-messageblk-data-as-blob-bug-737.patch 05-Dec-08 10:27 paul Assigned To => paul 05-Dec-08 10:27 paul Status new => assigned ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
