Cześć, mam problem z odczytaniem wartości z bazy danych, o to mój kod skript:
script options:
$ db url jdbc:mysql://localhost:3306/mc
$ db username admin
$ db password haslo
command /j:
trigger:
set {_x::*} to objects in column "lastNickname" from result of query "SELECT * FROM `user_profiles` ORDER BY `%player%` DESC LIMIT 1 OFFSET 0"
send "&c%{_x::*}%"
A tutaj mam taki crash:
Spoiler
[01:22:33 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'FlusieQ' in 'order clause'
[01:22:33 WARN]: at sun.reflect.GeneratedConstructorAccessor95.newInstance(Unknown Source)
[01:22:33 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[01:22:33 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[01:22:33 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[01:22:33 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[01:22:33 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
[01:22:33 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[01:22:33 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[01:22:33 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[01:22:33 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[01:22:33 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
[01:22:33 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
[01:22:33 WARN]: at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
[01:22:33 WARN]: at com.w00tmast3r.skquery.elements.expressions.ExprSQLQuery.get(ExprSQLQuery.java:36)
[01:22:33 WARN]: at com.w00tmast3r.skquery.elements.expressions.ExprSQLQuery.get(ExprSQLQuery.java:22)
[01:22:33 WARN]: at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:100)
[01:22:33 WARN]: at ch.njol.skript.lang.util.SimpleExpression.getSingle(SimpleExpression.java:58)
[01:22:33 WARN]: at com.w00tmast3r.skquery.elements.expressions.ExprSQLQueryObjects.get(ExprSQLQueryObjects.java:30)
[01:22:33 WARN]: at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:100)
[01:22:33 WARN]: at ch.njol.skript.effects.EffChange.execute(EffChange.java:276)
[01:22:33 WARN]: at ch.njol.skript.lang.Effect.run(Effect.java:51)
[01:22:33 WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:60)
[01:22:33 WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:88)
[01:22:33 WARN]: at ch.njol.skript.lang.Trigger.execute(Trigger.java:56)
[01:22:33 WARN]: at ch.njol.skript.command.ScriptCommand.execute2(ScriptCommand.java:291)
[01:22:33 WARN]: at ch.njol.skript.command.ScriptCommand.execute(ScriptCommand.java:250)
[01:22:33 WARN]: at ch.njol.skript.command.ScriptCommand.onCommand(ScriptCommand.java:194)
[01:22:33 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
[01:22:33 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
[01:22:33 WARN]: at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchCommand(CraftServer.java:641)
[01:22:33 WARN]: at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchServerCommand(CraftServer.java:627)
[01:22:33 WARN]: at net.minecraft.server.v1_12_R1.DedicatedServer.aP(DedicatedServer.java:443)
[01:22:33 WARN]: at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:406)
[01:22:33 WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:678)
[01:22:33 WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:576)
[01:22:33 WARN]: at java.lang.Thread.run(Unknown Source)
[01:22:33 INFO]: <none>
Pytanie
Usunięty#32366 15
Cześć, mam problem z odczytaniem wartości z bazy danych, o to mój kod skript:
script options: $ db url jdbc:mysql://localhost:3306/mc $ db username admin $ db password haslo command /j: trigger: set {_x::*} to objects in column "lastNickname" from result of query "SELECT * FROM `user_profiles` ORDER BY `%player%` DESC LIMIT 1 OFFSET 0" send "&c%{_x::*}%"A tutaj mam taki crash:
[01:22:33 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'FlusieQ' in 'order clause'
[01:22:33 WARN]: at sun.reflect.GeneratedConstructorAccessor95.newInstance(Unknown Source)
[01:22:33 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[01:22:33 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[01:22:33 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[01:22:33 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[01:22:33 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
[01:22:33 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[01:22:33 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[01:22:33 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[01:22:33 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[01:22:33 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
[01:22:33 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
[01:22:33 WARN]: at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
[01:22:33 WARN]: at com.w00tmast3r.skquery.elements.expressions.ExprSQLQuery.get(ExprSQLQuery.java:36)
[01:22:33 WARN]: at com.w00tmast3r.skquery.elements.expressions.ExprSQLQuery.get(ExprSQLQuery.java:22)
[01:22:33 WARN]: at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:100)
[01:22:33 WARN]: at ch.njol.skript.lang.util.SimpleExpression.getSingle(SimpleExpression.java:58)
[01:22:33 WARN]: at com.w00tmast3r.skquery.elements.expressions.ExprSQLQueryObjects.get(ExprSQLQueryObjects.java:30)
[01:22:33 WARN]: at ch.njol.skript.lang.util.SimpleExpression.getArray(SimpleExpression.java:100)
[01:22:33 WARN]: at ch.njol.skript.effects.EffChange.execute(EffChange.java:276)
[01:22:33 WARN]: at ch.njol.skript.lang.Effect.run(Effect.java:51)
[01:22:33 WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:60)
[01:22:33 WARN]: at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.java:88)
[01:22:33 WARN]: at ch.njol.skript.lang.Trigger.execute(Trigger.java:56)
[01:22:33 WARN]: at ch.njol.skript.command.ScriptCommand.execute2(ScriptCommand.java:291)
[01:22:33 WARN]: at ch.njol.skript.command.ScriptCommand.execute(ScriptCommand.java:250)
[01:22:33 WARN]: at ch.njol.skript.command.ScriptCommand.onCommand(ScriptCommand.java:194)
[01:22:33 WARN]: at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
[01:22:33 WARN]: at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
[01:22:33 WARN]: at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchCommand(CraftServer.java:641)
[01:22:33 WARN]: at org.bukkit.craftbukkit.v1_12_R1.CraftServer.dispatchServerCommand(CraftServer.java:627)
[01:22:33 WARN]: at net.minecraft.server.v1_12_R1.DedicatedServer.aP(DedicatedServer.java:443)
[01:22:33 WARN]: at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:406)
[01:22:33 WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:678)
[01:22:33 WARN]: at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:576)
[01:22:33 WARN]: at java.lang.Thread.run(Unknown Source)
[01:22:33 INFO]: <none>
A w bazie danych wszystko wygląda tak:
Odnośnik do komentarza
Udostępnij na innych stronach
1 odpowiedź na to pytanie
Rekomendowane odpowiedzi
Dołącz do dyskusji
Możesz dodać zawartość już teraz a zarejestrować się później. Jeśli posiadasz już konto, zaloguj się aby dodać zawartość za jego pomocą.