Print Page | Close Window

Quarantine, Multiple Recipient Problem

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5547
Printed Date: 31 July 2025 at 8:53am


Topic: Quarantine, Multiple Recipient Problem
Posted By: Matt
Subject: Quarantine, Multiple Recipient Problem
Date 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.


Replies:
Posted By: LogSat
Date Posted: 13 March 2006 at 9:33pm
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.


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP


Print Page | Close Window