The mailing list for listmasters using Sympa

[Steve Shipway <address@concealed>]

On Thu, 2019-07-18 at 09:00 -0500, dee heffem wrote:

> SELECT 1 FROM admin_table
> WHERE admin_table.user_admin = user_table.email_user ) OR EXISTS (
> SELECT 1 FROM subscriber_table WHERE subscriber_table.user_subscriber =
> user_table.email_user )": (HY000) Illegal mix of collations
> (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
> Jul 18 08:46:32 lists task_manager[21883]: err main::#399 >

This looks like the problem to me -- either your subscriber_table and user_table , or your admin_table and user_table, are using different collation sequences -- specifically, one has utf8_unicode_ci and the other has utf8_general_ci.  The general one is the default (when the character set is utf8), and so somewhere you have a table explicitly set to use the unicode collation sequence - possibly you have changed your server's default at some point and ended up with inconsistent definitions?

Some stackoverflow discussion: https://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci

This would imply that (if you use non-ascii characters in your names) you are better off switching all tables and your server default to use the utf8_unicode_ci collation, or possibly utf8mb4_unicode_ci (with character set utf8mb4).

Info on changing collation: https://stackoverflow.com/questions/742205/how-to-change-the-default-collation-of-a-table

Steve

--
Steve Shipway | Senior Email Systems Administrator 
Phone: +64 9 302 0515 Fax: +64 9 302 0518 
Freephone: 0800 SMX SMX (769 769) 
SMX Limited: Level 10, 19 Victoria Street West, Auckland, New Zealand 
Web: http://smxemail.com 

This email has been filtered by SMX. For more information visit smxemail.com.