mangos zero REGEN_FLAG_HEALTH DB Error

[Hvemklomater]

=14:45:47 Table `creature` have creature (GUID: 590097 Entry: 60004) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (10625), `creature_template`.`MinLevelHealth`=10626.
14:45:47 Table `creature` have creature (GUID: 590098 Entry: 16381) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (13647), `creature_template`.`MinLevelHealth`=19500.
14:45:47 Table `creature` have creature (GUID: 24916 Entry: 3209) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (546), `creature_template`.`MinLevelHealth`=25450.
14:45:47 Table `creature` have creature (GUID: 24916 Entry: 3209) with low current mana (0), `creature_template`.`MinLevelMana`=3000.
14:45:47 Table `creature` have creature (GUID: 590104 Entry: 60001) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (9563), `creature_template`.`MinLevelHealth`=25564.
=14:45:47 Table `creature` have creature (GUID: 590102 Entry: 60001) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (9563), `creature_template`.`MinLevelHealth`=25564.
14:45:47 Table `creature` have creature (GUID: 590094 Entry: 60003) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (4845), `creature_template`.`MinLevelHealth`=11000.
14:45:47 Table `creature` have creature (GUID: 590084 Entry: 60000) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (5158), `creature_template`.`MinLevelHealth`=19563.
14:45:47 Table `creature` have creature (GUID: 590088 Entry: 60001) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (9563), `creature_template`.`MinLevelHealth`=25564.
=14:45:47 Table `creature` have creature (Entry: 7017) with equipment_id 627 not found in table `creature_equip_template` or `creature_equip_template_raw`, set to no equipment.
14:45:47 Table `creature` have creature (GUID: 38041 Entry: 11320) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (905), `creature_template`.`MinLevelHealth`=7892.
14:45:47 Table `creature` have creature (GUID: 38043 Entry: 11320) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (905), `creature_template`.`MinLevelHealth`=7892.
14:45:47 Table `creature` have creature (GUID: 38044 Entry: 11320) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (905), `creature_template`.`MinLevelHealth`=7892.
14:45:47 Table `creature` have creature (GUID: 38045 Entry: 11320) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (905), `creature_template`.`MinLevelHealth`=7892.
14:45:47 Table `creature` have creature (GUID: 38046 Entry: 11320) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (905), `creature_template`.`MinLevelHealth`=7892.
14:45:47 Table `creature` have creature (GUID: 38047 Entry: 11320) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (905), `creature_template`.`MinLevelHealth`=7892.
14:45:47 Table `creature` have creature (GUID: 38048 Entry: 11320) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (905), `creature_template`.`MinLevelHealth`=7892.
=14:45:47 Table `creature` have creature (GUID: 48642 Entry: 11320) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (905), `creature_template`.`MinLevelHealth`=7892.
14:45:47 Table `creature` have creature (GUID: 48675 Entry: 11320) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (905), `creature_template`.`MinLevelHealth`=7892.
14:45:47 Table `creature` have creature (GUID: 48679 Entry: 11320) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (905), `creature_template`.`MinLevelHealth`=7892.
14:45:47 Table `creature` have creature (GUID: 48684 Entry: 11320) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (905), `creature_template`.`MinLevelHealth`=7892.
=14:45:47 Table `creature` have creature (GUID: 590078 Entry: 14524) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (10110), `creature_template`.`MinLevelHealth`=10111.
14:45:47 Table `creature` have creature (Entry: 7017) with equipment_id 627 not found in table `creature_equip_template` or `creature_equip_template_raw`, set to no equipment.
14:45:47 Table `creature` have creature (GUID: 590079 Entry: 14525) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (10110), `creature_template`.`MinLevelHealth`=10111.
14:45:47 Table `creature` have creature (GUID: 590080 Entry: 14526) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (10110), `creature_template`.`MinLevelHealth`=10111.

I've tried so many different things to fix it... the only thing that worked was to change the value of regen_flag_health = 0, but then the NPC won't regen.

Any ideas or fixes for this?
 

[Hvemklomater]

41 minutes ago, Necrovoice said:

I would strongly suggest using our database wiki.  If you are on discord i would be happy to help you there.. I find it easer to have a conversation on live chat vs. The forum 

Sent you a PM... could use some help lol.

[Necrovoice]

Need to change the value in the Creature table under curhealth. To match the hp values in. Creature_template.

[Hvemklomater]

3 hours ago, Necrovoice said:

Need to change the value in the Creature table under curhealth. To match the hp values in. Creature_template.

Hi,

Thank you very much, this seems to have done it. 

I have another (last one) that I am not able to solve:

2017-11-18 22:08:53 Spell 21084 (prev: 0, first: 21084, rank: 1, req: 0) listed in `spell_chain` expected rank 2 by DBC data.
2017-11-18 22:08:53 Spell 20287 (prev: 21084, first: 21084, rank: 2, req: 0) listed in `spell_chain` has different first spell in chain compared to previous rank spell (prev: 20154, first: 20154, rank: 2, req: 0).

 

18:50:18 Table `creature` have creature (Entry: 7017) with equipment_id 627 not found in table `creature_equip_template` or `creature_equip_template_raw`, set to no equipment.
=18:50:18 Table `creature` have creature (GUID: 590078 Entry: 14524) with `creature_template`.`RegenerateStats` & REGEN_FLAG_HEALTH and low current health (10110), `creature_template`.`MinLevelHealth`=10111.
18:50:18 Table `creature` have creature (Entry: 7017) with equipment_id 627 not found in table `creature_equip_template` or `creature_equip_template_raw`, set to no equipment.

The strange thing about the equipment one is I am not able to find this NPC with that equipment ID

[Necrovoice]

Yes, someone was working on this some time ago.. not sure what the end goal was for it...  will look into it at some point...  I am currently woorking an ever geowing list of errors hidden in the db during start up...

[Hvemklomater]

5 minutes ago, Necrovoice said:

Yes, someone was working on this some time ago.. not sure what the end goal was for it...  will look into it at some point...  I am currently woorking an ever geowing list of errors hidden in the db during start up...

Oh sweet.

[madmax]

10 minutes ago, Necrovoice said:

Yes, someone was working on this some time ago.. not sure what the end goal was for it...  will look into it at some point...  I am currently woorking an ever geowing list of errors hidden in the db during start up...

I only found a few thousand 

[Necrovoice]

HAHA @madmax, indeed you did.

If you are using the most recent build /database.   There should only be a small handfull(10-15? If that) with default .config settings.

If you are using rhe default settings and getting hundredsof errors then something is not right with your db im guessig.

But, Yes there are  a few hundred if the config file is altered to show said errors.

 

[Hvemklomater]

How can you see the hidden errors?

Would love to look into some of them and perhaps find a solution.

[Hvemklomater]

Anyone?

[madmax]

On 11/27/2017 at 9:24 PM, Hvemklomater said:

How can you see the hidden errors?

Would love to look into some of them and perhaps find a solution.

https://github.com/mangoszero/server/blob/master/src/mangosd/mangosd.conf.dist.in#L395
Set that to 0, default appears to hide the errors.

[Necrovoice]

@Hvemklomater, if you like to join up on this shoot me a PM. There we can share our orogress and once done if tou like i can  batch it all together for the repo

[Hvemklomater]

3 minutes ago, Necrovoice said:

@Hvemklomater, if you like to join up on this shoot me a PM. There we can share our orogress and once done if tou like i can  batch it all together for the repo

Sounds good to me. Will shoot you a PM once I have checked some of the errors.

[Necrovoice]

Awsome.  Each core does share some of the errors in addition to unique errors to that core.

[Hvemklomater]

12:43:45 Spell (ID: 7082) has effect EffectImplicitTargetA/EffectImplicitTargetB = 38 (TARGET_SCRIPT), but does not have record in `spell_script_target`

I did some testing with the one above

I just added the ID entry: 7082 -> type: 0 (can't figure out which type, since I don't know the target) --> target 0 (for now) and mask 0. Error is gone, but still not a proper solution lol

Do you happen to know how I find the target entry for the specified spell? 

[Necrovoice]

Research, cross-checking.....Research, cross-checking......Research, cross-checking......Research, cross-checking  and a lot of luck... or in my case alcohol 

 

[Hvemklomater]

1 minute ago, Necrovoice said:

Research, cross-checking.....Research, cross-checking......Research, cross-checking......Research, cross-checking  and a lot of luck... or in my case alcohol 

 

 

welp... guess I'll have to do some more re-search and figure it out slowly  

[Necrovoice]

I would strongly suggest using our database wiki.  If you are on discord i would be happy to help you there.. I find it easer to have a conversation on live chat vs. The forum