Solved MYSQL Error, help me please

[jomjonejame]

Skript Version (do not put latest): Skript 2.2 (dev33)
Skript Author: Bensku
Minecraft Version: 1.8.8
---
Full Code:

script options:
    $ db url jdbc:mysql://localhost:3306/????
    $ db username ????
    $ db password ????
    
options:
    f_level: 1
    f_minEXP: 0
    f_maxEXP: 100
    f_str: 1
    f_agi: 1
    f_dex: 1
    f_point: 1
    
function getStatus(p:player):
    set {_Level::*} to objects in column "level" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
    set {_minEXP::*} to objects in column "minEXP" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
    set {_maxEXP::*} to objects in column "maxEXP" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
    set {_STR::*} to objects in column "str" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
    set {_AGI::*} to objects in column "agi" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
    set {_DEX::*} to objects in column "dex" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
    set {_point::*} to objects in column "point" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"

    send " Level: %{_Level::*}% ( EXP: %{_minEXP::*}%/%{_maxEXP::*}% )" to {_p}
    send " STR: %{_STR::*}%" to {_p}
    send " AGI: %{_AGI::*}%" to {_p}
    send " DEX: %{_DEX::*}%" to {_p}
    send " Status Point: %{_point::*}%" to {_p}
        
function LevelUP(p:player):
    set {_Level::*} to objects in column "level" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
    set {_minEXP::*} to objects in column "minEXP" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
    set {_maxEXP::*} to objects in column "maxEXP" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%{_p}%'"
    set {_min} to "%{_minEXP::*}%" parsed as integer
    set {_max} to "%{_maxEXP::*}%" parsed as integer
    
    if {_Level::*} <= 10:
        set {_nextEXP} to 1000
    else if {_Level::*} <= 50:
        set {_nextEXP} to 5000
    else if {_Level::*} <= 99:
        set {_nextEXP} to 10000
        
    if {_min} >= {_max}:
        update "UPDATE `mc_user_status` SET `level`= `level`+1,`maxEXP`=`maxEXP`+'%{_nextEXP}%',`point`=`point`+1 WHERE `username` = '%{_p}%'"
        send {_p} title "Level UP!"
    
function setEXP(p:player):
    update "UPDATE `mc_user_status` SET `minEXP`=`minEXP`+10 WHERE `username` = '%{_p}%'"
    LevelUP({_p})
    
on join:
    set {_Username::*} to objects in column "username" from result of query "SELECT * FROM `mc_user_status` WHERE `username` = '%player%'"
    if {_Username::*} is not set:
        send "%{_Username::*}%"
        update "INSERT INTO `mc_user_status` (`username`, `level`, `minEXP`, `maxEXP`, `str`, `agi`, `dex`, `point`) VALUES ('%player%','{@f_level}','{@f_minEXP}','{@f_maxEXP}','{@f_str}','{@f_agi}','{@f_dex}','{@f_point}')"
command /level:
    trigger:
        getStatus(player)

on death:
    setEXP(attacker)

Errors on Reload:

reload is successfuilly

Console Errors: (if applicable)

[12:35:31] [Server thread/WARN]: java.sql.SQLException: Operation not allowed after ResultSet closed
[12:35:31] [Server thread/WARN]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
[12:35:31] [Server thread/WARN]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
[12:35:31] [Server thread/WARN]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
[12:35:31] [Server thread/WARN]:     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
[12:35:31] [Server thread/WARN]:     at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:794)
[12:35:31] [Server thread/WARN]:     at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7145)
[12:35:31] [Server thread/WARN]:     at com.w00tmast3r.skquery.elements.expressions.ExprSQLQueryObjects.get(ExprSQLQueryObjects.java:33)
[12:35:31] [Server thread/WARN]:     at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:104)
[12:35:31] [Server thread/WARN]:     at ch.njol.skript.effects.EffChange.execute(EffChange.java:268)
[12:35:31] [Server thread/WARN]:     at ch.njol.skript.lang.Effect.run(Effect.java:52)
[12:35:31] [Server thread/WARN]:     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:61)
[12:35:31] [Server thread/WARN]:     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:89)
[12:35:31] [Server thread/WARN]:     at ch.njol.skript.lang.Trigger.execute(Trigger.java:55)
[12:35:31] [Server thread/WARN]:     at ch.njol.skript.SkriptEventHandler.check(SkriptEventHandler.java:151)
[12:35:31] [Server thread/WARN]:     at ch.njol.skript.SkriptEventHandler$1.execute(SkriptEventHandler.java:109)
[12:35:31] [Server thread/WARN]:     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
[12:35:31] [Server thread/WARN]:     at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502)
[12:35:31] [Server thread/WARN]:     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487)
[12:35:31] [Server thread/WARN]:     at net.minecraft.server.v1_8_R3.PlayerList.onPlayerJoin(PlayerList.java:298)
[12:35:31] [Server thread/WARN]:     at net.minecraft.server.v1_8_R3.PlayerList.a(PlayerList.java:157)
[12:35:31] [Server thread/WARN]:     at net.minecraft.server.v1_8_R3.LoginListener.b(LoginListener.java:144)
[12:35:31] [Server thread/WARN]:     at net.minecraft.server.v1_8_R3.LoginListener.c(LoginListener.java:54)
[12:35:31] [Server thread/WARN]:     at net.minecraft.server.v1_8_R3.NetworkManager.a(NetworkManager.java:231)
[12:35:31] [Server thread/WARN]:     at net.minecraft.server.v1_8_R3.ServerConnection.c(ServerConnection.java:148)
[12:35:31] [Server thread/WARN]:     at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:814)
[12:35:31] [Server thread/WARN]:     at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:374)
[12:35:31] [Server thread/WARN]:     at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)
[12:35:31] [Server thread/WARN]:     at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)
[12:35:31] [Server thread/WARN]:     at java.lang.Thread.run(Unknown Source)

Addons using (including versions):
Skellett 1.9.6b
SkQuery 3.6.0-Lime
skRayFall+v1.9.12
Skript dev33
SkStuff
WildSkript 1.7-1.8

 

[GandalfDev]

Hello there,
I think theres an error on your resultset can you check if your mysql querys is working?

 

[jomjonejame]

Hello there,
I think theres an error on your resultset can you check if your mysql querys is working?

MySQL is working on skript 2.2 by Njol

before error i'm used skript 2.2 by Njol
but now i'm using skript 2.2 by bensku and error as seen
[doublepost=1528209378,1528113204][/doublepost]before error:
skript 2.2 by Njol
SkQuery 3.21.4 author: w00tmast3r

but now:
skript 2.2 by bensku
SkQuery 3.6.0-Lime

 

[Pikachu]

use skript-db, not skquery. skquery is unsafe

 

[jomjonejame]

use skript-db, not skquery. skquery is unsafe

Thank you so much
[doublepost=1528255442,1528253731][/doublepost]how to select data where username ?

command /db:
    trigger:
        execute "SELECT * FROM authme WHERE username=%player%" in {sql} and store the result in {_result::*}
        send "%{_result::realname::*}%"

i'm try, but value is <none>


but uuid is work

execute "SELECT * FROM authme WHERE uuid=%uuid of player%" in {sql} and store the result in {_result::*}