brenoepics
commented
5 years ago In GitLab by @Harmonic on Jul 17, 2019, 18:36
It's failing to execute this query.
try (PreparedStatement statement = connection.prepareStatement("INSERT INTO users_badges (id,user_id,slot_id,badge_code) VALUES (null, (SELECTidFROMusersWHEREusername= ? LIMIT 1), 0, ?)")) { statement.setString(1, params[1]); statement.setString(2, params[2]); statement.execute(); }
Can you ensure that your structure looks like this?
In GitLab by @Killua on Jul 17, 2019, 16:33
Build Information
Emulator Version: http://prntscr.com/oggfjf Arcturus Morningstar 2.1.1 Stable Emulator Build (hash): f22d822fc1b84b80b3cadcc093cdc10d
What is the error?
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1283) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:783) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197) at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) at com.eu.habbo.habbohotel.commands.BadgeCommand.handle(BadgeCommand.java:59) at com.eu.habbo.habbohotel.commands.CommandHandler.handleCommand(CommandHandler.java:77) at com.eu.habbo.habbohotel.rooms.Room.talk(Room.java:3049) at com.eu.habbo.habbohotel.rooms.Room.talk(Room.java:2977) at com.eu.habbo.messages.incoming.rooms.users.RoomUserTalkEvent.handle(RoomUserTalkEvent.java:29) at com.eu.habbo.messages.PacketManager.handlePacket(PacketManager.java:183) at com.eu.habbo.threading.runnables.ChannelReadHandler.run(ChannelReadHandler.java:40) at com.eu.habbo.threading.ThreadPooling$1.run(ThreadPooling.java:45) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) at java.base/java.lang.Thread.run(Thread.java:835)