Azerothcore-wotlk: [DB] Remove all server loading warnings

[Yehonal]

Edit by Shin (@FrancescoBorzi):

As of: https://github.com/azerothcore/azerothcore-wotlk/commit/b1b48b92df68a2d55340d2795a320c24cc45b32f

Current startup errors:

2018-12-26 15:46:10 >>  Loaded 0 Players data!
2018-12-26 15:46:14 Table 'mail_loot_template' entry 90 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 119 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 124 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 140 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 180 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 183 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 216 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 217 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 218 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 270 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 4989 Type: 19), ignored.
2018-12-26 15:46:14 Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 4988 Type: 19), ignored.
2018-12-26 15:46:14 Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 5620 Type: 73), ignored.
2018-12-26 15:46:14 Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 5632 Type: 73), ignored.
2018-12-26 15:46:14 Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 5619 Type: 73), ignored.
2018-12-26 15:46:14 Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 4987 Type: 19), ignored.
2018-12-26 15:46:15 Table `spell_scripts` using non-existent spell (id: 0) in SCRIPT_COMMAND_CAST_SPELL for script id 16805948
2018-12-26 15:46:15 Table `spell_scripts` using non-existent spell (id: 0) in SCRIPT_COMMAND_CAST_SPELL for script id 16831313

Follow up:

• https://github.com/azerothcore/azerothcore-wotlk/pull/1151
• https://github.com/azerothcore/azerothcore-wotlk/issues/1152
• https://github.com/azerothcore/azerothcore-wotlk/issues/1155
• https://github.com/azerothcore/azerothcore-wotlk/issues/1156

---

Original post:

Before release AC 2.0 we need to remove all db loading warnings at server start.

It could also fix some game contents

If something is missing please notify me (NOTE: must be errors about a clean AzerothCore version, we cannot fix modules/custom issues here)

I'll try to list here:

Gameobject (GUID: 5286 Entry 203624 GoType: 0) has an invalid displayId (9624), not loaded.


Table 'creature_loot_template' entry 1 isn't creature entry and not referenced from loot, and then useless.
Table 'creature_loot_template' entry 1175 isn't creature entry and not referenced from loot, and then useless.

SourceGroup 15550 in `condition` table, does not exist in `creature_loot_template`, ignoring.
ConditionMgr: Item 23612 not found in LootTemplate 21060
Not handled grouped condition, SourceGroup 21060
ConditionMgr: Item 23612 not found in LootTemplate 21061
Not handled grouped condition, SourceGroup 21061

---

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[FrancescoBorzi]

totally agree, and any PR should not be accepted if it introduces new startup errors

[STARRHELD]

-- Fix Startup Errors
UPDATE `conditions` SET `SourceGroup`=16152 WHERE `SourceEntry`=23809;
DELETE FROM `conditions` WHERE `SourceGroup`=21060 AND `SourceEntry`=23612;
DELETE FROM `conditions` WHERE `SourceGroup`=21061 AND `SourceEntry`=23612;
DELETE FROM `creature_loot_template` WHERE `entry`=1175;

[Yehonal]

I ll test it asap. Did you notice any other warning in your installation?
Please import latest 2 sql and if yes i have to add it to the first post

Il 14 Ott 2017 20:00, "Kevin Starrheld" [e-mail] ha
scritto:

CLEANUP

-- Fix Startup ErrorsUPDATE creature_addon SET auras='' WHERE guid=6432;UPDATE creature_template SET skinloot=80102 WHERE entry IN(18343, 20268);DELETE FROM creature_addon WHERE guid=3574;DELETE FROM conditions WHERE SourceGroup=15550;DELETE FROM conditions WHERE SourceGroup=21060 AND SourceEntry=23612;DELETE FROM conditions WHERE SourceGroup=21061 AND SourceEntry=23612;DELETE FROM creature_loot_template WHERE entry=1175;DELETE FROM creature_loot_template WHERE entry=1;DELETE FROM conditions WHERE SourceEntry IN(18228, 43314, 43322, 43323, 43324, 44808, 44809);

Needs testing, thank you!

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/azerothcore/azerothcore-wotlk/issues/679#issuecomment-336652498,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AAI-lH9M50KaEFWHsmQ75su0zfZwV15gks5ssPasgaJpZM4P4Szq
.

[renaldre]

world table.

ERROR: [1146] Table 'acore_world.holiday_dates' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

because : 612e996209efa0f1b9ced4d5559199715e784bd3
and then removed : 3d908d31a22f6cddf65706e2806aff37a5e60cf6

[dd667]

modules: mod-random-enchants
Branch: master
d0af1c812bf4ea15204cad37b39ff27ff6bae339

2017-10-18 12:44:03 Loading Achievement Criteria Data...
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` has data for non-existing criteria (Entry: 10001), ignore.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100001 Type: 0) for achievement 10001.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100002 Type: 0) for achievement 10002.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100003 Type: 0) for achievement 10003.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100004 Type: 0) for achievement 10004.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100005 Type: 0) for achievement 10005.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100006 Type: 0) for achievement 10006.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100007 Type: 0) for achievement 10007.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100008 Type: 0) for achievement 10008.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100009 Type: 0) for achievement 10009.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100010 Type: 0) for achievement 10010.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100011 Type: 0) for achievement 10011.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100012 Type: 0) for achievement 10012.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100013 Type: 0) for achievement 10013.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100014 Type: 0) for achievement 10014.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100015 Type: 0) for achievement 10015.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100016 Type: 0) for achievement 10016.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100017 Type: 0) for achievement 10017.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100018 Type: 0) for achievement 10018.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100019 Type: 0) for achievement 10019.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100020 Type: 0) for achievement 10020.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100021 Type: 0) for achievement 10021.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100022 Type: 0) for achievement 10022.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100023 Type: 0) for achievement 10023.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100024 Type: 0) for achievement 10024.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100025 Type: 0) for achievement 10025.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100026 Type: 0) for achievement 10026.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100027 Type: 0) for achievement 10027.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100028 Type: 0) for achievement 10028.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100029 Type: 0) for achievement 10029.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100030 Type: 0) for achievement 10030.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100031 Type: 0) for achievement 10031.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100032 Type: 0) for achievement 10032.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100033 Type: 0) for achievement 10033.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100034 Type: 0) for achievement 10034.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100035 Type: 0) for achievement 10035.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100036 Type: 0) for achievement 10036.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100037 Type: 0) for achievement 10037.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100038 Type: 0) for achievement 10038.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100039 Type: 0) for achievement 10039.
2017-10-18 12:44:03 ERROR: Table `achievement_criteria_data` does not have expected data for criteria (Entry: 100040 Type: 0) for achievement 10040.
2017-10-18 12:44:03 >> Loaded 2734 additional achievement criteria data in 141 ms

[STARRHELD]

Related to the Achievement_Criteria.dbc file, download this and replace yours:
https://mega.nz/#!6wQDETKB!fc98_kDSU6tNpdjIZ86s2r2fs7YRlIiTqJoyUgHmqd0

@dd667

[OlegVintage88]

modules: no
Branch: master
4bc2124632fd6f7120a6b5d6539ec0ad4795c142

2017-11-20 11:37:27 Loading Achievement Criteria Data...
2017-11-20 11:37:27 ERROR: Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 4989 Type: 19), ignored.
2017-11-20 11:37:27 ERROR: Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 4988 Type: 19), ignored.
2017-11-20 11:37:27 ERROR: Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 5620 Type: 73), ignored.
2017-11-20 11:37:27 ERROR: Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 5632 Type: 73), ignored.
2017-11-20 11:37:27 ERROR: Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 5619 Type: 73), ignored.
2017-11-20 11:37:27 ERROR: Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 4987 Type: 19), ignored.
2017-11-20 11:37:27 >> Loaded 2767 additional achievement criteria data in 41 ms

[Maurowin]

2979fd6+ Master
DBErrors.log

[Nefertumm]

-- Useless loot
DELETE FROM `creature_loot_template` WHERE `entry` IN (1, 1175);
-- Conditions for lootid 1, useless
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 1 AND `SourceGroup` = 1;

-- Attumen the Huntsman - Fix condition on item 23809
UPDATE `conditions` SET `SourceGroup` = 16152 WHERE `SourceGroup` = 15550 AND `SourceEntry` = 23809;

-- Conditions that aren't referenced and, still, aren't correct.
DELETE FROM `conditions` WHERE `SourceGroup` = 21060 AND `SourceEntry` = 23612;
DELETE FROM `conditions` WHERE `SourceGroup` = 21061 AND `SourceEntry` = 23612;

This fix:

2018-01-16 19:55:08 Table 'creature_loot_template' entry 1 isn't creature entry and not referenced from loot, and then useless.
2018-01-16 19:55:08 Table 'creature_loot_template' entry 1175 isn't creature entry and not referenced from loot, and then useless.
2018-01-16 19:55:09 SourceGroup 15550 in condition table, does not exist in creature_loot_template, ignoring.
2018-01-16 19:55:09 ConditionMgr: Item 23612 not found in LootTemplate 21060
2018-01-16 19:55:09 Not handled grouped condition, SourceGroup 21060
2018-01-16 19:55:09 ConditionMgr: Item 23612 not found in LootTemplate 21061
2018-01-16 19:55:09 Not handled grouped condition, SourceGroup 21061

[Nefertumm]

To fix:

Area trigger (ID:60) map (ID: 24) does not exist in `Map.dbc`.
Area trigger (ID:81) map (ID: 28) does not exist in `Map.dbc`.
Area trigger (ID:83) map (ID: 28) does not exist in `Map.dbc`.
Table 'mail_loot_template' entry 90 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 119 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 124 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 140 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 180 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 183 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 216 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 217 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 218 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 270 isn't mail template id and not referenced from loot, and then useless.
Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 4989 Type: 19), ignored.
Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 4988 Type: 19), ignored.
Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 5620 Type: 73), ignored.
Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 5632 Type: 73), ignored.
Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 5619 Type: 73), ignored.
Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 4987 Type: 19), ignored.
Table `spell_scripts` using non-existent spell (id: 0) in SCRIPT_COMMAND_CAST_SPELL for script id 16805948
Table `spell_scripts` using non-existent spell (id: 0) in SCRIPT_COMMAND_CAST_SPELL for script id 16831313

[StygianTheBest]

I remember pushing to keep the core clean and free of errors back in 09/2017. I came hunting for this because I'm seeing several more. I'll try to look through here and see if any of these fixes work. I tried using the .DBC referenced above just in case and it doesn't fix the issues.

Table spell_scripts using non-existent spell (id: 0) in SCRIPT_COMMAND_CAST_SPELL for script id 16805948
Table spell_scripts using non-existent spell (id: 0) in SCRIPT_COMMAND_CAST_SPELL for script id 16831313

Loading Achievement Criteria Data...
Table achievement_criteria_data has data for non-supported criteria type (Entry: 4989 Type: 19), ignored.
Table achievement_criteria_data has data for non-supported criteria type (Entry: 4988 Type: 19), ignored.
Table achievement_criteria_data has data for non-supported criteria type (Entry: 5620 Type: 73), ignored.
Table achievement_criteria_data has data for non-supported criteria type (Entry: 5632 Type: 73), ignored.
Table achievement_criteria_data has data for non-supported criteria type (Entry: 5619 Type: 73), ignored.
Table achievement_criteria_data has data for non-supported criteria type (Entry: 4987 Type: 19), ignored.

Loading mail loot templates...
Table mail_loot_template entry 90 isnt mail template id and not referenced from loot, and then useless.
Table mail_loot_template entry 119 isnt mail template id and not referenced from loot, and then useless.
Table mail_loot_template entry 124 isnt mail template id and not referenced from loot, and then useless.
Table mail_loot_template entry 140 isnt mail template id and not referenced from loot, and then useless.
Table mail_loot_template entry 180 isnt mail template id and not referenced from loot, and then useless.
Table mail_loot_template entry 183 isnt mail template id and not referenced from loot, and then useless.
Table mail_loot_template entry 216 isnt mail template id and not referenced from loot, and then useless.
Table mail_loot_template entry 217 isnt mail template id and not referenced from loot, and then useless.
Table mail_loot_template entry 218 isnt mail template id and not referenced from loot, and then useless.
Table mail_loot_template entry 270 isnt mail template id and not referenced from loot, and then useless.

[FrancescoBorzi]

We should prevent commits that creates new warnings to be merged on master.

One possible solution could be:

1) solve all current warnings
2) add a configuration option (disabled by default) that prevents the server to start whenever there are warnings
3) run the server in the pipeline with that configuration enabled, it if fails: fail the build

Another solution could be creating a small, external tool that checks for issues in the DB and run it in the database (not sure how hard this other solution would be).

[BarbzYHOOL]

very good suggestions

[FrancescoBorzi]

Another idea:

• run the server with logs enabled
• check the file DBErrors.log -> if there are errors then fail the build

[FrancescoBorzi]

As of: https://github.com/azerothcore/azerothcore-wotlk/commit/b1b48b92df68a2d55340d2795a320c24cc45b32f

Current startup errors:

2018-12-26 15:46:10 >>  Loaded 0 Players data!
2018-12-26 15:46:14 Table 'mail_loot_template' entry 90 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 119 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 124 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 140 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 180 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 183 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 216 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 217 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 218 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table 'mail_loot_template' entry 270 isn't mail template id and not referenced from loot, and then useless.
2018-12-26 15:46:14 Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 4989 Type: 19), ignored.
2018-12-26 15:46:14 Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 4988 Type: 19), ignored.
2018-12-26 15:46:14 Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 5620 Type: 73), ignored.
2018-12-26 15:46:14 Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 5632 Type: 73), ignored.
2018-12-26 15:46:14 Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 5619 Type: 73), ignored.
2018-12-26 15:46:14 Table `achievement_criteria_data` has data for non-supported criteria type (Entry: 4987 Type: 19), ignored.
2018-12-26 15:46:15 Table `spell_scripts` using non-existent spell (id: 0) in SCRIPT_COMMAND_CAST_SPELL for script id 16805948
2018-12-26 15:46:15 Table `spell_scripts` using non-existent spell (id: 0) in SCRIPT_COMMAND_CAST_SPELL for script id 16831313

[FrancescoBorzi]

Follow up:

• https://github.com/azerothcore/azerothcore-wotlk/pull/1151
• https://github.com/azerothcore/azerothcore-wotlk/issues/1152
• https://github.com/azerothcore/azerothcore-wotlk/issues/1155
• https://github.com/azerothcore/azerothcore-wotlk/issues/1156

[StygianTheBest]

I posted this on Discord a while back. All are related to quests, so my guess is sorting this out will fix some uncovered quest bugs too. Lucky Red Envelope's are from the Lunar Festival Event. Then we have Brewfest, and a few other quests.

90  - 21746 - lucky red envelope
119 - 15564 - rugged armor kit
124 - 21746 - lucky red envelope
140 - 21746 - lucky red envelope
180 - 24132 - leter admiral
183 - 31698 - letter shattrath
216 - 37902 - springtime stout
217 - 37903 - blackrock lager
218 - 37904 - stranglethorn brew
270 - 46544, 46545 - curious wolvar pup, curious oracle hatchling

Table 'mail_loot_template' entry 90 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 119 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 124 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 140 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 180 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 183 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 216 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 217 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 218 isn't mail template id and not referenced from loot, and then useless.
Table 'mail_loot_template' entry 270 isn't mail template id and not referenced from loot, and then useless.