Spam Filter ISP Forums : Update SQL script missing in step 2b https://www.logsat.com/spamfilter/forums/ Mon, 20 Apr 2026 11:50:56 +0000 Sat, 21 Aug 2010 12:26:40 +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=6868 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Update SQL script missing in step 2b : For the record, the activity log...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6868&PID=13777&title=update-sql-script-missing-in-step-2b#13777 Author: LogSat
Subject: 6868
Posted: 21 August 2010 at 12:26pm

For the record, the activity log in the database tab showed:

Step 1:  Successfully connected to database!

Step 2:  ==============

please wait...

Found tblQuarantine

tblMsgs - not found

Found tblRejectCodes

Found tblLogins

Found tblServers

Some Database tables not found - recreating...

 

CREATE TABLE `tblMsgs` (

  `MsgID` int(11) NOT NULL auto_increment,

  `Msg` longtext,

  PRIMARY KEY  (`MsgID`)

) TYPE=MyISAM

[MySQL][ODBC 3.51 Driver][mysqld-5.0.19-nt]Table 'tblmsgs' already exists

 

Checking the tblMsgs table on MySQL we noticed it was corrupted. As simple "repair table" command issued via MySQL solved the issue.

table tblMsgs in MySQL was corrupted. 
]]> Sat, 21 Aug 2010 12:26:40 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6868&PID=13777&title=update-sql-script-missing-in-step-2b#13777 <![CDATA[Update SQL script missing in step 2b : cyrusnooriala, can you please...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6868&PID=13768&title=update-sql-script-missing-in-step-2b#13768 Author: LogSat
Subject: 6868
Posted: 18 August 2010 at 8:52pm

cyrusnooriala, can you please zip and email us at support at logsat.com your SpamFilter's activity logfile for a day you tried to do this so we can see what is happening? If you have more info on what you mean by "the db has become corrupt", we'll take any additional details you can provide us so we can try to understand the problem better.]]> Wed, 18 Aug 2010 20:52:33 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6868&PID=13768&title=update-sql-script-missing-in-step-2b#13768 <![CDATA[Update SQL script missing in step 2b : I have also tried stopping the...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6868&PID=13767&title=update-sql-script-missing-in-step-2b#13767 Author: cyrusnooriala
Subject: 6868
Posted: 18 August 2010 at 5:51pm

I have also tried stopping the SpamFilter service, deleting the Corpus directory and trying to force SpamFilter to recreate the table to no avail.]]> Wed, 18 Aug 2010 17:51:44 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6868&PID=13767&title=update-sql-script-missing-in-step-2b#13767 <![CDATA[Update SQL script missing in step 2b : We&#039;re running SpamFilter...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6868&PID=13766&title=update-sql-script-missing-in-step-2b#13766 Author: cyrusnooriala
Subject: 6868
Posted: 18 August 2010 at 5:49pm

We're running SpamFilter version 3.1.3.605 (I know, very old).

The Quarantine DB has become corrupt and when trying to follow the 3 steps to make sure the database is configured correctly, SpamFilter says, "ERROR - Some fields are missing from the tables!
Please proceed to Step 2-b to add missing fields
Done."

When proceeding to Step 2b, it says to choose the proper update SQL script and click on UPDATE, but there are no scripts to choose from.  Please help.
]]> Wed, 18 Aug 2010 17:49:57 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6868&PID=13766&title=update-sql-script-missing-in-step-2b#13766