I get errors on startup with Mangosd PLEASE HELP

[BrainStorm]

Hi and thanks for looking in !

here is some of the errors :

2011-03-19 19:34:34 ERROR:>> Loaded 0 Item converts . DB table `item_convert` is empty.
2011-03-19 19:34:34 Loading Creature Model Based Info Data...
2011-03-19 19:34:34 ERROR:Table `creature_model_info` has redundant modelid_other_gender model (11226) defined for model id 11226.
2011-03-19 19:34:34 ERROR:Table `creature_model_info` has redundant modelid_other_gender model (15552) defined for model id 15552.
2011-03-19 19:34:34 ERROR:Table `creature_model_info` has redundant modelid_other_gender model (20287) defined for model id 20287.

2011-03-19 19:34:40 ERROR:Creature (Entry: 69) has wrong spell 0 defined in `auras` field in `creature_template_addon`.
2011-03-19 19:34:40 ERROR:Creature (Entry: 89) has wrong spell 0 defined in `auras` field in `creature_template_addon`.
2011-03-19 19:34:40 ERROR:Creature (Entry: 299) has wrong spell 0 defined in `auras` field in `creature_template_addon`.
2011-03-19 19:34:40 ERROR:Creature (Entry: 454) has wrong spell 0 defined in `auras` field in `creature_template_addon`.

2011-03-19 19:34:49 >> Loaded 10 creature reactions at game events
2011-03-19 19:34:49 ERROR:`game_event_quest` game event id (9) not exist in `game_event`

2011-03-19 19:34:52 >> Loaded 5054 loot definitions (286 templates)
2011-03-19 19:34:52 ERROR:Table 'item_loot_template' entry 5523 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.
2011-03-19 19:34:52 ERROR:Table 'item_loot_template' entry 5524 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.
2011-03-19 19:34:52 ERROR:Table 'item_loot_template' entry 6712 isn't item entry with ITEM_FLAG_LOOTABLE and not referenced from loot, and then useless.

And lots lots more..

about over 100 errors..

How can i fix em ?

[Schmoozerd]

Reset your database and reapply the updates proper

and ofc also possible that your db-provider screwed up things

[BrainStorm]

Reset your database and reapply the updates proper

and ofc also possible that your db-provider screwed up things

ehm okey so its the updates that is the problem.

then im gonna see if i can get someone or some to make an update db tutorial

cuz i dont realy get how to do the updates ! ive read all the tutorials but still no luck.

[Cyberfreak]

Once again, the content database is not related to the mangos core.

[Auntie Mangos]

Dear BrainStorm,

some of these errors you posted are the result of wrong database content, meaning that a row in a table e.g. is missing, or not needed, or contains wrong flags, etc.

E.g. you posted

2011-03-19 19:34:49 >> Loaded 10 creature reactions at game events
2011-03-19 19:34:49 ERROR:`game_event_quest` game event id (9) not exist in `game_event`

This tells you, that in the table game_event_quest a quest is listed which has a world event as condition which is not defined in your database table game_event.

Usually you can take on such error messages word by word, since they pretty much tell you what is wrong.

In many cases UDB/YTDB, or any other database provider may have a fix on their forums, and in some, you will have to browse our Wiki for database documentation and correct errors yourself.

Should you have no idea how to do that, try learning SQL, which is the language used to describe the MaNGOS databases and their content.

[BrainStorm]

MasterControlProgram

Thanx for the perfect awser.

well ive serached and searched and i came to an concluesion that to update the databases you do not need the "Required_mangos_****" file

what you need is the file after so now ive done it and my server is fully functionel !

Thanx for thouse who have tryed to help me !

This Post is solved !

Exuse my bad spelling !

[BrainStorm]

Well i thuagt i fixed all but still there are errors..

Some one who can tell me how to fix the errors ?

How do i find the right uppdates fixes ?

were do i look ?

[Auntie Mangos]

First, please take a deep breath and do not hurry. Updating MaNGOS and the database should be done slowly and with caution.

As I mentioned in your other thread, you will have to make a choice, if you either want to update to the latest MaNGOS sources, or if you want to update to the latest UDB revision (which is 399 as of this reply).

Tell us which you want, and you'll surely get help