UGCC 2.3X+ MySQL Database Error
Posted: Fri Aug 14, 2020 10:03 am
If you're using MySQL and after upgrading to a 2.3x+ release of UGCC and see an error message similar to
You will need to run the following commands against your database. Replace <database> with the name of your database and replace <tablename> with the name of a table within the database.
ALTER DATABASE <databasename> CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
Then for each table:
ALTER TABLE <tablename> CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
Most likely just need to run alter table on: 'servers' and 'gametype' tables
If you need more help please let us know.
Code: Select all
Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' atALTER DATABASE <databasename> CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
Then for each table:
ALTER TABLE <tablename> CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
Most likely just need to run alter table on: 'servers' and 'gametype' tables
If you need more help please let us know.