Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Update SQL script missing in step 2b
  FAQ FAQ  Forum Search   Register Register  Login Login

Update SQL script missing in step 2b

 Post Reply Post Reply
Author
cyrusnooriala View Drop Down
Newbie
Newbie


Joined: 18 August 2010
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote cyrusnooriala Quote  Post ReplyReply Direct Link To This Post Topic: Update SQL script missing in step 2b
    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.
Back to Top
cyrusnooriala View Drop Down
Newbie
Newbie


Joined: 18 August 2010
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote cyrusnooriala Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4068
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.063 seconds.