A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=455 ====================================================================== Reported By: dirixmjm Assigned To: ====================================================================== Project: DBMail Issue ID: 455 Category: IMAP daemon Reproducibility: always Severity: feature Priority: normal Status: acknowledged target: ====================================================================== Date Submitted: 21-Nov-06 23:34 CET Last Modified: 01-Dec-06 23:14 CET ====================================================================== Summary: Set status 1 for messages for which the mailbox they belong in is deleted instead of deleting them instantly. Description: If per accident a user removes a mailbox through imap al messages inside the mailbox are deleted at once. This seems rather odd against the dbmail option to restore messages for 2 days (three step removal plan).
Therefor I think when a user deletes a mailbox the messages should get a status 1, set for removal. This way it is easy to restore a message (chang mailbox_idnr and set status 0). ====================================================================== ---------------------------------------------------------------------- aaron - 01-Dec-06 08:44 ---------------------------------------------------------------------- Good idea, we should do this! ---------------------------------------------------------------------- jnorell - 01-Dec-06 17:15 ---------------------------------------------------------------------- status 1 seems to be incorrect behavior here, go with status 2. Mail clients can handle this already - ie. if you delete a folder, it could copy the mail to the trash and then remove the folder, or even move the whole folder underneath trash in heiarchy, and later delete it all (eg. squirrelmail does that). The proposed change to status 1 would make me intentionally deleting a folder and all mail under it make all that mail show up in my INBOX (the only folder that's guaranteed to be there, so obviously where it would have to go), showing with read status. Not exactly nice behavior. Putting it in INBOX but status 2 would preserve dbmail's recovery behavior, which is the issue being addressed. ---------------------------------------------------------------------- zeut - 01-Dec-06 17:59 ---------------------------------------------------------------------- Would it make sense to treat a folder much like we treat a file? That is, we can mark it deleted and have the DBMail code ignore such folders? That way when we actually delete the folder, we can still use referential integrity to delete all the associated messages. We could also use a trigger to mark all the messages inside a folder as deleted when a folder gets marked deleted, though I'm not sure that's totally necessary. Thought? ---------------------------------------------------------------------- dirixmjm - 01-Dec-06 23:14 ---------------------------------------------------------------------- Ok, stupid, I did mean a status 2 for the messages. The problem with letting the mailclient decide, is that outlook does not support moving mailboxes to the deleted folder on delete. To prevent mesages being deleted right away after a user mistakenly deletes the mailbox, I proposed to set them status 2 (1 was as stated a mistake). If we could also treat the folder as a file, would be ok by me, but I think is a lott more work then only setting message status. I also have no need for them to be added to INBOX because either they will be deleted after 3 time-periods, or I need to manually recover them by sql command, and will be able to change mailbox_idnr also. Issue History Date Modified Username Field Change ====================================================================== 21-Nov-06 23:34 dirixmjm New Issue 01-Dec-06 08:44 aaron Note Added: 0001636 01-Dec-06 08:44 aaron Status new => acknowledged 01-Dec-06 17:15 jnorell Note Added: 0001638 01-Dec-06 17:59 zeut Note Added: 0001639 01-Dec-06 23:14 dirixmjm Note Added: 0001640 ======================================================================