Skellett MySQL Error

  • 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.

DieHollander_

Active Member
Mar 25, 2018
188
12
18
21
Netherlands
Hello everyone!
So I'm trying to use mysql on my server, but I found this bug...
Its a console error:
code_language.skript:
> [17:32:47 ERROR]: #!#!
> [17:32:47 ERROR]: #!#! [Skript] Severe Error:
> [17:32:47 ERROR]: #!#! Could not load mysql.sk
> [17:32:47 ERROR]: #!#!
> [17:32:47 ERROR]: #!#! Something went horribly wrong with Skript.
> [17:32:47 ERROR]: #!#! This issue is NOT your fault! You probably can't fix it yourself, either.
> [17:32:47 ERROR]: #!#! Your Minecraft version or server software appears to be unsupported by Skript (bensku's version).
> [17:32:47 ERROR]: #!#! Currently only supported servers are Spigot and its forks for Minecraft 1.9 or newer.
> [17:32:47 ERROR]: #!#! Other versions might work, but since you're getting this error message something is NOT working,
> [17:32:47 ERROR]: #!#! nor it will work, unless you switch to supported platform.
> [17:32:47 ERROR]: #!#! Issue tracker: https://github.com/SkriptLang/Skript/issues (only if you know what you're doing!)
> [17:32:47 ERROR]: #!#!
> [17:32:47 ERROR]: #!#! Stack trace:
> [17:32:47 ERROR]: #!#! ch.njol.skript.SkriptAPIException: No class info found for resultset
> [17:32:47 ERROR]: #!#! at ch.njol.skript.registrations.Classes.getClassInfo(Classes.java:263)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.createExprInfo(SkriptParser.java:1804)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.getExprInfo(SkriptParser.java:1771)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1519)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1492)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1531)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1465)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1465)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:225)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:180)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parseSingleExpr(SkriptParser.java:495)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parseExpression(SkriptParser.java:814)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1535)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1531)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:225)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:180)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.Statement.parse(Statement.java:59)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:972)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:662)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.ScriptLoader.lambda$1(ScriptLoader.java:389)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:401)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:434)
> [17:32:47 ERROR]: #!#! at ch.njol.skript.SkriptCommand.onCommand(SkriptCommand.java:181)
> [17:32:47 ERROR]: #!#! at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
> [17:32:47 ERROR]: #!#! at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
> [17:32:47 ERROR]: #!#! at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:641)
> [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.PlayerConnection.handleCommand(PlayerConnection.java:1162)
> [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.PlayerConnection.a(PlayerConnection.java:997)
> [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.PacketPlayInChat.a(PacketPlayInChat.java:45)
> [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.PacketPlayInChat.a(PacketPlayInChat.java:1)
> [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.PlayerConnectionUtils$1.run(SourceFile:13)
> [17:32:47 ERROR]: #!#! at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> [17:32:47 ERROR]: #!#! at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.SystemUtils.a(SourceFile:44)
> [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:715)
> [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374)
> [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)
> [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)
> [17:32:47 ERROR]: #!#! at java.lang.Thread.run(Thread.java:748)
> [17:32:47 ERROR]: #!#!
> [17:32:47 ERROR]: #!#! Version Information:
> [17:32:47 ERROR]: #!#! Skript: 2.2-dev36
> [17:32:47 ERROR]: #!#! Bukkit: 1.8.8-R0.1-SNAPSHOT
> [17:32:47 ERROR]: #!#! Minecraft: 1.8.8
> [17:32:47 ERROR]: #!#! Java: 1.8.0_181 (Java HotSpot(TM) 64-Bit Server VM 25.181-b13)
> [17:32:47 ERROR]: #!#! OS: Linux amd64 4.15.0-39-generic
> [17:32:47 ERROR]: #!#!
> [17:32:47 ERROR]: #!#! Server platform: Spigot
> [17:32:47 ERROR]: #!#!
> [17:32:47 ERROR]: #!#! Current node: set {_am::*} to mysql object "amount" in {_result} (mysql.sk, line 19)
> [17:32:47 ERROR]: #!#! Current item: null
> [17:32:47 ERROR]: #!#!
> [17:32:47 ERROR]: #!#! Thread: Server thread
> [17:32:47 ERROR]: #!#!
> [17:32:47 ERROR]: #!#! Language: english
> [17:32:47 ERROR]: #!#! Link parse mode: DISABLED
> [17:32:47 ERROR]: #!#!
> [17:32:47 ERROR]: #!#! End of Error.
> [17:32:47 ERROR]: #!#!

Skript code:
code_language.skript:
on load:
    set {_host} to "haha"
    set {_username} to "haha"
    set {_password} to "haha"
    set mysql host to {_host}
    set mysql username to {_username}
    set mysql password to {_password}
    set mysql database to "hahah"
    connect to mysql
    
on script load:
    mysql update "CREATE TABLE IF NOT EXISTS `coins` (`playeruuid` varchar(255), `playername` varchar(255), `amount` int(255))"

    
#default
on join:
    set {_result} to mysql result of query "SELECT * FROM coins WHERE `playeruuid` = '%player's uuid%'"
    set {_am::*} to mysql object "amount" in {_result}
    if {_am::1} is not set:
        mysql update "INSERT INTO `coins` (`playeruuid`, `playername`, `amount`) VALUES ('%player's uuid%', '%player%', '0')"
    mysql update "UPDATE coins SET `playername` = '%player%' WHERE playeruuid = '%player's uuid%'"
    


#set coins   
command /setcoins <player> <integer>:
    trigger:
        mysql update "UPDATE coins SET `amount` = '%arg-2%' WHERE playeruuid = '%arg-1's uuid%'"
        
#get coin amount       
command /getcoins <player>:
    trigger:
        set {_result} to mysql result of query "SELECT * FROM coins WHERE `playeruuid` = '%arg-1's uuid%'"
        set {_am::*} to mysql object "amount" in {_result}
        broadcast "%arg-1%, %{_am::1}%"
    
#remove from database
command /delcoins <player>:
    trigger:
        mysql update "DELETE FROM coins WHERE playeruuid = '%arg-1's uuid%'"

The reason I'm getting this error is because SkQuery and Skellett have the same syntaxes.
When I remove SkQuery everything works fine, but I kinda need SkQuery.
Hopefully someone can help me out!
[doublepost=1545607944,1545518195][/doublepost]Up
[doublepost=1545687826][/doublepost]Anyone?
 
Status
Not open for further replies.