Quarantine, Multiple Recipient Problem |
Post Reply ![]() |
Author | |
Matt ![]() Newbie ![]() ![]() Joined: 03 March 2006 Location: United States Status: Offline Points: 17 |
![]() ![]() ![]() ![]() ![]() Posted: 13 March 2006 at 5:20pm |
I am running SpamFilter ISP 2.7.1.532 and using MySQL 5.0 to store the quarantine data. The quarantine is set to delete the e-mails after they become 8 days old. I delete the expired items every 60 minutes. The problem I have is when an e-mail containing more than one recipient is quarantined and one of the intended recipients either sends or deletes the e-mail. When the person sends or deletes the email from their quarantine area the expire flag is set. When the program runs the 60 minutes cycle to delete the expired messages, it deletes the record for the user that released the message from the tblquarantine table, and deletes the message from the tblmsgs table with the corresponding msgID. Now if the other recipients of the message check their quarantine they see the header, but when they try to view the message they get an error saying message can not be found. If I manually look at the database I can see the tblquarantine records for the users of the e-mail in question, except the user that released the e-mail. The MsgID that the tblQuarantine record points to does not exist anymore because it was deleted when the 60 minute expired message cycle ran. |
|
![]() |
|
LogSat ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
![]() ![]() ![]() ![]() ![]() |
Matt,
What you found is a limitation in how SpamFilter is able to handle the case you described. There is currently no solution to this. As a workaround, a scheduled query could be executed on the database so that records with the email data in the tblMsgs table are "unflagged" for deletion should they be linked to multiple records in the tblQuarantine table. The record for the single user who opted to delete the email can then be removed from the tblQuarantine table. This is however untested, and I'm only brainstorming. The real fix should come from SpamFilter, but I do not have right now estimates on when this will occurr. |
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.129 seconds.