SkQuery mysql

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

Dave

Active Member
Jul 20, 2018
227
9
18
I'm trying to test SkQuery mysql manager but it doesn't work, I'm using MySql_Manager's SK example

[20:58:39] [pool-2-thread-1/WARN]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[20:58:39] [pool-2-thread-1/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[20:58:39] [pool-2-thread-1/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
[20:58:39] [pool-2-thread-1/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[20:58:39] [pool-2-thread-1/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
[20:58:39] [pool-2-thread-1/WARN]: at java.sql.DriverManager.getConnection(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.sql.DriverManager.getConnection(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at com.w00tmast3r.skquery.db.ScriptCredentials.validate(ScriptCredentials.java:69)
[20:58:39] [pool-2-thread-1/WARN]: at com.w00tmast3r.skquery.db.ScriptCredentials.setPassword(ScriptCredentials.java:36)
[20:58:39] [pool-2-thread-1/WARN]: at com.w00tmast3r.skquery.elements.effects.EffOptionSQLPassword.register(EffOptionSQLPassword.java:20)
[20:58:39] [pool-2-thread-1/WARN]: at com.w00tmast3r.skquery.elements.effects.base.Pragma.init(Pragma.java:24)
[20:58:39] [pool-2-thread-1/WARN]: at com.w00tmast3r.skquery.elements.effects.base.OptionsPragma.init(OptionsPragma.java:18)
[20:58:39] [pool-2-thread-1/WARN]: at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:248)
[20:58:39] [pool-2-thread-1/WARN]: at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:175)
[20:58:39] [pool-2-thread-1/WARN]: at ch.njol.skript.lang.Statement.parse(Statement.java:60)
[20:58:39] [pool-2-thread-1/WARN]: at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:650)
[20:58:39] [pool-2-thread-1/WARN]: at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:510)
[20:58:39] [pool-2-thread-1/WARN]: at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:245)
[20:58:39] [pool-2-thread-1/WARN]: at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:199)
[20:58:39] [pool-2-thread-1/WARN]: at ch.njol.skript.Skript$2.run(Skript.java:408)
[20:58:39] [pool-2-thread-1/WARN]: at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:59)
[20:58:39] [pool-2-thread-1/WARN]: at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:344)
[20:58:39] [pool-2-thread-1/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.B(MinecraftServer.java:750)
[20:58:39] [pool-2-thread-1/WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:342)
[20:58:39] [pool-2-thread-1/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:699)
[20:58:39] [pool-2-thread-1/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.lambda$startTickloop$0(MinecraftServer.java:589)
[20:58:39] [pool-2-thread-1/WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.lang.Thread.run(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: Caused by: java.net.UnknownHostException: IP
[20:58:39] [pool-2-thread-1/WARN]: at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
[20:58:39] [pool-2-thread-1/WARN]: at java.net.InetAddress$2.lookupAllHostAddr(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.net.InetAddress.getAddressesFromNameService(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.net.InetAddress.getAllByName0(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.net.InetAddress.getAllByName(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at java.net.InetAddress.getAllByName(Unknown Source)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244)
[20:58:39] [pool-2-thread-1/WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
[20:58:39] [pool-2-thread-1/WARN]: ... 40 more
[20:58:39] [pool-2-thread-1/ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (sql.sk, line 12: update "CREATE TABLE IF NOT EXISTS `{@Table}` (`id` varchar(255),`value` varchar(255))"')
[20:58:39] [pool-2-thread-1/ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (sql.sk, line 13: update "ALTER TABLE {@Table} ADD UNIQUE (id, value)"')
[20:58:39] [pool-2-thread-1/ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (sql.sk, line 16: set {_SetResult::*} to objects in column "id" from result of query "SELECT * FROM {@Table} WHERE id = '%{_id}%'" and close')
[20:58:39] [pool-2-thread-1/ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (sql.sk, line 22: update "INSERT INTO `{@Table}` (`id`,`value`) valueS ('%{_id}%', '%{_value}%')"')
[20:58:39] [pool-2-thread-1/ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (sql.sk, line 25: update "UPDATE `{@Table}` SET `value` = '%{_value}%' WHERE `{@Table}`.`id` ='%{_id}%'"')
[20:58:39] [pool-2-thread-1/ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (sql.sk, line 29: set {_SetResult::*} to objects in column "id" from result of query "SELECT * FROM {@Table} WHERE id = '%{_id}%'" and close')
[20:58:39] [pool-2-thread-1/ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (sql.sk, line 35: update "DELETE FROM {@Table} WHERE id = '%{_id}%'"')
[20:58:39] [pool-2-thread-1/ERROR]: [Skript] Database features are disabled until the script has SQL credentials associated with it. (sql.sk, line 41: set {_SetResult::*} to objects in column "value" from result of query "SELECT * FROM {@Table} WHERE id = '%{_id}%'" and close')
[20:58:40] [pool-2-thread-1/INFO]: [Skript] Loaded 1 script with a total of 2 triggers and 1 command in 3.05 seconds
[20:58:40] [pool-2-thread-1/INFO]: [Skript] Finished loading.
 
Status
Not open for further replies.
Top Bottom
Back