Skip to content

Problems with SQL, Midi and documentation #191

@victorgluz

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

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