NPC TABLE ERROR

[fokys]

Hello!

I use L2J Freya last rev!

Created few custom NPC's in custom_npc table!

Each time i reboot server i have to respawn them manualy,because i get this!

com.l2jserver.gameserver.datatables.SpawnTable addNewSpawn

WARNING: SpawnTable: Could not store spawn in the DB:Data truncation: Out of range value adjusted for column 'id' at row 1

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'id' at row 1

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

ID's for those NPC's are:1000005,7206,71000!

However i have NPC with id 1000004 and it can be spawned just fine!

I reboot server using admin panel!

[ucko1991]

Navicat => l2jdb => spawnlist => right button  => design table => on "id" this 'Type' must be  'int' and on this  'length' put  11.  and be happy ;]

 

look first line

 

like on screen

[reyhanbjk]

Navicat => l2jdb => spawnlist => right button  => design table => on "id" this 'Type' must be  'int' and on this  'length' put  11.  and be happy ;]

 

look first line

 

like on screen

 

You learned that from me? :P // BG: Туй от мен го научи, нали? :P

[maoq93]

Hello, I have the same problem that Fokys, and already I did what u says ucko1991, but the error continue.

 

SpawnTable: Couldnt 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 column "id" at row 1

etc..

[Small72]

I got this error aswell but followed the above instructions and so far ive not recieved it agian.

ucko1991 ty.got the error,then fixed it in 3 min with your help. :)

[Matim]

I got this error aswell but followed the above instructions and so far ive not recieved it agian.

ucko1991 ty.got the error,then fixed it in 3 min with your help. :)

 

As we can see problem is solved, locked.