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: [email protected]
Reporter: [email protected]
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.