diff options
| author | tkrokli <tkrokli@gmail.com> | 2018-02-13 07:58:49 +0100 |
|---|---|---|
| committer | tkrokli <tkrokli@gmail.com> | 2018-02-13 07:59:37 +0100 |
| commit | 1ca0e776ceb9f84f0248e4bbc02e2c1c454cc1bc (patch) | |
| tree | 7d5b36fac1e340f3deb35cc1d74fd2ac4abe139b | |
| parent | 9f59fb54fc16e06f81a1e99df4076c939bdb3339 (diff) | |
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
| -rw-r--r-- | sql/updates/world/3.3.5/2018_02_13_00_world_335.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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"), |