[HELP]Spawn

[Soulmaster]

Hello :) i just spawned a lot of NPC / Mobs on my game , done farming zones and stuff , i restarted the server and puff all gone ...

i checked my gameserver and i get the following error :(( can you please help me :-s

 

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)

 

[Tryskell]

Do a search, this problem is recurrent and solution have been already posted.

[Soulmaster]

Thanks :D Problem solved :)

[Matim]

Thanks :D Problem solved :)

 

Locked.