Exception occurred during ChecktblReloadTableInfo |
Post Reply 
|
| Author | |
gns 
Newbie 
Joined: 27 July 2008 Status: Offline Points: 3 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Exception occurred during ChecktblReloadTableInfoPosted: 27 July 2008 at 12:00pm |
|
Hallo! We're using the latest stable build with SQL 2005 and we have 2 problems.
1. A lot of log entries like:
[skipped]
07/27/08 18:54:04:765 -- (2740) No Data Received
07/27/08 18:54:04:765 -- (2740) Disconnect 07/27/08 18:54:05:953 -- Exception occurred during ChecktblReloadTableInfo: String or binary data would be truncated 07/27/08 18:54:09:093 -- (3404) Connection from: 69.65.56.26 - Originating country : United States [skipped]
2. Can't save settings. For example, adding new IP to blacklist, clicking on "Save settings". Nothing happens, no error appears, actually settings not saved. Files/folders permissions are OK, configuration files are NOT marked as Read-Only. User accout have administrator privilegies.
Any ideas? Edited by gns - 27 July 2008 at 12:15pm |
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
Posted: 28 July 2008 at 10:46pm |
|
gns,
The most likely cause (without seeing your logs we can't be sure) is a misconfigured database, with either some triggers missing, and/or some patches not being applied to the database. Could you try to follow the steps indicated in this recent post: http://www.logsat.com/SpamFilter/Forums/forum_posts.asp?TID=6528#12287 And, after restarting SpamFilter, clicking on the "Create / Check Database tables" button in the "Settings - Enterprise / Standard Version" tab in SpamFilter? |
|
|
|
|
gns
Newbie
Joined: 27 July 2008 Status: Offline Points: 3 |
Post Options
Thanks(0)
Quote Reply
Posted: 29 July 2008 at 6:28am |
|
Recommended actions not helped. Mailed log, SpamFilter.ini and tblReloadTableInfo structure and content.
|
|
|
|
|
LogSat
Admin Group
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
Posted: 29 July 2008 at 4:57pm |
|
I'm afraid you've just uncovered a new bug (in SpamFilter Enterprise only). The "tablename" field in the table "tblreloadtableinfo" has a length of 45 characters. This length is not enough once this table reaches 9,999,999 rows.
If you can please edit this field length in SQL Server and increase it to VARCHAR(55) this will solve the issue. You may make the change on the fly while SpamFilter is running. |
|
|
|
|
gns
Newbie
Joined: 27 July 2008 Status: Offline Points: 3 |
Post Options
Thanks(0)
Quote Reply
Posted: 30 July 2008 at 4:54am |
Yoahhoooo! It solved both problems! Thanx!
|
|
|
|
Topic Options
LogSat wrote:|
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.340 seconds.