-
Notifications
You must be signed in to change notification settings - Fork 20
Problems with SQL, Midi and documentation #191
Description
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