This is because your database is in UTF8 format.  As a result SA cannot
read it (though it can write it).

Drop the database and recreate it and the tables in latin and it will
work just fine.  You will have to retrain after that though.

-----Original Message-----
From: Hamish Marson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 08, 2006 3:42 AM
To: users@spamassassin.apache.org
Subject: Bayes errors...

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


I keep getting the following from spamassasin (Running under amavisd
debug-sa). Any ideas what I've done wrong this time?

The database is mysql. SpamAssassin is 3.1.4 (It also did the same
with 3.1.3).

[12172] dbg: bayes: database connection established
[12172] dbg: bayes: found bayes db version 3
[12172] dbg: bayes: Using userid: 1
[12172] dbg: bayes: tok_get: SQL error: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
operation '='
[12172] dbg: bayes: _put_token: SQL error: Duplicate entry '1-?7?k?'
for key 1
[12172] dbg: bayes: tok_get: SQL error: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
operation '='
[12172] dbg: bayes: _put_token: SQL error: Duplicate entry '1-??%m!'
for key 1
[12172] dbg: bayes: tok_get: SQL error: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
operation '='
[12172] dbg: bayes: _put_token: SQL error: Duplicate entry '1-?4??%'
for key 1
[12172] dbg: bayes: tok_get: SQL error: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for
operation '='
[12172] dbg: bayes: _put_token: SQL error: Duplicate entry '1-l???'
for key 1

When it's not giving the above it gives

[12254] dbg: bayes: database connection established
[12254] dbg: bayes: found bayes db version 3
[12254] dbg: bayes: Using userid: 1
[12254] dbg: bayes: corpus size: nspam = 7492, nham = 100752
[12254] dbg: bayes: tok_get_all: token count: 198
[12254] dbg: bayes: tok_get_all: SQL error: Illegal mix of collations
for operation ' IN '
[12254] dbg: bayes: cannot use bayes on this message; none of the
tokens were found in the database
[12254] dbg: bayes: not scoring message, returning undef



TIA
  Hamish.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFE2GqC/3QXwQQkZYwRAsg+AKDTrpxO1Zs/D3vMpHpH33v192LwfACdHriQ
gPVGxD5aCuAImhjhUzaFR9w=
=kll1
-----END PGP SIGNATURE-----

Reply via email to