All pastes #20897 Raw Edit

Anonymous

public text v1 · immutable
#20897 ·published 2005-08-23 19:51 UTC
rendered paste body
data error on delete char:
java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax.  Che
ck the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE pets.item_obj_id=ite
ms.object_id AND items.owner_id=26854"
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1371)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)
        at net.sf.l2j.gameserver.ClientThread.deleteChar(ClientThread.java:188)
        at net.sf.l2j.gameserver.clientpackets.CharacterDelete.runImpl(CharacterDelete.java:58)
        at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePacket.java:56)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)