Potential compatibility issue with MySQL 8

Question

Potential compatibility issue with MySQL 8

Tommakazi opened this issue 4 years ago · 4 comments

Tommakazi commented 4 years ago

I did a fresh install of LuckPerms on Ubuntu 20 with Bungeecord, Spigot, and MySQL 8. The only DB tables that were created were "messages" and "user_permissions". I looked into the MySQL.sql DB Schema for LuckPerms and found that the "tracks" table uses "groups" as a column name and "groups" is a reserved word in MySQL 8 and therefore cannot be used in this way. I am not sure what else this may affect, but it seems that MySQL 8 is not compatible with the current version of LuckPerms.

lucko · Answer 1 · 2020-10-12T21:26:10.000Z

Thanks for the report, but I'm not sure that's actually the cause. I've used LP with MySQL 8 with no problems before.

Try deleting all LP tables and restarting the server to see if they generate correctly.

Tommakazi · Answer 2 · 2020-10-12T21:35:42.000Z

I tried that and had the same behavior. I also tried reinstalling completely. I switched to MariaDB and did not have any issues at all.

…

On Mon, Oct 12, 2020, 3:26 PM Luck ***@***.***> wrote: Thanks for the report, but I'm not sure that's actually the cause. I've used LP with MySQL 8 with no problems before. Try deleting all LP tables and restarting the server to see if they generate correctly. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#2658 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AIO6YWL4R5NL4BUMUFZRFEDSKNYABANCNFSM4SJKBHYQ> .

Tommakazi · Answer 3 · 2020-10-12T21:37:01.000Z

I only noticed it when I went to manually build the tables.

…

On Mon, Oct 12, 2020, 3:35 PM Thomas Laird ***@***.***> wrote: I tried that and had the same behavior. I also tried reinstalling completely. I switched to MariaDB and did not have any issues at all. On Mon, Oct 12, 2020, 3:26 PM Luck ***@***.***> wrote: > Thanks for the report, but I'm not sure that's actually the cause. I've > used LP with MySQL 8 with no problems before. > > Try deleting all LP tables and restarting the server to see if they > generate correctly. > > — > You are receiving this because you authored the thread. > Reply to this email directly, view it on GitHub > <#2658 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AIO6YWL4R5NL4BUMUFZRFEDSKNYABANCNFSM4SJKBHYQ> > . >

lucko · Answer 4 · 2020-11-10T23:04:43.000Z

I believe this has been fixed by 00d4a2a

I've confirmed that groups has been correctly escaped in all places, so even though it is a reserved keyword it should be fine!

Share to