On 12/8/18 1:58 PM, Csaba Banhalmi wrote:
Hi,
I upgraded to mysql and since then I can’t use bases db to score my
mails. Spam assassin -D says the following:
[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
Collation is the same as before, moreover I dumped the db and imported
in a mysql 5.6 which works fine, I get my bayes scoring just fine.
I use spamassassin 3.4.2 and mysql 8.0.12
Any help is appreciated, thank you!
Have you run mysql_upgrade after upgrading?
I'd also consider changing to mariadb if it's supported by your
distribution.
Regards,
Dave
Best regards,
Csaba
