com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE name=sleinexxx' at line 1
Вот код:
Причем такой же код только таблица другая работает, а этот нет
Вот код:
Java:
public void saveStream() throws SQLException {
Connection connection = getConnection();
Statement statement = (Statement) connection.createStatement();
HashMap<Player, Long> players = PlayerLevels.getPlayers();
for (Player player : Bukkit.getOnlinePlayers()) {
ResultSet RS = statement.executeQuery("SELECT name, url FROM players_streams where name ='" + player.getName() + "'");
if( RS.absolute(1)) {
PlayerStreams.addPlayer(player, RS.getString("url"));
statement.executeUpdate(String.format("UPDATE players_streams set url=%s WHERE name=%s", PlayerStreams.getUrl(player), player.getName()));
} else {
PlayerStreams.addPlayer(player, "not");
addStreamPlayer(player);
}
RS.close();
connection.close();
statement.close();
}
}
Код:
[21:46:28] [PlayerDataSaver/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[21:46:28] [PlayerDataSaver/WARN]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[21:46:28] [PlayerDataSaver/WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[21:46:28] [PlayerDataSaver/WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[21:46:28] [PlayerDataSaver/WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[21:46:28] [PlayerDataSaver/WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[21:46:28] [PlayerDataSaver/WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[21:46:28] [PlayerDataSaver/WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
[21:46:28] [PlayerDataSaver/WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
[21:46:28] [PlayerDataSaver/WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
[21:46:28] [PlayerDataSaver/WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
[21:46:28] [PlayerDataSaver/WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2480)
[21:46:28] [PlayerDataSaver/WARN]: at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1552)
[21:46:28] [PlayerDataSaver/WARN]: at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2607)
[21:46:28] [PlayerDataSaver/WARN]: at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1480)
[21:46:28] [PlayerDataSaver/WARN]: at com.vk.bestrax.SQLDatabase.saveStream(SQLDatabase.java:111)
[21:46:28] [PlayerDataSaver/WARN]: at com.vk.bestrax.neverAPI.saveStreams(neverAPI.java:100)
[21:46:28] [PlayerDataSaver/WARN]: at com.vk.bestrax.DataSaver.run(DataSaver.java:16)
[21:46:28] [PlayerDataSaver/WARN]: at java.lang.Thread.run(Unknown Source)