Skellett mysql issue: console error? help?

  • Welcome to skUnity!

    Welcome to skUnity! This is a forum where members of the Skript community can communicate and interact. Skript Resource Creators can post their Resources for all to see and use.

    If you haven't done so already, feel free to join our official Discord server to expand your level of interaction with the comminuty!

    Now, what are you waiting for? Join the community now!

  • LOOKING FOR A VERSION OF SKRIPT?

    You can always check out skUnity Downloads for downloads and any other information about Skript!

Status
Not open for further replies.

pepper82

Member
Jan 26, 2017
272
1
18
41
Hi all,
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]: #!#!


What's wrong? Thank you!
 
But isn't the syntax I posted from skellett and not skquery?
[doublepost=1550082306,1550064157][/doublepost]
Uhhm, I'm not sure. But skquery also has a mysql feature that uses the same syntax as skellet, so yea

hey @DieHollander_ when do you think you have the chance to send me the working skquery?
 
Status
Not open for further replies.