All pastes #21143 Raw Edit

Miscellany

public text v1 · immutable
#21143 ·published 2005-08-25 19:13 UTC
rendered paste body
data error on delete char:
java.sql.SQLException: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server ver
sion for the right syntax to use near 'WHERE pets.item_obj_id=items.object_id AND items.owner_id=26845
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:770)
        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)