Print Page | Close Window

rejectid cannot be modified

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=6037
Printed Date: 13 August 2025 at 7:36pm


Topic: rejectid cannot be modified
Posted By: tcig
Subject: rejectid cannot be modified
Date Posted: 21 April 2007 at 7:35pm

after update to 3.5.3.661 we got the following errors during startup:

04.22.07 01:21:15:471 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:486 -- Adding default Reject Codes: EmailFrom is in local blacklist file
04.22.07 01:21:15:486 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:518 -- Adding default Reject Codes: Reverse DNS not found
04.22.07 01:21:15:518 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:533 -- Adding default Reject Codes: Empty Mail From
04.22.07 01:21:15:533 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:565 -- Adding default Reject Codes: Mail From and Mail To are equal
04.22.07 01:21:15:565 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:596 -- Adding default Reject Codes: Mail From and Mail To domains are equal
04.22.07 01:21:15:596 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:611 -- Adding default Reject Codes: Exceeded maximum number of RCPT TO
04.22.07 01:21:15:627 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:643 -- Adding default Reject Codes: IP address is from a blacklisted country
04.22.07 01:21:15:643 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:658 -- Adding default Reject Codes: EmailTO is in local blacklist file
04.22.07 01:21:15:658 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:674 -- Adding default Reject Codes: EmailTO is not in AuthorizedTOEmail list
04.22.07 01:21:15:674 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:690 -- Adding default Reject Codes: no relay allowed or % found in FROM address
04.22.07 01:21:15:690 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:705 -- Adding default Reject Codes: IP found in MAPS search
04.22.07 01:21:15:705 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:721 -- Adding default Reject Codes: Keywords found in content
04.22.07 01:21:15:721 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:736 -- Adding default Reject Codes: Statistical filter match
04.22.07 01:21:15:736 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:752 -- Adding default Reject Codes: SPF Sender Policy Framework match
04.22.07 01:21:15:752 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:768 -- Adding default Reject Codes: Invalid sender domain MX record
04.22.07 01:21:15:768 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:783 -- Adding default Reject Codes: Virus Found in email
04.22.07 01:21:15:799 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:799 -- Adding default Reject Codes: IP blocked by honeypot entry
04.22.07 01:21:15:815 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:815 -- Adding default Reject Codes: URL in email found in SURBL search
04.22.07 01:21:15:830 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:830 -- Adding default Reject Codes: Detected spam signature in embedded image
04.22.07 01:21:15:846 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:846 -- Adding default Reject Codes: SFDB filter match
04.22.07 01:21:15:861 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:861 -- Adding default Reject Codes: Failed AUTH LOGIN
04.22.07 01:21:15:877 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:15:877 -- Adding default Reject Codes: Found prohibited attachment
04.22.07 01:21:15:893 -- Error updading/checking tblRejectCodes - Field 'rejectid' cannot be modified
04.22.07 01:21:16:486 -- Listener Started

After this no messages are stored in the quarantine database

System: win2003 R2, Sp 2, Mysql 5.037, ODBC 5.00.11 (also tried 3.5)

any help ?

 

 


Replies:
Posted By: LogSat
Date Posted: 22 April 2007 at 10:43am
Can you please also add the lines in the log prior to the error? There should be something indicating why SpamFilter is trying to re-insert these entries in the tblRejectCodes table. The entries probably already exist, which is why the errors are appearing.

Please also let us know if you've upgraded an existing version of SpamFilter, or if this is a new install. Please also let us know if you're running SpamFilter in "Standard" or in "Enterprise" mode.


-------------
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: tcig
Date Posted: 22 April 2007 at 2:05pm

solved ! It's also the problem of the ODBC Driver. Either ODBC 3.51.14 nor ODBC 5 cannot be used. After using ODBC 3.51.12 everything is working fine.

The problem was: before I changed to Spamfilter 3.5.3.661 I did a upgrade to Mysql 5.037 and ODBC 3.51.14. ...

Do anybody knows where is the Problem in those ODBC - Connectors ?

 

 

Posted By: LogSat
Date Posted: 22 April 2007 at 10:04pm
We're looking into it. For some reason one of the DLLs used by the MySQL ODBC drivers 3.51.14 (MSDART.DLL - a Microsoft DLL) is throwing an Access Violation (it's crashing...). We're trying to find out what the differences between v3.51.12 and v3.51.14 of the MySQL ODBC drivers could be causing this.

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