Jump to content
MaxCheaters Official Group on X
MaxCheaters Official Group on Discord
--> Place your ad text here <--
  • 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

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;

  • 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
  • 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'
  • 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

  • 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
  • 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

  • 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
  • 0
^Wyatt Newbie

^Wyatt

Posted
Posted

If you just only need custom npcs and so, it's way easier to save your custom_npc things and reinstall bd, then add your custom tables.

  • 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...

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


×
×
  • Create New...