LuckPerms

LuckPerms

41.4k Downloads

sql exception

Zacushka opened this issue · 9 comments

commented

I get this https://hatebin.com/lizbknwjsq with using this command "lp user %player% meta setprefix 1 &6◆Bronze◆ towny"
I believe it only happens when symbols are included in the command. I am using lp v. 4.4.1

Here are some screen sh
databse
database2

commented

Did you actually try it with the latest download?
It may have been already fixed as 4.4.1 is not the newest version at all.

commented

Should not make any difference in this case, since 4.4.1 was released after the fix introduced is response to the original issue. And the tables look like they should with that fix.

commented

This seems to be related to #1586, but as you can see in the screenshots the table is using the utf8mb4 encoding,

commented

I will update once I install the latest

commented

https://hatebin.com/twbtymvzbm
This is with the current version
Prefix assigning from game in game command with symbols in prefix cause this.

commented

I'm not sure this is a LP issue to be honest - can't see how it could be doing anything wrong encoding wise. Might be a case of https://github.com/lucko/LuckPerms/wiki/Storage-system-errors

commented

Could you show us the structure of all tables?
I have an idea.

commented

https://github.com/lucko/LuckPerms/blob/master/common/src/main/java/me/lucko/luckperms/common/messaging/sql/AbstractSqlMessenger.java#L57
Collation of the messaging table isn't set to utf8_mb4, so; Will be using the platform default

commented

Ah crap yeah, I glossed over this being related to SQL messaging and not normal storage.