Jump to content
MaxCheaters Official Group on X
MaxCheaters Official Group on Discord
  • 0

[L2J Frozen] Wipe

Akken

Asked by Akken,

 Share

Question

Akken Newbie

Akken

Posted
Posted (edited)

when i wipe i get some errors like so if someone can give me the correct l2jfrozen db tables to empty this will be solved

Error loading minion data: java.lang.NullPointerException
================================================================-[ Characters
LevelUpData: Loaded 89 Character Level Up Templates.
HennaTable: Loaded 180 Templates.
HennaTreeTable: Loaded 7128 Henna Tree Templates.
Helper Buff Table: Loaded 14 Templates.
====================================================-[ Geodata - Path Finding
Geo Engine: - Loading Geodata...
PathFinding Engine: - Loading Path Nodes...
===================================================================-[ Economy
TradeController: Loaded 578 Buylists.
TradeController: Loaded 120 Limited Buylists.
TradeController: Loaded 0 Custom Buylists.
================================================================-[ Clan Halls
Initializing ClanHallManager
java.lang.NullPointerException
Initializing AuctionManager
        at com.l2jfrozen.gameserver.model.entity.ClanHall$FeeTask.run(ClanHall
ava:692)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
access$301(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Sour
)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Loaded: 20 auction(s)
java.lang.NullPointerException
        at com.l2jfrozen.gameserver.model.entity.ClanHall$FeeTask.run(ClanHall
ava:692)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
access$301(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Sour
)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
        at com.l2jfrozen.gameserver.model.entity.ClanHall$FeeTask.run(ClanHall
ava:692)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
access$301(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Sour
)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
        at com.l2jfrozen.gameserver.model.entity.ClanHall$FeeTask.run(ClanHall
ava:692)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
access$301(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Sour
)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Exception: Auction.initNPC(): Duplicate entry 'ClanHall-33-0' for key 'PRIMARY
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Du
icate entry 'ClanHall-33-0' for key 'PRIMARY'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Metho
 
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Sourc
 
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown S
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.
va:2086)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:136
 
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxy
eparedStatement.java:989)
        at com.l2jfrozen.gameserver.managers.AuctionManager.initNPC(AuctionMan
er.java:224)
        at com.l2jfrozen.gameserver.managers.ClanHallManager.load(ClanHallMana
r.java:119)
        at com.l2jfrozen.gameserver.managers.ClanHallManager.<init>(ClanHallMa
ger.java:62)
        at com.l2jfrozen.gameserver.managers.ClanHallManager.getInstance(ClanH
lManager.java:48)
        at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:283)
 
java.lang.NullPointerException
        at com.l2jfrozen.gameserver.model.entity.ClanHall$FeeTask.run(ClanHall
ava:692)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
access$301(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Sour
)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
        at com.l2jfrozen.gameserver.model.entity.ClanHall$FeeTask.run(ClanHall
ava:692)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
access$301(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Sour
)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
        at com.l2jfrozen.gameserver.model.entity.ClanHall$FeeTask.run(ClanHall
ava:692)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
access$301(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTas
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Sour
)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run..
Edited by Akken
Link to comment
Share on other sites

15 answers to this question

Recommended Posts

  • 0
Akken Newbie

Akken

Posted
  • Author
Posted
 heroes;

itemsonground;

 pkkills;

rebirth_manager;


 accounts;

 characters;

 auction_bid;

auction_watch;

augumentations;

 characters_custom_data;

character_friends;

character_hennas;

 character_macroses;

 character_offline_trade;

 character_offline_trade_items;

 character_quests;

 character_raid_points;

character_recipebook;

character_recommends;

character_subclasses;

 clan_data;

clan_notices;

 clan_privs;

clan_skills;

clan_subpledges;

 clan_wars;

Link to comment
Share on other sites
  • 0
Akken Newbie

Akken

Posted
  • Author
Posted (edited)

bah i will post my db so if someone tell me the correct ones

 

image.jpg

 

 

 

and here is my sql code

 

DELETE FROM accounts;
DELETE FROM characters;
DELETE FROM auction_bid;
DELETE FROM auction_watch;
DELETE FROM augumentations;
DELETE FROM characters_custom_data;
DELETE FROM character_friends;
DELETE FROM character_hennas;
DELETE FROM character_macroses;
DELETE FROM character_offline_trade;
DELETE FROM character_offline_trade_items;
DELETE FROM character_quests;
DELETE FROM character_raid_points;
DELETE FROM character_recipebook;
DELETE FROM character_recommends;
DELETE FROM character_subclasses;
DELETE FROM clan_data;
DELETE FROM clan_notices;
DELETE FROM clan_privs;
DELETE FROM clan_skills;
DELETE FROM clan_subpledges;
DELETE FROM clan_wars;
DELETE FROM heroes;
DELETE FROM itemsonground;
DELETE FROM pkkills;
Edited by Akken
Link to comment
Share on other sites
  • 0
FirefoxAurora Newbie

FirefoxAurora

Posted
Posted

Take a look @

 

  1. Initializing AuctionManager         at com.l2jfrozen.gameserver.model.entity.ClanHall$FeeTask.run(ClanHall ava:692)
  2. Exception: Auction.initNPC(): Duplicate entry 'ClanHall-33-0' for key 'PRIMARY
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Du
    icate entry '    ClanHall-33-0' for key 'PRIMARY'
Link to comment
Share on other sites
  • 0
^Wyatt Newbie

^Wyatt

Posted
Posted

Take a look @

  • Initializing AuctionManager         at com.l2jfrozen.gameserver.model.entity.ClanHall$FeeTask.run(ClanHall ava:692)
  • Exception: Auction.initNPC(): Duplicate entry 'ClanHall-33-0' for key 'PRIMARY

    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Du

    icate entry 'ClanHall-33-0' for key 'PRIMARY'

He said "that error is fixed" :?

this error is fixed now i get scripts errors if you need the error tell me

Link to comment
Share on other sites
  • 0
^Wyatt Newbie

^Wyatt

Posted
Posted (edited)

@author

why u say that the error is fixed and then u ask to me if I want you to post the error, I say yes and you post your bd? where is the error ;(

Edited by ^Wyatt
Link to comment
Share on other sites
  • 0
Guest Elfocrash

Guest Elfocrash

Posted
Posted

Oh god.. Just run again the database isntallation from the tools folder and deleted te existing one.

You fucked up deleting something you need such us the auction_bid

Link to comment
Share on other sites
  • 0
Akken Newbie

Akken

Posted
  • Author
Posted (edited)

server is fully custom i just dont need the characters if i delete chars only i got full of duplicates and npes... not that stupid to make a server all over again in the custom db .. so why to reinstall it just need the tables

 

 

the next error comes from ais just ass all quests give me errors for no reason.. so i guess i fucked up something when i delete a non must table.. so which table am i suppose to empty so i dont have the crappy chars in my db

Edited by Akken
Link to comment
Share on other sites
  • 0
^Wyatt Newbie

^Wyatt

Posted
Posted

Even if your db is fully custom, it's way easier to reinstall and add your customs...

With the list you showed it seems that any of that tables can generate that error...

Link to comment
Share on other sites

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.

×
 Share
Go to question listing


  • Posts

    • vgc.sys
      WIP Free Assasins Interface for Interlude

      By vgc.sys · Posted

      I don't care what these random rats are typing to me. I will ruin their business for scamming other people's work. I'm very good at it, no matter what protection or obfuscation they add to their files. I will break them and share everything for free with the community that's what they deserve.
    • Warendo
      Dark Dragon New Era

      By Warendo · Posted

    • Warendo
      [L2J] Dark Dragon

      By Warendo · Posted

    • Vraekar
      WIP Free Assasins Interface for Interlude

      By Vraekar · Posted

      Look are you crazy or dumb? yes, im aware of this post, but i have NOTHING to do with it! unfortunately, when people sent me this post i even thought it was strange, and when i downloaded the server and the files really are without any protection, what do you want me to do about it? the reality is that im not even up to date on anything about Lineage anymore... im doing my things peacefully, bothering nobody.. He is talking about me, this guy is saying im the one who leaked or anyhting
    • HyperBlown
      Celsas, Interface (Re)-Seller

      By HyperBlown · Posted

      Ps: I do know the guy, talked with him before, a few friends have bought stuff from him in the past and never had any issue. But hey, It happend so I'm posting it here. If he somehow answers back and sends the interface I will delete this post. A few days ago he made contact with me saying he had interface 474 code to sell. And since I also develop interfaces, I was interested in buying.   He told me the price, said he only accepted advcash/volet. I asked if he had any other crypto wallet or paypal email. He said no. After a while, he came back with a paypal email, in which we sent the money. But since its a new account, paypal blocked it for safekeeping. After this, he returned the money and we went to check on how to make a advcash/volet account. After a bit, we successfully created a "volet" account and transferred the money to him in 2 parts. 5 EUR first to check if he received the correct amount and later the 595 remaining to complete the 600 EUR for the asked price of the interface code and editors for it. His last message was on the 25th of September saying he wasn't home. Haven't heard from him since. I asked a friend of mine if he was legit and if he worked far from home and he did confirm this for me. But still. I would at least expect him to keep in touch with me to update his whereabouts and saying if he would need more time to arrive home. Here are the screens with the full discord conversation:    

  • Topics

×
×
  • Create New...