Hello everyone!
So I'm trying to use mysql on my server, but I found this bug...
Its a console error:
Skript code:
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?
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?