A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=575 ====================================================================== Reported By: rhstone Assigned To: ====================================================================== Project: DBMail Issue ID: 575 Category: IMAP daemon Reproducibility: always Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 24-Apr-07 04:21 CEST Last Modified: 25-Apr-07 17:35 CEST ====================================================================== Summary: Search using PINE returns incorrect results Description: When using PINE, I am able to press the TAB key to advance to the next unread message. This works on occasion, and tends to only function if PINE has cached the next page of headers, rather than needing to run a SEARCH command on the server.
The IMAP telemetry is as follows: 00000054 SEARCH 1534:2248 OR (UNDELETED UNSEEN) (FLAGGED) * SEARCH 00000054 OK SEARCH completed this appears to return an empty result, as I understand it. I will scrounge up some server side logs when I have a chance. ====================================================================== ---------------------------------------------------------------------- rhstone - 24-Apr-07 06:59 ---------------------------------------------------------------------- Apr 24 05:01:13 Info:[imap] imap4.c,IMAPClientHandler(+178): COMMAND: [0000000e SEARCH 1471:2247 OR (UNDELETED UNSEEN) (FLAGGED)] Apr 24 05:01:13 Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2282): arg[0]: '1471:2247' Apr 24 05:01:13 Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2282): arg[1]: 'OR' Apr 24 05:01:13 Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2282): arg[2]: '(' Apr 24 05:01:13 Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2282): arg[3]: 'UNDELETED' Apr 24 05:01:13 Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2282): arg[4]: 'UNSEEN' Apr 24 05:01:13 Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2282): arg[5]: ')' Apr 24 05:01:13 Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2282): arg[6]: '(' Apr 24 05:01:13 Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2282): arg[7]: 'FLAGGED' Apr 24 05:01:13 Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2282): arg[8]: ')' Apr 24 05:01:13 Info:[imap] imap4.c,IMAPClientHandler(+291): Executing command search... Apr 24 05:01:13 Debug:[db] db.c,db_acl_has_right(+4015): checking ACL [read_flag] for user [2] on mailbox [2] Apr 24 05:01:13 Debug:[db] db.c,db_acl_has_right(+4025): mailbox [2] is owned by user [2], is that also [2]? Apr 24 05:01:13 Debug:[db] db.c,db_acl_has_right(+4029): mailbox [2] is owned by user [2], giving all rights Apr 24 05:01:13 Debug:[sql] dbmysql.c,db_query(+286): query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = 2 AND status IN (0,1) ORDER BY message_idnr] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,mailbox_build_uid_map(+162): ids [2247], msn [2247] Apr 24 05:01:13 Debug:[misc] misc.c,check_msg_set(+996): [1471:2247] [ok] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,append_search(+563): [0x648c00] [1] type [2] field [] search [1471:2247] at depth [1] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,append_search(+563): [0x64e600] [1] type [15] field [] search [] at depth [2] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,append_search(+563): [0x667a00] [1] type [14] field [] search [] at depth [3] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,append_search(+563): [0x63c200] [0] type [2] field [] search [1:*] at depth [3] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,append_search(+563): [0x635200] [0] type [3] field [] search [deleted_flag=0] at depth [3] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,append_search(+563): [0x639400] [0] type [3] field [] search [seen_flag=0] at depth [3] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,append_search(+563): [0x66bc00] [1] type [14] field [] search [] at depth [3] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,append_search(+563): [0x652800] [0] type [2] field [] search [1:*] at depth [3] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,append_search(+563): [0x645e00] [0] type [3] field [] search [flagged_flag=1] at depth [3] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,dbmail_mailbox_get_set(+1288): [1471:2247] Apr 24 05:01:13 Debug:[misc] misc.c,g_tree_merge(+1260): a[0] [OR] b[1] -> a[1] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,_do_search(+1451): [0x648c00] depth [1] type [2] rows [1] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,dbmail_mailbox_get_set(+1288): [1:*] Apr 24 05:01:13 Debug:[misc] misc.c,g_tree_merge(+1260): a[0] [OR] b[2247] -> a[2247] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,_do_search(+1451): [0x63c200] depth [4] type [2] rows [2247] Apr 24 05:01:13 Debug:[sql] dbmysql.c,db_query(+286): query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = 2 AND status IN (0,1) AND deleted_flag=0 ORDER BY message_idnr] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,_do_search(+1451): [0x635200] depth [4] type [3] rows [2244] Apr 24 05:01:13 Debug:[sql] dbmysql.c,db_query(+286): query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = 2 AND status IN (0,1) AND seen_flag=0 ORDER BY message_idnr] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,_do_search(+1451): [0x639400] depth [4] type [3] rows [270] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,_do_search(+1451): [0x667a00] depth [3] type [14] rows [0] Apr 24 05:01:13 Debug:[mailbox] dbmail-mailbox.c,dbmail_mailbox_get_set(+1288): [1:*] Apr 24 05:01:14 Debug:[misc] misc.c,g_tree_merge(+1260): a[0] [OR] b[2247] -> a[2247] Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,_do_search(+1451): [0x652800] depth [4] type [2] rows [2247] Apr 24 05:01:14 Debug:[sql] dbmysql.c,db_query(+286): query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = 2 AND status IN (0,1) AND flagged_flag=1 ORDER BY message_idnr] Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,_do_search(+1451): [0x645e00] depth [4] type [3] rows [0] Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,_do_search(+1451): [0x66bc00] depth [3] type [14] rows [0] Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,_do_search(+1451): [0x64e600] depth [2] type [15] rows [0] Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,_merge_search(+1476): [0x648c00] depth [1] type [2] Apr 24 05:01:14 Debug:[misc] misc.c,g_tree_merge(+1260): a[2247] [AND] b[1] -> a[1] Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,_merge_search(+1476): [0x64e600] depth [2] type [15] Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,_merge_search(+1476): [0x63c200] depth [4] type [2] Apr 24 05:01:14 Debug:[misc] misc.c,g_tree_merge(+1260): a[1] [AND] b[2247] -> a[1] Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,_merge_search(+1476): [0x635200] depth [4] type [3] Apr 24 05:01:14 Debug:[misc] misc.c,g_tree_merge(+1260): a[1] [AND] b[2244] -> a[1] Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,_merge_search(+1476): [0x639400] depth [4] type [3] Apr 24 05:01:14 Debug:[misc] misc.c,g_tree_merge(+1260): a[1] [AND] b[270] -> a[0] Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,_merge_search(+1476): [0x652800] depth [4] type [2] Apr 24 05:01:14 Debug:[misc] misc.c,g_tree_merge(+1260): a[0] [AND] b[2247] -> a[0] Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,_merge_search(+1476): [0x645e00] depth [4] type [3] Apr 24 05:01:14 Debug:[misc] misc.c,g_tree_merge(+1260): a[0] [AND] b[0] -> a[0] Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,dbmail_mailbox_search(+1548): found [0] ids Apr 24 05:01:14 Debug:[mailbox] dbmail-mailbox.c,dbmail_mailbox_ids_as_string(+484): no ids found Apr 24 05:01:14 Debug:[imapsession] dbmail-imapsession.c,dbmail_imap_session_printf(+1348): RESPONSE: [* SEARCH ] Apr 24 05:01:14 Debug:[imapsession] dbmail-imapsession.c,dbmail_imap_session_printf(+1348): RESPONSE: [0000000e OK SEARCH completed ] Apr 24 05:01:14 Info:[imap] imap4.c,IMAPClientHandler(+308): Finished command search [0] ---------------------------------------------------------------------- aaron - 25-Apr-07 17:35 ---------------------------------------------------------------------- Bug report corresponds to dbmail_2_2_branch, rev 2521. Issue History Date Modified Username Field Change ====================================================================== 24-Apr-07 04:21 rhstone New Issue 24-Apr-07 06:59 rhstone Note Added: 0002083 25-Apr-07 17:35 aaron Note Added: 0002096 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev