0005317: MySQL4Exception: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' - SOGo

ID	Project	Category	View Status	Date Submitted	Last Update

0005317	SOGo	Backend General	public	2021-05-06 14:30	2021-05-06 15:33

Reporter	FoZo	Assigned To
Priority	normal	Severity	crash	Reproducibility	always
Status	closed	Resolution	no change required
Platform	Linux	OS	Ubuntu	OS Version	20.04
Product Version	5.1.0

Summary	0005317: MySQL4Exception: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='
Description	After an upgrade from Ubuntu 18.04 to 20.04 , we are unable to login go sogo. May 06 16:18:05 sogod [41336]: [ERROR] <0x0x5583735165f0[SQLSource]> could not run SQL 'c_uid = 'ko@testmail.ne'': <MySQL4Exception: 0x55837356c190> NAME:ExecutionFailed REASON:Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' May 06 16:18:05 sogod [41336]: <0x0x5583736aaf20[SOGoDAVAuthenticator]> tried wrong password for user 'ko@testmail.ne'! The collation for the database and all tables is set to utf8mb4_unicode_ci. Mysql 8.0 is set to use utf8mb4_unicode_ci as default collation. MySQL4Encoding is set to utf8mb4
Tags	No tags attached.

Date Modified	Username	Field	Change
2021-05-06 14:30	FoZo	New Issue
2021-05-06 15:16	FoZo	Note Added: 0015248
2021-05-06 15:33	francis	Status	new => closed
2021-05-06 15:33	francis	Resolution	open => no change required

FoZo 2021-05-06 15:16 reporter ~0015248	Sorry, it looks like it is a local problem related to the view. You can close/delete this one.