Jump to content

arrer

Members
  • Posts

    1
  • Credits

  • Joined

  • Last visited

  • Feedback

    0%

About arrer

Profile Information

  • Gender
    Male

arrer's Achievements

Newbie

Newbie (1/16)

0

Reputation

  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...