Illegal mix of collations error
On the advanced contact search page, we get the following errors:
Unknown DB
and Unable to reach the server. Please refresh this page in your browser and try again
.
In the logs, it says Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=']
.
We have tried updating the encoding of the civicrm_booking_resource table, but the error remains.
Please advise if you need more information - there's quite a lot more data in the log.