Hi all,
simple mysql test command:
I also tried "mysql objects" and "mysql number" instead of mysql string. It throws a NPE when reloading this script.
What's wrong? Thank you!
simple mysql test command:
Code:
command /sqltest [<text>] [<text>] [<text>] [<text>] [<text>]:
trigger:
set {_p} to the player
set {_result} to mysql result of query "SELECT * FROM mytable WHERE `uuid` = '%uuid of {_p}%'"
# the following line will throw NPE in console...
set {_player::*} to mysql string "player" in {_result}
set {_name} to {_p}'s name
set {_uuid} to {_p}'s uuid
I also tried "mysql objects" and "mysql number" instead of mysql string. It throws a NPE when reloading this script.
[10:47:43] [Server thread/ERROR]: #!#! [Skript] Severe Error:
[10:47:43] [Server thread/ERROR]: #!#! Could not load test.sk
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Something went horribly wrong with Skript.
[10:47:43] [Server thread/ERROR]: #!#! This issue is NOT your fault! You probably can't fix it yourself, either.
[10:47:43] [Server thread/ERROR]: #!#! It looks like you are using some plugin(s) that alter how Skript works (addons).
[10:47:43] [Server thread/ERROR]: #!#! Here is full list of them:
[10:47:43] [Server thread/ERROR]: #!#! skRayFall (https://sk.rayfall.net/) TuSKe (github.com/Tuke-Nuke/TuSKe) SK-NBeeT (https://github.com/ShaneBeee/Sk-NBeeT) Tablisknu (tlatoani.us/tablisknu) Skellett (https://forums.skunity.com/resources/skellett-the-addon-with-a-beast-name.24/) skript-db skDragon skUtilities (https://tim740.github.io/) skript-yaml LyriaSK SkQuery
[10:47:43] [Server thread/ERROR]: #!#! We could not identify which of those are specially related, so this might also be Skript issue.
[10:47:43] [Server thread/ERROR]: #!#! You should try disabling those plugins one by one, trying to find which one causes it.
[10:47:43] [Server thread/ERROR]: #!#! If the error doesn't disappear even after disabling all listed plugins, it is probably Skript issue.
[10:47:43] [Server thread/ERROR]: #!#! In that case, you will be given instruction on how should you report it.
[10:47:43] [Server thread/ERROR]: #!#! On the other hand, if the error disappears when disabling some plugin, report it to author of that plugin.
[10:47:43] [Server thread/ERROR]: #!#! Only if the author tells you to do so, report it to Skript's issue tracker.
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Stack trace:
[10:47:43] [Server thread/ERROR]: #!#! ch.njol.skript.SkriptAPIException: No class info found for resultset
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.registrations.Classes.getClassInfo(Classes.java:263)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.createExprInfo(SkriptParser.java:1833)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.getExprInfo(SkriptParser.java:1800)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1548)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1521)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1560)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1494)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1494)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:224)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:179)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parseSingleExpr(SkriptParser.java:502)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parseExpression(SkriptParser.java:836)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1564)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1560)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:224)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:179)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.Statement.parse(Statement.java:59)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:1006)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.command.Commands.loadCommand(Commands.java:493)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:651)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.lambda$1(ScriptLoader.java:409)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:428)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:472)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.SkriptCommand.onCommand(SkriptCommand.java:182)
[10:47:43] [Server thread/ERROR]: #!#! at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
[10:47:43] [Server thread/ERROR]: #!#! at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:149)
[10:47:43] [Server thread/ERROR]: #!#! at org.bukkit.craftbukkit.v1_13_R2.CraftServer.dispatchCommand(CraftServer.java:732)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.PlayerConnection.handleCommand(PlayerConnection.java:1796)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.PlayerConnection.a(PlayerConnection.java:1604)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.PacketPlayInChat.a(PacketPlayInChat.java:45)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.PacketPlayInChat.a(PacketPlayInChat.java:5)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.PlayerConnectionUtils.lambda$ensureMainThread$0(PlayerConnectionUtils.java:13)
[10:47:43] [Server thread/ERROR]: #!#! at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[10:47:43] [Server thread/ERROR]: #!#! at java.util.concurrent.FutureTask.run(Unknown Source)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.SystemUtils.a(SystemUtils.java:108)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.MinecraftServer.b(MinecraftServer.java:1011)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.DedicatedServer.b(DedicatedServer.java:439)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.MinecraftServer.a(MinecraftServer.java:938)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.MinecraftServer.run(MinecraftServer.java:836)
[10:47:43] [Server thread/ERROR]: #!#! at java.lang.Thread.run(Unknown Source)
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Version Information:
[10:47:43] [Server thread/ERROR]: #!#! Skript: 2.3.5 (latest)
[10:47:43] [Server thread/ERROR]: #!#! Flavor: skriptlang-github
[10:47:43] [Server thread/ERROR]: #!#! Date: 2019-02-09
[10:47:43] [Server thread/ERROR]: #!#! Bukkit: 1.13.2-R0.1-SNAPSHOT
[10:47:43] [Server thread/ERROR]: #!#! Minecraft: 1.13.2
[10:47:43] [Server thread/ERROR]: #!#! Java: 1.8.0_121 (Java HotSpot(TM) 64-Bit Server VM 25.121-b13)
[10:47:43] [Server thread/ERROR]: #!#! OS: Windows 8.1 amd64 6.3
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Server platform: Paper
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Current node: set {_player::*} to mysql string "player" in {_result} (test.sk, line 27)
[10:47:43] [Server thread/ERROR]: #!#! Current item: null
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Thread: Server thread
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Language: english
[10:47:43] [Server thread/ERROR]: #!#! Link parse mode: STRICT
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! End of Error.
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Could not load test.sk
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Something went horribly wrong with Skript.
[10:47:43] [Server thread/ERROR]: #!#! This issue is NOT your fault! You probably can't fix it yourself, either.
[10:47:43] [Server thread/ERROR]: #!#! It looks like you are using some plugin(s) that alter how Skript works (addons).
[10:47:43] [Server thread/ERROR]: #!#! Here is full list of them:
[10:47:43] [Server thread/ERROR]: #!#! skRayFall (https://sk.rayfall.net/) TuSKe (github.com/Tuke-Nuke/TuSKe) SK-NBeeT (https://github.com/ShaneBeee/Sk-NBeeT) Tablisknu (tlatoani.us/tablisknu) Skellett (https://forums.skunity.com/resources/skellett-the-addon-with-a-beast-name.24/) skript-db skDragon skUtilities (https://tim740.github.io/) skript-yaml LyriaSK SkQuery
[10:47:43] [Server thread/ERROR]: #!#! We could not identify which of those are specially related, so this might also be Skript issue.
[10:47:43] [Server thread/ERROR]: #!#! You should try disabling those plugins one by one, trying to find which one causes it.
[10:47:43] [Server thread/ERROR]: #!#! If the error doesn't disappear even after disabling all listed plugins, it is probably Skript issue.
[10:47:43] [Server thread/ERROR]: #!#! In that case, you will be given instruction on how should you report it.
[10:47:43] [Server thread/ERROR]: #!#! On the other hand, if the error disappears when disabling some plugin, report it to author of that plugin.
[10:47:43] [Server thread/ERROR]: #!#! Only if the author tells you to do so, report it to Skript's issue tracker.
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Stack trace:
[10:47:43] [Server thread/ERROR]: #!#! ch.njol.skript.SkriptAPIException: No class info found for resultset
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.registrations.Classes.getClassInfo(Classes.java:263)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.createExprInfo(SkriptParser.java:1833)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.getExprInfo(SkriptParser.java:1800)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1548)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1521)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1560)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1494)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1494)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:224)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:179)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parseSingleExpr(SkriptParser.java:502)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parseExpression(SkriptParser.java:836)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1564)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1560)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:224)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:179)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.lang.Statement.parse(Statement.java:59)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:1006)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.command.Commands.loadCommand(Commands.java:493)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:651)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.lambda$1(ScriptLoader.java:409)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:428)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:472)
[10:47:43] [Server thread/ERROR]: #!#! at ch.njol.skript.SkriptCommand.onCommand(SkriptCommand.java:182)
[10:47:43] [Server thread/ERROR]: #!#! at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
[10:47:43] [Server thread/ERROR]: #!#! at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:149)
[10:47:43] [Server thread/ERROR]: #!#! at org.bukkit.craftbukkit.v1_13_R2.CraftServer.dispatchCommand(CraftServer.java:732)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.PlayerConnection.handleCommand(PlayerConnection.java:1796)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.PlayerConnection.a(PlayerConnection.java:1604)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.PacketPlayInChat.a(PacketPlayInChat.java:45)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.PacketPlayInChat.a(PacketPlayInChat.java:5)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.PlayerConnectionUtils.lambda$ensureMainThread$0(PlayerConnectionUtils.java:13)
[10:47:43] [Server thread/ERROR]: #!#! at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[10:47:43] [Server thread/ERROR]: #!#! at java.util.concurrent.FutureTask.run(Unknown Source)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.SystemUtils.a(SystemUtils.java:108)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.MinecraftServer.b(MinecraftServer.java:1011)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.DedicatedServer.b(DedicatedServer.java:439)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.MinecraftServer.a(MinecraftServer.java:938)
[10:47:43] [Server thread/ERROR]: #!#! at net.minecraft.server.v1_13_R2.MinecraftServer.run(MinecraftServer.java:836)
[10:47:43] [Server thread/ERROR]: #!#! at java.lang.Thread.run(Unknown Source)
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Version Information:
[10:47:43] [Server thread/ERROR]: #!#! Skript: 2.3.5 (latest)
[10:47:43] [Server thread/ERROR]: #!#! Flavor: skriptlang-github
[10:47:43] [Server thread/ERROR]: #!#! Date: 2019-02-09
[10:47:43] [Server thread/ERROR]: #!#! Bukkit: 1.13.2-R0.1-SNAPSHOT
[10:47:43] [Server thread/ERROR]: #!#! Minecraft: 1.13.2
[10:47:43] [Server thread/ERROR]: #!#! Java: 1.8.0_121 (Java HotSpot(TM) 64-Bit Server VM 25.121-b13)
[10:47:43] [Server thread/ERROR]: #!#! OS: Windows 8.1 amd64 6.3
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Server platform: Paper
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Current node: set {_player::*} to mysql string "player" in {_result} (test.sk, line 27)
[10:47:43] [Server thread/ERROR]: #!#! Current item: null
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Thread: Server thread
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! Language: english
[10:47:43] [Server thread/ERROR]: #!#! Link parse mode: STRICT
[10:47:43] [Server thread/ERROR]: #!#!
[10:47:43] [Server thread/ERROR]: #!#! End of Error.
[10:47:43] [Server thread/ERROR]: #!#!
What's wrong? Thank you!