Exception occurred during ChecktblReloadTableInfo |
Post Reply ![]() |
Author | |
gns ![]() Newbie ![]() Joined: 27 July 2008 Status: Offline Points: 3 |
![]() ![]() ![]() ![]() ![]() Posted: 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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
Yoahhoooo! It solved both problems! Thanx!
|
|
![]() |
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.141 seconds.