L2J Server

Server Version= 4173
Datapack Version= 7402


Hello everyone
I need information
what tables need to backup to save all from
pg, clan, castle, etc, etc?

I get an error at startup depends on some of the gameserver
table of clans but I can not solve.
This is the error:


12-mag-2010 21.16.57
com.l2jserver.gameserver.model.itemcontainer.ItemContainer restore
AVVERTENZA: could not restore container:
java.lang.NullPointerException
at com.l2jserver.gameserver.model.ClanWarehouse.getOwner(ClanWarehouse.java:39)
at com.l2jserver.gameserver.model.ClanWarehouse.getOwner(ClanWarehouse.java:22)
at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.restore(ItemContainer.java:636)
at com.l2jserver.gameserver.model.L2Clan.<init>(L2Clan.java:188)
at com.l2jserver.gameserver.datatables.ClanTable.<init>(ClanTable.java:93)
at com.l2jserver.gameserver.datatables.ClanTable.<init>(ClanTable.java:56)
at com.l2jserver.gameserver.datatables.ClanTable$SingletonHolder.<clinit>(ClanTable.java:528)
at com.l2jserver.gameserver.datatables.ClanTable.getInstance(ClanTable.java:64)
at com.l2jserver.gameserver.instancemanager.ClanHallManager.load(ClanHallManager.java:105)
at com.l2jserver.gameserver.instancemanager.ClanHallManager.<init>(ClanHallManager.java:61)
at com.l2jserver.gameserver.instancemanager.ClanHallManager.<init>(ClanHallManager.java:36)
at com.l2jserver.gameserver.instancemanager.ClanHallManager$SingletonHolder.<clinit>(ClanHallManager.java:250)
at com.l2jserver.gameserver.instancemanager.ClanHallManager.getInstance(ClanHallManager.java:47)
at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:214)
at com.l2jserver.gameserver.GameServer.main(GameServer.java:502)


THX

Solved

Navicat was not restored in the table Characters
correct missing some fields including "clanid" and "clan_privs.

LOL

how you fix it??, i have the same error after crash my server .

Replace the missing fields to fix it

Xaras2 wrote:Solved

Navicat was not restored in the table Characters
correct missing some fields including "clanid" and "clan_privs.

LOL

Don't use navicat for that kind of work

Database backup: To restore, run mysql.exe, then "connect l2jdb", then "source l2jdb_dump.sql". Not only very fast, but also you won't loose db entires - what navicat likes to do often...

And if you wan't a very good app, here's much much better than navicat: MySQL-Front

Hello,
I'm having the same problem after extracting backup to database.
From what i understand the error occurs when there is now owner of a clan in clan table.
Thus making it impossible to load clan warehouse items.
I'm trying to figure out a query that shows clans with no clan leader or leader.
Correct me if i'm wrong here. But if all clans have appropriate leader info this error should not take place.

after running this : i get 2 fields that do not match the rest.
normal value of clan_privs is 16777214
i gues if i change these 2 fields the error will stop.
Please correct me if i'm wrong.
Thank you for your time.

up.