PyvesB / advanced-achievements

:fireworks: Popular plugin that adds unique and challenging achievements to Minecraft servers.
https://www.spigotmc.org/resources/83466
GNU General Public License v3.0
200 stars 211 forks source link

SQL ERROR #1085

Closed QiuRui920811 closed 2 years ago

QiuRui920811 commented 2 years ago

πŸŽ† Advanced Achievements version

8.0.0

πŸ–₯ Server version

1.17.1

🚰 Spigot username

jerry0615

𝑾 Wiki read

πŸ“ Existing issues

πŸ› Description

set up Database type: mysql

Except for h2, the rest will not work properly The plugin will not work properly

πŸ“„ Server logs

org.bukkit.command.CommandException: Cannot execute command 'aach' in plugin AdvancedAchievements v8.0.0 - plugin is disabled. at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37) ~[patched_1.17.1.jar:git-Airplane-23] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:172) ~[patched_1.17.1.jar:git-Airplane-23] at org.bukkit.craftbukkit.v1_17_R1.CraftServer.dispatchCommand(CraftServer.java:821) ~[patched_1.17.1.jar:git-Airplane-23] at net.minecraft.server.network.ServerGamePacketListenerImpl.handleCommand(ServerGamePacketListenerImpl.java:2309) ~[?:?] at net.minecraft.server.network.ServerGamePacketListenerImpl.handleChat(ServerGamePacketListenerImpl.java:2120) ~[?:?] at net.minecraft.server.network.ServerGamePacketListenerImpl.handleChat(ServerGamePacketListenerImpl.java:2101) ~[?:?] at net.minecraft.network.protocol.game.ServerboundChatPacket.handle(ServerboundChatPacket.java:46) ~[?:?] at net.minecraft.network.protocol.game.ServerboundChatPacket.handle(ServerboundChatPacket.java:6) ~[?:?] at net.minecraft.network.protocol.PacketUtils.lambda$ensureRunningOnSameThread$1(PacketUtils.java:56) ~[?:?] at net.minecraft.server.TickTask.run(TickTask.java:18) ~[patched_1.17.1.jar:git-Airplane-23] at net.minecraft.util.thread.BlockableEventLoop.doRunTask(BlockableEventLoop.java:149) ~[?:?] at net.minecraft.util.thread.ReentrantBlockableEventLoop.doRunTask(ReentrantBlockableEventLoop.java:23) ~[?:?] at net.minecraft.server.MinecraftServer.doRunTask(MinecraftServer.java:1422) ~[patched_1.17.1.jar:git-Airplane-23] at net.minecraft.server.MinecraftServer.shouldRun(MinecraftServer.java:190) ~[patched_1.17.1.jar:git-Airplane-23] at net.minecraft.util.thread.BlockableEventLoop.pollTask(BlockableEventLoop.java:122) ~[?:?] at net.minecraft.server.MinecraftServer.pollTaskInternal(MinecraftServer.java:1400) ~[patched_1.17.1.jar:git-Airplane-23] at net.minecraft.server.MinecraftServer.pollTask(MinecraftServer.java:1393) ~[patched_1.17.1.jar:git-Airplane-23] at net.minecraft.util.thread.BlockableEventLoop.managedBlock(BlockableEventLoop.java:132) ~[?:?] at net.minecraft.server.MinecraftServer.waitUntilNextTick(MinecraftServer.java:1369) ~[patched_1.17.1.jar:git-Airplane-23] at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1280) ~[patched_1.17.1.jar:git-Airplane-23] at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:319) ~[patched_1.17.1.jar:git-Airplane-23] at java.lang.Thread.run(Thread.java:831) [?:?]

βš™ Configuration

DatabaseBackup: true

DatabaseType: mysql

TablePrefix: ""

TableMaxSizeOfGroupedSubcategories: 128

AdditionalConnectionOptions: ""

DatabaseAddress: "jdbc:mysql://localhost:3306/minecraft" DatabaseUser: xxxxxxxxxxx DatabasePassword: xxxxxxxxxxxxx

PyvesB commented 2 years ago

Hello @QiuRui920811 ! :wave:

Could you please share the stack trace corresponding to the SQL error? Does this problem also occur in version 7.3.0 of the plugin?

QiuRui920811 commented 2 years ago

The same exists. I changed it to 8.0.0 today.

Is it possible to contact with Discord?

PyvesB commented 2 years ago

The same exists. I changed it to 8.0.0 today.

To clarify, you confirm that this problem was also happening in version 7.3.0?

Is it possible to contact with Discord?

No, please share the requested stack trace using an appropriate medium, i.e. GitHub.