Can not Save Spawned L2J NPC Buffer in DB.

[rabzer]

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)

[jurchiks]

You should enable the custom_spawnlist table in configs: game/config/General.properties, "CustomSpawnlistTable = true" and "SaveGmSpawnOnCustom = true".
Consider enabling the other tables aswell.

[rabzer]

Thx man, this worked .