problem spawn custom

[JavierDC]

when spawn a npc, get this error.
en castellano
cuando spawn un npc, sale este error.


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)
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.java:2113)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.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.java:180)
at com.l2jserver.gameserver.network.clientpackets.SendBypassBuildCmd.runImpl(SendBypassBuildCmd.java:79)
at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)
at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:997)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)


fix

Code: Select all

 Index: E:/todo l2j/developer l2/l2j/datapack_development_freya/sql/spawnlist.sql===================================================================--- E:/todo l2j/developer l2/l2j/datapack_development_freya/sql/spawnlist.sql   (revision 7672)+++ E:/todo l2j/developer l2/l2j/datapack_development_freya/sql/spawnlist.sql   (working copy)@@ -1,6 +1,6 @@ DROP TABLE IF EXISTS `spawnlist`; CREATE TABLE `spawnlist` (-  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,+  `id` mediumint(7) unsigned NOT NULL AUTO_INCREMENT,   `location` varchar(40) NOT NULL DEFAULT '',   `count` tinyint(1) unsigned NOT NULL DEFAULT '0',   `npc_templateid` smallint(5) unsigned NOT NULL DEFAULT '0',Index: E:/todo l2j/developer l2/l2j/datapack_development_freya/sql/custom/custom_spawnlist.sql===================================================================--- E:/todo l2j/developer l2/l2j/datapack_development_freya/sql/custom/custom_spawnlist.sql (revision 7672)+++ E:/todo l2j/developer l2/l2j/datapack_development_freya/sql/custom/custom_spawnlist.sql (working copy)@@ -1,5 +1,5 @@ CREATE TABLE IF NOT EXISTS `custom_spawnlist` (-  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,+  `id` mediumint(7) unsigned NOT NULL AUTO_INCREMENT,   `location` varchar(40) NOT NULL DEFAULT '',   `count` tinyint(1) unsigned NOT NULL DEFAULT '0',   `npc_templateid` mediumint(7) unsigned NOT NULL DEFAULT '0',  

this to whatever you put in General.properties configuration
en castellano
este para cualquiera sea la configuracion que coloquen en General.properties

[Edelvez]

I have it as follows and it works wonderfully

Code: Select all

Index: D:/Server Packs/L2J Server/Freya/DP/sql/spawnlist.sql===================================================================--- D:/Server Packs/L2J Server/Freya/DP/sql/spawnlist.sql   (revision 7672)+++ D:/Server Packs/L2J Server/Freya/DP/sql/spawnlist.sql   (working copy)@@ -1,6 +1,6 @@ DROP TABLE IF EXISTS `spawnlist`; CREATE TABLE `spawnlist` (-  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,+  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,   `location` varchar(40) NOT NULL DEFAULT '',   `count` tinyint(1) unsigned NOT NULL DEFAULT '0',   `npc_templateid` smallint(5) unsigned NOT NULL DEFAULT '0',Index: D:/Server Packs/L2J Server/Freya/DP/sql/custom/custom_spawnlist.sql===================================================================--- D:/Server Packs/L2J Server/Freya/DP/sql/custom/custom_spawnlist.sql (revision 7672)+++ D:/Server Packs/L2J Server/Freya/DP/sql/custom/custom_spawnlist.sql (working copy)@@ -1,5 +1,5 @@ CREATE TABLE IF NOT EXISTS `custom_spawnlist` (-  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,+  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,   `location` varchar(40) NOT NULL DEFAULT '',   `count` tinyint(1) unsigned NOT NULL DEFAULT '0',   `npc_templateid` mediumint(7) unsigned NOT NULL DEFAULT '0',

[denser]

dont forget about custom_droplist - there too tinyint