Mailscanner: Cannot insert row: ..... SQL syntax error....

[Martin Hepworth]

    [ 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. ]

Samuel

you're forgiven (I've cross posted this to the correct list so I'll need 
forgiveness from the internet police too :-)

Given the latest CVS version is mid upgrade to 0.6 for Mailwatch I'd 
suggest you are running pre-production code at the least.

SteveF's the best person to answer this, assuming he's around at the moment.

--
Martin Hepworth
Snr Systems Administrator
Solid State Logic
Tel: +44 (0)1865 842300


Samuel Luxford-Watts wrote:
> 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 
> <http://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!*

**********************************************************************

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote confirms that this email message has been swept
for the presence of computer viruses and is believed to be clean.	

**********************************************************************

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