Filter settings not sticking |
Post Reply ![]() |
Author | |
Rifleman ![]() Groupie ![]() Joined: 08 August 2005 Location: United States Status: Offline Points: 53 |
![]() ![]() ![]() ![]() ![]() Posted: 06 June 2007 at 10:52am |
I have SF Ent .678 and I am still unable to get some filter settings to stick.
I check the box in the BlackList area "Do Not quarantine emails from this blacklist are" in certain categories, I click on "Save settings" but wwhen I close and re-open it, they are unchecked again. This is annoying because I am quarantining ALL emails. I do not want to quarantine emails for example in Keywords and the BlackList To lists.
|
|
![]() |
|
Desperado ![]() Senior Member ![]() ![]() Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
![]() ![]() ![]() ![]() ![]() |
Rifleman, Does this happen on all list? I tried to duplicate your issue and can not. And ... You did hit the save and not just "close"? |
|
The Desperado
Dan Seligmann. Work: http://www.mags.net Personal: http://www.desperado.com |
|
![]() |
|
Rifleman ![]() Groupie ![]() Joined: 08 August 2005 Location: United States Status: Offline Points: 53 |
![]() ![]() ![]() ![]() ![]() |
It happens on all the Blacklists. And yes, I hit save prior to closing.
|
|
![]() |
|
WebGuyz ![]() Senior Member ![]() Joined: 09 May 2005 Location: United States Status: Offline Points: 348 |
![]() ![]() ![]() ![]() ![]() |
Try hitting the tab key to get off that checkbox. Seems that if you click on some fields but don't tab to the next the program doesn't 'know' about it and it requires moving to another field so it does.
|
|
http://www.webguyz.net
|
|
![]() |
|
Rifleman ![]() Groupie ![]() Joined: 08 August 2005 Location: United States Status: Offline Points: 53 |
![]() ![]() ![]() ![]() ![]() |
Just tried that, same thing. It unchecks itself.
|
|
![]() |
|
Desperado ![]() Senior Member ![]() ![]() Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
![]() ![]() ![]() ![]() ![]() |
Can you look in one of your "domains" folders and see if each domain has a "Filters.ini" file?
Edited by Desperado |
|
The Desperado
Dan Seligmann. Work: http://www.mags.net Personal: http://www.desperado.com |
|
![]() |
|
WebGuyz ![]() Senior Member ![]() Joined: 09 May 2005 Location: United States Status: Offline Points: 348 |
![]() ![]() ![]() ![]() ![]() |
Just double checked my test server running 678 and it works correctly for separate domains as well as ALL Domains.
|
|
http://www.webguyz.net
|
|
![]() |
|
LogSat ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
![]() ![]() ![]() ![]() ![]() |
Rifleman,
We can't reproduce it either... Could you please note the computer's time just before clicking on the "Save Settings" button, and them email us the section of SpamFilter's activity logfile from that time on (include about 5 minutes worth of data after that point). |
|
![]() |
|
Rifleman ![]() Groupie ![]() Joined: 08 August 2005 Location: United States Status: Offline Points: 53 |
![]() ![]() ![]() ![]() ![]() |
Here is the Filter.ini file
[Filter Settings]
id=1 domainid=1 bl_domainsforcedelete=0 bl_emailsfromforcedelete=0 bl_emailstoforcedelete=0 bl_countriesforcedelete=0 bl_mapsforcedelete=0 bl_keywordsforcedelete=0 bl_attachmentsforcedelete=0 bl_surblforcedelete=0 bl_ipsforcedelete=0 bl_honeypotemailsforcedelete=0 rejectnoreverseforcedelete=0 rejectnomxforcedelete=0 spffilterenableforcedelete=0 rejectemptymailfromforcedelete=0 rejectsametofromdomainforcedelete=0 rejectsametofromforcedelete=0 sfdbforcedelete=0 maxrcpt_toforcedelete=0 authorizedtoforcedelete=0 antivirusforcedelete=0 imageforcedelete=0 surblforcedelete=0 bayesianfilterenable=1 bayesianforcedelete=0 spffilterenable=1 spfneutralfilter=1 spfsoftfailfilter=0 spffailfilter=0 allowpercent=1 tagspam=0 tagspamsubject=0 tagspamandquarantine=0 rejectnoreverse=1 rejectnomx=1 rejectemptymailfrom=1 rejectsametofrom=0 rejectsametofromdomain=0 enableipcacheblacklist=1 autowhitelistforcedeliveryenabled=1 minmaps=2 maxsubjectspaces=10 spamimagethreshold=10 sfdb_networkreliability=2 sfdb_filtersall=1 sfdb_filterslist= id_1=1 domainname= ALL DOMAINS destsmtpserver= |
|
![]() |
|
Rifleman ![]() Groupie ![]() Joined: 08 August 2005 Location: United States Status: Offline Points: 53 |
![]() ![]() ![]() ![]() ![]() |
Here is the logfile entry
06/08/07 08:50:11:695 -- (2560) Exception occurred during TFilterObject.SaveFilterSettings: Invalid field size - 12
|
|
![]() |
|
LogSat ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
![]() ![]() ![]() ![]() ![]() |
Rifleman,
We received your entire logfile, and the entry above is indeed what we believe is the problem. The error: Invalid field size is returned by the ODBC / OLEDB driver when SpamFilter tries to execute the following query against the database: select * from tbl_filtersettings where domainid=1; It's caused by a bug (#5427) in MySQL. There's a workaround, which is to try configuring the MySQL ODBC DNS to "Return Matching Rows". Please see the screenshot below for the exact location. ![]() |
|
![]() |
|
Rifleman ![]() Groupie ![]() Joined: 08 August 2005 Location: United States Status: Offline Points: 53 |
![]() ![]() ![]() ![]() ![]() |
I just did that. and the results are the same.
|
|
![]() |
|
LogSat ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
![]() ![]() ![]() ![]() ![]() |
The issue was caused by using an earlier, unsupported version of the MySQL ODBC Driver (v3.51.11). Upgrading to the latest MySQL ODBC 3.51.15 solved the problem.
|
|
![]() |
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.145 seconds.