On Tue, Jun 21, 2011 at 5:47 PM, Mark Martinec <mark.martinec...@ijs.si> wrote: > Dave, > >> dbg: bayes: error inserting token for line: t 1 0 1308114254 >> 4fd2b3f2f0 dbg: bayes: _put_token: Updated an unexpected number >> of rows. [repeats ...] > > Which version of MySQL? > > Did you remember to replace TYPE=MyISAM with TYPE=InnoDB in the > schema (according to README.bayes) if you are using the recommended > Mail::SpamAssassin::BayesStore::MySQL as the bayes_store_module? > > Please try the following patch (against 3.3.2), at least it should provide > more informative diagnostics:
[snip..] I faced the same problem today. In my case, MySQL was configured to use utf8 by default: # my.cnf [client] default-character-set=utf8 [mysqld] character-set-server=utf8 collation-server=utf8_unicode_ci init_connect='set collation_connection = utf8_unicode_ci;' After commenting out the utf8 definitions and reverting back to latin1 "sa-learn --restore" worked fine. Regards, Panagiotis
