Having problems with the panel? Have questions? Post here!
- Site Admin
- Posts: 3589
- Joined: Thu Apr 20, 2006 2:54 pm
- Location: America's Heartland
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.
Please do not PM me unless asked to!
We are a small company. If you have an issue or question it would be best to post it in the forums where it can help others in the future.
Join our Discord