Problème MySQL - CoinsMySQL

Bonjour à tous, j'utilise le Skript CoinsMySQL de @MinePlugins sauf que j'ai pas mal d'erreurs avec son Skript :/

[10:55:10] [server thread/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.

[10:55:10] [server thread/WARN]: at sun.reflect.GeneratedConstructorAccessor77.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

[10:55:10] [server thread/WARN]: at sun.reflect.GeneratedConstructorAccessor74.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)

[10:55:10] [server thread/WARN]: at java.sql.DriverManager.getConnection(Unknown Source)

[10:55:10] [server thread/WARN]: at java.sql.DriverManager.getConnection(Unknown Source)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.db.ScriptCredentials.validate(ScriptCredentials.java:69)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.db.ScriptCredentials.setURL(ScriptCredentials.java:24)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.elements.effects.EffOptionSQLURL.register(EffOptionSQLURL.java:20)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.elements.effects.base.Pragma.init(Pragma.java:24)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.elements.effects.base.OptionsPragma.init(OptionsPragma.java:18)

[10:55:10] [server thread/WARN]: at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:237)

[10:55:10] [server thread/WARN]: at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:164)

[10:55:10] [server thread/WARN]: at ch.njol.skript.lang.Statement.parse(Statement.java:42)

[10:55:10] [server thread/WARN]: at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:615)

[10:55:10] [server thread/WARN]: at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:489)

[10:55:10] [server thread/WARN]: at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:239)

[10:55:10] [server thread/WARN]: at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:193)

[10:55:10] [server thread/WARN]: at ch.njol.skript.Skript.reload(Skript.java:548)

[10:55:10] [server thread/WARN]: at ch.njol.skript.SkriptCommand.onCommand(SkriptCommand.java:130)

[10:55:10] [server thread/WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)

[10:55:10] [server thread/WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)

[10:55:10] [server thread/WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:641)

[10:55:10] [server thread/WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchServerCommand(CraftServer.java:627)

[10:55:10] [server thread/WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.aO(DedicatedServer.java:412)

[10:55:10] [server thread/WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:375)

[10:55:10] [server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)

[10:55:10] [server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)

[10:55:10] [server thread/WARN]: at java.lang.Thread.run(Unknown Source)

[10:55:10] [server thread/WARN]: Caused by: java.net.UnknownHostException: mysql.hostinger.fr

[10:55:10] [server thread/WARN]: at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)

[10:55:10] [server thread/WARN]: at java.net.InetAddress$2.lookupAllHostAddr(Unknown Source)

[10:55:10] [server thread/WARN]: at java.net.InetAddress.getAddressesFromNameService(Unknown Source)

[10:55:10] [server thread/WARN]: at java.net.InetAddress.getAllByName0(Unknown Source)

[10:55:10] [server thread/WARN]: at java.net.InetAddress.getAllByName(Unknown Source)

[10:55:10] [server thread/WARN]: at java.net.InetAddress.getAllByName(Unknown Source)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)

[10:55:10] [server thread/WARN]: ... 36 more

[10:55:10] [server thread/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.

[10:55:10] [server thread/WARN]: at sun.reflect.GeneratedConstructorAccessor77.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

[10:55:10] [server thread/WARN]: at sun.reflect.GeneratedConstructorAccessor74.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)

[10:55:10] [server thread/WARN]: at java.sql.DriverManager.getConnection(Unknown Source)

[10:55:10] [server thread/WARN]: at java.sql.DriverManager.getConnection(Unknown Source)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.db.ScriptCredentials.validate(ScriptCredentials.java:69)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.db.ScriptCredentials.setUsername(ScriptCredentials.java:30)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.elements.effects.EffOptionSQLUsername.register(EffOptionSQLUsername.java:20)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.elements.effects.base.Pragma.init(Pragma.java:24)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.elements.effects.base.OptionsPragma.init(OptionsPragma.java:18)

[10:55:10] [server thread/WARN]: at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:237)

[10:55:10] [server thread/WARN]: at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:164)

[10:55:10] [server thread/WARN]: at ch.njol.skript.lang.Statement.parse(Statement.java:42)

[10:55:10] [server thread/WARN]: at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:615)

[10:55:10] [server thread/WARN]: at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:489)

[10:55:10] [server thread/WARN]: at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:239)

[10:55:10] [server thread/WARN]: at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:193)

[10:55:10] [server thread/WARN]: at ch.njol.skript.Skript.reload(Skript.java:548)

[10:55:10] [server thread/WARN]: at ch.njol.skript.SkriptCommand.onCommand(SkriptCommand.java:130)

[10:55:10] [server thread/WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)

[10:55:10] [server thread/WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)

[10:55:10] [server thread/WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:641)

[10:55:10] [server thread/WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchServerCommand(CraftServer.java:627)

[10:55:10] [server thread/WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.aO(DedicatedServer.java:412)

[10:55:10] [server thread/WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:375)

[10:55:10] [server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)

[10:55:10] [server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)

[10:55:10] [server thread/WARN]: at java.lang.Thread.run(Unknown Source)

[10:55:10] [server thread/WARN]: Caused by: java.net.UnknownHostException: mysql.hostinger.fr

[10:55:10] [server thread/WARN]: at java.net.InetAddress.getAllByName0(Unknown Source)

[10:55:10] [server thread/WARN]: at java.net.InetAddress.getAllByName(Unknown Source)

[10:55:10] [server thread/WARN]: at java.net.InetAddress.getAllByName(Unknown Source)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)

[10:55:10] [server thread/WARN]: ... 36 more

[10:55:10] [server thread/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.

[10:55:10] [server thread/WARN]: at sun.reflect.GeneratedConstructorAccessor77.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

[10:55:10] [server thread/WARN]: at sun.reflect.GeneratedConstructorAccessor74.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)

[10:55:10] [server thread/WARN]: at java.sql.DriverManager.getConnection(Unknown Source)

[10:55:10] [server thread/WARN]: at java.sql.DriverManager.getConnection(Unknown Source)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.db.ScriptCredentials.validate(ScriptCredentials.java:69)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.db.ScriptCredentials.setPassword(ScriptCredentials.java:36)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.elements.effects.EffOptionSQLPassword.register(EffOptionSQLPassword.java:20)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.elements.effects.base.Pragma.init(Pragma.java:24)

[10:55:10] [server thread/WARN]: at com.w00tmast3r.skquery.elements.effects.base.OptionsPragma.init(OptionsPragma.java:18)

[10:55:10] [server thread/WARN]: at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:237)

[10:55:10] [server thread/WARN]: at ch.njol.skript.lang.SkriptParser.parse(SkriptParser.java:164)

[10:55:10] [server thread/WARN]: at ch.njol.skript.lang.Statement.parse(Statement.java:42)

[10:55:10] [server thread/WARN]: at ch.njol.skript.ScriptLoader.loadItems(ScriptLoader.java:615)

[10:55:10] [server thread/WARN]: at ch.njol.skript.ScriptLoader.loadScript(ScriptLoader.java:489)

[10:55:10] [server thread/WARN]: at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:239)

[10:55:10] [server thread/WARN]: at ch.njol.skript.ScriptLoader.loadScripts(ScriptLoader.java:193)

[10:55:10] [server thread/WARN]: at ch.njol.skript.Skript.reload(Skript.java:548)

[10:55:10] [server thread/WARN]: at ch.njol.skript.SkriptCommand.onCommand(SkriptCommand.java:130)

[10:55:10] [server thread/WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)

[10:55:10] [server thread/WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)

[10:55:10] [server thread/WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchCommand(CraftServer.java:641)

[10:55:10] [server thread/WARN]: at org.bukkit.craftbukkit.v1_8_R3.CraftServer.dispatchServerCommand(CraftServer.java:627)

[10:55:10] [server thread/WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.aO(DedicatedServer.java:412)

[10:55:10] [server thread/WARN]: at net.minecraft.server.v1_8_R3.DedicatedServer.B(DedicatedServer.java:375)

[10:55:10] [server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.A(MinecraftServer.java:654)

[10:55:10] [server thread/WARN]: at net.minecraft.server.v1_8_R3.MinecraftServer.run(MinecraftServer.java:557)

[10:55:10] [server thread/WARN]: at java.lang.Thread.run(Unknown Source)

[10:55:10] [server thread/WARN]: Caused by: java.net.UnknownHostException: mysql.hostinger.fr

[10:55:10] [server thread/WARN]: at java.net.InetAddress.getAllByName0(Unknown Source)

[10:55:10] [server thread/WARN]: at java.net.InetAddress.getAllByName(Unknown Source)

[10:55:10] [server thread/WARN]: at java.net.InetAddress.getAllByName(Unknown Source)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244)

[10:55:10] [server thread/WARN]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)

[10:55:10] [server thread/WARN]: ... 36 more

[10:55:10] [server thread/ERROR]: 'update "CREATE TABLE IF NOT EXISTS `Coins_Coins` (`Player` varchar(255),`UUID` varchar(255),`Coins` varchar(255),`Join` varchar(255))"' is not a boolean (yes/no) (CoinsMySQL.sk, line 30: update "CREATE TABLE IF NOT EXISTS `{@table_prefix}Coins` (`Player` varchar(255),`UUID` varchar(255),`Coins` varchar(255),`Join` varchar(255))"')

[10:55:10] [server thread/ERROR]: Database features are disabled until the script has SQL credentials associated with it. (CoinsMySQL.sk, line 35: set {_Join::*} to objects in column "Join" from result of query "SELECT * FROM `{@table_prefix}Coins` WHERE `{@table_prefix}Coins`.`UUID` = '%{_uuid}%'"')

[10:55:10] [server thread/ERROR]: 'player%', '0', '1')"' is not an item stack (CoinsMySQL.sk, line 40: update "INSERT INTO `{@table_prefix}Coins` (`Player`, `UUID`, `Coins`, `Join`) VALUES ('%player%', '%uuid of player%', '{@start_with}', '1')"')

[10:55:10] [server thread/ERROR]: 'AddCoin(player: player, uuid: text, number: number)' is not a text (CoinsMySQL.sk, line 41: function AddCoin(player: player, uuid: text, number: number):')

[10:55:10] [server thread/ERROR]: 'RemCoin(player: player, uuid: text, number: number)' is not a text (CoinsMySQL.sk, line 45: function RemCoin(player: player, uuid: text, number: number):')

[10:55:11] [server thread/ERROR]: 'set {_Coins} to CheckCoin(player , uuid of player)' is not a boolean (yes/no) (CoinsMySQL.sk, line 58: set {_Coins} to CheckCoin(player , uuid of player)')

Je ne comprend toujours pas pourquoi il y a ces erreurs.

Bonjour à tous, j'utilise le Skript CoinsMySQL de @MinePlugins sauf que j'ai pas mal d'erreurs avec son Skript :/

 

Je ne comprend toujours pas pourquoi il y a ces erreurs.

Version de Skript et de Minecraft ?

Version Skript : 2.2

Version Minecraft : 1.8.8

Version Skript : 2.2

Version Minecraft : 1.8.8

Il y a pas mal de versions 2.2 de Skript, donc fais

Contenu masqué

Réagissez ou répondez à ce message afin de consulter le contenu masqué.

en jeu et dis-moi la version exacte.

Tas base de données n'est pas accessible

Et est-ce que tu sais où je peux en avoir une gratuitement ?

Wamp

Ok c'est bon ça marche merci ! Je passe le topic en résolu :)