Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - deliver quarantined mail
  FAQ FAQ  Forum Search   Register Register  Login Login

deliver quarantined mail

 Post Reply Post Reply
Author
carlore View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote carlore Quote  Post ReplyReply Direct Link To This Post Topic: deliver quarantined mail
    Posted: 11 May 2006 at 4:55am

ht,

I've a problem with a quarantined message. I've tried to deliver it but the system crashed. When I've tried later, Spamfilter give me this error:

05/11/06 10.44.48.021 -- Exception occurred during MarkQuarantineItemsForDelivery: Impossibile individuare la riga specificata per l'aggiornamento.  possibile che alcuni valori siano stati modificati dopo l'ultima operazione di lettura

Now I need to deliver this message. How can I do?

thanks

Carlo

Back to Top
JohnD View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote JohnD Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2006 at 8:58am

go into the database an manually tag it for delivery

 

John,

 

Back to Top
carlore View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote carlore Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2006 at 9:20am
Originally posted by JohnD JohnD wrote:

go into the database an manually tag it for delivery

 

John,

 

I use MySQL, but I don't know it works... How can I deliver it manually? Thanks.

 

Back to Top
JohnD View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote JohnD Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2006 at 10:51am

It sounded to me like the error was occuring during the attempt to change the deliver Flag in TBLQuarintine from 0 to -1.  If you go into the table using either a query of editor, you can change the flag to -1.  That might do it for you. 

Is the quarintine working for other emails?

 

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

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4106
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 11 May 2006 at 10:48pm
Carlo,

From the error it possible that a crash left corrupted the database records for that email, as there  are two records in two different tables linked together.

Have you tried to stop/start SpamFilter and tried again? If that did not work, can you try stopping/restart MySQL, hoping it will self-heal?

Assuming the two records are still in the database, you can manually edit the record in the tblQuarantine just like JohnD states (thank you John!), but please note that this will only work in the licensed verison of SpamFilter. The free version only allows emails to be delivered using  SpamFilter's GUI.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
carlore View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote carlore Quote  Post ReplyReply Direct Link To This Post Posted: 12 May 2006 at 11:41am

Thanks everybody.

I stop and restart all the services and Mysql and now it works.

Bye

Carlo

 

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.176 seconds.