Hello, I have a problem with MySQL query.
Everything was installed correctly, but then came
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'charI
d' in 'where clause'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.Util.getInstance(Util.java:382)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2119)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2281)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
at com.l2jfrozen.gameserver.masteriopack.rankpvpsystem.TopTable.updateTo
pTable(TopTable.java:206)
at com.l2jfrozen.gameserver.masteriopack.rankpvpsystem.TopTable.load(Top
Table.java:98)
at com.l2jfrozen.gameserver.masteriopack.rankpvpsystem.TopTable.<init>(T
opTable.java:52)
at com.l2jfrozen.gameserver.masteriopack.rankpvpsystem.TopTable.getInsta
nce(TopTable.java:60)
at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:501)
Tried to change "charId" on "obj_id" here
private static final String SQL_PLAYER_DATA = "SELECT char_name as name, base_class as base_class, level as level FROM characters WHERE charId=?";
and got this
Multiply prepared statement! SELECT char_name as name, base_class as base_class, level as level FROM characters WHERE obj_Id=?
Please help in solving this problem.
Core: L2JFrozen [iT] latest revision