Hello there MaxCheaters i have an issue with my NPC's after finally getting all my GGK, GMShop and buffers working....they dont seem to stay spawned and neither will my original GK in giran :s seems no NPCs thats i move/spawn with stay spawned now Can anyone give me some insite on this please and thanks thats would be great!! :D

 

Read our section info,post as much info as u can, for example:

 

Project info, or maybe there was some kind of error logs while spawning NPC's?

Ok so i went back and tried everything again and saw these messages in my gameserver window :s

Not quite sure where to start or if this is enough info or not

 

**EDIT** i might add that is does this for any npc i spawn now....so it isnt just costom NPCs

 

SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value

for column 'id' at row 1

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu

mn 'id' at row 1

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2113)

       at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)

 

       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr

eparedStatement.java:989)

       at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable

.java:286)

       at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java

:246)

       at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.j

ava:180)

       at com.l2jserver.gameserver.network.clientpackets.SendBypassBuildCmd.run

Impl(SendBypassBuildCmd.java:79)

       at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:62)

       at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:9

97)

       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)

 

SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value

for column 'id' at row 1

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu

mn 'id' at row 1

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2113)

       at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)

 

       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr

eparedStatement.java:989)

       at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable

.java:286)

       at handlers.admincommandhandlers.AdminTeleport.recallNPC(AdminTeleport.j

ava:524)

       at handlers.admincommandhandlers.AdminTeleport.useAdminCommand(AdminTele

port.java:119)

       at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.

runImpl(RequestBypassToServer.java:111)

       at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:62)

       at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:9

97)

       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)

 

SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value

for column 'id' at row 1

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu

mn 'id' at row 1

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2113)

       at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)

 

       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr

eparedStatement.java:989)

       at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable

.java:286)

       at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java

:246)

       at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.j

ava:180)

       at com.l2jserver.gameserver.network.clientpackets.SendBypassBuildCmd.run

Impl(SendBypassBuildCmd.java:79)

       at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:62)

       at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:9

97)

       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)

 

SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value

for column 'id' at row 1

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu

mn 'id' at row 1

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2113)

       at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)

 

       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr

eparedStatement.java:989)

       at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable

.java:286)

       at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java

:246)

       at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.j

ava:180)

       at com.l2jserver.gameserver.network.clientpackets.SendBypassBuildCmd.run

Impl(SendBypassBuildCmd.java:79)

       at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:62)

       at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:9

97)

       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)

 

SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value

for column 'id' at row 1

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu

mn 'id' at row 1

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2113)

       at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)

 

       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr

eparedStatement.java:989)

       at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable

.java:286)

       at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java

:246)

       at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.j

ava:180)

       at com.l2jserver.gameserver.network.clientpackets.SendBypassBuildCmd.run

Impl(SendBypassBuildCmd.java:79)

       at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:62)

       at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:9

97)

       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)

 

SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value

for column 'id' at row 1

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu

mn 'id' at row 1

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2113)

       at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)

 

       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr

eparedStatement.java:989)

       at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable

.java:286)

       at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java

:246)

       at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.j

ava:180)

       at com.l2jserver.gameserver.network.clientpackets.SendBypassBuildCmd.run

Impl(SendBypassBuildCmd.java:79)

       at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:62)

       at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:9

97)

       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)

 

SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value

for column 'id' at row 1

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu

mn 'id' at row 1

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2113)

       at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)

 

       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr

eparedStatement.java:989)

       at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable

.java:286)

       at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java

:246)

       at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.j

ava:180)

       at com.l2jserver.gameserver.network.clientpackets.SendBypassBuildCmd.run

Impl(SendBypassBuildCmd.java:79)

       at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:62)

       at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:9

97)

       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)

 

SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value

for column 'id' at row 1

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu

mn 'id' at row 1

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2113)

       at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)

 

       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr

eparedStatement.java:989)

       at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable

.java:286)

       at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java

:246)

       at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.j

ava:180)

       at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.

runImpl(RequestBypassToServer.java:111)

       at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:62)

       at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:9

97)

       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)

 

SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value

for column 'id' at row 1

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for colu

mn 'id' at row 1

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)

       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

       at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

va:2113)

       at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)

 

       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPr

eparedStatement.java:989)

       at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable

.java:286)

       at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java

:246)

       at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.j

ava:180)

       at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.

runImpl(RequestBypassToServer.java:111)

       at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run

(L2GameClientPacket.java:62)

       at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:9

97)

       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)

 

As I said, checking error logs is the best way.. always.

 

Anyway, my advice is to try to use lower ID for your NPC's.

 

Not something like this one... 234534753475345

But what about the Giran GateKeeper that all i did was move it and now it dosnt stay spawned aswell?

I mean my ID's are this

Buffer 1000003(kinda long but stayed at one point in game)

GMShop 10002(Short)

GGK 36604(Short)

And well as you prob know Girn GK 30080...it more buggs me thats this NPC wont stay spawned cause its liike the actual game NPV right

Check This thread, it has similar subject.

TYVM..i have to head to work but this is what ill be doing when i get home :)

ty for your support and fast response

Ok that worked TY so much Matim for your help

 

Problem solved**

 

//Request delete thread?

seeing as how the fix is already here at http://www.maxcheaters.com/forum/index.php?topic=185917.0

Ok that worked TY so much Matim for your help

 

Problem solved**

 

//Request delete thread?

seeing as how the fix is already here at http://www.maxcheaters.com/forum/index.php?topic=185917.0

 

Locked.