Jump to content

arrer

Members
  • Posts

    1
  • Joined

  • Last visited

  • Feedback

    0%

Everything posted by arrer

  1. 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
×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock