Skip to content

Problems with SQL, Midi and documentation #191

Description

@victorgluz

Describe the bug

I couldn't find a wiki that would help me create a script that does a MySQL query, the existing ones don't have examples or the examples don't help at all.

Unable to execute querys:
java.sql.SQLException: Operation not allowed after ResultSet closed
[12:00:35 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
[12:00:35 WARN]: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)

Skript:
script options:
$ init com.mysql.jdbc.Driver
$ db url jdbc:mysql://myhost/mydb
$ db username root
$ db password 1234
command /testquery:
trigger:
set {_objects::} to objects in column "realname" from result of query "SELECT realname FROM authme limit 10"
broadcast {_objects::
}

Error trying to reproduce midi:
command /midi:
trigger:
play midi from link "https://redemine.com.br/sounds/mario.mid" to event-player
Exception:
Exception in thread "Java Sound Sequencer" java.lang.NoClassDefFoundError: Could not initialize class com.w00tmast3r.skquery.util.note.Instrument
[11:54:04 WARN]: at SkQuery-4.2.0.jar//com.w00tmast3r.skquery.util.note.NoteBlockReceiver.send(NoteBlockReceiver.java:39)
[11:54:04 WARN]: at java.desktop/com.sun.media.sound.AbstractMidiDevice$TransmitterList.sendMessage(AbstractMidiDevice.java:627)

Information:

  • Skript version: 2.10.0
  • SkQuery versin: 4.2.0
  • Server software: Paper
  • Server version: 1.21

Activity

  1. victorgluz commented on Jan 22, 2025

    @victorgluz
    Author
  2. DexterSK commented on Jan 23, 2025

    @DexterSK

    @TheLimeGlass

    Do not bother with this, i've reported this a year ago, nothing changed

  3. victorgluz commented on Jan 23, 2025

    @victorgluz
    Author

    @TheLimeGlass

    Do not bother with this, i've reported this a year ago, nothing changed

    What a shame, I'll create a fork of the repository and try to fix this myself.

    I'll let you know if I get any results.

  4. DexterSK commented on Jan 23, 2025

    @DexterSK

    @TheLimeGlass

    Do not bother with this, i've reported this a year ago, nothing changed

    What a shame, I'll create a fork of the repository and try to fix this myself.

    I'll let you know if I get any results.

    same, i think problem will be in Skript not in this addon, i'll check it deeper later

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