MySQL - CLOSE

  • 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.
Nikd0

Nikd0

Active Member
May 30, 2020
208
21
18
Czech Republic
Skript version: 2.5.1 (MC version 1.13.2)

Full code:
Code: 
script options:
    $ init com.mysql.jdbc.Driver
    $ db url jdbc:mysql://****
    $ db username ****
    $ db password ****

command /test <text>:
    trigger:
        set {_result::*} to objects in column "coins" from result of query "SELECT coins FROM mytable WHERE player = '%arg-1%'" and close
        set {_msg} to "%{_result::*}%"
        send "%{_msg}%"
Console error (no reload errors):
Code: 
[20:57:04 WARN]: java.sql.SQLException: Operation not allowed after ResultSet closed
[20:57:04 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
[20:57:04 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
[20:57:04 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
[20:57:04 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
[20:57:04 WARN]: at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:743)
[20:57:04 WARN]: at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6289)
[20:57:04 WARN]: at com.w00tmast3r.skquery.elements.expressions.ExprSQLQueryObjects.get(ExprSQLQueryObjects.java:34)
[20:57:04 WARN]: at ch.njol.skript.lang.util.SimpleExpression.getAll(SimpleExpression.java:74)
[20:57:04 WARN]: at ch.njol.skript.lang.ExpressionList.getAll(ExpressionList.java:115)
[20:57:04 WARN]: at ch.njol.skript.lang.ExpressionList.getArray(ExpressionList.java:98)
[20:57:04 WARN]: at ch.njol.skript.effects.EffChange.execute(EffChange.java:276)
[20:57:04 WARN]: at ch.njol.skript.lang.Effect.run(Effect.java:51)
[20:57:04 WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:60)
[20:57:04 WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:88)
[20:57:04 WARN]: at ch.njol.skript.lang.Trigger.execute(Trigger.java:56)
[20:57:04 WARN]: at ch.njol.skript.lang.function.ScriptFunction.execute(ScriptFunction.java:89)
[20:57:04 WARN]: at ch.njol.skript.lang.function.Function.execute(Function.java:135)
[20:57:04 WARN]: at ch.njol.skript.lang.function.FunctionReference.execute(FunctionReference.java:265)
[20:57:04 WARN]: at ch.njol.skript.lang.function.ExprFunctionCall.get(ExprFunctionCall.java:43)
[20:57:04 WARN]: at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:100)
[20:57:04 WARN]: at ch.njol.skript.effects.EffChange.execute(EffChange.java:276)
[20:57:04 WARN]: at ch.njol.skript.lang.Effect.run(Effect.java:51)
[20:57:04 WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:60)
[20:57:04 WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:88)
[20:57:04 WARN]: at ch.njol.skript.lang.Trigger.execute(Trigger.java:56)
[20:57:04 WARN]: at ch.njol.skript.command.ScriptCommand.execute2(ScriptCommand.java:291)
[20:57:04 WARN]: at ch.njol.skript.command.ScriptCommand.execute(ScriptCommand.java:250)
[20:57:04 WARN]: at ch.njol.skript.command.Commands.handleCommand(Commands.java:248)
[20:57:04 WARN]: at ch.njol.skript.command.Commands$1.onPlayerCommand(Commands.java:165)
[20:57:04 WARN]: at com.destroystokyo.paper.event.executor.MethodHandleEventExecutor.execute(MethodHandleEventExecutor.java:37)
[20:57:04 WARN]: at co.aikar.timings.TimedEventExecutor.execute(TimedEventExecutor.java:80)
[20:57:04 WARN]: at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:66)
[20:57:04 WARN]: at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:520)
[20:57:04 WARN]: at net.minecraft.server.v1_13_R2.PlayerConnection.handleCommand(PlayerConnection.java:1775)
[20:57:04 WARN]: at net.minecraft.server.v1_13_R2.PlayerConnection.a(PlayerConnection.java:1591)
[20:57:04 WARN]: at net.minecraft.server.v1_13_R2.PacketPlayInChat.a(PacketPlayInChat.java:45)
[20:57:04 WARN]: at net.minecraft.server.v1_13_R2.PacketPlayInChat.a(PacketPlayInChat.java:5)
[20:57:04 WARN]: at net.minecraft.server.v1_13_R2.PlayerConnectionUtils.lambda$ensureMainThread$0(PlayerConnectionUtils.java:15)
[20:57:04 WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
[20:57:04 WARN]: at java.util.concurrent.FutureTask.run(FutureTask.java:266)
[20:57:04 WARN]: at net.minecraft.server.v1_13_R2.SystemUtils.a(SystemUtils.java:108)
[20:57:04 WARN]: at net.minecraft.server.v1_13_R2.MinecraftServer.b(MinecraftServer.java:1018)
[20:57:04 WARN]: at net.minecraft.server.v1_13_R2.DedicatedServer.b(DedicatedServer.java:439)
[20:57:04 WARN]: at net.minecraft.server.v1_13_R2.MinecraftServer.a(MinecraftServer.java:940)
[20:57:04 WARN]: at net.minecraft.server.v1_13_R2.MinecraftServer.run(MinecraftServer.java:837)
[20:57:04 WARN]: at java.lang.Thread.run(Thread.java:748)

When I run the command /test I get message "CLOSE".
Can someone figure out where's the problem? :emoji_slight_smile:
I'm not using skript-db because it does not work on 1.13.2
 
Status
Not open for further replies.
Top Bottom
Back