Illegal mix of collations error

Hello,

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

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

1 Like

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

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

@Michel_Loriaux

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

Regards, Marina

Hi @Marina.Rudenko,

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

We are seeing the same issue again today

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

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

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

Thanks @Andriy_Konoz !

Thank you @Andriy_Konoz