https://bz.apache.org/SpamAssassin/show_bug.cgi?id=8042
Bug ID: 8042 Summary: Bayes warnings when using MySQL Product: Spamassassin Version: SVN Trunk (Latest Devel Version) Hardware: PC OS: Linux Status: NEW Severity: normal Priority: P2 Component: Plugins Assignee: dev@spamassassin.apache.org Reporter: giova...@paclan.it Target Milestone: Undefined Created attachment 5815 --> https://bz.apache.org/SpamAssassin/attachment.cgi?id=5815&action=edit db_connect fix When using Bayes with MySQL, reading bayes data may not work. With debug enabled I have this warnings: Sep 9 18:13:55.180 [67917] dbg: bayes: tok_get_all: SQL error: Illegal mix of collations for operation 'in' Sep 9 18:13:55.180 [67917] dbg: bayes: cannot use bayes on this message; none of the tokens were found in the database Sep 9 18:13:55.181 [67917] dbg: bayes: not scoring message, returning undef It seems that, if some tokens are utf8, MySQL cannot correctly query the database. The attached patch fixes the issue by making sure all returned data are utf8. -- You are receiving this mail because: You are the assignee for the bug.