[utf-8] Mailscanner: Cannot insert row: ..... S[utf-8] QL syntax error....

[[utf-8] Samuel Luxford-Watts]

    [ The following text is in the "utf-8" character set. ]
    [ Your display is set for the "US-ASCII" character set.  ]
    [ Some characters may be displayed incorrectly. ]


Hi All,

 

I am not too sure which list this should be posted to so forgive me if I
got the wrong one!

 

I have been running Mailscanner V 4.31 and MailWatch for some time now
with no problems (thankyou people!) and upgraded MailScanner
V4.41.3-1.suse .and SpamAssassin 3.03 last night. Since then I have been
getting the following error displayed every so often in /var/log/mail:

 

----

May 26 14:49:02 mailscanner MailScanner[9293]: Cannot insert row: You
have an error in your SQL syntax near '829 logged
in,'192.168.16.5','',0,0,0,NULL,0,0,-1.039,'not spam, SpamAssassin (s' at
line 1

--

 

Everything is working fine, I upgraded MailWatch with the latest current
CVS and dropped the mailscanner database and re-created it to ensure that
everything was up to date, but still I get the same error.

 

The curious thing is its not happening for all emails and most are being
logged successfully to the MySQL database. It is running SuSE linux 8.1
and MySQL V3.23.52 tho which is ancient I know but I donâ^À^Ùt really
want to have to upgrade just yet.

 

If anyone has any ideas then please let me know?

 

 

Thanks in advance,

 

Sam

Winckworth Sherwood Solicitors and Parliamentary Agents
DX 148400 WESTMINSTER 5 : 35 Great Peter Street, London SW1P 3LR
Telephone 020 7593 5000 Fax 020 7593 5099

Confidentiality
This email message and any attachments are confidential; they may be
subject to legal professional privilege and are intended for the named
recipient only. If you are not the named recipient, please return the
message and enclosures immediately and delete them from your system.

Caution
Before advice received only by email (whether by attachment or otherwise)
may be relied on, the authenticity of the communication must be verified
by means independent of email.

Regulation
The firm is regulated by the Law Society.

Partners
A list of partners is available for inspection at each office of the firm
and on the firm's website at www.winckworths.co.uk

------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
'leave mailscanner' in the body of the email.
Before posting, read the Wiki (http://wiki.mailscanner.info/)
and the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).

Support MailScanner development - buy the book off the website!