Update SQL script missing in step 2b |
Post Reply 
|
| Author | |
cyrusnooriala 
Newbie 
Joined: 18 August 2010 Status: Offline Points: 2 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Update SQL script missing in step 2bPosted: 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. |
|
 |
|
|
cyrusnooriala
Newbie
Joined: 18 August 2010 Status: Offline Points: 2 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.148 seconds.