1. 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!

  2. LOOKING FOR A VERSION OF SKRIPT??:

    You can always check our our Wiki for downloads and any other information about Skript!

Dismiss Notice
This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Skellett mysql issue: console error? help?

Discussion in 'Skript' started by pepper82, Feb 13, 2019.

  1. pepper82

    pepper82 Member

    Joined:
    Jan 26, 2017
    Messages:
    227
    Likes Received:
    1
    Hi all,
    simple mysql test command:

    Code (Text):
    1. command /sqltest [<text>] [<text>] [<text>] [<text>] [<text>]:
    2.     trigger:
    3.         set {_p} to the player
    4.         set {_result} to mysql result of query "SELECT * FROM mytable WHERE `uuid` = '%uuid of {_p}%'"
    5.         # the following line will throw NPE in console...
    6.         set {_player::*} to mysql string "player" in {_result}
    7.         set {_name} to {_p}'s name
    8.         set {_uuid} to {_p}'s uuid
    9.  
    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!
     
  2. DieHollander_

    DieHollander_ Well-Known Member

    Joined:
    Mar 25, 2018
    Messages:
    165
    Likes Received:
    12
    Its because of skquery, I'll send you a modified version of skquery when im able to
     
  3. pepper82

    pepper82 Member

    Joined:
    Jan 26, 2017
    Messages:
    227
    Likes Received:
    1
    Oh, so SkQuery is broken atm?

    I have version
    SkQuery v3.6.2-Lime
     
  4. DieHollander_

    DieHollander_ Well-Known Member

    Joined:
    Mar 25, 2018
    Messages:
    165
    Likes Received:
    12
    Uhhm, I'm not sure. But skquery also has a mysql feature that uses the same syntax as skellet, so yea
     
  5. pepper82

    pepper82 Member

    Joined:
    Jan 26, 2017
    Messages:
    227
    Likes Received:
    1
    But isn't the syntax I posted from skellett and not skquery?
    --- Double Post Merged, Feb 13, 2019, Original Post Date: Feb 13, 2019 ---
    hey @DieHollander_ when do you think you have the chance to send me the working skquery?
     
Loading...