Table Backup

[Xaras2]

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

[Xaras2]

Solved

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

LOL

[bady]

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

Code: Select all

Loaded 30 forums. Last forum id used: 32 Cache[Crest]: 0,004MB on 19 files loaded. (Forget Time: 300s , Capacity: 50) 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:521)    at com.l2jserver.gameserver.datatables.ClanTable.getInstance(ClanTable.java:64)    at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:256)    at com.l2jserver.gameserver.GameServer.main(GameServer.java:504)  Restored 31 clans from the database. Initializing ClanHallManager Initializing AuctionManager Loaded: 33 auction(s) Loaded: 5 clan halls Loaded: 39 free clan hall

[hope]

Replace the missing fields to fix it

[Szponiasty]

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:

Code: Select all

 mysqldump.exe -u your_db_login --password=yourdb_password l2jdb > l2jdb_dump.sql 

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

[n0name12]

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 :

Code: Select all

select clan_data.leader_id, characters.charId, characters.char_name, characters.clanid, characters.clan_privsfrom clan_dataleft join characterson clan_data.leader_id = characters.charId;

i get 2 fields that do not match the rest.

Code: Select all

269997692   269997692    YYYYY  0   0 

Code: Select all

269432931   269432931   XXXXX   269780138          311294 

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.

[n0name12]

up.