search

weaondara / BungeePerms

A permissions plugin for BungeeCord/Waterfall/Velocity and Spigot/Paper
GNU General Public License v3.0
53 stars 43 forks source link

Issues with the MySQL2-database #310

Closed MineTim closed 5 years ago

MineTim commented 7 years ago

20170530_225948

Hey :), When I start the server, there is this warning and after finishing loading, there is no group/permission (but one session before, I created some groups and some permissions (BP wrote the permissions into the mysql-database and after restarting, the mysql-database is not empty (there are the uuids with the name of the players and the ID! But BP deleted the permissions and groups...! :C )

Please help me!!!! I use BP on Minecraft 1.11.

Greetings Minecraft_Tim

BlackBeltPanda commented 7 years ago

Also having this problem after updating to MySQL 5.7

MineTim commented 5 years ago

Thank you for no response and no help! Thank you.

Greetings MineTim.

aurorasmiles commented 5 years ago

Thank you for no response and no help! Thank you.

Greetings MineTim.

Hey, I closed multiple old issues today, this one was supposed to stay open, sorry for that.

weaondara commented 5 years ago

Hey, this might help you https://stackoverflow.com/questions/36829911/how-to-resolve-order-by-clause-is-not-in-select-list-caused-mysql-5-7-with-sel

weaondara commented 5 years ago

We konw of that problem but we did not fix it yet. But the link I posted is a "work-around". The work around tells the server to behave like in previous versions.

MineTim commented 5 years ago

At this moment, I don't have a minecraft network to test that. Maybe BlackBeltPanda is able to test that.

With posting that comment from me, I want to help others with the same problem (even if I don't have a minecraft server anymore).

Hopefully BlackBeltPanda is reading this...

Greetings MineTim

BlackBeltPanda commented 5 years ago

Sorry, I switched to LuckPerms; more convenient for a network.

aurorasmiles commented 5 years ago

Should be fixed