Re: mysql 8 database problem

2018-12-09 Thread Giovanni Bechis
On 12/8/18 1:20 PM, Csaba Banhalmi wrote: > Hi, > > I upgraded to mysql and since then I can’t use bases db to score my mails. > Spam assassin -D says the following: > > [12254] dbg: bayes: tok_get_all: SQL error: Illegal mix of collations > for operation ' IN ' > [12254] dbg: bayes: cannot use

Re: mysql 8 database problem

2018-12-09 Thread Brent Clark
On 2018/12/08 21:21, Dave Wreski wrote: I'd also consider changing to mariadb if it's supported by your distribution. Regards, Dave ^ This Regards Brent

Re: mysql 8 database problem

2018-12-08 Thread Dave Wreski
On 12/8/18 1:58 PM, Csaba Banhalmi wrote: Hi, I upgraded to mysql and since then I can’t use bases db to score my mails. Spam assassin -D says the following: [12254] dbg: bayes: tok_get_all: SQL error: Illegal mix of collations for operation ' IN ' [12254] dbg: bayes: cannot use bayes on

mysql 8 database problem

2018-12-08 Thread Csaba Banhalmi
Hi, I upgraded to mysql and since then I can’t use bases db to score my mails. Spam assassin -D says the following: [12254] dbg: bayes: tok_get_all: SQL error: Illegal mix of collations for operation ' IN ' [12254] dbg: bayes: cannot use bayes on this message; none of the tokens were found

mysql 8 database problem

2018-12-08 Thread Csaba Banhalmi
Hi, I upgraded to mysql and since then I can’t use bases db to score my mails. Spam assassin -D says the following: [12254] dbg: bayes: tok_get_all: SQL error: Illegal mix of collations for operation ' IN ' [12254] dbg: bayes: cannot use bayes on this message; none of the tokens were found