L2-scripts Форум

L2-scripts Форум (http://l2-scripts.ru/forum/index.php)
-   Archive Lindvior, Ertheia, Odyssey, Undergeround, Helios, Grand Crusade (http://l2-scripts.ru/forum/forumdisplay.php?f=103)
-   -   [core] Character Variables DAO insert playerObjId var (FIXED) (http://l2-scripts.ru/forum/showthread.php?t=3760)

l2gold 05.08.2013 12:51
[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)

iqman 08.08.2013 00:28
Хм у вас на продажу можно выставить более чем 100 вещей? О_о

l2gold 08.08.2013 01:26
нельзья,
там стандартно на продажу

Core 14.08.2013 18:58
Исправлено.


Часовой пояс GMT +4, время: 16:24.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd. Перевод: zCarot