Remote entities and MySQL problems?

Discussion in 'Plugin Development' started by ESSHD, Jan 25, 2015.

Thread Status:
Not open for further replies.
  1. Offline

    ESSHD

    I'm trying to make a tokens plugin that actually works cross server, and it does work, but my addTokens method doesn't work, and RemoteEntities says the class I need to make an NPC with interact behaviors cannot be found.

    Remote entities stack trace:
    Code:
    [20:57:44 ERROR]: Error occurred while enabling MLFTokens v1.0 (Is it up to date
    ?)
    java.lang.NoClassDefFoundError: de/kumpelblase2/remoteentities/RemoteEntities
            at me.majorleaguefactions.Tokens.onEnable(Tokens.java:31) ~[?:?]
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316) ~[c
    raftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
    .java:332) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
    r.java:412) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at org.bukkit.craftbukkit.v1_7_R4.CraftServer.loadPlugin(CraftServer.jav
    a:476) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at org.bukkit.craftbukkit.v1_7_R4.CraftServer.enablePlugins(CraftServer.
    java:394) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at org.bukkit.craftbukkit.v1_7_R4.CraftServer.reload(CraftServer.java:86
    6) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at org.bukkit.Bukkit.reload(Bukkit.java:301) [craftbukkit.jar:git-Spigot
    -1.7.9-R0.2-207-g03373bb]
            at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:
    23) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:18
    1) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchCommand(CraftServe
    r.java:767) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchServerCommand(Craf
    tServer.java:753) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at net.minecraft.server.v1_7_R4.DedicatedServer.aB(DedicatedServer.java:
    326) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at net.minecraft.server.v1_7_R4.DedicatedServer.v(DedicatedServer.java:2
    90) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at net.minecraft.server.v1_7_R4.MinecraftServer.u(MinecraftServer.java:5
    84) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at net.minecraft.server.v1_7_R4.MinecraftServer.run(MinecraftServer.java
    :490) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at net.minecraft.server.v1_7_R4.ThreadServerApplication.run(SourceFile:6
    28) [craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
    Caused by: java.lang.ClassNotFoundException: de.kumpelblase2.remoteentities.Remo
    teEntities
            at java.net.URLClassLoader$1.run(Unknown Source) ~[?:1.8.0_31]
            at java.net.URLClassLoader$1.run(Unknown Source) ~[?:1.8.0_31]
            at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_
    31]
            at java.net.URLClassLoader.findClass(Unknown Source) ~[?:1.8.0_31]
            at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.
    java:101) ~[craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.
    java:86) ~[craftbukkit.jar:git-Spigot-1.7.9-R0.2-207-g03373bb]
            at java.lang.ClassLoader.loadClass(Unknown Source) ~[?:1.8.0_31]
            at java.lang.ClassLoader.loadClass(Unknown Source) ~[?:1.8.0_31]
            ... 17 more
    and here's the error when I try add tokens to a player:
    Code:
    [20:59:39 INFO]: ESSPlaysMC issued server command: /addtokens ESSPlaysMC 1
    [20:59:39 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unkn
    own column 'c0748ae5-8a18-4f1a-b017-bf65c4fdd847' in 'where clause'
    [20:59:39 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    [20:59:39 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (Unknown Source)
    [20:59:39 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(Unknown Source)
    [20:59:39 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Sou
    rce)
    [20:59:39 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    [20:59:39 WARN]:        at com.mysql.jdbc.Util.getInstance(Util.java:382)
    [20:59:39 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:1052)
    [20:59:39 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3593)
    [20:59:39 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3525)
    [20:59:39 WARN]:        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    
    [20:59:39 WARN]:        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
    40)
    [20:59:39 WARN]:        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2626)
    [20:59:39 WARN]:        at com.mysql.jdbc.PreparedStatement.executeInternal(Prep
    aredStatement.java:2111)
    [20:59:39 WARN]:        at com.mysql.jdbc.PreparedStatement.executeUpdate(Prepar
    edStatement.java:2407)
    [20:59:39 WARN]:        at com.mysql.jdbc.PreparedStatement.executeUpdate(Prepar
    edStatement.java:2325)
    [20:59:39 WARN]:        at com.mysql.jdbc.PreparedStatement.executeUpdate(Prepar
    edStatement.java:2310)
    [20:59:39 WARN]:        at me.majorleaguefactions.MySQL.addTokens(MySQL.java:52)
    
    [20:59:39 WARN]:        at me.majorleaguefactions.Tokens.onCommand(Tokens.java:9
    8)
    [20:59:39 WARN]:        at org.bukkit.command.PluginCommand.execute(PluginComman
    d.java:44)
    [20:59:39 WARN]:        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCo
    mmandMap.java:181)
    [20:59:39 WARN]:        at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchCo
    mmand(CraftServer.java:767)
    [20:59:39 WARN]:        at net.minecraft.server.v1_7_R4.PlayerConnection.handleC
    ommand(PlayerConnection.java:1043)
    [20:59:39 WARN]:        at net.minecraft.server.v1_7_R4.PlayerConnection.a(Playe
    rConnection.java:880)
    [20:59:39 WARN]:        at net.minecraft.server.v1_7_R4.PacketPlayInChat.a(Packe
    tPlayInChat.java:28)
    [20:59:39 WARN]:        at net.minecraft.server.v1_7_R4.PacketPlayInChat.handle(
    PacketPlayInChat.java:65)
    [20:59:39 WARN]:        at net.minecraft.server.v1_7_R4.NetworkManager.a(Network
    Manager.java:186)
    [20:59:39 WARN]:        at net.minecraft.server.v1_7_R4.ServerConnection.c(Serve
    rConnection.java:81)
    [20:59:39 WARN]:        at net.minecraft.server.v1_7_R4.MinecraftServer.v(Minecr
    aftServer.java:734)
    [20:59:39 WARN]:        at net.minecraft.server.v1_7_R4.DedicatedServer.v(Dedica
    tedServer.java:289)
    [20:59:39 WARN]:        at net.minecraft.server.v1_7_R4.MinecraftServer.u(Minecr
    aftServer.java:584)
    [20:59:39 WARN]:        at net.minecraft.server.v1_7_R4.MinecraftServer.run(Mine
    craftServer.java:490)
    [20:59:39 WARN]:        at net.minecraft.server.v1_7_R4.ThreadServerApplication.
    run(SourceFile:628)
    And this is my MySQL code:
    Code:
     public void addTokens(Player p, Integer amount) {
              try {
              PreparedStatement statement = connection.prepareStatement("UPDATE `razedhub`.`tokens` SET `balance` = `balance` + account WHERE `tokens`.`uuid`=`" + p.getUniqueId() + "`");
              statement.executeUpdate();
              statement.close();
              } catch (Exception e) {
              e.printStackTrace();
      }
      }
    What am I doing wrong!??
     
  2. Offline

    InfamousSheep

    Code:
    [20:59:39 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'c0748ae5-8a18-4f1a-b017-bf65c4fdd847' in 'where clause'
    
    That's your problem ^
    It can't find the column to update it.
     
  3. Offline

    Lolmewn

    Suggestion: Use Prepared statements and lose all the quotes.
     
  4. Offline

    ESSHD

  5. Offline

    InfamousSheep

    Code:
    PreparedStatement statement = connection.prepareStatement("UPDATE razedhub.tokens SET balance = ? WHERE tokens.uuid = ?;");
    statement.setInt(1, balance + account);
    statement.setString(2, p.getUniqueID());
    
    Also, just realised; you didn't end the query with a semi-colon.
     
  6. Offline

    Lolmewn

    @InfamousSheep Not actually required when it's only one query, it seems to do just fine without it :) It's probably better to do it though, yeah.
     
Thread Status:
Not open for further replies.

Share This Page