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

    • asert88
      Need help with lineageefect.u

      By asert88 · Posted

      Hello! I need help with the file lineageeffect.u (Interlude client) I need to remove ForcedLifeTime from the following skills:   Battle Heal Greater Major Heal Hurricane Solar Flare Hydro Blast Aura Bolt Aura Flare Aura Flash   Thank you in advance for your help!
    • Meissgenry
      Image Masking Using Photoshop

      By Meissgenry · Posted

      Used to have the same issue managing all my masked files from different edits. What really helped me stay organized was this list: https://www.blueberry-ai.com/blog/12-best-digital-asset-management-software-for-photographers. Found a couple of tools there that make sorting, tagging, and finding assets way easier, especially when working on multiple projects or sharing with clients. Took a massive load off my workflow and saved me a lot of time digging through folders.
    • Tinker123aa
      IBServer for L2OFF GF-H5-GD-Classic

      By Tinker123aa · Posted

      IBServer for L2OFF GF-H5-GD-Classic I’m excited to share IBServer, a fully standalone authentication and billing server designed for Lineage II Official (L2OFF) Generations Supporting Gracia Final (GF), High Five (H5), Glory Days (GD), and Classic Year(2018-2020).   Key features: 🔌 Real IB Communication: Integrates directly with the L2OFF client protocol for in‑band packet handling. ⚙️ Zero Client/Server Modification: No changes required to L2Server.exe, no extenders, no hooks — plug and play. 🛠️ ODBC SQL Server Support: Built‑in DBManager C++ class for handling premium points, purchases, and account data via stored procedures. 📦 Complete Packet API: Full implementation of RequestCheckVersion, GetPremiumItems, GetGamePoint, AddGamePoint, BuyItem, DeleteItem, etc. 🚀 Ready to Deploy: Simple config.txt for port and connection string, runs as a native Windows service or console app.   Price: $150 USD (one‑time payment, no licensing restrictions — use on as many PCs as you want)   How to purchase & support: Please reply here or send me a private message on MaxCheaters. I’ll provide a compiled binary along with installation instructions.
    • Albert Scott
      Hello Everyone I need support for DEV l2JOrion

      By Albert Scott · Posted

      Hello everyone I'm Albert, Starting now with the dream on have a L2 server, I'm having several issues with RS and I need someone help to Create an skill and implement to the correct class ID and make it work. Skill Required from me is  Festival Sweep  Skill or Item with the ability. I really need help guys and then after if possible i would need NPC and skins with .dressme        
    • Tryskell
      aCis - another CRAPPY interlude server

      By Tryskell · Posted

      Changeset 410 (3371)   Makers, NpcAi / Desires, Cursed Weapon rework, Bugfixes, Admincommands, Movement, Organization   Makers Fix ghost corpses. Introduce task manager for MultiSpawn spawn schedule. Introduce task managers for Npc respawn and despawn tasks. Add missing random treasurebox maker. NpcAi / Desires AttackableAttack > NpcAttack, allowing ATTACK_FINISHED event over Npc. Merge all reduceWeight from NpcAI operations. Don't broadcast MoveToPawn packet for cast hold scenarii. CH and CP managers use hold cast. Probably way more to add. Rework DesireQueue#addOrUpdate to avoid to generate a List. Drop _isInHitAnimation, avoid twice runAI calls upon attack end animation, save a ThreadPool. Implement Desire#isInvalid, used over the main loop to clean invalid Desires. All sided getDesires().removeIf are dropped, notably over AggroList/HateList. Cursed Weapon rework Fix potential task scheduling issues, reworking the whole layers. Reduce code by 1/3. Use L2OFF formulas/data for item drop rate, staging process. CW end duration now decreases when killing other Players. Bugfixes Revert schedule part from ThreadPool. Fix Pet inventory IU. Ty Denzel for the report. Fix Pet item timestamp reuse delay. Ty artemis for the fix. Disable automatic beastshots when his owner dies. Ty Root for the report. Player cannot craft while casting a skill, nor trade. Ty Root for the report. Add missing weight checks for player/summon pickup, and player craft. Ty Root for the report. Implement /graduatelist command, which displays a list of clan academy graduates for the past week. Ty RooT for the report. Fix PLAYING_FOR_LONG_TIME concept ; rest message is server related, not Player related. Ty RooT for the report. Player should stop movement when opening store. Fix Q351 occurences of itemId 4310 by 4407 one + slight fix. Fix Q365 missing memoState + poison skillId. Ty Root for the report. Fix Q417 Torai despawn over cond 11. Fix Q216 4 missing npcIds. Ty Karudin for the report. Fix the invalid comment of DeleteCharAfterDays Config. Fix NPC drop penalty level calculation. Ty Bandnentans for the report. Items are now dropped in a 30/45 donut shape around dropper. Ty Bandnentans for the report. PartyMatch fixes Don't show Party members or CW holder as available waiting members. You can't show overall List or join a PartyMatch room as CW holder. CW owner, upon acquisition, leave PartyMatch system. PartyMatch window is now automatically closed upon Player#removeMeFromPartyMatch. Remove Player from PartyMatch if Player and newly joined Party leader PartyMatch rooms differ. You can't join or be invited in a PartyMatch room if already partying/CW holding. Fix ShowLicence config when set to false. Ty artemis for the fix. Fix maximum number of macros. Ty artemis for the fix. Fix invalid IU update over //enchant. Ty artemis for the fix. Fix Castle Mass Gatekeeper HTMs. Ty kingNik0n for the fix. Drop _disabledItems implementation. Won't be used by next refactors. Ty artemis for the report. Fix loading handlers under debug. Ty Keku for the fix. Fix character_macroses table structure (commands = 12x32 chars minimum). Admincommands Merge all old spawn admincommands (//list_spawns, //spawn, //unspawnall, //respawnall, //delete) to //spawn and //unspawn (previously //delete). Generate //help. //unspawn works over all ASpawn. Merge all old fence admincommands (//spawnfence, //deletefence, //listfence) to //fence [add|remove], generate AdminFence. They now use proper Pagination. You can also teleport to it. Implementation of //show manor. Implementation of //set quest <id> [cond]. Related items must be hand-given. Implementation of //set henna [page] [add|remove symbolId]. The hennas are still bound to game logic (slots, canBeUsedBy). Movement - Ty LaRoja, Bandnentans Fix Boats IOOBE. Adapt getHeight logic from L2OFF. Introduce back WASD movement, handle boat board/unboard. Fix WATER/FLY movement logic. Avoid to pathfind diagonal cells with detected obstacle. Organization Addition of QuestVars class, holding all related variables from quests (itemIds, npcIds, questNames, sounds, etc), allowing to reduce length of each script while reusing variables. 100+ cloned variables were deleted. Refactor geometry package and Territory. Territory is now a unique 3D shape, holding any type of 2D geometry.  Remove few useless Location#clone uses. Implementation of ItemContainer#forEachItem. Clean many unused FrequentSkill. The whole enum is questionable. Drop MathUtil#checkIfInRange, implement WorldObject#isInStrictRadius (involve collision of that WorldObject, and potential WorldObject parameter). WorldObject#isIn2DRadius parameter is now a Point2D, not a Location (since a Location inherits Point2D, Location are still usable as parameter). Rework Pagination#generatePages to handle page number > 1000. Use Pagination over Tryskell SchemeBuffer. Ty CUCU23 for the share.

  • Topics

×
×
  • Create New...