search

TheNewEconomy / EconomyCore

The core code powering TNE.
Other
8 stars 5 forks source link

[BUG]: java.sql.SQLSyntaxErrorException: FUNCTION mc.BIN_TO_UUID does not exist #58

Closed ClayCoffee closed 11 months ago

ClayCoffee commented 11 months ago

TNE Version

0.1.1.20

Spigot Version

1.20.1

Your config.yml

-

Your latest server log

-

What modules are you using?

Conversion

What part of TNE is the bug affecting?

Won't Startup

Is your server using online mode?

Yes

Bug description

[17:27:09 WARN]: java.sql.SQLSyntaxErrorException: FUNCTION mc.BIN_TO_UUID does not exist [17:27:09 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) [17:27:09 WARN]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) [17:27:09 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) [17:27:09 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.connect.SQLConnector.executeQuery(SQLConnector.java:115) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.loadAll(SQLAccount.java:278) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.StorageManager.loadAll(StorageManager.java:143) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.TNECore.onEnable(TNECore.java:267) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.bukkit.BukkitCore.onEnable(BukkitCore.java:57) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.TNECore.enable(TNECore.java:152) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.bukkit.TNE.onEnable(TNE.java:65) [17:27:09 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:281) [17:27:09 WARN]: at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:189) [17:27:09 WARN]: at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) [17:27:09 WARN]: at java.base/java.lang.reflect.Method.invoke(Method.java:578) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:421) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:374) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.util.PaperPluginUtil.reload(PaperPluginUtil.java:526) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.command.ReloadCommand.execute(ReloadCommand.java:125) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.PlugManCommandHandler.onCommand(PlugManCommandHandler.java:97) [17:27:09 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:45) [17:27:09 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168) [17:27:09 WARN]: at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchCommand(CraftServer.java:1021) [17:27:09 WARN]: at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchServerCommand(CraftServer.java:984) [17:27:09 WARN]: at net.minecraft.server.dedicated.DedicatedServer.bf(DedicatedServer.java:541) [17:27:09 WARN]: at net.minecraft.server.dedicated.DedicatedServer.b(DedicatedServer.java:488) [17:27:09 WARN]: at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:1421) [17:27:09 WARN]: at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:1192) [17:27:09 WARN]: at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:323) [17:27:09 WARN]: at java.base/java.lang.Thread.run(Thread.java:1589) [17:27:09 ERROR]: Error occurred while enabling TheNewEconomy v0.1.2.0 (Is it up to date?) java.lang.NullPointerException: Cannot invoke "java.sql.ResultSet.next()" because "result" is null at net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.loadAll(SQLAccount.java:280) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.core.io.storage.StorageManager.loadAll(StorageManager.java:143) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.core.TNECore.onEnable(TNECore.java:267) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.bukkit.BukkitCore.onEnable(BukkitCore.java:57) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.core.TNECore.enable(TNECore.java:152) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.bukkit.TNE.onEnable(TNE.java:65) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:281) ~[purpur-api-1.20.1-R0.1-SNAPSHOT.jar:?] at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:189) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:578) ~[?:?] at com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:421) ~[PlugManX.jar:?] at com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:374) ~[PlugManX.jar:?] at com.rylinaux.plugman.util.PaperPluginUtil.reload(PaperPluginUtil.java:526) ~[PlugManX.jar:?] at com.rylinaux.plugman.command.ReloadCommand.execute(ReloadCommand.java:125) ~[PlugManX.jar:?] at com.rylinaux.plugman.PlugManCommandHandler.onCommand(PlugManCommandHandler.java:97) ~[PlugManX.jar:?] at org.bukkit.command.PluginCommand.execute(PluginCommand.java:45) ~[purpur-api-1.20.1-R0.1-SNAPSHOT.jar:?] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168) ~[purpur-api-1.20.1-R0.1-SNAPSHOT.jar:?] at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchCommand(CraftServer.java:1021) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchServerCommand(CraftServer.java:984) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.dedicated.DedicatedServer.handleConsoleInputs(DedicatedServer.java:541) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.dedicated.DedicatedServer.tickChildren(DedicatedServer.java:488) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.MinecraftServer.tickServer(MinecraftServer.java:1421) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1192) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:323) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at java.lang.Thread.run(Thread.java:1589) ~[?:?]

How to reproduce

  1. use mysql
  2. startup the server
  3. error occurs
creatorfromhell commented 11 months ago

TNE Version

0.1.1.20

Spigot Version

1.20.1

Your config.yml

Your latest server log

What modules are you using?

Conversion

What part of TNE is the bug affecting?

Won't Startup

Is your server using online mode?

Yes

Bug description

[17:27:09 WARN]: java.sql.SQLSyntaxErrorException: FUNCTION mc.BIN_TO_UUID does not exist [17:27:09 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) [17:27:09 WARN]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) [17:27:09 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) [17:27:09 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.connect.SQLConnector.executeQuery(SQLConnector.java:115) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.loadAll(SQLAccount.java:278) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.StorageManager.loadAll(StorageManager.java:143) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.TNECore.onEnable(TNECore.java:267) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.bukkit.BukkitCore.onEnable(BukkitCore.java:57) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.TNECore.enable(TNECore.java:152) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.bukkit.TNE.onEnable(TNE.java:65) [17:27:09 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:281) [17:27:09 WARN]: at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:189) [17:27:09 WARN]: at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) [17:27:09 WARN]: at java.base/java.lang.reflect.Method.invoke(Method.java:578) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:421) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:374) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.util.PaperPluginUtil.reload(PaperPluginUtil.java:526) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.command.ReloadCommand.execute(ReloadCommand.java:125) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.PlugManCommandHandler.onCommand(PlugManCommandHandler.java:97) [17:27:09 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:45) [17:27:09 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168) [17:27:09 WARN]: at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchCommand(CraftServer.java:1021) [17:27:09 WARN]: at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchServerCommand(CraftServer.java:984) [17:27:09 WARN]: at net.minecraft.server.dedicated.DedicatedServer.bf(DedicatedServer.java:541) [17:27:09 WARN]: at net.minecraft.server.dedicated.DedicatedServer.b(DedicatedServer.java:488) [17:27:09 WARN]: at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:1421) [17:27:09 WARN]: at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:1192) [17:27:09 WARN]: at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:323) [17:27:09 WARN]: at java.base/java.lang.Thread.run(Thread.java:1589) [17:27:09 ERROR]: Error occurred while enabling TheNewEconomy v0.1.2.0 (Is it up to date?) java.lang.NullPointerException: Cannot invoke "java.sql.ResultSet.next()" because "result" is null at net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.loadAll(SQLAccount.java:280) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.core.io.storage.StorageManager.loadAll(StorageManager.java:143) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.core.TNECore.onEnable(TNECore.java:267) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.bukkit.BukkitCore.onEnable(BukkitCore.java:57) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.core.TNECore.enable(TNECore.java:152) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.bukkit.TNE.onEnable(TNE.java:65) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:281) ~[purpur-api-1.20.1-R0.1-SNAPSHOT.jar:?] at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:189) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:578) ~[?:?] at com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:421) ~[PlugManX.jar:?] at com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:374) ~[PlugManX.jar:?] at com.rylinaux.plugman.util.PaperPluginUtil.reload(PaperPluginUtil.java:526) ~[PlugManX.jar:?] at com.rylinaux.plugman.command.ReloadCommand.execute(ReloadCommand.java:125) ~[PlugManX.jar:?] at com.rylinaux.plugman.PlugManCommandHandler.onCommand(PlugManCommandHandler.java:97) ~[PlugManX.jar:?] at org.bukkit.command.PluginCommand.execute(PluginCommand.java:45) ~[purpur-api-1.20.1-R0.1-SNAPSHOT.jar:?] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168) ~[purpur-api-1.20.1-R0.1-SNAPSHOT.jar:?] at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchCommand(CraftServer.java:1021) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchServerCommand(CraftServer.java:984) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.dedicated.DedicatedServer.handleConsoleInputs(DedicatedServer.java:541) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.dedicated.DedicatedServer.tickChildren(DedicatedServer.java:488) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.MinecraftServer.tickServer(MinecraftServer.java:1421) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1192) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:323) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at java.lang.Thread.run(Thread.java:1589) ~[?:?]

How to reproduce

  1. use mysql
  2. startup the server
  3. error occurs

Are you using mariadb or MySQL?

ClayCoffee commented 11 months ago

TNE Version

0.1.1.20

Spigot Version

1.20.1

Your config.yml

Your latest server log

What modules are you using?

Conversion

What part of TNE is the bug affecting?

Won't Startup

Is your server using online mode?

Yes

Bug description

[17:27:09 WARN]: java.sql.SQLSyntaxErrorException: FUNCTION mc.BIN_TO_UUID does not exist [17:27:09 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) [17:27:09 WARN]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) [17:27:09 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) [17:27:09 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.connect.SQLConnector.executeQuery(SQLConnector.java:115) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.loadAll(SQLAccount.java:278) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.StorageManager.loadAll(StorageManager.java:143) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.TNECore.onEnable(TNECore.java:267) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.bukkit.BukkitCore.onEnable(BukkitCore.java:57) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.TNECore.enable(TNECore.java:152) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.bukkit.TNE.onEnable(TNE.java:65) [17:27:09 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:281) [17:27:09 WARN]: at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:189) [17:27:09 WARN]: at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) [17:27:09 WARN]: at java.base/java.lang.reflect.Method.invoke(Method.java:578) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:421) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:374) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.util.PaperPluginUtil.reload(PaperPluginUtil.java:526) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.command.ReloadCommand.execute(ReloadCommand.java:125) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.PlugManCommandHandler.onCommand(PlugManCommandHandler.java:97) [17:27:09 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:45) [17:27:09 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168) [17:27:09 WARN]: at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchCommand(CraftServer.java:1021) [17:27:09 WARN]: at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchServerCommand(CraftServer.java:984) [17:27:09 WARN]: at net.minecraft.server.dedicated.DedicatedServer.bf(DedicatedServer.java:541) [17:27:09 WARN]: at net.minecraft.server.dedicated.DedicatedServer.b(DedicatedServer.java:488) [17:27:09 WARN]: at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:1421) [17:27:09 WARN]: at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:1192) [17:27:09 WARN]: at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:323) [17:27:09 WARN]: at java.base/java.lang.Thread.run(Thread.java:1589) [17:27:09 ERROR]: Error occurred while enabling TheNewEconomy v0.1.2.0 (Is it up to date?) java.lang.NullPointerException: Cannot invoke "java.sql.ResultSet.next()" because "result" is null at net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.loadAll(SQLAccount.java:280) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.core.io.storage.StorageManager.loadAll(StorageManager.java:143) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.core.TNECore.onEnable(TNECore.java:267) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.bukkit.BukkitCore.onEnable(BukkitCore.java:57) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.core.TNECore.enable(TNECore.java:152) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.bukkit.TNE.onEnable(TNE.java:65) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:281) ~[purpur-api-1.20.1-R0.1-SNAPSHOT.jar:?] at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:189) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:578) ~[?:?] at com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:421) ~[PlugManX.jar:?] at com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:374) ~[PlugManX.jar:?] at com.rylinaux.plugman.util.PaperPluginUtil.reload(PaperPluginUtil.java:526) ~[PlugManX.jar:?] at com.rylinaux.plugman.command.ReloadCommand.execute(ReloadCommand.java:125) ~[PlugManX.jar:?] at com.rylinaux.plugman.PlugManCommandHandler.onCommand(PlugManCommandHandler.java:97) ~[PlugManX.jar:?] at org.bukkit.command.PluginCommand.execute(PluginCommand.java:45) ~[purpur-api-1.20.1-R0.1-SNAPSHOT.jar:?] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168) ~[purpur-api-1.20.1-R0.1-SNAPSHOT.jar:?] at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchCommand(CraftServer.java:1021) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchServerCommand(CraftServer.java:984) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.dedicated.DedicatedServer.handleConsoleInputs(DedicatedServer.java:541) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.dedicated.DedicatedServer.tickChildren(DedicatedServer.java:488) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.MinecraftServer.tickServer(MinecraftServer.java:1421) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1192) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:323) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at java.lang.Thread.run(Thread.java:1589) ~[?:?]

How to reproduce

  1. use mysql
  2. startup the server
  3. error occurs

Are you using mariadb or MySQL?

mysql

creatorfromhell commented 11 months ago

TNE Version

0.1.1.20

Spigot Version

1.20.1

Your config.yml

Your latest server log

What modules are you using?

Conversion

What part of TNE is the bug affecting?

Won't Startup

Is your server using online mode?

Yes

Bug description

[17:27:09 WARN]: java.sql.SQLSyntaxErrorException: FUNCTION mc.BIN_TO_UUID does not exist [17:27:09 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) [17:27:09 WARN]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) [17:27:09 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) [17:27:09 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.connect.SQLConnector.executeQuery(SQLConnector.java:115) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.loadAll(SQLAccount.java:278) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.StorageManager.loadAll(StorageManager.java:143) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.TNECore.onEnable(TNECore.java:267) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.bukkit.BukkitCore.onEnable(BukkitCore.java:57) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.TNECore.enable(TNECore.java:152) [17:27:09 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.bukkit.TNE.onEnable(TNE.java:65) [17:27:09 WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:281) [17:27:09 WARN]: at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:189) [17:27:09 WARN]: at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) [17:27:09 WARN]: at java.base/java.lang.reflect.Method.invoke(Method.java:578) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:421) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:374) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.util.PaperPluginUtil.reload(PaperPluginUtil.java:526) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.command.ReloadCommand.execute(ReloadCommand.java:125) [17:27:09 WARN]: at PlugManX.jar//com.rylinaux.plugman.PlugManCommandHandler.onCommand(PlugManCommandHandler.java:97) [17:27:09 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:45) [17:27:09 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168) [17:27:09 WARN]: at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchCommand(CraftServer.java:1021) [17:27:09 WARN]: at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchServerCommand(CraftServer.java:984) [17:27:09 WARN]: at net.minecraft.server.dedicated.DedicatedServer.bf(DedicatedServer.java:541) [17:27:09 WARN]: at net.minecraft.server.dedicated.DedicatedServer.b(DedicatedServer.java:488) [17:27:09 WARN]: at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:1421) [17:27:09 WARN]: at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:1192) [17:27:09 WARN]: at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:323) [17:27:09 WARN]: at java.base/java.lang.Thread.run(Thread.java:1589) [17:27:09 ERROR]: Error occurred while enabling TheNewEconomy v0.1.2.0 (Is it up to date?) java.lang.NullPointerException: Cannot invoke "java.sql.ResultSet.next()" because "result" is null at net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.loadAll(SQLAccount.java:280) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.core.io.storage.StorageManager.loadAll(StorageManager.java:143) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.core.TNECore.onEnable(TNECore.java:267) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.bukkit.BukkitCore.onEnable(BukkitCore.java:57) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.core.TNECore.enable(TNECore.java:152) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at net.tnemc.bukkit.TNE.onEnable(TNE.java:65) ~[TNE-Bukkit-0.1.2.0-Pre-22.jar:?] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:281) ~[purpur-api-1.20.1-R0.1-SNAPSHOT.jar:?] at io.papermc.paper.plugin.manager.PaperPluginInstanceManager.enablePlugin(PaperPluginInstanceManager.java:189) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:578) ~[?:?] at com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:421) ~[PlugManX.jar:?] at com.rylinaux.plugman.util.PaperPluginUtil.load(PaperPluginUtil.java:374) ~[PlugManX.jar:?] at com.rylinaux.plugman.util.PaperPluginUtil.reload(PaperPluginUtil.java:526) ~[PlugManX.jar:?] at com.rylinaux.plugman.command.ReloadCommand.execute(ReloadCommand.java:125) ~[PlugManX.jar:?] at com.rylinaux.plugman.PlugManCommandHandler.onCommand(PlugManCommandHandler.java:97) ~[PlugManX.jar:?] at org.bukkit.command.PluginCommand.execute(PluginCommand.java:45) ~[purpur-api-1.20.1-R0.1-SNAPSHOT.jar:?] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168) ~[purpur-api-1.20.1-R0.1-SNAPSHOT.jar:?] at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchCommand(CraftServer.java:1021) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at org.bukkit.craftbukkit.v1_20_R1.CraftServer.dispatchServerCommand(CraftServer.java:984) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.dedicated.DedicatedServer.handleConsoleInputs(DedicatedServer.java:541) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.dedicated.DedicatedServer.tickChildren(DedicatedServer.java:488) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.MinecraftServer.tickServer(MinecraftServer.java:1421) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.MinecraftServer.runServer(MinecraftServer.java:1192) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at net.minecraft.server.MinecraftServer.lambda$spin$0(MinecraftServer.java:323) ~[purpur-1.20.1.jar:git-Purpur-"e2e2dbc"] at java.lang.Thread.run(Thread.java:1589) ~[?:?]

How to reproduce

  1. use mysql
  2. startup the server
  3. error occurs

Are you using mariadb or MySQL?

mysql

Then your MySQL is not using the required version specified for TNE usage. You'll need MySQL Server Version 8.0+.

creatorfromhell commented 11 months ago

@ClayCoffee Any updates on this situation? Did you upgrade your MySQL version?

ClayCoffee commented 11 months ago

@ClayCoffee Any updates on this situation? Did you upgrade your MySQL version?

Too much data, i can't upgrade it simply

creatorfromhell commented 11 months ago

@ClayCoffee Any updates on this situation? Did you upgrade your MySQL version?

Too much data, i can't upgrade it simply

Gotcha. As stated in the spigot/GitHub/paper page, TNE requires MySQL 8.0, which was initially released in 2018. You may use the YAML format until you upgrade to MySQL if you wish. Let me know if you need any assistance after you upgrade, if you do. Also worth noting is MySQL 5.X has reached end of life this year meaning that support won't be provided for it.

creatorfromhell commented 11 months ago

Reopening this, as I'll look at adding an outdated MySQL dialect with warnings attached at startup.

ClayCoffee commented 11 months ago

[12:09:32 WARN]: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (mc.tne_players_accounts, CONSTRAINT tne_players_accounts_ibfk_1 FOREIGN KEY (uid) REFERENCES tne_accounts (uid) ON DELETE CASCADE) [12:09:32 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) [12:09:32 WARN]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) [12:09:32 WARN]: at com.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:555) [12:09:32 WARN]: at com.mysql.cj.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:339) [12:09:32 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061) [12:09:32 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009) [12:09:32 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320) [12:09:32 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.connect.SQLConnector.executeUpdate(SQLConnector.java:135) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.store(SQLAccount.java:105) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.store(SQLAccount.java:51) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.StorageManager.lambda$store$0(StorageManager.java:160) [12:09:32 WARN]: at org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftTask.run(CraftTask.java:101) [12:09:32 WARN]: at org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57) [12:09:32 WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) [12:09:32 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) [12:09:32 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) [12:09:32 WARN]: at java.base/java.lang.Thread.run(Thread.java:1589)

？

ClayCoffee commented 11 months ago

Have you tested the plugin before?

ClayCoffee commented 11 months ago

Gold blocks in player's ender chest are gone, why?

creatorfromhell commented 11 months ago

Have you tested the plugin before?

Gold blocks in player's ender chest are gone, why?

Yes the plugin has been tested before, for months of private testing with users actually. Did you delete the old tables after updating?

Ender chests are included with balance checks so if you didn't convert from a previous economy plugin it's adjusting the balances, since I'm assuming their balance is zero and you probably have ender chest support enabled in the config.

Have you updated to MySQL 8.0 and did you delete the old tables before retrying since the table creation probably didn't finish before since the requirements weren't looked over?

ClayCoffee commented 11 months ago

Have you tested the plugin before?

Gold blocks in player's ender chest are gone, why?

Yes the plugin has been tested before, for months of private testing with users actually. Did you delete the old tables after updating?

Ender chests are included with balance checks so if you didn't convert from a previous economy plugin it's adjusting the balances, since I'm assuming their balance is zero and you probably have ender chest support enabled in the config.

Have you updated to MySQL 8.0 and did you delete the old tables before retrying since the table creation probably didn't finish before since the requirements weren't looked over?

yes

creatorfromhell commented 11 months ago

Have you tested the plugin before?

Gold blocks in player's ender chest are gone, why?

Yes the plugin has been tested before, for months of private testing with users actually. Did you delete the old tables after updating? Ender chests are included with balance checks so if you didn't convert from a previous economy plugin it's adjusting the balances, since I'm assuming their balance is zero and you probably have ender chest support enabled in the config. Have you updated to MySQL 8.0 and did you delete the old tables before retrying since the table creation probably didn't finish before since the requirements weren't looked over?

yes

This error is from a database issue, seems like the accounts tables were messed with and aren't in sync with the player accounts table. Which sounds like an update issue happened.

creatorfromhell commented 11 months ago

Have you tested the plugin before?

Gold blocks in player's ender chest are gone, why?

Yes the plugin has been tested before, for months of private testing with users actually. Did you delete the old tables after updating? Ender chests are included with balance checks so if you didn't convert from a previous economy plugin it's adjusting the balances, since I'm assuming their balance is zero and you probably have ender chest support enabled in the config. Have you updated to MySQL 8.0 and did you delete the old tables before retrying since the table creation probably didn't finish before since the requirements weren't looked over?

yes

Also, what was the server log as that is required for the format and wasn't provided with the new issue.

ClayCoffee commented 11 months ago

No error but the gold blocks in the ender chest are gone

creatorfromhell commented 11 months ago

No error but the gold blocks in the ender chest are gone

Yes that was answered above. If you didn't convert TNE is going to assume new account balances are 0 and set balances and items accordingly.

ClayCoffee commented 11 months ago

No error but the gold blocks in the ender chest are gone

Yes that was answered above. If you didn't convert TNE is going to assume new account balances are 0 and set balances and items accordingly.

i followed the instructions https://github.com/TheNewEconomy/EconomyCore/wiki/Converting-From-Pre-0.1.2.0-Builds

ClayCoffee commented 11 months ago

[12:09:32 WARN]: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (mc.tne_players_accounts, CONSTRAINT tne_players_accounts_ibfk_1 FOREIGN KEY (uid) REFERENCES tne_accounts (uid) ON DELETE CASCADE) [12:09:32 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) [12:09:32 WARN]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) [12:09:32 WARN]: at com.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:555) [12:09:32 WARN]: at com.mysql.cj.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:339) [12:09:32 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061) [12:09:32 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009) [12:09:32 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320) [12:09:32 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.connect.SQLConnector.executeUpdate(SQLConnector.java:135) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.store(SQLAccount.java:105) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.store(SQLAccount.java:51) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.StorageManager.lambda$store$0(StorageManager.java:160) [12:09:32 WARN]: at org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftTask.run(CraftTask.java:101) [12:09:32 WARN]: at org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57) [12:09:32 WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) [12:09:32 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) [12:09:32 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) [12:09:32 WARN]: at java.base/java.lang.Thread.run(Thread.java:1589)

？

so how to fix it

creatorfromhell commented 11 months ago

No error but the gold blocks in the ender chest are gone

Yes that was answered above. If you didn't convert TNE is going to assume new account balances are 0 and set balances and items accordingly.

i followed the instructions https://github.com/TheNewEconomy/EconomyCore/wiki/Converting-From-Pre-0.1.2.0-Builds

Did you run /TNE old after recreating the tables on MySQL 8?

creatorfromhell commented 11 months ago

[12:09:32 WARN]: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (mc.tne_players_accounts, CONSTRAINT tne_players_accounts_ibfk_1 FOREIGN KEY (uid) REFERENCES tne_accounts (uid) ON DELETE CASCADE) [12:09:32 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) [12:09:32 WARN]: at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) [12:09:32 WARN]: at com.mysql.cj.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:555) [12:09:32 WARN]: at com.mysql.cj.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:339) [12:09:32 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061) [12:09:32 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009) [12:09:32 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320) [12:09:32 WARN]: at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.libs.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.connect.SQLConnector.executeUpdate(SQLConnector.java:135) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.store(SQLAccount.java:105) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.datables.sql.standard.SQLAccount.store(SQLAccount.java:51) [12:09:32 WARN]: at TNE-Bukkit-0.1.2.0-Pre-22.jar//net.tnemc.core.io.storage.StorageManager.lambda$store$0(StorageManager.java:160) [12:09:32 WARN]: at org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftTask.run(CraftTask.java:101) [12:09:32 WARN]: at org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57) [12:09:32 WARN]: at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) [12:09:32 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) [12:09:32 WARN]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) [12:09:32 WARN]: at java.base/java.lang.Thread.run(Thread.java:1589) ？

so how to fix it

Try deleting the tables and letting them get recreated to see if there's any errors.

ClayCoffee commented 11 months ago

No error but the gold blocks in the ender chest are gone

Yes that was answered above. If you didn't convert TNE is going to assume new account balances are 0 and set balances and items accordingly.

i followed the instructions https://github.com/TheNewEconomy/EconomyCore/wiki/Converting-From-Pre-0.1.2.0-Builds

Did you run /TNE old after recreating the tables on MySQL 8?

yes

creatorfromhell commented 11 months ago

No error but the gold blocks in the ender chest are gone

Yes that was answered above. If you didn't convert TNE is going to assume new account balances are 0 and set balances and items accordingly.

i followed the instructions https://github.com/TheNewEconomy/EconomyCore/wiki/Converting-From-Pre-0.1.2.0-Builds

Did you run /TNE old after recreating the tables on MySQL 8?

yes

Did your last server have ender chest balances enabled?

ClayCoffee commented 11 months ago

No error but the gold blocks in the ender chest are gone

Yes that was answered above. If you didn't convert TNE is going to assume new account balances are 0 and set balances and items accordingly.

i followed the instructions https://github.com/TheNewEconomy/EconomyCore/wiki/Converting-From-Pre-0.1.2.0-Builds

Did you run /TNE old after recreating the tables on MySQL 8?

yes

Did your last server have ender chest balances enabled?

yes

creatorfromhell commented 11 months ago

No error but the gold blocks in the ender chest are gone

Yes that was answered above. If you didn't convert TNE is going to assume new account balances are 0 and set balances and items accordingly.

i followed the instructions https://github.com/TheNewEconomy/EconomyCore/wiki/Converting-From-Pre-0.1.2.0-Builds

Did you run /TNE old after recreating the tables on MySQL 8?

yes

Did your last server have ender chest balances enabled?

yes

Here's what I'll say, retry deleting the tables and letting them recreate then send a log of performing /TNE old with /TNE debug developer and also are the balances in extracted.yml correct?

ClayCoffee commented 11 months ago

No error but the gold blocks in the ender chest are gone

Yes that was answered above. If you didn't convert TNE is going to assume new account balances are 0 and set balances and items accordingly.

i followed the instructions https://github.com/TheNewEconomy/EconomyCore/wiki/Converting-From-Pre-0.1.2.0-Builds

Did you run /TNE old after recreating the tables on MySQL 8?

yes

Did your last server have ender chest balances enabled?

yes

Here's what I'll say, retry deleting the tables and letting them recreate then send a log of performing /TNE old and also are the balances in extracted.yml correct?

The balances were extracted when last time running the old version of TNE

creatorfromhell commented 11 months ago

No error but the gold blocks in the ender chest are gone

Yes that was answered above. If you didn't convert TNE is going to assume new account balances are 0 and set balances and items accordingly.

i followed the instructions https://github.com/TheNewEconomy/EconomyCore/wiki/Converting-From-Pre-0.1.2.0-Builds

Did you run /TNE old after recreating the tables on MySQL 8?

yes

Did your last server have ender chest balances enabled?

yes

Here's what I'll say, retry deleting the tables and letting them recreate then send a log of performing /TNE old and also are the balances in extracted.yml correct?

The balances were extracted when last time running the old version of TNE

That didn't answer any of the above. Checking if the extracted.yml balances are correct would mean looking inside the file.

ClayCoffee commented 11 months ago

https://pastebin.com/G7uSP7eP

creatorfromhell commented 11 months ago

https://pastebin.com/G7uSP7eP

Do those balances look correct?

creatorfromhell commented 11 months ago

https://pastebin.com/G7uSP7eP

Also, when you said gold blocks removed from ender chests, are they put in the inventory or?

ClayCoffee commented 11 months ago

https://pastebin.com/G7uSP7eP

Do those balances look correct?

No, the gold blocks in ender chest are not included in the balance But i enabled ender chest in the config in the old server

ClayCoffee commented 11 months ago

https://pastebin.com/G7uSP7eP

Also, when you said gold blocks removed from ender chests, are they put in the inventory or?

they are gone, just removed from the ender chest

creatorfromhell commented 11 months ago

https://pastebin.com/G7uSP7eP

Do those balances look correct?

No, the gold blocks in ender chest are not included in the balance But i enabled ender chest in the config in the old server

It sounds like it wasn't included. I would suggest disabling it on the new server.

The only alternative would be to wait for a new build to where I could include something for this situation such as not setting the item balance of new accounts on their first join. I wouldn't have time to do this until the weekend. Not a guarantee that there will be a solution for this, that works perfectly. At this point the solution that would work the best is to disable ender chest balances until players have moved over their gold. Then re enabling.

creatorfromhell commented 11 months ago

@ClayCoffee also, still need a full latest server log as this is required for the report format.

ClayCoffee commented 11 months ago

i have rolled back to the old version