Jump to content
--> Place your ad text here <--
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team
  • 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


  • Posts

    • ratchet
      Help and Interlude+

      By ratchet · Posted

      interlude: l2acis uber alles
    • DNClassic
      Dragon-Network: The Survey

      By DNClassic · Posted

      New Dragon-Network Server – Vote Now!   We’re launching a new Dragon-Network (Multiskill) server under a new domain, created by the original Classic-Interlude team. We no longer have access to the old domain, but this is the official continuation — not a scam, just a new home. The new domain will host: A main migrated server (nothing lost – all chars/items kept) Plus seasonal servers (voted by players) All seasonal progress will be merged into the main realm Help shape the new server – vote now: https://dragon-network.eu/   Let’s build the future of DN – together.
    • tomlondon12
      ✅ Mass DM Panel | Instagram, Twitter, Telegram and Discord!

      By tomlondon12 · Posted

      We are taking new orders. DM us on Telegram!
    • Lezzz
      Help and Interlude+

      By Lezzz · Posted

      Hello there, Im beyond confused and dont know what path to take. I want to start working on a L2 server, changing some stuff here and there and finally in the future if  im happy with the results, to launch the server, but... L2j or L2off? After all this years, is there a Interlude L2j close to off?   Ive spent some time lookin over this forum, searching what would be better and what files to take but I ain't near to a clear answer.  Most of the time everyone is trowing stones at everyone, "your filles are trash, my filles are good" and viceversa. Therefore, Im reaching out to a knowledge guy, hopefully from a neutral position to all this drama, that can pin point me in a direction.    To explain what I want for a base start is an Interlude with a classic interface (features), low rate. Mostly what this guy TravorJ is describing in his post TravorJ post , and to do some reworks on it, ex: mobs drop, rethink the augment system/interface, rethink learning skills/enchant skills, create some custom potions/buff effects, siege mechanics... Is that possible on off files? or is better to go with L2j? I also want to mention that I have little to none L2 dev experince (13-15yrs ago I had an L2j server running  for a month where I made some basics changes), but I have coding background so Im used to that and more than willing to learn.   So in conclusion, I dont want to get some free shared files without any support, that I need to wrap my head around and fix stuff for long time to make them work, stuff thats already fixed buy someone else. Instead im looking to buy something thats more updated and start working from there. Question is what and from whom? Kinda sux when you go and buy something and u dont know what the hell are you buying (need some guidance here)   Is L2j Orion a good choice? I saw that is regularly updated. Lucera2 I dont think is something that I want cuz they dont sell soruce, prefer to have control and not to be dependent on someone to much...   Big thanks in advance!   
    • protoftw
      Graphic/Html Designs - Protojah

      By protoftw · Posted

      L2 INSIDE - HTML DESIGN     Portfolio - protojahdesigns.com You can also join Protojah Designs Discord

  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock