Can not Save Spawned L2J NPC Buffer in DB.
Posted: Fri Sep 06, 2013 8:11 am
Hello,
Everytime got this error when i spawn the l2j NPC buffer. After Server restart buffer missed. What wrong ?
sept 06, 2013 10:49:40 AM com.l2jserver.gameserver.datatables.SpawnTable addNewSpawn
WARNING: SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value for column 'npc_templateid' at row 1
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'npc_templateid' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4118)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:823)
at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable.java:203)
at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java:452)
at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.java:271)
at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:132)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:70)
at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1091)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Everytime got this error when i spawn the l2j NPC buffer. After Server restart buffer missed. What wrong ?
sept 06, 2013 10:49:40 AM com.l2jserver.gameserver.datatables.SpawnTable addNewSpawn
WARNING: SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value for column 'npc_templateid' at row 1
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'npc_templateid' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4118)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:823)
at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable.java:203)
at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java:452)
at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.java:271)
at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:132)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:70)
at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1091)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)