bayes in MySQL with replication

[Jason Ede]

It's the standard bayes MySQL module. I've looked at both ends and I can't see where that code is generated.

Jason

-----Original Message-----
From: mailscanner-bounces at lists.mailscanner.info [mailto:mailscanner-bounces at lists.mailscanner.info] On Behalf Of Rick Cooper
Sent: 23 February 2008 00:29
To: 'MailScanner discussion'
Subject: RE: bayes in MySQL with replication



 > -----Original Message-----
 > From: mailscanner-bounces at lists.mailscanner.info
 > [mailto:mailscanner-bounces at lists.mailscanner.info] On
 > Behalf Of Julian Field
 > Sent: Friday, February 22, 2008 11:50 AM
 > To: MailScanner discussion
 > Subject: Re: bayes in MySQL with replication
 >
 > -----BEGIN PGP SIGNED MESSAGE-----
 > Hash: SHA1
 >
 >
 >
 > Jason Ede wrote:
 > >
 > > Many thanks for that... just what I was looking for...
 > >
 > > I also saw a
 > >
 > > 080222 15:38:55 [ERROR] Slave: Error 'You have an error in
 > your SQL
 > > syntax; check the manual that corresponds to your MySQL
 > server version
 > > for the right syntax to use near 'ON DUPLICATE KEY UPDATE
 > spam_count =
 > > GREATEST(spam_count + '0', 0),
 > >
 > > ' at line 2' on query. Default database: 'sa_bayes'.
 > Query: 'INSERT
 > > INTO bayes_token
 > >
 > > (id ON DUPLICATE KEY UPDATE spam_count =
 > GREATEST(spam_count + '0', 0),
 > >
 > > ham_count = GREATEST(ham_count + '1', 0),
 > >
 > > atime = GREATEST(atime, '1203694258')Ã', Error_code: 1064
 > >
 > That capital A with an accent of some sort right at the end
 > of the query
 > it reports looks very suspicious to me...
[...]

The part that mysql is complaining about starts 'ON DUPLICATE KEY UPDATE
spam_count =
GREATEST(spam_count + '0', 0)'. It makes sense to me because the entire
Syntax looks wacked. Unless there is something I missed all this time, the
syntax
For that statement goes

INSERT INTO table (item1,item2,...) VALUES (value1,value2,...) ON DUPLICATE
KEY UPDATE field1='value', field2='value',...

Unless there way it is written is a special mysql short hand I have never
seen before. Could be ;->).

Rick


--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


--
MailScanner mailing list
mailscanner at lists.mailscanner.info
http://lists.mailscanner.info/mailman/listinfo/mailscanner

Before posting, read http://wiki.mailscanner.info/posting

Support MailScanner development - buy the book off the website!