A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=962 ====================================================================== Reported By: qliratu Assigned To: paul ====================================================================== Project: DBMail Issue ID: 962 Category: IMAP daemon Reproducibility: N/A Severity: minor Priority: normal Status: assigned target: ====================================================================== Date Submitted: 13-Mar-12 09:00 CET Last Modified: 08-Jul-13 12:57 CEST ====================================================================== Summary: Sorting IMAP Description: Yesterday i downloaded 3.0.2 and build it. Right after i noticed that the sorting of the e-mail is off.
New mails are not being sorted the right way and apear near the botom of my mail list. build version 3.0.1 again and the problem disapears. ====================================================================== Relationships ID Summary ---------------------------------------------------------------------- has duplicate 0000971 Rouncube Client - Date sorting broken ====================================================================== ---------------------------------------------------------------------- (0003419) paul (administrator) - 13-Mar-12 09:28 http://www.dbmail.org/mantis/view.php?id=962#c3419 ---------------------------------------------------------------------- Some additional information is required. What email client are you using? ---------------------------------------------------------------------- (0003420) qliratu (reporter) - 13-Mar-12 10:50 http://www.dbmail.org/mantis/view.php?id=962#c3420 ---------------------------------------------------------------------- Roundcube 0.7.2 And another wierd thing.. send mail from gmail to dbmail everything is oké. send from my corperate mail NOK. Send from another ubuntu dbmail server NOK. ---------------------------------------------------------------------- (0003421) qliratu (reporter) - 13-Mar-12 10:50 http://www.dbmail.org/mantis/view.php?id=962#c3421 ---------------------------------------------------------------------- I dont know where to look for additional logging. if u tell me where i shoud look i can get it for u. ---------------------------------------------------------------------- (0003422) gweaver (reporter) - 15-Mar-12 18:03 http://www.dbmail.org/mantis/view.php?id=962#c3422 ---------------------------------------------------------------------- I can confirm this behaviour with dbmail 3.0.2 and roundcube 0.7.2. I have reverted to dbmail 3.0.1 and it is behaving again. I'm afraid I'm too busy to produce logs right now, sorry. Maybe at the weekend. ---------------------------------------------------------------------- (0003423) paul (administrator) - 15-Mar-12 23:48 http://www.dbmail.org/mantis/view.php?id=962#c3423 ---------------------------------------------------------------------- Please try to verify against a 3.0.2 installation with a truncated and rebuild header-cache: mysql> truncate dbmail_headers dbmail-util -by If that doesn't help I need specific IMAP command and response traces, for 3.0.1 and 3.0.2 ---------------------------------------------------------------------- (0003424) qliratu (reporter) - 16-Mar-12 09:12 http://www.dbmail.org/mantis/view.php?id=962#c3424 ---------------------------------------------------------------------- I have builded version 3.02 again and truncate dbmail_header (no s). After that i used dbmail-util -by to recreate all of the headers envelopes etc.. This did not resolved the issue. if u can guide me a bit with the imap command and response i can give u that information. ---------------------------------------------------------------------- (0003425) paul (administrator) - 16-Mar-12 09:54 http://www.dbmail.org/mantis/view.php?id=962#c3425 ---------------------------------------------------------------------- You need to set file_logging_levels=127 I just did a fresh install of roundcube, and things look just fine to me... ---------------------------------------------------------------------- (0003439) qliratu (reporter) - 13-Apr-12 07:56 http://www.dbmail.org/mantis/view.php?id=962#c3439 ---------------------------------------------------------------------- Hello, I have not paid attention to this problem couple of weeks now.. but i saw your twitter about resolving imap sort issue. Today i tried it and now my e-mail is being sorted like it always have. Meening issue resolved ticket can be closed Thank u very mutch! ---------------------------------------------------------------------- (0003448) Bloody (reporter) - 15-May-12 18:22 http://www.dbmail.org/mantis/view.php?id=962#c3448 ---------------------------------------------------------------------- How you can resolve issue? I upgrade installation to 3.0.2, do TRUNCATE dbmail_headername, dbmail_header, dbmail_headervalue, dbmail_referencesfield dbmail-util -ay and still have invalid sorting by date ---------------------------------------------------------------------- (0003457) ealekseev (reporter) - 10-Jun-12 13:08 http://www.dbmail.org/mantis/view.php?id=962#c3457 ---------------------------------------------------------------------- I use roundcube 0.7.2 with latest dbmail from git + postgresql 9.0.7. When I chose to sort messages by any field - all messages become invisible until I disable sorting at all. I check logs and find that there is an error in sql query: SELECT DISTINCT(message_idnr) FROM dbmail_messages m LEFT JOIN dbmail_physmessage p ON m.physmessage_id=p.id WHERE m.mailbox_idnr = 1 AND m.status IN (0,1) ORDER BY messagesize,message_idnr; ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...m.mailbox_idnr = 1 AND m.status IN (0,1) ORDER BY messagesiz... It seems that sorting field must be in select list. Logs attached. imap_sort_error.log ---------------------------------------------------------------------- (0003458) ealekseev (reporter) - 13-Jun-12 08:03 http://www.dbmail.org/mantis/view.php?id=962#c3458 ---------------------------------------------------------------------- It seems that my problem is resolved in commit 159b113da83d5c2312f1ece407a66d4bbfc91a5c Thank you. ---------------------------------------------------------------------- (0003540) jvanvelden (reporter) - 08-Jul-13 12:57 http://www.dbmail.org/mantis/view.php?id=962#c3540 ---------------------------------------------------------------------- I have been using dbmail 3.0.2 with roundcube 0.9.1. I migrated users data from another server to dbmail using imapsync, and dates were displaying out of order in roundcube (but not in thunderbird). I have recently upgraded to GIT version and without any change to roundcube (no roundcube cache was set up), the dates in roundcube are now sorting correctly. I was not the original bug reporter, but perhaps this bug can be closed. Issue History Date Modified Username Field Change ====================================================================== 13-Mar-12 09:00 qliratu New Issue 13-Mar-12 09:28 paul Note Added: 0003419 13-Mar-12 10:50 qliratu Note Added: 0003420 13-Mar-12 10:50 qliratu Note Added: 0003421 15-Mar-12 18:03 gweaver Note Added: 0003422 15-Mar-12 23:48 paul Note Added: 0003423 15-Mar-12 23:49 paul Assigned To => paul 15-Mar-12 23:49 paul Status new => assigned 16-Mar-12 09:12 qliratu Note Added: 0003424 16-Mar-12 09:54 paul Note Added: 0003425 13-Apr-12 07:55 qliratu Note Added: 0003439 13-Apr-12 07:56 qliratu Note Edited: 0003439 09-May-12 09:24 paul Relationship added has duplicate 0000971 15-May-12 18:22 Bloody Note Added: 0003448 15-May-12 18:22 Bloody Note Edited: 0003448 10-Jun-12 12:01 ealekseev File Added: imap_sort_error.log 10-Jun-12 12:01 ealekseev Note Added: 0003457 10-Jun-12 13:08 ealekseev Note Edited: 0003457 13-Jun-12 08:03 ealekseev Note Added: 0003458 08-Jul-13 12:57 jvanvelden Note Added: 0003540 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
