From 1ca0e776ceb9f84f0248e4bbc02e2c1c454cc1bc Mon Sep 17 00:00:00 2001 From: tkrokli Date: Tue, 13 Feb 2018 07:58:49 +0100 Subject: DB/Loot: add missing column name to 2018_02_13_00_world_335.sql Error message upon loading the original file into DB: - ERROR 1136 (21S01) at line 6: Column count doesn't match value count at row 1 Closes #21407 --- sql/updates/world/3.3.5/2018_02_13_00_world_335.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2018_02_13_00_world_335.sql b/sql/updates/world/3.3.5/2018_02_13_00_world_335.sql index c991c6b1554..828f0c7083a 100644 --- a/sql/updates/world/3.3.5/2018_02_13_00_world_335.sql +++ b/sql/updates/world/3.3.5/2018_02_13_00_world_335.sql @@ -3,7 +3,7 @@ DELETE FROM `reference_loot_template` WHERE `Entry`=24064 AND `Item` IN (911, 92 -- Add former items from reference table 24064 to their proper NPCs DELETE FROM `creature_loot_template` WHERE `Item` IN (911, 920, 1076, 1406, 1455, 2034, 2232, 3429); -INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `GroupId`) VALUES +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Chance`, `GroupId`, `Comment`) VALUES (889, 911, 0.1, 0, "Splinter Fist Ogre - Ironwood Treebranch"), (215, 920, 0.1, 0, "Defias Night Runner - Wicked Spiked Mace"), (909, 920, 0.1, 0, "Defias Night Blade - Wicked Spiked Mace"), -- cgit v1.2.3