Spam Filter ISP Forums : Cannot save filter settings for domain https://www.logsat.com/spamfilter/forums/ Wed, 20 May 2026 13:08:52 +0000 Wed, 16 May 2007 10:37:08 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=6066 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Cannot save filter settings for domain : I can&#039;t reproduce it... Could...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10149&title=cannot-save-filter-settings-for-domain#10149 Author: LogSat
Subject: 6066
Posted: 16 May 2007 at 10:37am

I can't reproduce it... Could you either post or email us a screenshot(or an export) of the table, for the "before" and "after" this happens?]]> Wed, 16 May 2007 10:37:08 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10149&title=cannot-save-filter-settings-for-domain#10149 <![CDATA[Cannot save filter settings for domain : OK, I understand that but ALL...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10148&title=cannot-save-filter-settings-for-domain#10148 Author: Belvoir
Subject: 6066
Posted: 16 May 2007 at 9:37am

OK, I understand that but ALL entries for domain 11 are being written as domainid 1 and all entries for domain 12 are also being written as domainid 1 as are 13, 14, 15 . . . etc]]> Wed, 16 May 2007 09:37:12 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10148&title=cannot-save-filter-settings-for-domain#10148 <![CDATA[Cannot save filter settings for domain : Belvoir,Actually that is by design....]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10147&title=cannot-save-filter-settings-for-domain#10147 Author: LogSat
Subject: 6066
Posted: 16 May 2007 at 9:33am

Belvoir,

Actually that is by design. When a blacklist/whitelist is modified, SpamFilter will first delete all entries relative to a domain from the table (meaning it will delete all the ones for that specific domainID), and will then add them all at once again.

We opted to do this rather than add/remove each individual entry from the table as it's often slower to compare the list of entries in SpamFilter to the one in the database and keeping them in sync.
]]> Wed, 16 May 2007 09:33:42 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10147&title=cannot-save-filter-settings-for-domain#10147 <![CDATA[Cannot save filter settings for domain : Thanks Roberto, that&#039;s fixed...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10146&title=cannot-save-filter-settings-for-domain#10146 Author: Belvoir
Subject: 6066
Posted: 16 May 2007 at 9:07am

Thanks Roberto, that's fixed that problem but here's another related one for you.

Whenever I add "Authorized To Emails" addresses for local domains with an "id" greater than 10, it writes a row into tblwl_athorizedtoemails with a "domainid" of 1 and overwrites (deletes and re-creates) what was already there.

Domain id=10 is OK though!

 

Regards

]]> Wed, 16 May 2007 09:07:15 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10146&title=cannot-save-filter-settings-for-domain#10146 <![CDATA[Cannot save filter settings for domain : That seems to fix the problem...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10143&title=cannot-save-filter-settings-for-domain#10143 Author: Web123
Subject: 6066
Posted: 16 May 2007 at 12:26am

That seems to fix the problem for me!

Thanks

]]> Wed, 16 May 2007 00:26:52 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10143&title=cannot-save-filter-settings-for-domain#10143 <![CDATA[Cannot save filter settings for domain : Can you please try configuring...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10141&title=cannot-save-filter-settings-for-domain#10141 Author: LogSat
Subject: 6066
Posted: 15 May 2007 at 7:59pm

Can you please try configuring the MySQL ODBC DNS to "Return Matching Rows". Please see the screenshot below for the exact location. This *may* be caused by a bug (#5427) in MySQL.


]]> Tue, 15 May 2007 19:59:19 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10141&title=cannot-save-filter-settings-for-domain#10141 <![CDATA[Cannot save filter settings for domain : We&#039;re looking into it and...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10140&title=cannot-save-filter-settings-for-domain#10140 Author: LogSat
Subject: 6066
Posted: 15 May 2007 at 4:19pm

We're looking into it and are trying to replicate the problem.]]> Tue, 15 May 2007 16:19:59 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10140&title=cannot-save-filter-settings-for-domain#10140 <![CDATA[Cannot save filter settings for domain : I get exactly the same error on...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10136&title=cannot-save-filter-settings-for-domain#10136 Author: Web123
Subject: 6066
Posted: 15 May 2007 at 6:26am

I get exactly the same error on my test server when trying to edit/add records trough the gui?

3.5.3.665 on Win2000 server with MySQL 5.0.26

 

]]> Tue, 15 May 2007 06:26:27 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10136&title=cannot-save-filter-settings-for-domain#10136 <![CDATA[Cannot save filter settings for domain : Can someone please help. I have...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10135&title=cannot-save-filter-settings-for-domain#10135 Author: Belvoir
Subject: 6066
Posted: 15 May 2007 at 6:22am

Can someone please help.  I have just starting setting up SFE version 3.5.3.665 and I am having a problem trying to set individual filter settings per domain.

I am using Windows 2003 standard edition and MySQL v5.1.17-beta-community-nt-debug.  All the database tables have been created correctly and I have created local domains, however, when I enter "Authorized TO Emails" and click "Save Settings", the changes are not stored.  A check in the logfiles reveals the following error message:

Exception occurred during TFilterObject.SaveFilterSettings: Query-based update failed because the row to update could not be found - 12345 SPFFilterEnable SPFNeutralFilter SPFSoftfailFilter SPFFailFilter SPFFilterEnableForceDelete RejectNoReverseForceDelete RejectNoMXForceDelete RejectEmptyMailFromForceDelete RejectSameToFromForceDelete RejectSameToFromDomainForceDelete BL_MAPSForceDelete BL_KeywordsForceDelete BL_IPsForceDelete BL_DomainsForceDelete BL_CountriesForceDelete BL_EmailsFromForceDelete BL_EmailsTOForceDelete BL_AttachmentsForceDelete BL_HoneypotEmailsForceDelete BL_SURBLForceDelete SFDB_NetworkReliability SFDB_FiltersAll SFDBForceDelete SFDB_FiltersList AllowPercent TagSPAM TagSPAMSubject TagSPAMAndQuarantine RejectNoReverse RejectNoMX RejectEmptyMailFrom RejectSameToFrom RejectSameToFromDomain AutoWhiteListForceDeliveryEnabled MinMAPS MaxSubjectSpaces SpamImageThreshold

I would be grateful for any help.

Thanks

]]> Tue, 15 May 2007 06:22:53 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6066&PID=10135&title=cannot-save-filter-settings-for-domain#10135