Illegal mix of collations error

General
1

Hello,

I receive the following error:
Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation ‘<>’

image
image1085×55 4.96 KB

This error is showing up on a page which hasnt been changed for months, can you help me with this error?

1 Like
2

Hi, @Michel_Loriaux

We are sorry for the inconvenience. We have an internal ticket for this issue - BKNDLSS-28372. Our engineers are already looking into the issue. We will do our best to fix the problem as soon as possible. We will notify you in this thread when it is ready.

Regards,
Marina

3

Thanks @Marina.Kan,
Currently a lot of users are experiencing this issue on the home page of the app and users cannot use the app anymore.

4

@Michel_Loriaux

This problem is of the highest priority for us. We are sorry for the inconvenience.

Regards, Marina

5

Hi @Marina.Kan,

I see now that the same error is back again, can you please urgently
check?

image
image999×60 4.25 KB

6

We are seeing the same issue again today

7

Hi.
We think we’ve found the cause. Now we are trying the fix on one of our servers. If everything will be fine we apply it everywhere. We will post here about the result.

1 Like
8

Hello,

I am also receiving this error

  1. code: 1267

  2. message: “Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation ‘<>’”

  3. errorData: Object

9

Hi @Hezzron_Austin , @Tony_Goodchild , @Michel_Loriaux ,

We had located the cause and fixed the error. This error will not happen again.

Sorry for inconvenience.

Regards, Andriy

10

Thanks @Andriy_Konoz !

11

Thank you @Andriy_Konoz