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