A NOTE has been added to this issue. ====================================================================== http://dbmail.org/mantis/view.php?id=348 ====================================================================== Reported By: eZeus Assigned To: ====================================================================== Project: DBMail Issue ID: 348 Category: Database layer Reproducibility: always Severity: minor Priority: none Status: feedback ====================================================================== Date Submitted: 11-May-06 16:19 CEST Last Modified: 12-May-06 09:32 CEST ====================================================================== Summary: When delete subfolder, MS Outlook don't delete messages inside it. Description: I use MS Outlook 2003 When I create a subfolder and put some messages inside (even one), after that I want to delete this subfolder. dbmail_mailboxes table delete subfolder fine and there is no messages in dbmail_message table, but other tables still have all other information about "deleted" messages. I switch the sequence of deleting of mailbox in db.c:db_delete_mailbox function: 1. Delete all messages 2. Delete the mailbox ======================================================================
---------------------------------------------------------------------- paul - 11-May-06 17:49 ---------------------------------------------------------------------- What 'other tables still have all other information about "deleted" message' ? If you're talking about physmessages/messageblks: it's a feature not a bug. Running dbmail-util -ty should get rid of any physmessages that don't have any corresponding messages. ---------------------------------------------------------------------- eZeus - 11-May-06 18:06 ---------------------------------------------------------------------- Unfortunately it is not. I am talking about dbmail_ccfield, dbmail_datefield, dbmail_fromfield, dbmail_headervalue, dbmail_replytofield, dbmail_subjectfield, dbmail_tofield and those table that you have mentioned. dbmail-util -ty return output: Opening connection to database... Opening connection to authentication... Ok. Connected. Repairing DBMAIL messageblocks integrity... Ok. Found [0] unconnected messageblks. Checking DBMAIL message integrity... Ok. Found [0] unconnected messages. Checking DBMAIL mailbox integrity... Ok. Found [0] unconnected mailboxes. Maintenance done. No errors found. But I can see that there is some messages in dbmail_physmessage after executing. ---------------------------------------------------------------------- paul - 12-May-06 09:32 ---------------------------------------------------------------------- All the header cache tables have foreign key constraints on the physmessage table. My guess is that dbmail-util -ty doesn't detect unconnected physmessages which would make this bug report a dupe of http://dbmail.org/mantis/view.php?id=305 Issue History Date Modified Username Field Change ====================================================================== 11-May-06 16:19 eZeus New Issue 11-May-06 17:49 paul Note Added: 0001164 11-May-06 17:49 paul Priority normal => none 11-May-06 17:49 paul Status new => feedback 11-May-06 17:49 paul Resolution open => no change required 11-May-06 18:05 eZeus Note Added: 0001165 11-May-06 18:06 eZeus Note Edited: 0001165 12-May-06 09:32 paul Note Added: 0001166 ======================================================================
