Jump to content


SQL errors


1 reply to this topic

#1 wwwampy

    Member

  • Members
  • PipPip
  • 27 posts

Posted 04 November 2018 - 08:56 PM

I have lots of this in my SQL error log after upgrading to version 8:

03.11.18 22:41:52 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = '��⁧&#34;���������' LIMIT 1;
03.11.18 22:46:55 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = '��-��������޲إ' LIMIT 1;
03.11.18 23:00:30 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = '�)���Zʖ�����v' LIMIT 1;
04.11.18 01:19:26 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = 'jKb��&#34;�����ނ+-��&#34;�' LIMIT 1;
04.11.18 03:39:50 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = '��g�O�yק�G����q' LIMIT 1;
04.11.18 04:30:37 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = 'v��r(��v�����突�&#34;�' LIMIT 1;
04.11.18 04:30:38 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = '��g�O�yק�G����q' LIMIT 1;
04.11.18 04:30:39 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = 'jKb��&#34;��(��h��&#34;�' LIMIT 1;
04.11.18 04:30:40 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = '����צk����+�k' LIMIT 1;
04.11.18 04:30:40 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = 'jKb��&#34;��&#26;��/{6�' LIMIT 1;
04.11.18 04:34:54 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = '��⁧&#34;���������' LIMIT 1;
04.11.18 07:06:53 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = '�9�q�ڞ7���+i�⒋' LIMIT 1;
04.11.18 07:38:12 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = 'jKb��&#34;��(��h��&#34;�' LIMIT 1;
04.11.18 08:24:49 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = '�9�q�ڞ7���+i�⒋' LIMIT 1;
04.11.18 10:14:49 - 1267: Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
SQL: SELECT * FROM `lz_resources` WHERE `discarded`<>1 AND (`kb_public`=1 OR `kb_bot`=1) AND `id` = '�g�mﮦ��nx��' LIMIT 1;

I'm not sure what it means.

#2 Patrick Keil

    Administrator

  • Administrators
  • 3635 posts
  • LocationSingen, Germany

Posted 05 November 2018 - 01:16 PM

Hi,

Thanks for bringimg this to our attantion.

We will investigate and fix this issue asap.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users