UGCC 2.3X+ MySQL Database Error

[Masher]

If you're using MySQL and after upgrading to a 2.3x+ release of UGCC and see an error message similar to

Code: Select all

Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' at

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.