Jump to content
  • 0

[Help]Class Trader Dissapear


Question

Posted

Hello, I'm using L2jFrozen 1118rev, and I have one problem. I spawn roy the cat(31228), he working perfectly, but after server restart he disappear and it exist in db, spawnlist. With other NPC's is everything right. GameServer doesn't show any errors. What should I do?

 

10 answers to this question

Recommended Posts

  • 0
Posted

gameserver/config/functions/l2jfrozen.properties

lines 39-52

# --------------------------
#  Custom Tables -
# --------------------------
# Enable / Disable custom tables.
# The rest of the custom tables are already activated.

# Custom Spawnlist Table
CustomSpawnlistTable = True

# Gm Spawn gets saved on custom_spawnlist Table?
SaveGmSpawnOnCustom = True

# Gm Spawn gets deleted on custom_spawnlist Table?
DeleteGmSpawnOnCustom = True
  • 0
Posted

There is a stupid config to save (custom) spawns in database. You have to search for it. I don't know the config name, nor directory. Else wait till someone who was/is using frozen reply with the exact place.

  • 0
Posted (edited)

Like SweeTs said 

Go to Config/Functions and open l2jfrozen.properties

and find this line
 

 

# Custom Spawnlist Table

CustomSpawnlistTable = True
 
Edit : Damn Spirako xD
Edited by Alexi
  • 0
Posted (edited)
 

not solved! Still dissapear's!

It must work, otherwise you need to intall some custom spawn table. I will not be surprised if it's necessary..

 

Also, don't expect changes if you had server running.

Edited by SweeTs
  • 0
Posted

 

 
 

It must work, otherwise you need to intall some custom spawn table. I will not be surprised if it's necessary..

 

Also, don't expect changes if you had server running.

 

 

 

Well, there is already custom spawn table, other custom npcs working perfectly, and don't disappear after server restart.

  • 0
Posted (edited)

Search for another config then, class master related. I bet there is :happyforever:

 

Such a lol pack.

Edited by SweeTs
  • 0
Posted

I saw one error today.

ERROR SpawnTable: Could not store spawn in the DB
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '4755' for key 'PRIMARY'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        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.l2jfrozen.gameserver.datatables.sql.SpawnTable.addNewSpawn(SpawnTable.java:314)
        at com.l2jfrozen.gameserver.handler.admincommandhandlers.AdminSpawn.spawnMonster(AdminSpawn.java:293)
        at com.l2jfrozen.gameserver.handler.admincommandhandlers.AdminSpawn.useAdminCommand(AdminSpawn.java:173)
        at com.l2jfrozen.gameserver.network.clientpackets.SendBypassBuildCmd.runImpl(SendBypassBuildCmd.java:76)
        at com.l2jfrozen.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:77)
        at com.l2jfrozen.gameserver.network.L2GameClient.run(L2GameClient.java:1213)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
  • 0
Posted

ERROR SpawnTable

Duplicate entry '4755' for key 'PRIMARY'

 

You already have a spawnlist with this id in your spawnlist table , if you tried to add something just change the id.

  • 0
Posted

ERROR SpawnTable

Duplicate entry '4755' for key 'PRIMARY'

 

You already have a spawnlist with this id in your spawnlist table , if you tried to add something just change the id.

 

already tryied that.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...