Тема: [core] Character Variables DAO insert playerObjId var (FIXED)
Показать сообщение отдельно
Старый 05.08.2013, 12:51   #1
l2gold
Клиент Расширенка Crusade, + Classic 2.5 + svn + New GEO
 
Регистрация: 13.04.2012
Сообщений: 2,226
По умолчанию [core] Character Variables DAO insert playerObjId var (FIXED)
Код:
[16:03:08] ERROR CharacterVariablesDAO:insert(playerObjId,var)
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'value' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4185)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2s.gameserver.dao.CharacterVariablesDAO.insert(CharacterVariablesDAO.java:97)
    at l2s.gameserver.model.Player.setVar(Player.java:6816)
    at l2s.gameserver.model.Player.saveTradeList(Player.java:8932)
    at l2s.gameserver.network.l2.c2s.SetPrivateStoreSellList.runImpl(SetPrivateStoreSellList.java:109)
    at l2s.gameserver.network.l2.c2s.L2GameClientPacket.run(L2GameClientPacket.java:49)
    at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MMOExecutableQueue.java:39)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
[16:03:43] ERROR CharacterVariablesDAO:insert(playerObjId,var)
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'value' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4185)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2s.gameserver.dao.CharacterVariablesDAO.insert(CharacterVariablesDAO.java:97)
    at l2s.gameserver.model.Player.setVar(Player.java:6816)
    at l2s.gameserver.model.Player.saveTradeList(Player.java:8932)
    at l2s.gameserver.network.l2.c2s.SetPrivateStoreSellList.runImpl(SetPrivateStoreSellList.java:109)
    at l2s.gameserver.network.l2.c2s.L2GameClientPacket.run(L2GameClientPacket.java:49)
    at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MMOExecutableQueue.java:39)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
[16:10:16] ERROR CharacterVariablesDAO:insert(playerObjId,var)
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'value' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4185)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2s.gameserver.dao.CharacterVariablesDAO.insert(CharacterVariablesDAO.java:97)
    at l2s.gameserver.model.Player.setVar(Player.java:6816)
    at l2s.gameserver.model.Player.saveTradeList(Player.java:8932)
    at l2s.gameserver.network.l2.c2s.SetPrivateStoreSellList.runImpl(SetPrivateStoreSellList.java:109)
    at l2s.gameserver.network.l2.c2s.L2GameClientPacket.run(L2GameClientPacket.java:49)
    at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MMOExecutableQueue.java:39)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
[16:10:28] ERROR CharacterVariablesDAO:insert(playerObjId,var)
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'value' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4185)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at l2s.gameserver.dao.CharacterVariablesDAO.insert(CharacterVariablesDAO.java:97)
    at l2s.gameserver.model.Player.setVar(Player.java:6816)
    at l2s.gameserver.model.Player.saveTradeList(Player.java:8932)
    at l2s.gameserver.network.l2.c2s.SetPrivateStoreSellList.runImpl(SetPrivateStoreSellList.java:109)
    at l2s.gameserver.network.l2.c2s.L2GameClientPacket.run(L2GameClientPacket.java:49)
    at l2s.commons.net.nio.impl.MMOExecutableQueue.run(MMOExecutableQueue.java:39)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
l2gold вне форума