search

Arkania / ArkCORE-NG

Cataclysm 4.3.4 emulator.. with archeology..
http://gpn39f.spdns.de/forum1/
GNU General Public License v2.0
71 stars 93 forks source link

Latest DBError.log errors help me to fix it #248

Open shinebayar-g opened 7 years ago

shinebayar-g commented 7 years ago

Okay I updated the core and trying to work on latest DBErrors however I don't understand some of these errors. Please help me to solve it.

  1. pool_gameobject has a non existing gameobject spawn (GUID: 19017) defined for pool id (5829), skipped. So this means world.pool_pool table doesn't have value for pool_id: 5829 , I've no data for this one.

  2. Table 'gameobject_loot_template' Entry 2843 isn't gameobject entry and not referenced from loot, and thus useless. I have no clue how to solve this one?

  3. Table 'reference_loot_template' Entry 11050 isn't reference id and not referenced from loot, and thus useless.
Table 'reference_loot_template' Entry 11051 isn't reference id and not referenced from loot, and thus useless.

    I have no clue how to solve this one?

  4. Spell (ID: 82175) not have MECHANIC_DISCOVERY (28) value in Mechanic field in spell.dbc and not 100% chance random discovery ability but listed for spellId 82180 (and maybe more) in 'skill_discovery_template' table
Spell (ID: 81275) not have MECHANIC_DISCOVERY (28) value in Mechanic field in spell.dbc and not 100% chance random discovery ability but listed for spellId 82180 (and maybe more) in 'skill_discovery_template' table

    Frank and I talked about this one, any help would be nice!

ArkCore commit 56085b6ba5d7588799a5275d18a1635c642c78fc

graham79 commented 7 years ago

Table 'gameobject_loot_template' Entry 2843 isn't gameobject entry and not referenced from loot, and thus useless. I have no clue how to solve this one? This is actually easy to fix. First check entry 2843 in gameobject_loot_template, if there is entry, check gameobject_template for that entry, check for missing value in data1, Trinity use the gameobject entry ID as the loot ID which should be in data1=2843. I see this object is a battered chest and since nobody has attempted to fill the loot tables for chests, It very likely has no loot_template entry. just checked object, It had no value in data1 and no entry in the loot_template.

graham79 commented 7 years ago

question 1 & 3 has been fixed in recent updates. As for question 4, this problem has been around since arkcore 4.0.6. when blizzard introduced "Discoverable" recipes for certain professions. The table is supposed to define at what skill level and the spell you need to have to discover the recipe. with alchemist, the spell is constant as they learn a spell "northern research" at a certain level so they have a % chance of Discovering the new recipes. The Alchemist table works fine. The Engineers table which this error refers to, we have very little information on. This makes it hard to fix the table prperly.

shinebayar-g commented 7 years ago

question 1 & 3 has been fixed in recent updates.

recent commits caused this errors, not fix.

Thanks for explaining, about 4 i remember it was there in 4.0.6...

About 2 I'll checkout when i get home :)