DB Errors - Looking to find out how to fix.

Auntie Mangos · January 1, 1970

The server install is:

2010-08-30 19:17:27 MaNGOS/0.17.0-DEV (* * Revision 10426 - *) for Win32 (little-endian) [world-daemon]

using UDB_0.12.0_mangos_9582_SD2_1639 for a database.

Followed http://getmangos.eu/community/viewtopic.php?id=13121 for the guide to install Mangos and database.

The server compiles with SD2 just find no errors.

Completed all the updates from c:\\Mangos\\sql\\updates for all three databases. mangos, realmd, and character. Again, using the instructions from http://getmangos.eu/community/viewtopic.php?id=13121 as a guide. I have no idea how to apply any required updates for ScriptDev2. If there is a guide for safely doing that please let me know.

I get a bunch of DB errors. I cant post the whole thing, but sample lines are:

2010-08-30 19:17:33 Spell 16954 listed in `spell_proc_event` is not first rank (16952) in chain

2010-08-30 19:17:33 Spell 16961 listed in `spell_proc_event` is not first rank (16958) in chain

2010-08-30 19:17:35 Item (Entry: 3034) has wrong item class (6) for disenchanting, remove disenchanting loot id.

2010-08-30 19:17:35 Item (Entry: 8840) has wrong item class (9) for disenchanting, remove disenchanting loot id.

2010-08-30 19:17:35 Item (Entry: 11825) not correct -1 material, must be 4 (still using DB value).

2010-08-30 19:17:35 Item (Entry: 11826) not correct -1 material, must be 4 (still using DB value).

2010-08-30 19:17:35 Item (Entry: 15196) not correct -1 material, must be 4 (still using DB value).

2010-08-30 19:17:35 Item (Entry: 15197) not correct -1 material, must be 4 (still using DB value).

2010-08-30 19:17:36 >> Loaded `reputation_reward_rate`, table is empty!

2010-08-30 19:17:36 >> Loaded `reputation_spillover_template`, table is empty!

2010-08-30 19:17:39 Creature (GUID: 71979) has wrong spell 66162 defined in `auras` field in `creature_addon`.

2010-08-30 19:17:42 Weekly Quest 236 not marked as repeatable in `SpecialFlags`, added.

2010-08-30 19:17:42 Weekly Quest 13153 not marked as repeatable in `SpecialFlags`, added.

2010-08-30 19:17:42 Weekly Quest 13154 not marked as repeatable in `SpecialFlags`, added.

2010-08-30 19:17:42 Table `areatrigger_tavern` has area trigger (ID:4776) not listed in `AreaTrigger.dbc`.

2010-08-30 19:17:46 Table 'spell_loot_template' entry 61500 (spell id (random item creating)) not exist but used as loot id in DB.

2010-08-30 19:17:46 Table `achievement_criteria_requirement`.`criteria_id` 8804 does not exist, ignoring.

2010-08-30 19:17:46 Table `achievement_criteria_requirement` is missing expected data for `criteria_id` 13308 (type: 0) for achievement 1104.

2010-08-30 19:17:46 Table `achievement_criteria_requirement` is missing expected data for `criteria_id` 13309 (type: 0) for achievement 1104.

2010-08-30 19:17:46 Table `achievement_criteria_requirement` is missing expected data for `criteria_id` 13310 (type: 0) for achievement 1768.

2010-08-30 19:17:46 Table `achievement_criteria_requirement` is missing expected data for `criteria_id` 13311 (type: 0) for achievement 1768.

010-08-30 19:17:49 Table creature_movement has waypoint for creature guid 326 (entry 1718), but MovementType is not WAYPOINT_MOTION_TYPE(2). Creature will not use this path.

2010-08-30 19:17:49 Table creature_movement has waypoint for creature guid 1012 (entry 705), but MovementType is not WAYPOINT_MOTION_TYPE(2). Creature will not use this path.

2010-08-30 19:17:49 Table creature_movement has waypoint for creature guid 3557 (entry 1199), but MovementType is not WAYPOINT_MOTION_TYPE(2). Creature will not use this path.

That is not the exhaustive list, but all the different categories of errors are listed. I have no clue as to where to begin to fix these. I am somewhat familiar with Quince, but I don't understand the table relations enough to know where to begin. Googling takes me to X-Reapers sites often, but still the results just come back to try again. This is attempt number 4 to at least come up with a database that I can clean up. Any advice?

Bodmin · September 1, 2010

Tried a couple other ways to put the database together. I still get this kind of error:

010-08-30 19:17:49 Table creature_movement has waypoint for creature guid 326 (entry 1718), but MovementType is not WAYPOINT_MOTION_TYPE(2). Creature will not use this path.

I just wish I knew where to begin looking for a way to fix it.

VladimirMangos · September 1, 2010

as any DB error it can be 2 case: error exactly describe problem and then point to fix.

In this cases for above error you just need drop data from `creature_movement` fir creature guid 326

Or can be second case: error only indirect point to real bug. In this cases for creature in `creature` (or `creature_template`) set wrong movemend type and need set waypoint movement.

What from 2 ways correct dependent from creature itself.

crackm · September 1, 2010

yes some of the error's exist in 392 due to mangos updates in betweenthe releases, those will be corrected.

The others as Vladimir was describing small glitches in the code.

Bodmin · September 3, 2010

@VladimirMangos - Thank you very much. I used Quice to check on the MovementType of the guid's that were in error, and the ones that were either type 1 or 0 had their creature_movement entries removed using MySQL Workbench.

@crackm would it be of any benefit to have these deletions from creature_movement put into a script and sent to someone?

Bodmin · September 3, 2010

I managed to get rid of all but a few:

2010-09-03 10:42:17 Spell 16954 listed in `spell_proc_event` is not first rank (16952) in chain
2010-09-03 10:42:17 Spell 16961 listed in `spell_proc_event` is not first rank (16958) in chain

2010-09-03 10:42:20 >> Loaded `reputation_spillover_template`, table is empty!

I imagine there is little if anything I can do with reputation_spillover_template, but is there any chance on getting any guidance in correcting spell_proc_event?

VladimirMangos · September 5, 2010

first 2 lines must be already fixed (it has been core problem)

last related to used DB. Just wait when it will filled by correct data.

Bodmin · September 5, 2010

Will do VladimirMangos. Thanks again for your help.

mindblack · February 16, 2011

first 2 lines must be already fixed (it has been core problem)
last related to used DB. Just wait when it will filled by correct data.

i have mangos server running, but i have a little problem

2011-02-16 12:23:57 MaNGOS/0.17.0 (* * Revision 11157 - *) for Linux_x64 (little-endian) [world-daemon]

2011-02-16 12:23:57 <Ctrl-C> to stop.

MM MM MM MM MMMMM MMMM MMMMM

MM MM MM MM MMM MMM MM MM MMM MMM

MMM MMM MMM MM MMM MMM MM MM MMM

MM M MM MMMM MM MMM MM MM MMM

MM M MM MMMMM MM MMMM MMM MM MM MMM

MM M MM M MMM MM MMM MMMMMMM MM MM MMM

MM MM MMM MM MM MM MMM MM MM MMM

MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM

MM MM MM MMM MM MM MMMMMM MMMM MMMMM

MM MMM http://getmangos.eu

MMMMMM

2011-02-16 12:23:57 Using configuration file /opt/mangos/etc/mangosd.conf.

2011-02-16 12:23:57 World Database: 95.168.xxx.xx;3306;xxxxxxxx;xxxxxxxxx;mangos, total connections: 2

2011-02-16 12:23:57 MySQL client library: 5.0.51a