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 out 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 Error

Discussion in 'Skript' started by DieHollander_, Dec 22, 2018.

Thread Status:
Not open for further replies.
  1. DieHollander_

    DieHollander_ Active Member

    Joined:
    Mar 25, 2018
    Messages:
    188
    Likes Received:
    12
    Hello everyone!
    So I'm trying to use mysql on my server, but I found this bug...
    Its a console error:
    Code (Skript):
    1. > [17:32:47 ERROR]: #!#!
    2. > [17:32:47 ERROR]: #!#! [Skript] Severe Error:
    3. > [17:32:47 ERROR]: #!#! Could not load mysql.sk
    4. > [17:32:47 ERROR]: #!#!
    5. > [17:32:47 ERROR]: #!#! Something went horribly wrong with Skript.
    6. > [17:32:47 ERROR]: #!#! This issue is NOT your fault! You probably can't fix it yourself, either.
    7. > [17:32:47 ERROR]: #!#! Your Minecraft version or server software appears to be unsupported by Skript (bensku's version).
    8. > [17:32:47 ERROR]: #!#! Currently only supported servers are Spigot and its forks for Minecraft 1.9 or newer.
    9. > [17:32:47 ERROR]: #!#! Other versions might work, but since you're getting this error message something is NOT working,
    10. > [17:32:47 ERROR]: #!#! nor it will work, unless you switch to supported platform.
    11. > [17:32:47 ERROR]: #!#! Issue tracker: https://github.com/SkriptLang/Skript/issues (only if you know what you're doing!)
    12. > [17:32:47 ERROR]: #!#!
    13. > [17:32:47 ERROR]: #!#! Stack trace:
    14. > [17:32:47 ERROR]: #!#! ch.njol.skript.SkriptAPIException: No class info found for resultset
    15. > [17:32:47 ERROR]: #!#! at ch.njol.skript.registrations.Classes.getClassInfo(Classes.java:263)
    16. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.createExprInfo(SkriptParser.java:1804)
    17. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.getExprInfo(SkriptParser.java:1771)
    18. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1519)
    19. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1492)
    20. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1531)
    21. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1465)
    22. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1465)
    23. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:225)
    24. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:180)
    25. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parseSingleExpr(SkriptParser.java:495)
    26. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parseExpression(SkriptParser.java:814)
    27. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1535)
    28. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse_i(SkriptParser.java:1531)
    29. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:225)
    30. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:180)
    31. > [17:32:47 ERROR]: #!#! at ch.njol.skript.lang.Statement.parse(Statement.java:59)
    32. > [17:32:47 ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:972)
    33. > [17:32:47 ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:662)
    34. > [17:32:47 ERROR]: #!#! at ch.njol.skript.ScriptLoader.lambda$1(ScriptLoader.java:389)
    35. > [17:32:47 ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:401)
    36. > [17:32:47 ERROR]: #!#! at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:434)
    37. > [17:32:47 ERROR]: #!#! at ch.njol.skript.SkriptCommand.onCommand(SkriptCommand.java:181)
    38. > [17:32:47 ERROR]: #!#! at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
    39. > [17:32:47 ERROR]: #!#! at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
    40. > [17:32:47 ERROR]: #!#! at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:641)
    41. > [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.PlayerConnection.handleCommand(PlayerConnection.java:1162)
    42. > [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.PlayerConnection.a(PlayerConnection.java:997)
    43. > [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.PacketPlayInChat.a(PacketPlayInChat.java:45)
    44. > [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.PacketPlayInChat.a(PacketPlayInChat.java:1)
    45. > [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.PlayerConnectionUtils$1.run(SourceFile:13)
    46. > [17:32:47 ERROR]: #!#! at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    47. > [17:32:47 ERROR]: #!#! at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    48. > [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.SystemUtils.a(SourceFile:44)
    49. > [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:715)
    50. > [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374)
    51. > [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)
    52. > [17:32:47 ERROR]: #!#! at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)
    53. > [17:32:47 ERROR]: #!#! at java.lang.Thread.run(Thread.java:748)
    54. > [17:32:47 ERROR]: #!#!
    55. > [17:32:47 ERROR]: #!#! Version Information:
    56. > [17:32:47 ERROR]: #!#! Skript: 2.2-dev36
    57. > [17:32:47 ERROR]: #!#! Bukkit: 1.8.8-R0.1-SNAPSHOT
    58. > [17:32:47 ERROR]: #!#! Minecraft: 1.8.8
    59. > [17:32:47 ERROR]: #!#! Java: 1.8.0_181 (Java HotSpot(TM) 64-Bit Server VM 25.181-b13)
    60. > [17:32:47 ERROR]: #!#! OS: Linux amd64 4.15.0-39-generic
    61. > [17:32:47 ERROR]: #!#!
    62. > [17:32:47 ERROR]: #!#! Server platform: Spigot
    63. > [17:32:47 ERROR]: #!#!
    64. > [17:32:47 ERROR]: #!#! Current node: set {_am::*} to mysql object "amount" in {_result} (mysql.sk, line 19)
    65. > [17:32:47 ERROR]: #!#! Current item: null
    66. > [17:32:47 ERROR]: #!#!
    67. > [17:32:47 ERROR]: #!#! Thread: Server thread
    68. > [17:32:47 ERROR]: #!#!
    69. > [17:32:47 ERROR]: #!#! Language: english
    70. > [17:32:47 ERROR]: #!#! Link parse mode: DISABLED
    71. > [17:32:47 ERROR]: #!#!
    72. > [17:32:47 ERROR]: #!#! End of Error.
    73. > [17:32:47 ERROR]: #!#!
    Skript code:
    Code (Skript):
    1.  
    2. on load:
    3.     set {_host} to "haha"
    4.     set {_username} to "haha"
    5.     set {_password} to "haha"
    6.     set mysql host to {_host}
    7.     set mysql username to {_username}
    8.     set mysql password to {_password}
    9.     set mysql database to "hahah"
    10.     connect to mysql
    11.    
    12. on script load:
    13.     mysql update "CREATE TABLE IF NOT EXISTS `coins` (`playeruuid` varchar(255), `playername` varchar(255), `amount` int(255))"
    14.  
    15.    
    16. #default
    17. on join:
    18.     set {_result} to mysql result of query "SELECT * FROM coins WHERE `playeruuid` = '%player's uuid%'"
    19.     set {_am::*} to mysql object "amount" in {_result}
    20.     if {_am::1} is not set:
    21.         mysql update "INSERT INTO `coins` (`playeruuid`, `playername`, `amount`) VALUES ('%player's uuid%', '%player%', '0')"
    22.     mysql update "UPDATE coins SET `playername` = '%player%' WHERE playeruuid = '%player's uuid%'"
    23.    
    24.  
    25.  
    26. #set coins  
    27. command /setcoins <player> <integer>:
    28.     trigger:
    29.         mysql update "UPDATE coins SET `amount` = '%arg-2%' WHERE playeruuid = '%arg-1's uuid%'"
    30.        
    31. #get coin amount      
    32. command /getcoins <player>:
    33.     trigger:
    34.         set {_result} to mysql result of query "SELECT * FROM coins WHERE `playeruuid` = '%arg-1's uuid%'"
    35.         set {_am::*} to mysql object "amount" in {_result}
    36.         broadcast "%arg-1%, %{_am::1}%"
    37.    
    38. #remove from database
    39. command /delcoins <player>:
    40.     trigger:
    41.         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!
    --- Double Post Merged, Dec 23, 2018, Original Post Date: Dec 22, 2018 ---
    Up
    --- Double Post Merged, Dec 24, 2018 ---
    Anyone?
     
  2. Kiip

    Kiip New Member

    Joined:
    Jan 21, 2019
    Messages:
    8
    Likes Received:
    1
    Edit your Skellett syntaxes in your Skellett folder
     
  3. DieHollander_

    DieHollander_ Active Member

    Joined:
    Mar 25, 2018
    Messages:
    188
    Likes Received:
    12
    Thank u for replying after 1 month, btw, the mysql syntaxes aren't in the file
     
Thread Status:
Not open for further replies.

Share This Page

Loading...