LuckPerms

LuckPerms

41.4k Downloads

MySQL charset issues

ZConnorZ opened this issue ยท 1 comments

commented

When you install meta suffix or prefix in Russian or Unicode characters, you receive an error in the console.
Error: https://pastebin.com/j3jqRACN

Mysql: Ver 14.14 Distrib 5.5.62
Server: Paper 1.12.2
Luck: v4.3.52

commented

The above commit fixes this issue for all new database creations, but as your database already exists, this patch won't apply and you'll need to manually adjust the charset using this SQL command.

ALTER TABLE luckperms_user_permissions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE luckperms_group_permissions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;