UGCC 2.3X+ MySQL Database Error

Having problems with the panel? Have questions? Post here!
Post Reply
Masher
Site Admin
Posts: 3612
Joined: Thu Apr 20, 2006 2:54 pm
Location: America's Heartland
Contact:

UGCC 2.3X+ MySQL Database Error

Post by 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.
Masher
-----------
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.

NEW Join our Discord!
Post Reply