Jump to content
  • 0

[Help]NPC Wont stay spawned?**[Problem Solved]


blindtolive
 Share

Question

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

 

Link to comment
Share on other sites

8 answers to this question

Recommended Posts

  • 0

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?

Link to comment
Share on other sites

  • 0

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)

 

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

  • 0

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

Link to comment
Share on other sites

  • 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

Link to comment
Share on other sites

  • 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.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share



×
×
  • Create New...