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.

Reply via email to