This site works best with JavaScript enabled. Please enable JavaScript to get the best experience from this site.
What steps will reproduce the problem?1. Pick some Item (Dirt) with Amount 2, quit from server after saving the inventory2. Edit the InventorySetting with a Webpage to Amount 123. Join the Server an the editet Data will not load
What is the expected output? What do you see instead?I want to Use this Plugin with the CB 1.7.9 (Beta -release) and to make a small webshop.The Inventory was safed into de MySqlDatabase.I can change the data with gzdecode -> json_decode -> edit the array -> json_encode -> gzencode -> save in the MySqlDatabase.Now i join back to my server an the inventory wasnt updatet ingame. afeter 1 Minute gameserver override the inventorydata in the database.
What version of the product are you using?3.4.6 and 3.4.7
Do you have an error log of what happened?Sry not.
Please provide any additional information below.
I hope i make all right this is my first ticket and my english are not realy good, german where better.
Best reguards
[02:42:54] [Server thread/INFO]: Starting minecraft server version 1.7.9 [02:42:54] [Server thread/INFO]: Loading properties [02:42:54] [Server thread/INFO]: Default game type: SURVIVAL [02:42:54] [Server thread/INFO]: Generating keypair [02:42:54] [Server thread/INFO]: Starting Minecraft server on *:25565 [02:42:54] [Server thread/INFO]: This server is running CraftBukkit version git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks (MC: 1.7.9) (Implementing API version 1.7.9-R0.2) [02:42:54] [Server thread/INFO]: [InvSQL] Loading InventorySQL v3.4.0 [02:42:54] [Server thread/INFO]: Preparing level "world" [02:42:54] [Server thread/INFO]: Preparing start region for level 0 (Seed: 8799377420992978274) [02:42:54] [Thread-7/INFO]: ----- Bukkit Auto Updater ----- [02:42:54] [Thread-7/INFO]: It appears that you're running a Beta Build, when you've specified in bukkit.yml that you prefer to run Recommended Builds. [02:42:54] [Thread-7/INFO]: If you would like to be kept informed about new Beta Build releases, it is recommended that you change 'preferred-channel' in your bukkit.yml to 'beta'. [02:42:54] [Thread-7/INFO]: With that set, you will be told whenever a new version is available for download, so that you can always keep up to date and secure with the latest fixes. [02:42:54] [Thread-7/INFO]: If you would like to disable this warning, simply set 'suggest-channels' to false in bukkit.yml [02:42:54] [Thread-7/INFO]: ----- ------------------- ----- [02:42:55] [Server thread/INFO]: Preparing start region for level 1 (Seed: 8799377420992978274) [02:42:55] [Server thread/INFO]: Preparing start region for level 2 (Seed: 8799377420992978274) [02:42:55] [Server thread/INFO]: [InvSQL] Enabling InventorySQL v3.4.0 [02:42:56] [Server thread/INFO]: null com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'food -- -----------------------------------------------------
-- ALTER TABLE `i' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.7.0_60] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.7.0_60] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[?:1.7.0_60] at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[?:1.7.0_60] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) ~[craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at com.mysql.jdbc.Util.getInstance(Util.java:382) ~[craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) ~[craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) ~[craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) ~[craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) ~[craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) ~[craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620) ~[craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570) ~[craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779) ~[craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622) ~[craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at tk.manf.InventorySQL.database.handler.MySQLDatabaseHandler.init(MySQLDatabaseHandler.java:71) ~[InventorySQL.3.4.7.jar] at tk.manf.InventorySQL.manager.DatabaseManager.reload(DatabaseManager.java:63) ~[InventorySQL.3.4.7.jar] at tk.manf.InventorySQL.manager.DependenciesManager.checkDatabaseHandler(DependenciesManager.java:79) [InventorySQL.3.4.7.jar] at tk.manf.InventorySQL.manager.DependenciesManager.initialise(DependenciesManager.java:54) [InventorySQL.3.4.7.jar] at tk.manf.InventorySQL.InventorySQLPlugin.onEnable(InventorySQLPlugin.java:59) [InventorySQL.3.4.7.jar] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:324) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at org.bukkit.craftbukkit.v1_7_R3.CraftServer.loadPlugin(CraftServer.java:446) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at org.bukkit.craftbukkit.v1_7_R3.CraftServer.enablePlugins(CraftServer.java:380) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.MinecraftServer.n(MinecraftServer.java:352) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.MinecraftServer.g(MinecraftServer.java:326) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.MinecraftServer.a(MinecraftServer.java:282) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.DedicatedServer.init(DedicatedServer.java:182) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:436) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] [02:42:57] [Server thread/INFO]: [InvSQL][DEBUG] [Developer Message from manf] Thanks for supporting us and using Metrics :) [02:42:57] [Server thread/INFO]: Done (2,699s)! For help, type "help" or "?" [02:43:12] [User Authenticator #1/INFO]: UUID of player ZockerDelta is xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx [02:43:12] [Server thread/INFO]: ZockerDelta[/xxx.xxx.xxx.xx:xxxxx] logged in with entity id 101 at ([world] 34.29575729850255, 72.0, -232.9826522082229) [02:43:21] [Server thread/INFO]: ZockerDelta lost connection: Disconnected [02:43:21] [Server thread/INFO]: ZockerDelta left the game. [02:44:10] [User Authenticator #2/INFO]: UUID of player ZockerDelta is xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx [02:44:10] [Server thread/INFO]: [InvSQL][DEBUG] Your Problem was caused by: MySQLDatabaseHandler(connection=com.mysql.jdbc.JDBC4Connection@26c8d64, q=tk.manf.InventorySQL.database.handler.MySQLDatabaseHandler$Queries@24b6a17a) [02:44:10] [Server thread/INFO]: null java.lang.ClassCastException java.lang.String cannot be cast to java.lang.Integer at org.bukkit.inventory.ItemStack.deserialize(ItemStack.java:525) ~[craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at tk.manf.InventorySQL.datahandling.serializer.SimpleSerializer.deserial(SimpleSerializer.java:72) ~[InventorySQL.3.4.7.jar] at tk.manf.InventorySQL.datahandling.serializer.SimpleSerializer.deserializeItemStacks(SimpleSerializer.java:45) ~[InventorySQL.3.4.7.jar] at tk.manf.InventorySQL.manager.DataHandlingManager.deserial(DataHandlingManager.java:58) ~[InventorySQL.3.4.7.jar] at tk.manf.InventorySQL.database.handler.MySQLDatabaseHandler.loadPlayerInventory(MySQLDatabaseHandler.java:107) ~[InventorySQL.3.4.7.jar] at tk.manf.InventorySQL.manager.DatabaseManager.loadPlayer(DatabaseManager.java:90) ~[InventorySQL.3.4.7.jar] at tk.manf.InventorySQL.manager.DatabaseManager.onPlayerLogin(DatabaseManager.java:99) [InventorySQL.3.4.7.jar] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_60] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.7.0_60] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.7.0_60] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.7.0_60] at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:292) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:501) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:486) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.PlayerList.c(PlayerList.java:251) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.PlayerList.a(PlayerList.java:138) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.LoginListener.c(LoginListener.java:76) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.LoginListener.a(LoginListener.java:42) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.NetworkManager.a(NetworkManager.java:160) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.ServerConnection.c(SourceFile:134) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.MinecraftServer.v(MinecraftServer.java:667) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.DedicatedServer.v(DedicatedServer.java:260) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.MinecraftServer.u(MinecraftServer.java:558) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:469) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628) [craftbukkit-1.7.9-R0.2.jar:git-Bukkit-1.7.9-R0.1-10-g8688bd4-b3092jnks] [02:44:10] [Server thread/INFO]: ZockerDelta[/xxx.xxx.xxx.xxx:xxxxx] logged in with entity id 2596 at ([world] 45.56978121983773, 72.0, -240.65782973473813) [02:44:23] [Server thread/INFO]: ZockerDelta lost connection: Disconnected [02:44:23] [Server thread/INFO]: ZockerDelta left the game.
To post a comment, please login or register a new account.