[MISC] InventorySQL - (copy) Player inventory on MySQL table [BukkitDev]

Discussion in 'Archived: Plugin Releases' started by ThisIsAreku, Jul 14, 2011.

  1. Offline

    chopstick121

    Does is plugin save inventory when ppl logout and this wont let ppl lost there items?
     
  2. Offline

    digitalfiz

    Having this backup issue below. I tried tracing the issue down in the code on github but I have no experience with java so I just got lost lol

    Code:
    2012-08-29 14:13:42 [SEVERE] [InventorySQL] ---------------------------------------
    2012-08-29 14:13:42 [SEVERE] [InventorySQL] --- an unexpected error has occured ---
    2012-08-29 14:13:42 [SEVERE] [InventorySQL] -- please send line below to the dev --
    2012-08-29 14:13:42 [SEVERE] [InventorySQL] InventorySQL version 2.1.8
    2012-08-29 14:13:42 [SEVERE] [InventorySQL] Bukkit version git-Bukkit-1.3.1-R2.0-b2340jnks (MC: 1.3.1)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL] Message: Cannot do backup
    2012-08-29 14:13:42 [SEVERE] [InventorySQL] SQLState: 42S22
    2012-08-29 14:13:42 [SEVERE] [InventorySQL] Error Code: 1054
    2012-08-29 14:13:42 [SEVERE] [InventorySQL] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'inventories.date' in 'where clause' : Unknown column 'inventories.date' in 'where clause'
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    com.mysql.jdbc.Util.getInstance(Util.java:382)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    fr.areku.InventorySQL.database.SQLBackup.run(SQLBackup.java:91)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL]    java.lang.Thread.run(Thread.java:722)
    2012-08-29 14:13:42 [SEVERE] [InventorySQL] ---------------------------------------
     
  3. Update to v. 2.1.10, it's fixed :)
     
  4. Offline

    MariukasR

    Please plugin on CraftBukkit 1.4.2-R0.2 THANKS :)))
     
  5. It works on CB 1.4.2, but if the item has a name set by an anvil, this data is ignored, because the bukkit api is not ready
     
  6. Offline

    MariukasR

    But I keep getting an error that can not connect to the database, while the database work for about 2 years .. And I write my user password for the user and even tried to 127.0.01 IP with port and without port and another to record egsistuojančią database, maybe even what plugins need this stuff into action?
     
  7. Offline

    firewalled

    Is it right there's still no new webinterface, but only to the old 1.x version or so?
     
  8. Offline

    DevManABCD

    Code:
    [11:05:19] [Server thread/INFO]: [InvSQL][DEBUG] Your Problem was caused by: MySQLDatabaseHandler(connection=com.mysql.jdbc.JDBC4Connection@3d64e73d, q=tk.manf.InventorySQL.database.handler.MySQLDatabaseHandler$Queries@2b897548)
    [11:05:19] [Server thread/INFO]: null
    tk.manf.InventorySQL.datahandling.exceptions.SerializationException: Error while serializing: [Parsing Error]
        at tk.manf.InventorySQL.datahandling.serializer.SimpleSerializer.deserializeItemStacks(SimpleSerializer.java:47) ~[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_40]
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.7.0_40]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.7.0_40]
        at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.7.0_40]
        at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:292) [minecraft_server2.jar:git-Spigot-1387]
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) [minecraft_server2.jar:git-Spigot-1387]
        at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) [minecraft_server2.jar:git-Spigot-1387]
        at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502) [minecraft_server2.jar:git-Spigot-1387]
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487) [minecraft_server2.jar:git-Spigot-1387]
        at net.minecraft.server.v1_7_R2.PlayerList.c(PlayerList.java:249) [minecraft_server2.jar:git-Spigot-1387]
        at net.minecraft.server.v1_7_R2.PlayerList.a(PlayerList.java:135) [minecraft_server2.jar:git-Spigot-1387]
        at net.minecraft.server.v1_7_R2.LoginListener.c(LoginListener.java:97) [minecraft_server2.jar:git-Spigot-1387]
        at net.minecraft.server.v1_7_R2.LoginListener.a(LoginListener.java:42) [minecraft_server2.jar:git-Spigot-1387]
        at net.minecraft.server.v1_7_R2.NetworkManager.a(NetworkManager.java:151) [minecraft_server2.jar:git-Spigot-1387]
        at net.minecraft.server.v1_7_R2.ServerConnection.c(ServerConnection.java:77) [minecraft_server2.jar:git-Spigot-1387]
        at net.minecraft.server.v1_7_R2.MinecraftServer.v(MinecraftServer.java:705) [minecraft_server2.jar:git-Spigot-1387]
        at net.minecraft.server.v1_7_R2.DedicatedServer.v(DedicatedServer.java:273) [minecraft_server2.jar:git-Spigot-1387]
        at net.minecraft.server.v1_7_R2.MinecraftServer.u(MinecraftServer.java:568) [minecraft_server2.jar:git-Spigot-1387]
        at net.minecraft.server.v1_7_R2.MinecraftServer.run(MinecraftServer.java:474) [minecraft_server2.jar:git-Spigot-1387]
        at net.minecraft.server.v1_7_R2.ThreadServerApplication.run(SourceFile:618) [minecraft_server2.jar:git-Spigot-1387]
    Caused by: org.json.simple.parser.ParseException
        at org.json.simple.parser.Yylex.yylex(Yylex.java:610) ~[minecraft_server2.jar:git-Spigot-1387]
        at org.json.simple.parser.JSONParser.nextToken(JSONParser.java:269) ~[minecraft_server2.jar:git-Spigot-1387]
        at org.json.simple.parser.JSONParser.parse(JSONParser.java:118) ~[minecraft_server2.jar:git-Spigot-1387]
        at org.json.simple.parser.JSONParser.parse(JSONParser.java:81) ~[minecraft_server2.jar:git-Spigot-1387]
        at org.json.simple.parser.JSONParser.parse(JSONParser.java:75) ~[minecraft_server2.jar:git-Spigot-1387]
        at org.json.simple.JSONValue.parseWithException(JSONValue.java:78) ~[minecraft_server2.jar:git-Spigot-1387]
        at tk.manf.InventorySQL.datahandling.serializer.SimpleSerializer.deserializeItemStacks(SimpleSerializer.java:45) ~[InventorySQL.3.4.7.jar:?]
        ... 24 more

    When player joins server.
     

Share This Page