Jump to content
  • 0

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


Question

Posted

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

 

8 answers to this question

Recommended Posts

  • 0
Posted

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?

  • 0
Posted

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)

 

  • 0
Posted

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

  • 0
Posted

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

Guest
This topic is now closed to further replies.


  • Posts

    • Hey, any one can help me or tell advice how to make this shown damage on screen directly on enemy when im hitting it, becuase now this damage is located on my screen near my character. What script or what interface.u class i need modify?
    • Opening Date: Q4 2026 (exact date TBA) Chronicle: High Five (H5) Rates: Mob EXP/SP: low (secondary) | PvP EXP: main progression source (custom formula, exact rate TBA)   Hey everyone,   Announcing L2Berserk, a custom Lineage 2 High Five project currently in development. This is a solo project, so progress may take a bit longer than a full team would need — but it's moving forward steadily. The idea behind it is simple: most servers either force you into rigid factions or let PvP happen almost by accident while everyone grinds mobs for hours. L2Berserk is a crossover of both worlds — there's no faction split, no separate towns, everyone spawns and plays in one shared hub, but progression itself is built around fighting other players instead of farming spots. If you enjoy PvP more than staring at a bot-farming route, this is being built with you in mind.   Already implemented: Custom launcher — own CDN and updater, auto-detects your existing install so setup is fast and low-friction Tower of Trials — a 10-floor PvE dungeon, 3 monster waves per floor, difficulty scales as you climb; built as a solo/small-group challenge track separate from the PvP-EXP loop PvP Arena — an NPC that queues players into Party vs Party or Command Channel vs Command Channel arena matches on demand Olympiad — implemented and functional for structured 1v1/team PvP Event Manager — automated system running rotating events every 10 minutes non-stop, so there's always something active for players to jump into Single shared hub — no faction-locked zones; PvP-driven EXP progression is the main way you level PvP Zone — a dedicated zone avaiable through PvP Zone Teleport Scroll. Zones have boundaries so players won't run from pvp forever. Planned: Kill-streak rewards / bounty system — the more active you are in PvP, the more visible and rewarded you become PvP ranking / leaderboard with seasonal recognition More content and events Additional Discord integrations A live testing phase with the community before the official opening, so mechanics get stress-tested before Q4 A lot more features are planned beyond what's listed here — the project is still actively growing If you have suggestions, feel free to post them on Discord   A note on where things stand: the server is currently offline (0% uptime) — that's expected at this early stage, not a sign the project stalled. Following along and feedback from anyone interested in this kind of PvP-first server are very welcome.   Website: l2berserk.fun
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..