L2J Server

» Find Revision
L2J Revision Number: 4514
L2JDP Revision Number: 7818

Now I use L2JDP Revision Number: 7829, L2J Revision Number: 4521 and old db L2J Revision Number: 4514, L2JDP Revision Number: 7818.

When I apply updates from the folder "updates": 20110103update.sql, 20110112update.sql, 20110210update.sql, 20110316update.sql I have problems running the game server.

show error

pzdc loopenb. sotri log!

SEVERE: Error while creating skill tree (Class ID 0): Unknown column 'is_transfer' in 'field list'

update your skill_trees table.

zippel wrote:» Find Revision
L2J Revision Number: 4514
L2JDP Revision Number: 7818

Now I use L2JDP Revision Number: 7829, L2J Revision Number: 4521 and old db L2J Revision Number: 4514, L2JDP Revision Number: 7818.

When I apply updates from the folder "updates": 20110103update.sql, 20110112update.sql, 20110210update.sql, 20110316update.sql I have problems running the game server.

error0.zip

try and take the time to read the error it is not hard to work it out as it tells you what the problem is

updates": 20110103update.sql, 20110112update.sql, 20110210update.sql, 20110316update.sql
pzdc. What a skill trees?! What are you...

I apply 20110103update.sql, 20110112update.sql, 20110210update.sql, 20110316update.sql updates.
какой в пиз..у skill_trees?

If I insert a blank database with a ought - that works fine. If you upgrade an old - an error.

Then either you applied the updates incorrectly or you haven't applied all updates.
Or maybe there's smth wrong with the updates, but you can always try to apply them manually.

mde... Errors in log, log into a archive.
In short, I'll reinstalled the server. it's better ...

I used the upgrade - as soon as possible.

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

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'npc_templateid' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3601)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)
at com.l2jserver.gameserver.datatables.SpawnTable.addNewSpawn(SpawnTable.java:256)
at handlers.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java:383)
at handlers.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.java:267)
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:1001)
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)

WTF ???

see custom_spawnlist.sql
must be less than 7 digits npc_templateid.

dont worry ,that dialog message is normally.

now, delete your custom_spawnlist table.
then run database_installer.bat
and edit General.properties file: CustomSpawnlistTable=TRUE

Ok, I do it...