bayes in MySQL with replication

[Jason Ede]

-----Original Message-----
From: mailscanner-bounces at lists.mailscanner.info [mailto:mailscanner-bounces at lists.mailscanner.info] On Behalf Of Julian Field
Sent: 22 February 2008 16:50
To: MailScanner discussion
Subject: Re: bayes in MySQL with replication

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> 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...
>
> 080222 15:38:55 [ERROR] Error running query, slave SQL thread aborted.
> Fix the problem, and restart the slave SQL thread with "SLAVE START".
> We stopped at log 'mysql-bin.000011' position 5334725
>

I was kinda suspecting that... Although I'd have thought other people would have come across this if there was a problem in the bayes SQL code, but I can't seem to find that  problem reported.. I'll try some more digging.

Jason