Jump to content

arrer

Members
  • Posts

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

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..