Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Quarantine, Multiple Recipient Problem
  FAQ FAQ  Forum Search   Register Register  Login Login

Quarantine, Multiple Recipient Problem

 Post Reply Post Reply
Author
Matt View Drop Down
Newbie
Newbie
Avatar

Joined: 03 March 2006
Location: United States
Status: Offline
Points: 17
Post Options Post Options   Thanks (0) Thanks(0)   Quote Matt Quote  Post ReplyReply Direct Link To This Post Topic: Quarantine, Multiple Recipient Problem
    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.

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.129 seconds.