Skip to content

Operation not allowed after ResultSet closed #157

Description

@DexterSK

Describe the bug

[14:03:48 WARN]: java.sql.SQLException: Operation not allowed after ResultSet closed
[14:03:48 WARN]:        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
[14:03:48 WARN]:        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
[14:03:48 WARN]:        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
[14:03:48 WARN]:        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
[14:03:48 WARN]:        at com.mysql.cj.jdbc.result.ResultSetImpl.checkClosed(ResultSetImpl.java:485)
[14:03:48 WARN]:        at com.mysql.cj.jdbc.result.ResultSetImpl.next(ResultSetImpl.java:1802)
[14:03:48 WARN]:        at SkQuery-4.1.10.jar//com.w00tmast3r.skquery.elements.expressions.ExprSQLQueryObjects.get(ExprSQLQueryObjects.java:35)
[14:03:48 WARN]:        at Skript-2.7.0-beta1.jar//ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:101)
[14:03:48 WARN]:        at Skript-2.7.0-beta1.jar//ch.njol.skript.effects.EffChange.execute(EffChange.java:272)
[14:03:48 WARN]:        at Skript-2.7.0-beta1.jar//ch.njol.skript.lang.Effect.run(Effect.java:50)
[14:03:48 WARN]:        at Skript-2.7.0-beta1.jar//ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:62)
[14:03:48 WARN]:        at Skript-2.7.0-beta1.jar//ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:90)
[14:03:48 WARN]:        at Skript-2.7.0-beta1.jar//ch.njol.skript.lang.Trigger.execute(Trigger.java:52)
[14:03:48 WARN]:        at Skript-2.7.0-beta1.jar//ch.njol.skript.command.ScriptCommand.execute2(ScriptCommand.java:312)
[14:03:48 WARN]:        at Skript-2.7.0-beta1.jar//ch.njol.skript.command.ScriptCommand.lambda$execute$0(ScriptCommand.java:277)
[14:03:48 WARN]:        at Skript-2.7.0-beta1.jar//ch.njol.skript.command.ScriptCommand.execute(ScriptCommand.java:282)
[14:03:48 WARN]:        at Skript-2.7.0-beta1.jar//ch.njol.skript.command.Commands.handleCommand(Commands.java:193)
[14:03:48 WARN]:        at Skript-2.7.0-beta1.jar//ch.njol.skript.command.Commands$1.onPlayerCommand(Commands.java:152)

Steps To Reproduce

command /test:
  trigger:
    set {_result::*} to objects in column "name" from result of query "SELECT name FROM `table` ORDER BY `column` DESC LIMIT 3 OFFSET 0;"
    message "%{_result::*}%"

Information:

  • Skript version: 2.7.0-beta1
  • Server software: Purpur
  • Server version: 1.20.1

Additional context

Activity

  1. gfrancov commented on Feb 16, 2024

    @gfrancov

    Same!!

  2. Xgabi86 commented on Jul 15, 2024

    @Xgabi86

    same

  3. DexterSK commented on Jul 18, 2024

    @DexterSK
    Author

    same

    lmao its almost one year old post xD i think we have to fix this yourself

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions