Сообщений в этой теме

[l2-mega]

MySQL 5.0, java 6, Navicat for MySQL 8.0.20, ОС linux.

Роботал сервер, всё было отлично! Здесь мне бредовая мысль пришла нарыть в нете за конец 2008 года платную сборку базы и я что то нарыл. Сделал бекап таблиц:

Код

accounts
character_friends
character_hennas
character_macroses
character_quests
character_recipebook
character_recommends
character_shortcuts
character_skills
character_skills_save
character_subclasses
characters
clan_data
clan_skills
clan_subpledges
items
heroes
olympiad_nobles
augmentations

И создал бекап отдельно других обектов БД

Поставил сборку, установил её БД залил SQL бекапа назад (Без ошибок) но при запуске гейма ужас. (всё в ошибках)
Когда ставил другой сервер заменил все файлы кромe папки config, анонсы и велком.хтм так как конфиг идентичные

Ладно, решил я востановить старую сборку и не парить мозги.
Востановил сборку(Поставил старую) залил оба бекапа что сохрянял (Всю БД) Но при запуске гейм сервера проблемы:

[spoil]

Код

...java.lang.NullPointerException
        at net.sf.l2j.gameserver.skills.DocumentBase.attachSkill(DocumentBase.java:271)
        at net.sf.l2j.gameserver.skills.DocumentBase.parseTemplate(DocumentBase.java:143)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:147)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:101)
        at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:93)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:159)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:129)
        at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:242)
        at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:168)
        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:296)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:664)

Error in file /home/xxx/server_C6/data/stats/weapon/4600-4699.xml
java.lang.NullPointerException
        at net.sf.l2j.gameserver.skills.DocumentBase.attachSkill(DocumentBase.java:271)
        at net.sf.l2j.gameserver.skills.DocumentBase.parseTemplate(DocumentBase.java:143)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:147)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:101)
        at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:93)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:159)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:129)
        at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:242)
        at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:168)
        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:296)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:664)

Error in file /home/xxx/server_C6/data/stats/weapon/7800-7899.xml
java.lang.NullPointerException
        at net.sf.l2j.gameserver.templates.L2Weapon.<init>(L2Weapon.java:113)
        at net.sf.l2j.gameserver.skills.DocumentItem.makeItem(DocumentItem.java:157)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:146)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:101)
        at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:93)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:159)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:129)
        at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:242)
        at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:168)
        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:296)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:664)

Error in file /home/xxx/server_C6/data/stats/weapon/5600-5699.xml
java.lang.NullPointerException
        at net.sf.l2j.gameserver.skills.DocumentBase.attachSkill(DocumentBase.java:271)
        at net.sf.l2j.gameserver.skills.DocumentBase.parseTemplate(DocumentBase.java:143)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:147)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:101)
        at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:93)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:159)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:129)
        at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:242)
        at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:168)
        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:296)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:664)

Error in file /home/xxx/server_C6/data/stats/weapon/7700-7799.xml
java.lang.NullPointerException
        at net.sf.l2j.gameserver.templates.L2Weapon.<init>(L2Weapon.java:113)
        at net.sf.l2j.gameserver.skills.DocumentItem.makeItem(DocumentItem.java:157)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:146)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:101)
        at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:93)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:159)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:129)
        at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:242)
        at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:168)
        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:296)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:664)

Error in file /home/xxx/server_C6/data/stats/weapon/4700-4799.xml
java.lang.NullPointerException
        at net.sf.l2j.gameserver.skills.DocumentBase.attachSkill(DocumentBase.java:271)
        at net.sf.l2j.gameserver.skills.DocumentBase.parseTemplate(DocumentBase.java:143)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:147)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:101)
        at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:93)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:159)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:129)
        at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:242)
        at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:168)
        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:296)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:664)

Error in file /home/xxx/server_C6/data/stats/weapon/8100-8199.xml
java.lang.NullPointerException
        at net.sf.l2j.gameserver.skills.DocumentBase.attachSkill(DocumentBase.java:271)
        at net.sf.l2j.gameserver.skills.DocumentBase.parseTemplate(DocumentBase.java:143)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:147)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:101)
        at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:93)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:159)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:129)
        at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:242)
        at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:168)
        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:296)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:664)

Error in file /home/xxx/server_C6/data/stats/weapon/4900-4999.xml
java.lang.NullPointerException
        at net.sf.l2j.gameserver.skills.DocumentBase.attachSkill(DocumentBase.java:271)
        at net.sf.l2j.gameserver.skills.DocumentBase.parseTemplate(DocumentBase.java:143)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:147)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:101)
        at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:93)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:159)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:129)
        at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:242)
        at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:168)
        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:296)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:664)

Error in file /home/xxx/server_C6/data/stats/weapon/8700-8799.xml
java.lang.NullPointerException
        at net.sf.l2j.gameserver.skills.DocumentBase.attachSkill(DocumentBase.java:271)
        at net.sf.l2j.gameserver.skills.DocumentBase.parseTemplate(DocumentBase.java:143)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:147)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:101)
        at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:93)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:159)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:129)
        at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:242)
        at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:168)
        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:296)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:664)

Error in file /home/xxx/server_C6/data/stats/weapon/7500-7599.xml
java.lang.NullPointerException
        at net.sf.l2j.gameserver.skills.DocumentBase.attachSkill(DocumentBase.java:271)
        at net.sf.l2j.gameserver.skills.DocumentBase.parseTemplate(DocumentBase.java:143)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:147)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:101)
        at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:93)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:159)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:129)
        at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:242)
        at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:168)
        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:296)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:664)

Error in file /home/xxx/server_C6/data/stats/weapon/6300-6399.xml
java.lang.NullPointerException
        at net.sf.l2j.gameserver.skills.DocumentBase.attachSkill(DocumentBase.java:271)
        at net.sf.l2j.gameserver.skills.DocumentBase.parseTemplate(DocumentBase.java:143)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseItem(DocumentItem.java:147)
        at net.sf.l2j.gameserver.skills.DocumentItem.parseDocument(DocumentItem.java:101)
        at net.sf.l2j.gameserver.skills.DocumentBase.parse(DocumentBase.java:93)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadData(SkillsEngine.java:159)
        at net.sf.l2j.gameserver.skills.SkillsEngine.loadWeapons(SkillsEngine.java:129)
        at net.sf.l2j.gameserver.datatables.ItemTable.<init>(ItemTable.java:242)
        at net.sf.l2j.gameserver.datatables.ItemTable.getInstance(ItemTable.java:168)
        at net.sf.l2j.gameserver.GameServer.<init>(GameServer.java:296)
        at net.sf.l2j.gameserver.GameServer.main(GameServer.java:664)

ItemTable: Loaded 865 Weapons.
Extractable items data: Loaded 333 extractable items!
Summon items data: Loaded 14 summon items.
TradeController: Loaded 502 Buylists.
TradeController: Loaded 120 Limited Buylists.
Initializing Walkers Routes Table.
WalkerRoutesTable: Loaded 222 Npc Walker Routes.
RecipeController: Loaded 871 Recipes.
SkillTreeTable: Loaded 35613 skills.
FishingSkillTreeTable: Loaded 109 general skills.
FishingSkillTreeTable: Loaded 8 dwarven skills.
EnchantSkillTreeTable: Loaded 13200 enchant skills.
PledgeSkillTreeTable: Loaded 64 pledge skills
ArmorSetsTable: Loaded 51 armor sets.
FishTable: Loaded 270 Fishes.
SkillSpellbookTable: Loaded 334 Spellbooks.
CharTemplateTable: Loaded 89 Character Templates.
Cache[HTML]: Running lazy cache
Cache[Crest]: 0,000MB on 0 files loaded. (Forget Time: 300s , Capacity: 50)
Could not restore clan skills: java.lang.NullPointerException
L2World: Setting up World Regions
L2World: (87 by 128) World Region Grid set up.
Could not restore clan skills: java.lang.NullPointerException
Item item_id=5643 not known, object_id=269165956
Could not restore clan skills: java.lang.NullPointerException
Item item_id=4822 not known, object_id=268500481
Could not restore clan skills: java.lang.NullPointerException
Item item_id=5612 not known, object_id=268855006
Could not restore clan skills: java.lang.NullPointerException
Item item_id=4806 not known, object_id=268487292
Could not restore clan skills: java.lang.NullPointerException
Item item_id=6315 not known, object_id=268924632
Could not restore clan skills: java.lang.NullPointerException
Could not restore clan skills: java.lang.NullPointerException
Item item_id=6377 not known, object_id=268525033
Item item_id=6377 not known, object_id=268525030
Item item_id=6377 not known, object_id=268525029
Item item_id=6377 not known, object_id=268525028
Item item_id=6377 not known, object_id=268525024
Item item_id=6377 not known, object_id=268525023
Item item_id=6597 not known, object_id=268522872
Item item_id=6597 not known, object_id=268522869
Item item_id=6597 not known, object_id=268522868
Item item_id=6608 not known, object_id=268522759
Item item_id=6608 not known, object_id=268522756
Item item_id=6608 not known, object_id=268522755
Item item_id=6608 not known, object_id=268522749
Item item_id=6608 not known, object_id=268522748
Item item_id=6608 not known, object_id=268522747
Item item_id=6604 not known, object_id=268522618
Item item_id=6604 not known, object_id=268522611
Item item_id=6604 not known, object_id=268522610
Item item_id=6604 not known, object_id=268522609
Item item_id=7578 not known, object_id=268522457
Item item_id=7578 not known, object_id=268522455
Item item_id=7578 not known, object_id=268522451
Item item_id=6592 not known, object_id=268522337
Item item_id=6590 not known, object_id=268522332
Item item_id=6590 not known, object_id=268522327
Item item_id=6590 not known, object_id=268522325
Item item_id=6607 not known, object_id=268522080
Item item_id=6607 not known, object_id=268522077
Item item_id=6606 not known, object_id=268522075
Item item_id=6605 not known, object_id=268522071
Item item_id=6605 not known, object_id=268522068
Could not restore clan skills: java.lang.NullPointerException
Could not restore clan skills: java.lang.NullPointerException
Item item_id=6358 not known, object_id=269013058
Item item_id=4782 not known, object_id=268712985
Item item_id=6371 not known, object_id=268505968
Item item_id=6358 not known, object_id=268982304
Could not restore clan skills: java.lang.NullPointerException
Item item_id=7894 not known, object_id=268585159
Could not restore clan skills: java.lang.NullPointerException
Item item_id=8134 not known, object_id=268733626
Item item_id=4859 not known, object_id=268558795
Could not restore clan skills: java.lang.NullPointerException
Item item_id=6358 not known, object_id=268970255
Could not restore clan skills: java.lang.NullPointerException
Could not restore clan skills: java.lang.NullPointerException
Could not restore clan skills: java.lang.NullPointerException
Could not restore clan skills: java.lang.NullPointerException
Could not restore clan skills: java.lang.NullPointerException
Item item_id=6313 not known, object_id=268524104
Item item_id=6358 not known, object_id=268740189
Could not restore clan skills: java.lang.NullPointerException
Could not restore clan skills: java.lang.NullPointerException
Could not restore clan skills: java.lang.NullPointerException
Item item_id=6313 not known, object_id=268837750
Item item_id=4782 not known, object_id=268861424
Item item_id=6313 not known, object_id=268752278
Item item_id=7895 not known, object_id=268511540
Item item_id=6377 not known, object_id=268827083
Item item_id=6377 not known, object_id=268827077
Item item_id=6377 not known, object_id=268827072
Item item_id=6377 not known, object_id=268827063
Item item_id=6377 not known, object_id=268827058
Item item_id=6377 not known, object_id=268827053
Could not restore clan skills: java.lang.NullPointerException
Item item_id=6313 not known, object_id=268743617
Item item_id=6358 not known, object_id=268521575
Restored 84 clans from the database.
...

[/spoil]

Уже БД переустанавливал и что ток не делал :(
Помогите умоляю, что не так ?!