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