Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing
  • 0

[L2J Frozen] Wipe

Akken

Asked by Akken,

 Share

Question

Akken Iron Initiate

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 Iron Initiate

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 Iron Initiate

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 Iron Initiate

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 Iron Initiate

^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 Iron Initiate

^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 Iron Initiate

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 Iron Initiate

^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 Iron Initiate

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing


  • Posts

    • Databay
      █ 7,000,000+ RESIDENTIAL PROXIES ✅ FROM 0.65$ / GB █

      By Databay · Posted

      This is a bump
    • aguy
      [L2J] MAYHEM

      By aguy · Posted

      When you say bots allowed, it means we are allowed to use adrenaline ?
    • M4yh3m
      [L2J] MAYHEM

      By M4yh3m · Posted

      https://l2mayhem.ru/   The Mayhem Server is designed for players who want to enjoy the game without unnecessary stress or steep barriers. We focus on a comfortable gaming experience: the mechanics are adapted so that even newcomers can get up to speed quickly, while veterans will be happy to return to the beloved universe. On the server, character progression and content difficulty are well balanced: your character develops steadily, without the need to spend huge amounts of time on repetitive tasks. For players’ convenience, we’ve implemented autofarm - it lets you complete daily tasks efficiently. Moreover, bots are officially allowed on the server: they help automate routine actions, so you can focus on the most exciting parts of the game - sieges, PvP, clan wars, and crafting. The server’s atmosphere is friendly: the active community is always ready to offer advice, and the administration ensures order and fairness. Whether you’re looking for a relaxed leveling and world‑exploration experience or want to take part in intense events, everyone can find their own pace and playstyle here. Right now, the server features new activities: we’ve added new instances and locations with unique mechanics and rewards, as well as rare items that can only be obtained in these zones. This is a great chance to get powerful gear and stand out among other players.   Rates: - Grind: EXP/SP x3 (Raid Bosses: x3). - Loot: Drop/Spoil/Adena x3; Raid/Epic Raid drops x3. - Quests: All rewards x1.   Gameplay: - Accounts are created automatically. - Mammons is located in the Town of Giran. - Each character has access to the unlimited Auto Farm function. - Mass party functions activated by the party leader. - A pre-installed shortcut panel is provided for each new character. - The full list of chat commands is available on the Community Board. - Players have a x25 weight limit and an increased inventory capacity. - All buffs, dances, and songs last for 2 hours. - Spawn protection lasts 10 seconds after teleporting. - Treasure Chests have been removed from spawns. - Cursed Weapons have been removed from drops. - Common items can no longer be purchased or obtained as drops. - Mobs and Raid Bosses no longer use Cancel skill. - Equipment up to the Dynasty can be purchased with adena. - Shots up to S grade and consumables are available in the Community Board. - Offline shops are supported: simply set up a shop and type the .offline command in chat. - No drop penalty on Raid Bosses unless the player is over 5 levels higher than the boss; otherwise, the drop chance is reduced. - Mana Potions restore 1500 MP and have a 10‑second reuse time. Newbie Mana Potions restore 500 MP. - The Vitality, Nevit, and Recommendations systems have been disabled. - The store now offers a lower buy price for player‑sold items. - NPC Victor visits Town of Giran on Wednesdays and Saturdays for gear/doll upgrades and elemental exchange. - Once you hit level 40, every mob can drop one of three medals: Bronze, Silver, or Gold.   Premium: - +35% to EXP/SP, Adena, Seal Stones, Element Stones, and Epaulette drops. - Buffs, dances, and songs last 3 hours. - With Premium, players can get 3‑hour buffs by purchasing them from other players.   Enchanting: - The chance to successfully enchant gear is 65%. Safe enchantment is up to +3; the maximum enchant level is +20. - Elemental Stones: 50% chance. Elemental Crystals: 30% chance.   Skills: - Auto‑learn all skills and Forgotten Skills. - 30 buff slots, 12 Dance/Song slots. - Subclass max level raised to 85.   Quests: - 25 000 Adena is required to obtain the 1st class; 250 000 Adena for the 2nd class; 10 000 000 Adena for the 3rd class. - The subclass quest is not required. - The Freya quest is not required. - The Hard Freya quest is not required. - Access to Frintezza is granted only after completing the quest or upon having the purchased quest item. - Access to Baium is granted only after completing the quest or upon having the purchased quest item. - Access to Antharas is granted only after completing the quest or upon having the purchased quest item. - Access to Valakas is granted only after completing the quest or upon having the purchased quest item. - Hellbound progression is at level 1.   Olympiad: - Olympiads are held monthly. - Enchantment limit is +6. - Starting Olympiad requires 6 characters. - You need 15 battles to receive a reward. - Only non‑class battles are available.   Sieges/Territory Wars: - Flags are returned to their owners at the start of each Territory War, which occurs every 2 weeks. - A clan’s maximum number of captured flags in TW is 3.   Raid Bosses/Epic Bosses/Instance Features: - RB status is available on the Community Board. - Freya - 6-27 chars to enter. - Hard Freya - 6-27 chars to enter. - Frintezza - 6-45 chars to enter. - Ultra Daytime Zaken - 6-9 chars to enter. - Daytime Zaken - 6-9 chars to enter. - Nightly Zaken - 6-450 chars to enter. - Tiat - 9-45 chars to enter. - Beleth - 9 chars to enter. - Day/night restrictions for all Zaken instances have been removed. - Level‑limited zones: Ant Nest (levels 1–45), Sea of Spores (levels 1–56), Core (levels 1–56). - Almost all Raid Bosses listed in the Community Board drop an Enchanting Box with a 100% chance. - New Raid Bosses and their jewelry have been added. Teleport to these bosses via NPC Mirelle in Town of Giran. - New Instances: dolls, timed epic jewelry, and upgrade item for cloaks, bracelets, and accessories. Enter via NPC Ancient Portal in Town of Giran; 6-9 chars to enter.
    • leoleandro
      WTB Cloack's classic for Interlude

      By leoleandro · Posted

      Estou procurando cloacks do classic adaptadas para cliente interlude.
    • L2Empires
      [Interlude x1000] L2 Empire | Looking for testers

      By L2Empires · Posted

      10 Raid Bosses. PvP every 3 hours. Zero donations.   Welcome to L2 Empire. Interlude. x1000. Pure PvP. No donation shop. Not even "cosmetics only". Nothing. Everything in this game drops, gets farmed, or gets taken from someone else. Before we open the gates, we want real players to try to break it.   ⚔️ WHAT'S WAITING FOR YOU - Level 80 from the start, gear from the Starter Voucher, free buffs - Soulshots, spiritshots and potions: free, forever - 10 Raid Bosses on a fixed schedule, 4 arenas, everyone around them flagged - PvP Zone every 3 hours, Team vs Team, 1v1 Tournament, Olympiad, Sieges - Revenge: someone killed you? Get him within 10 minutes for double coins - Solo Dungeon, Player Market, weekly rankings, Hall of Fame - Our own anti cheat. One client per PC. Bots get nothing but a ban.   📡 A DISCORD CONNECTED TO THE GAME Our Discord is not just a chat. It lives with the server: - Live Raid Boss board: which boss is up, where, and when the next one comes - Every event on a countdown, shown in YOUR own time zone - Kill streaks, raid kills and weekly rankings posted live from the game - Link your character and get your PvP rank as a Discord role - The weekly PvP King, crowned on Discord - Your own stats with one command - Support tickets in English, Greek, Spanish and Portuguese - Development updates and sneak peeks before anyone else   🛠️ WHY WE NEED YOU The server is still being built, and we won't pretend otherwise. We want the bugs found now, not on launch night. We want clan leaders to tell us what their clan needs. We want to hear what you always hated on other servers, so it's not here.   🎖️ WHAT YOU GET Every tester gets an exclusive Beta Hero armor skin, forever. Keep the stats of your own armor, wear the look nobody else can ever get. You'll be the ones everyone recognizes as the first of L2 Empire.   👉 JOIN US: https://discord.gg/kQjk9md7fX Testers are picked on the Discord. See you in Giran. L2 Empire

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..