RE: Good ruleset

2006-04-21 Thread Jeremy Fowler
Here is my /etc/rulesdujour/config, its a modified version of the file from Gentoo Portage. As you can see, I use them all. I've had very little, if any, false positives at my location. It doesn't really matter how high the spam scores, just keep an eye out for false positives. I too am

dbg: bayes: tok_get_all: SQL error: Illegal mix of collations for operation ' IN '

2006-04-13 Thread Jeremy Fowler
Mysql: SHOW VARIABLES LIKE character% Variable_name Value character_set_clientutf8 character_set_connectionutf8 character_set_database latin1 character_set_results utf8 character_set_serverutf8 character_set_systemutf8 character_sets_dir /usr/share/mysql/charsets/

RE: bayes: tok_get_all: SQL error: Illegal mix of collations for operation ' IN '

2006-04-13 Thread Jeremy Fowler
Fixed the problem. Backed up the bayes tables with sa-learn --backup, and save the userpref and awl tables with mysqldump. Then deleted out the entire database, set everything to utf8 in my.cnf, recreated the database and tables using utf8 as the default character set. Then restored from