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.

MYSQL SKRIPT ERROR PLEASE HELP

Discussion in 'Skript' started by daniel81, Feb 21, 2020.

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

    daniel81 New Member

    Joined:
    Feb 21, 2020
    Messages:
    5
    Likes Received:
    0
    Code (Text):
    1. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    2. 21.02 15:05:12 [Server] Server thread/ERROR #!#! [Skript] Severe Error:
    3. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Could not load dbgeneration.sk
    4. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    5. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Something went horribly wrong with Skript.
    6. 21.02 15:05:12 [Server] Server thread/ERROR #!#! This issue is NOT your fault! You probably can't fix it yourself, either.
    7. 21.02 15:05:12 [Server] Server thread/ERROR #!#! It looks like you are using some plugin(s) that alter how Skript works (addons).
    8. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Here is full list of them:
    9. 21.02 15:05:12 [Server] Server thread/ERROR #!#! SkQuery
    10. 21.02 15:05:12 [Server] Server thread/ERROR #!#! We could not identify which of those are specially related, so this might also be Skript issue.
    11. 21.02 15:05:12 [Server] Server thread/ERROR #!#! You should try disabling those plugins one by one, trying to find which one causes it.
    12. 21.02 15:05:12 [Server] Server thread/ERROR #!#! If the error doesn't disappear even after disabling all listed plugins, it is probably Skript issue.
    13. 21.02 15:05:12 [Server] Server thread/ERROR #!#! In that case, you will be given instruction on how should you report it.
    14. 21.02 15:05:12 [Server] Server thread/ERROR #!#! On the other hand, if the error disappears when disabling some plugin, report it to author of that plugin.
    15. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Only if the author tells you to do so, report it to Skript's issue tracker.
    16. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    17. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Stack trace:
    18. 21.02 15:05:12 [Server] Server thread/ERROR #!#! java.lang.NullPointerException
    19. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at com.w00tmast3r.skquery.sql.ScriptCredentials.get(ScriptCredentials.java:50)
    20. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at com.w00tmast3r.skquery.sql.ScriptCredentials.get(ScriptCredentials.java:43)
    21. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at com.w00tmast3r.skquery.sql.ScriptCredentials.setURL(ScriptCredentials.java:17)
    22. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at com.w00tmast3r.skquery.elements.effects.EffOptionSQLURL.register(EffOptionSQLURL.java:21)
    23. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at com.w00tmast3r.skquery.elements.effects.base.Pragma.init(Pragma.java:24)
    24. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at com.w00tmast3r.skquery.elements.effects.base.OptionsPragma.init(OptionsPragma.java:18)
    25. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:252)
    26. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:179)
    27. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.lang.Statement.parse(Statement.java:59)
    28. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:1006)
    29. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:693)
    30. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.ScriptLoader.lambda$1(ScriptLoader.java:409)
    31. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:428)
    32. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.ScriptLoader.lambda$0(ScriptLoader.java:347)
    33. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:380)
    34. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.Skript.reloadScripts(Skript.java:926)
    35. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.SkriptCommand.onCommand(SkriptCommand.java:160)
    36. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at org.bukkit.command.PluginCommand.execute(PluginCommand.java:45)
    37. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:149)
    38. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at org.bukkit.craftbukkit.v1_14_R1.CraftServer.dispatchCommand(CraftServer.java:710)
    39. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.PlayerConnection.handleCommand(PlayerConnection.java:1641)
    40. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.PlayerConnection.a(PlayerConnection.java:1481)
    41. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.PacketPlayInChat.a(PacketPlayInChat.java:47)
    42. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.PacketPlayInChat.a(PacketPlayInChat.java:1)
    43. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.PlayerConnectionUtils.lambda$0(PlayerConnectionUtils.java:19)
    44. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.TickTask.run(SourceFile:18)
    45. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.IAsyncTaskHandler.executeTask(SourceFile:144)
    46. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.IAsyncTaskHandlerReentrant.executeTask(SourceFile:23)
    47. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.IAsyncTaskHandler.executeNext(SourceFile:118)
    48. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.MinecraftServer.aX(MinecraftServer.java:909)
    49. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.MinecraftServer.executeNext(MinecraftServer.java:902)
    50. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.IAsyncTaskHandler.executeAll(SourceFile:103)
    51. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.MinecraftServer.sleepForTick(MinecraftServer.java:885)
    52. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.MinecraftServer.run(MinecraftServer.java:819)
    53. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at java.lang.Thread.run(Thread.java:748)
    54. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    55. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Version Information:
    56. 21.02 15:05:12 [Server] Server thread/ERROR #!#!   Skript: 2.4.1 (latest)
    57. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     Flavor: skriptlang-github
    58. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     Date: 2019-12-22
    59. 21.02 15:05:12 [Server] Server thread/ERROR #!#!   Bukkit: 1.14.4-R0.1-SNAPSHOT
    60. 21.02 15:05:12 [Server] Server thread/ERROR #!#!   Minecraft: 1.14.4
    61. 21.02 15:05:12 [Server] Server thread/ERROR #!#!   Java: 1.8.0_222 (OpenJDK 64-Bit Server VM 25.222-b10)
    62. 21.02 15:05:12 [Server] Server thread/ERROR #!#!   OS: Linux amd64 3.10.0-1062.1.2.el7.x86_64
    63. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    64. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Server platform: Spigot
    65. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    66. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Current node: $ db url jdbc:url (dbgeneration.sk, line 3)
    67. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Current item: null
    68. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    69. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Thread: Server thread
    70. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    71. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Language: english
    72. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Link parse mode: DISABLED
    73. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    74. 21.02 15:05:12 [Server] Server thread/ERROR #!#! End of Error.
    75. 21.02 15:05:12 [Server] Server thread/ERROR #!#! 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    76. 21.02 15:05:12 [Server] Server thread/ERROR #!#! [Skript] Severe Error:
    77. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Could not load dbgeneration.sk
    78. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    79. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Something went horribly wrong with Skript.
    80. 21.02 15:05:12 [Server] Server thread/ERROR #!#! This issue is NOT your fault! You probably can't fix it yourself, either.
    81. 21.02 15:05:12 [Server] Server thread/ERROR #!#! It looks like you are using some plugin(s) that alter how Skript works (addons).
    82. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Here is full list of them:
    83. 21.02 15:05:12 [Server] Server thread/ERROR #!#! SkQuery
    84. 21.02 15:05:12 [Server] Server thread/ERROR #!#! We could not identify which of those are specially related, so this might also be Skript issue.
    85. 21.02 15:05:12 [Server] Server thread/ERROR #!#! You should try disabling those plugins one by one, trying to find which one causes it.
    86. 21.02 15:05:12 [Server] Server thread/ERROR #!#! If the error doesn't disappear even after disabling all listed plugins, it is probably Skript issue.
    87. 21.02 15:05:12 [Server] Server thread/ERROR #!#! In that case, you will be given instruction on how should you report it.
    88. 21.02 15:05:12 [Server] Server thread/ERROR #!#! On the other hand, if the error disappears when disabling some plugin, report it to author of that plugin.
    89. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Only if the author tells you to do so, report it to Skript's issue tracker.
    90. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    91. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Stack trace:
    92. 21.02 15:05:12 [Server] Server thread/ERROR #!#! java.lang.NullPointerException
    93. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at com.w00tmast3r.skquery.sql.ScriptCredentials.get(ScriptCredentials.java:50)
    94. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at com.w00tmast3r.skquery.sql.ScriptCredentials.get(ScriptCredentials.java:43)
    95. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at com.w00tmast3r.skquery.sql.ScriptCredentials.setURL(ScriptCredentials.java:17)
    96. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at com.w00tmast3r.skquery.elements.effects.EffOptionSQLURL.register(EffOptionSQLURL.java:21)
    97. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at com.w00tmast3r.skquery.elements.effects.base.Pragma.init(Pragma.java:24)
    98. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at com.w00tmast3r.skquery.elements.effects.base.OptionsPragma.init(OptionsPragma.java:18)
    99. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:252)
    100. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:179)
    101. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.lang.Statement.parse(Statement.java:59)
    102. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:1006)
    103. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:693)
    104. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.ScriptLoader.lambda$1(ScriptLoader.java:409)
    105. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:428)
    106. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.ScriptLoader.lambda$0(ScriptLoader.java:347)
    107. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:380)
    108. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.Skript.reloadScripts(Skript.java:926)
    109. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at ch.njol.skript.SkriptCommand.onCommand(SkriptCommand.java:160)
    110. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at org.bukkit.command.PluginCommand.execute(PluginCommand.java:45)
    111. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:149)
    112. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at org.bukkit.craftbukkit.v1_14_R1.CraftServer.dispatchCommand(CraftServer.java:710)
    113. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.PlayerConnection.handleCommand(PlayerConnection.java:1641)
    114. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.PlayerConnection.a(PlayerConnection.java:1481)
    115. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.PacketPlayInChat.a(PacketPlayInChat.java:47)
    116. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.PacketPlayInChat.a(PacketPlayInChat.java:1)
    117. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.PlayerConnectionUtils.lambda$0(PlayerConnectionUtils.java:19)
    118. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.TickTask.run(SourceFile:18)
    119. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.IAsyncTaskHandler.executeTask(SourceFile:144)
    120. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.IAsyncTaskHandlerReentrant.executeTask(SourceFile:23)
    121. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.IAsyncTaskHandler.executeNext(SourceFile:118)
    122. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.MinecraftServer.aX(MinecraftServer.java:909)
    123. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.MinecraftServer.executeNext(MinecraftServer.java:902)
    124. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.IAsyncTaskHandler.executeAll(SourceFile:103)
    125. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.MinecraftServer.sleepForTick(MinecraftServer.java:885)
    126. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at net.minecraft.server.v1_14_R1.MinecraftServer.run(MinecraftServer.java:819)
    127. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     at java.lang.Thread.run(Thread.java:748)
    128. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    129. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Version Information:
    130. 21.02 15:05:12 [Server] Server thread/ERROR #!#!   Skript: 2.4.1 (latest)
    131. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     Flavor: skriptlang-github
    132. 21.02 15:05:12 [Server] Server thread/ERROR #!#!     Date: 2019-12-22
    133. 21.02 15:05:12 [Server] Server thread/ERROR #!#!   Bukkit: 1.14.4-R0.1-SNAPSHOT
    134. 21.02 15:05:12 [Server] Server thread/ERROR #!#!   Minecraft: 1.14.4
    135. 21.02 15:05:12 [Server] Server thread/ERROR #!#!   Java: 1.8.0_222 (OpenJDK 64-Bit Server VM 25.222-b10)
    136. 21.02 15:05:12 [Server] Server thread/ERROR #!#!   OS: Linux amd64 3.10.0-1062.1.2.el7.x86_64
    137. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    138. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Server platform: Spigot
    139. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    140. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Current node: $ db url jdbc:url (dbgeneration.sk, line 3)
    141. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Current item: null
    142. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    143. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Thread: Server thread
    144. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    145. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Language: english
    146. 21.02 15:05:12 [Server] Server thread/ERROR #!#! Link parse mode: DISABLED
    147. 21.02 15:05:12 [Server] Server thread/ERROR #!#!
    148. 21.02 15:05:12 [Server] Server thread/ERROR #!#! End of Error.
    149. 21.02 15:05:12 [Server] Server thread/ERROR #!#!


    This is the error that i get.

    I have installed: Skript, SkQuery and SQLLibrary


    and 1 skript:

    Code (Text):
    1. script options:
    2.     $ init com.mysql.jdbc.Driver
    3.     $ db url jbdc:url
    4.     $ db username name
    5.     $ db password pass
    6.  
    7. on load:
    8.     update "CREATE TABLE IF NOT EXISTS Stats(uuid varchar(100), deaths int)"
    9.    

    PLEASE NOTE:

    DATABASE CREDENTIALS ARE LIKE THIS ON PURPOSE, IN MY CONFIG ARE RIGHT.


    any ideas?
     
  2. Goose

    Supporter

    Joined:
    Nov 23, 2019
    Messages:
    427
    Likes Received:
    30
    This has nothing to do with MySQL, this justs means there is something wrong with your SkQuery plugin. Try reinstalling it, you can get the latest version here
     
  3. daniel81

    daniel81 New Member

    Joined:
    Feb 21, 2020
    Messages:
    5
    Likes Received:
    0
    already did
     
  4. Goose

    Supporter

    Joined:
    Nov 23, 2019
    Messages:
    427
    Likes Received:
    30
    What version is your server?
     
  5. daniel81

    daniel81 New Member

    Joined:
    Feb 21, 2020
    Messages:
    5
    Likes Received:
    0
    1.14.4
     
  6. Goose

    Supporter

    Joined:
    Nov 23, 2019
    Messages:
    427
    Likes Received:
    30
    That might be the problem, I gave you the download link for SkQuery-Lime 1.15.2. You can get all downloads of SkQuery-Lime here
     
  7. daniel81

    daniel81 New Member

    Joined:
    Feb 21, 2020
    Messages:
    5
    Likes Received:
    0
    i already have that version
     
  8. TPGamesNL

    Supporter Addon Developer Dev Programme

    Joined:
    Jan 20, 2018
    Messages:
    1,500
    Likes Received:
    102
    Medals:
    Your SkQuery version is fine, but the error shows that there is something wrong with the url effect:
    So make sure your URL is right (for example $ db url jdbc:mysql://HOST:3306/DATABASE)
     
  9. daniel81

    daniel81 New Member

    Joined:
    Feb 21, 2020
    Messages:
    5
    Likes Received:
    0
    it is
     
  10. TPGamesNL

    Supporter Addon Developer Dev Programme

    Joined:
    Jan 20, 2018
    Messages:
    1,500
    Likes Received:
    102
    Medals:
    Try using skript-db
     
Thread Status:
Not open for further replies.

Share This Page

Loading...