CommandHelper

CommandHelper

46.5k Downloads

SQLException given when NULL is used in query

LadyCailinBot opened this issue ยท 1 comments

commented

CMDHELPER-2945 - Reported by kookster

run query('database','UPDATE all_info SET nickname=? WHERE username=?',null,'pl
ayer')
14:40:23 SQLException: Parameter metadata not available for the given statement
<

>:G:\Minecraft_World\plugins\CommandHelper\LocalPackages\Loc
alPackages Main\Main\commands.msa:1

14:40:23 The previous MethodScript error had an attached cause:
14:40:23 java.sql.SQLException: Parameter metadata not available for the given statement
14:40:23 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
14:40:23 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
14:40:23 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
14:40:23 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
14:40:23 at com.mysql.jdbc.MysqlParameterMetadata.checkAvailable(MysqlParameterMetadata.java:70)
14:40:23 at com.mysql.jdbc.MysqlParameterMetadata.isNullable(MysqlParameterMetadata.java:63)
14:40:23 at com.laytonsmith.core.functions.SQL$query.exec(SQL.java:106)
14:40:23 at com.laytonsmith.core.Script.eval(Script.java:352)
14:40:23 at com.laytonsmith.core.Script.seval(Script.java:239)
14:40:23 at com.laytonsmith.core.functions.DataHandling$eval.execs(DataHandling.java:3498)
14:40:23 at com.laytonsmith.core.Script.eval(Script.java:311)
14:40:23 at com.laytonsmith.core.functions.BasicLogic$ifelse.execs(BasicLogic.java:690)
14:40:23 at com.laytonsmith.core.Script.eval(Script.java:311)
14:40:23 at com.laytonsmith.core.MethodScriptCompiler.execute(MethodScriptCompiler.java:1842)
14:40:23 at com.laytonsmith.core.MethodScriptCompiler.execute(MethodScriptCompiler.java:1802)
14:40:23 at com.laytonsmith.core.Script.run(Script.java:193)
14:40:23 at com.laytonsmith.core.AliasCore.alias(AliasCore.java:166)
14:40:23 at com.laytonsmith.commandhelper.CommandHelperServerListener.onServerCommand(CommandHelperServerListener.java:41)
14:40:23 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:40:23 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
14:40:23 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
14:40:23 at java.lang.reflect.Method.invoke(Unknown Source)
14:40:23 at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:292)
14:40:23 at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
14:40:23 at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:47)
14:40:23 at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502)
14:40:23 at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487)
14:40:23 at net.minecraft.server.v1_7_R2.DedicatedServer.ax(DedicatedServer.java:305)
14:40:23 at net.minecraft.server.v1_7_R2.DedicatedServer.v(DedicatedServer.java:274)
14:40:23 at net.minecraft.server.v1_7_R2.MinecraftServer.u(MinecraftServer.java:566)
14:40:23 at net.minecraft.server.v1_7_R2.MinecraftServer.run(MinecraftServer.java:472)
14:40:23 at net.minecraft.server.v1_7_R2.ThreadServerApplication.run(SourceFile:618)

commented

Comment by LadyCailin

Fixed.