Spam Filter ISP Support - Reload Filtersettings

Reload Filtersettings

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=6802
Printed Date: 05 February 2025 at 1:03pm

Topic: Reload Filtersettings

Posted By: Bart
Subject: Reload Filtersettings
Date Posted: 18 February 2010 at 2:58am

Last couple of days i've people complaining that new items i add to the Expluded whitelist or Athorized To Emails won't be active.

When i look in SQL the Items are there and when i restart the Spamfilter Service also Spamfilter can see those Items like it should be.

Do i need to restart the Spamfilter Service after every Black/Whitelist item i add/remove or is something wrong with my server ?

The only line i could find in the logfile was this one.

Exception occurred during ChecktblReloadTableInfo: String or binary data would be truncated

It looks like this message is in the logfile every 5 seconds. Can you please tell me how i can found out what is causing this problem ?

Tnx

Replies:

Posted By: LogSat
Date Posted: 18 February 2010 at 4:09pm

All changes to the databases are reloaded automatically by SpamFilter within 5 seconds. From the error you reported I suspect there may be an issue with the database.

It's possible that, if you migrated/restored/re-created the SpamFilter database, and/or migrated the SpamFilter installation somewhere else, this created a mixup with the actual patches applied to the database and with what SpamFilter thinks was applied.

I'd recommend having SpamFilter re-apply all the database patches that are needed. This may cause errors to be logged when the scripts are trying to add database fields that exist already, but these errors can be ignored.

To proceed, please:

stop SpamFilter
then find and remove the line starting with DBPatchesApplied= in the SpamFilter.ini file
and then restart SpamFilter.

When done, the line you removed should have been automatically re-added.

If the problem still occurs after this, if you can then zip us (to support @ logsat.com) the activity logfile starting from when you restarted SpamFilter, we’ll try to figure out what is going on. If the zip is over 8MB in size, please let us know so we can provide you credentials to upload the file via FTP.

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

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

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