Print Page | Close Window

quarantine database problems

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=5344
Printed Date: 14 January 2026 at 12:14pm


Topic: quarantine database problems
Posted By: stevewalkup
Subject: quarantine database problems
Date Posted: 27 September 2005 at 1:48pm

I have a new setup of spamfilter isp which is working great. Now I am adding a MS SQL quarantine database. I am getting the following message when it attempts to quarantine a message.

Field not found ServerID' not found

The field is clearly there in the ServerTBLs folder with the correct server name.

Not sure where to go from here.

 



-------------
Steve A Reno


Replies:
Posted By: stevewalkup
Date Posted: 27 September 2005 at 3:36pm

Also I should note that when I run step 2 "check / create database tables I get:

================
please wait...
Found tblQuarantine
Found tblMsgs
Found tblRejectCodes
Found tblLogins
Found tblServers
Retrieved ServerID from tblServers: 1

ERROR - Some fields are missing from the tables!
Please proceed to Step 2-b to add missing fields
Done.

But there are no updates to run in step 2b......

Now what



-------------
Steve A Reno

Posted By: LogSat
Date Posted: 27 September 2005 at 6:30pm
Steve,

On Step 2, did you click on the "Create / Check Database tables" button?

Also, it's strange to see a field missing. How did you create the SQL database and SpamFilter's tables? Manually using the included SQL scripts, or using the 1-2-3 step wizard in SpamFilter?


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

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

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

Posted By: stevewalkup
Date Posted: 29 September 2005 at 2:52pm

Yes

when I run step 2 "check / create database tables I get:

================
please wait...
Found tblQuarantine
Found tblMsgs
Found tblRejectCodes
Found tblLogins
Found tblServers
Retrieved ServerID from tblServers: 1

ERROR - Some fields are missing from the tables!
Please proceed to Step 2-b to add missing fields
Done.

But there are no updates to run in step 2b......

Not sure where to go with this



-------------
Steve A Reno

Posted By: LogSat
Date Posted: 29 September 2005 at 4:54pm
Steve,

Can you please provide the info for:
============
How did you create the SQL database and SpamFilter's tables? Manually using the included SQL scripts, or using the 1-2-3 step wizard in SpamFilter?
============
Can you also please confirm that you're using Microsoft SQL Server (if so, which version), and not MS Access?


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

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

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


Print Page | Close Window