If I try to make changes for Users in System/Users of Matomo is following message displayed:
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’, caused by: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’
This error is displayed since Update to 3.11.0. The only possible action is: Add a new user, users are not displayed, login for Superuser is working. How can I recover the Userdata? Deleting and creating new users is also OK, but don’t know how.