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

Charles

Member
Jan 26, 2017
48
2
0
25
San Diego, California
Skript Version: Skript (2.2-Fixes-V8b)
Skript Author: No idea
Minecraft Version: 1.7/1.8
---
Full Code: Paste: https://ironwolfmc.net/paste/view/696dbe14

code_language.skript:
on join:
    set {_uuid} to "%uuid of event-player%"
    set {_name} to "%event-player%"
    if event-player has permission "rank.sponsor" or "rank.premium" or "rank.vip" or "rank.twitch" or "rank.youtube" or "rank.mod" or "rank.srmod" or "rank.host" or "rank.srhost" or "rank.director" or "rank.admin":
        set {_result} to mysql result of query "SELECT * FROM Player WHERE uuid = '%{_uuid}%'"
        set {_chatColor::*} to mysql string "chatCholor" in {_result}
        loop {_chatColor::*}:
            set {_chatColor} to loop-value-1
        if {_chatColor} is contains "&":
            set {chatColor::%event-player%} to "%{_chatColor}%"
        else:
            set {chatColor::%event-player%} to "&f"
    else:
        set {chatColor::%event-player%} to "&f"
    if event-player has permission "rank.admin":
        set {chatGroup::%player%} to "&f[&4A&f] &c"
        set {group::%player%} to "Admin"
        set {_result} to mysql result of query "SELECT * FROM Player WHERE uuid = '%{_uuid}%'"
        set {_group::*} to mysql string "group" in {_result}
        loop {_group::*}:
            set {_group} to loop-value-1
        if {_group} is not "Admin":
            mysql update "UPDATE `Player` SET `group` = 'Admin' WHERE `uuid` = '%{_uuid}%'"
            mysql update "UPDATE `Player` SET `chatGroup` = '&f[&4A&f] &c' WHERE `uuid` = '%{_uuid}%'"
        stop trigger

on chat:
    cancel the event
    if {chatColor::%event-player%} is not set:
        set {chatColor::%event-player%} to "&f"
    broadcast "%{chatGroup::%event-player%}%%event-player%&f: %{chatColor::%event-player%}%%message%"

Errors on Reload: None

Console Errors: Paste: https://ironwolfmc.net/paste/view/f13a4922

code_language.skript:
25.04 15:15:04 [Multicraft] Skipped 17 lines due to rate limit (30/s)
25.04 15:15:02 [Server] ERROR #!#!     at net.minecraft.server.v1_7_R4.ThreadServerApplication.run(SourceFile:628)
25.04 15:15:02 [Server] ERROR #!#!     at net.minecraft.server.v1_7_R4.MinecraftServer.run(MinecraftServer.java:549)
25.04 15:15:02 [Server] ERROR #!#!     at net.minecraft.server.v1_7_R4.MinecraftServer.u(MinecraftServer.java:643)
25.04 15:15:02 [Server] ERROR #!#!     at net.minecraft.server.v1_7_R4.DedicatedServer.v(DedicatedServer.java:308)
25.04 15:15:02 [Server] ERROR #!#!     at net.minecraft.server.v1_7_R4.DedicatedServer.aB(DedicatedServer.java:344)
25.04 15:15:02 [Server] ERROR #!#!     at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchServerCommand(CraftServer.java:751)
25.04 15:15:02 [Server] ERROR #!#!     at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchCommand(CraftServer.java:765)
25.04 15:15:02 [Server] ERROR #!#!     at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:181)
25.04 15:15:02 [Server] ERROR #!#!     at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
25.04 15:15:02 [Server] ERROR #!#!     at ch.njol.skript.SkriptCommand.onCommand(SkriptCommand.java:154)
25.04 15:15:02 [Server] ERROR #!#!     at ch.njol.skript.ScriptLoader.unloadScript(ScriptLoader.java:603)
25.04 15:15:02 [Server] ERROR #!#!     at ch.njol.skript.ScriptLoader.unloadScript_(ScriptLoader.java:609)
25.04 15:15:02 [Server] ERROR #!#!     at ch.njol.skript.SkriptEventHandler.removeTriggers(SkriptEventHandler.java:237)
25.04 15:15:02 [Server] ERROR #!#!     at ch.njol.skript.lang.function.Functions.clearFunctions(Functions.java:193)
25.04 15:15:02 [Server] ERROR #!#! java.lang.NullPointerException
25.04 15:15:02 [Server] ERROR #!#! Stack trace:
25.04 15:15:02 [Server] ERROR #!#! 
25.04 15:15:02 [Server] ERROR #!#! By following this guide fixing the error should be easy and done fast.
25.04 15:15:02 [Server] ERROR #!#! If you think that it's a trigger that's causing the error please post the trigger as well.
25.04 15:15:02 [Server] ERROR #!#! and describe what you did before it happened and/or what you think caused the error.
25.04 15:15:02 [Server] ERROR #!#! If not please create a new ticket with a meaningful title, copy & paste this whole error into it,
25.04 15:15:02 [Server] ERROR #!#! and check whether this error has already been reported.
25.04 15:15:02 [Server] ERROR #!#! If you're a server admin however please go to http://dev.bukkit.org/server-mods/skript/tickets/
25.04 15:15:02 [Server] ERROR #!#! If you're developing an add-on for Skript this likely means that you have done something wrong.
25.04 15:15:02 [Server] ERROR #!#! 
25.04 15:15:02 [Server] ERROR #!#! Used command: /sk reload api/mysql
25.04 15:15:02 [Server] ERROR #!#! Exception occurred in Skript's main command
25.04 15:15:02 [Server] ERROR #!#! [Skript] Severe Error:
25.04 15:15:02 [Server] ERROR #!#! 
25.04 15:15:02 [Server] INFO Reloading mysql.sk...

Addons using (including versions):
SkQuery (3.21.4)
SkStuff (1.6.2)
skRayFall (1.8)
SQLibrary (7.1)
skUtilities (0.8.9)
skWhitelist (0.1.0)
Skellett (1.8.9)

Have you tried searching the docs? Yes
Have you tried searching the forums? Yes
What other methods have you tried to fix it? I've tried different methods, but they don't return or store the correct value. (Note that this is my first time working with Skellett's MySQL)
[doublepost=1493225303,1493148224][/doublepost]@LimeGlass do you know of a solution?
 
Skript Version: Skript (2.2-Fixes-V8b)
Skript Author: No idea
Minecraft Version: 1.7/1.8
---
Full Code: Paste: https://ironwolfmc.net/paste/view/696dbe14

code_language.skript:
on join:
    set {_uuid} to "%uuid of event-player%"
    set {_name} to "%event-player%"
    if event-player has permission "rank.sponsor" or "rank.premium" or "rank.vip" or "rank.twitch" or "rank.youtube" or "rank.mod" or "rank.srmod" or "rank.host" or "rank.srhost" or "rank.director" or "rank.admin":
        set {_result} to mysql result of query "SELECT * FROM Player WHERE uuid = '%{_uuid}%'"
        set {_chatColor::*} to mysql string "chatCholor" in {_result}
        loop {_chatColor::*}:
            set {_chatColor} to loop-value-1
        if {_chatColor} is contains "&":
            set {chatColor::%event-player%} to "%{_chatColor}%"
        else:
            set {chatColor::%event-player%} to "&f"
    else:
        set {chatColor::%event-player%} to "&f"
    if event-player has permission "rank.admin":
        set {chatGroup::%player%} to "&f[&4A&f] &c"
        set {group::%player%} to "Admin"
        set {_result} to mysql result of query "SELECT * FROM Player WHERE uuid = '%{_uuid}%'"
        set {_group::*} to mysql string "group" in {_result}
        loop {_group::*}:
            set {_group} to loop-value-1
        if {_group} is not "Admin":
            mysql update "UPDATE `Player` SET `group` = 'Admin' WHERE `uuid` = '%{_uuid}%'"
            mysql update "UPDATE `Player` SET `chatGroup` = '&f[&4A&f] &c' WHERE `uuid` = '%{_uuid}%'"
        stop trigger

on chat:
    cancel the event
    if {chatColor::%event-player%} is not set:
        set {chatColor::%event-player%} to "&f"
    broadcast "%{chatGroup::%event-player%}%%event-player%&f: %{chatColor::%event-player%}%%message%"

Errors on Reload: None

Console Errors: Paste: https://ironwolfmc.net/paste/view/f13a4922

code_language.skript:
25.04 15:15:04 [Multicraft] Skipped 17 lines due to rate limit (30/s)
25.04 15:15:02 [Server] ERROR #!#!     at net.minecraft.server.v1_7_R4.ThreadServerApplication.run(SourceFile:628)
25.04 15:15:02 [Server] ERROR #!#!     at net.minecraft.server.v1_7_R4.MinecraftServer.run(MinecraftServer.java:549)
25.04 15:15:02 [Server] ERROR #!#!     at net.minecraft.server.v1_7_R4.MinecraftServer.u(MinecraftServer.java:643)
25.04 15:15:02 [Server] ERROR #!#!     at net.minecraft.server.v1_7_R4.DedicatedServer.v(DedicatedServer.java:308)
25.04 15:15:02 [Server] ERROR #!#!     at net.minecraft.server.v1_7_R4.DedicatedServer.aB(DedicatedServer.java:344)
25.04 15:15:02 [Server] ERROR #!#!     at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchServerCommand(CraftServer.java:751)
25.04 15:15:02 [Server] ERROR #!#!     at org.bukkit.craftbukkit.v1_7_R4.CraftServer.dispatchCommand(CraftServer.java:765)
25.04 15:15:02 [Server] ERROR #!#!     at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:181)
25.04 15:15:02 [Server] ERROR #!#!     at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
25.04 15:15:02 [Server] ERROR #!#!     at ch.njol.skript.SkriptCommand.onCommand(SkriptCommand.java:154)
25.04 15:15:02 [Server] ERROR #!#!     at ch.njol.skript.ScriptLoader.unloadScript(ScriptLoader.java:603)
25.04 15:15:02 [Server] ERROR #!#!     at ch.njol.skript.ScriptLoader.unloadScript_(ScriptLoader.java:609)
25.04 15:15:02 [Server] ERROR #!#!     at ch.njol.skript.SkriptEventHandler.removeTriggers(SkriptEventHandler.java:237)
25.04 15:15:02 [Server] ERROR #!#!     at ch.njol.skript.lang.function.Functions.clearFunctions(Functions.java:193)
25.04 15:15:02 [Server] ERROR #!#! java.lang.NullPointerException
25.04 15:15:02 [Server] ERROR #!#! Stack trace:
25.04 15:15:02 [Server] ERROR #!#!
25.04 15:15:02 [Server] ERROR #!#! By following this guide fixing the error should be easy and done fast.
25.04 15:15:02 [Server] ERROR #!#! If you think that it's a trigger that's causing the error please post the trigger as well.
25.04 15:15:02 [Server] ERROR #!#! and describe what you did before it happened and/or what you think caused the error.
25.04 15:15:02 [Server] ERROR #!#! If not please create a new ticket with a meaningful title, copy & paste this whole error into it,
25.04 15:15:02 [Server] ERROR #!#! and check whether this error has already been reported.
25.04 15:15:02 [Server] ERROR #!#! If you're a server admin however please go to http://dev.bukkit.org/server-mods/skript/tickets/
25.04 15:15:02 [Server] ERROR #!#! If you're developing an add-on for Skript this likely means that you have done something wrong.
25.04 15:15:02 [Server] ERROR #!#!
25.04 15:15:02 [Server] ERROR #!#! Used command: /sk reload api/mysql
25.04 15:15:02 [Server] ERROR #!#! Exception occurred in Skript's main command
25.04 15:15:02 [Server] ERROR #!#! [Skript] Severe Error:
25.04 15:15:02 [Server] ERROR #!#!
25.04 15:15:02 [Server] INFO Reloading mysql.sk...

Addons using (including versions):
SkQuery (3.21.4)
SkStuff (1.6.2)
skRayFall (1.8)
SQLibrary (7.1)
skUtilities (0.8.9)
skWhitelist (0.1.0)
Skellett (1.8.9)

Have you tried searching the docs? Yes
Have you tried searching the forums? Yes
What other methods have you tried to fix it? I've tried different methods, but they don't return or store the correct value. (Note that this is my first time working with Skellett's MySQL)
[doublepost=1493225303,1493148224][/doublepost]@LimeGlass do you know of a solution?
The error is from a function. There is a bug where if something in a function is incorrect, such as a parameter isn't the correct type, or something in the function doesn't work, it will tell you in a skript error what that error is. Then after editing and reloading a few times, the error turns into a null pointer. I reported this to bensku and he said he fixed it. But it turns out he just broke functions in the newest dev-26 edit. He doesn't know why it happens or how to fix it.

Can you restart your server and send me the whole console log. The issue should be in there.
 
  • Like
Reactions: Charles
Fixed.

There were two errors.

1) I had some features enabled in Skellet that didn't support 1.7, so I just disabled everything that was 1.8+.
2) skQuery's MySQL system was buggy so I switched to Lime's edit of skQuery where he fixes the bug.
 
  • Like
Reactions: LimeGlass
Status
Not open for further replies.