[patch][6414] Error In Mangos.sql

[evilatwow]

* What does the patch fix?

An SQL error when using mangos.sql to create a new database, because a value for heroic_entry is missing in one of the creature_template entries.

A search showed this was reported as a bug already:

Bug report 2

Bug report 1

* For which SubVersion revision was the patch created?

6413

* Who has been writing this patch?

Liontiger (he mentioned the solution in his bug post above). I just quickly created a patch to get your attention

Index: mangos.sql
===================================================================
--- mangos.sql        (revision 6413)
+++ mangos.sql        (working copy)
@@ -706,7 +706,7 @@
LOCK TABLES `creature_template` WRITE;
/*!40000 ALTER TABLE `creature_template` DISABLE KEYS */;
INSERT INTO `creature_template` VALUES
-(1,10045,0,10045,0,'Waypoint (Only GM can see it)','Visual',NULL,1,1,64,64,0,0,0,35,35,0,0.91,0,0,14,15,0,100,2000,2200,4096,0,8,0,0,0,
0,1.76,2.42,100,8,1,5242886,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,0,1,0,0,'');
+(1,0,10045,0,10045,0,'Waypoint (Only GM can see it)','Visual',NULL,1,1,64,64,0,0,0,35,35,0,0.91,0,0,14,15,0,100,2000,2200,4096,0,8,0,0,0,
0,1.76,2.42,100,8,1,5242886,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,0,1,0,0,'');
/*!40000 ALTER TABLE `creature_template` ENABLE KEYS */;
UNLOCK TABLES;

rapidshare download

[VladimirMangos]

Similar patch added in [6414]