Print Page | Close Window

Update SQL script missing in step 2b

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=6868
Printed Date: 27 December 2024 at 11:45am


Topic: Update SQL script missing in step 2b
Posted By: cyrusnooriala
Subject: Update SQL script missing in step 2b
Date 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.


Replies:
Posted By: cyrusnooriala
Date 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.

Posted By: LogSat
Date 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.

-------------
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: LogSat
Date 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. 


-------------
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