aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKittnz <frederik156@hotmail.com>2015-04-08 19:49:41 +0200
committerDDuarte <dnpd.dd@gmail.com>2015-04-14 01:02:10 +0100
commitcc00bcef0f365e12705b566b8ec492955fcd3dec (patch)
treef62a72175e99334e612de05cb487e9e652186275
parentbc188bc6b3457f0a35292403609f46795527ee56 (diff)
DB/Misc: Fix startup errors
(cherry picked from commit dd34736757cae77581758f4bf0cef7ba48c73e0d) Conflicts: sql/updates/world/2015_04_08_00_world.sql
-rw-r--r--sql/updates/world/2015_04_08_00_world_f335.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2015_04_08_00_world_f335.sql b/sql/updates/world/2015_04_08_00_world_f335.sql
new file mode 100644
index 00000000000..f2e13c01bd8
--- /dev/null
+++ b/sql/updates/world/2015_04_08_00_world_f335.sql
@@ -0,0 +1,7 @@
+-- Kill some database errors
+DELETE FROM `creature_addon` WHERE `guid` IN (52306, 52317, 52312, 52303, 52296, 127436, 127437);
+UPDATE `creature` SET `spawndist`=0 WHERE `guid`=52331;
+UPDATE `creature` SET `spawndist`=0 WHERE `guid`=52330;
+UPDATE `creature` SET `spawndist`=0 WHERE `guid`=120692;
+DELETE FROM `linked_respawn` WHERE `guid`=127436 AND `linkType`=0;
+DELETE FROM `linked_respawn` WHERE `guid`=127437 AND `linkType`=0;