Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

[3.3.5a] Start up errors #9569

Closed
ghost opened this Issue Apr 4, 2013 · 6 comments

Comments

Projects
None yet
3 participants
@ghost

ghost commented Apr 4, 2013

fresh db + include all world updates

rev 7df4d14

ERRORS:

Spell (Id: 53821) listed in spell_target_position expected point to zone 4342 bit point to zone 4356.
Spell (Id: 53821) listed in spell_target_position does not have target TARGET_DEST_DB (17).
ObjectEntry condition has wrong typeid set (28214), skipped
ObjectEntry condition has wrong typeid set (28215), skipped
ObjectEntry condition has wrong typeid set (28216), skipped
ObjectEntry condition has wrong typeid set (28120), skipped
ObjectEntry condition has wrong typeid set (28122), skipped
ObjectEntry condition has wrong typeid set (28121), skipped
ObjectEntry condition has wrong typeid set (28214), skipped
ObjectEntry condition has wrong typeid set (28215), skipped
ObjectEntry condition has wrong typeid set (28216), skipped
ObjectEntry condition has wrong typeid set (28120), skipped
ObjectEntry condition has wrong typeid set (28121), skipped
ObjectEntry condition has wrong typeid set (28122), skipped
ObjectEntry condition has wrong typeid set (28120), skipped
ObjectEntry condition has wrong typeid set (28215), skipped
ObjectEntry condition has wrong typeid set (28216), skipped
ObjectEntry condition has wrong typeid set (28121), skipped
ObjectEntry condition has wrong typeid set (28122), skipped
ObjectEntry condition has wrong typeid set (28214), skipped
ObjectEntry condition has wrong typeid set (28120), skipped
ObjectEntry condition has wrong typeid set (28121), skipped
ObjectEntry condition has wrong typeid set (28122), skipped
ObjectEntry condition has wrong typeid set (28362), skipped
ObjectEntry condition has wrong typeid set (28122), skipped
ObjectEntry condition has wrong typeid set (28121), skipped
ObjectEntry condition has wrong typeid set (28216), skipped
ObjectEntry condition has wrong typeid set (28215), skipped
ObjectEntry condition has wrong typeid set (28215), skipped
Creature entry 28371 has EventAI scripts, but its AIName is not 'EventAI' - possible AI-mismatch?

Contributor

Pitcrawler commented Apr 4, 2013

ObjectEntry errors should be fixed with

SET @LAFOO := 28120;
SET @MOODLE := 28122;
SET @JALOOT := 28121;
SET @GOREGEK := 28214;
SET @DAJIK := 28215;
SET @ZEPIK := 28216;
SET @GLINTINGDIRT := 28362;
SET @FRENZYAURA := 51234;
SET @MISTWHISPERAURA := 51239; 
SET @DIGGINGFORTEASURE := 51405;
SET @TREASUREPING:= 51420;
SET @RAINSPEAKERAURA := 51639;
SET @SPEARBORNAURA := 51642;
SET @MOSSWALKERAURA := 51644;
SET @SKYREACHPILLARAURA:= 51645;
SET @SAPPHIREHIVEAURA := 51651;
SET @WOLVARPING  := 51791;
SET @GORLOCPING  := 51794;
SET @DESSAWNRETAINER := 53163;

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (@FRENZYAURA,@RAINSPEAKERAURA,@WOLVARPING,@GORLOCPING,@DESSAWNRETAINER,@TREASUREPING,@DIGGINGFORTEASURE,@MOSSWALKERAURA,@SPEARBORNAURA,@MISTWHISPERAURA,@SAPPHIREHIVEAURA,@SKYREACHPILLARAURA);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(13,7,@FRENZYAURA,0,31,3,@GOREGEK,0,0,0,'','Spell Frenzyheart Hill Aura targets Goregek the Bristlepine Hunter'),
(13,7,@FRENZYAURA,1,31,3,@DAJIK,0,0,0,'','Spell Frenzyheart Hill Aura targets Dajik the Wasp Hunter'),
(13,7,@FRENZYAURA,2,31,3,@ZEPIK,0,0,0,'','Spell Frenzyheart Hill Aura targets Zepik the Gorloc Hunter'),
(13,7,@RAINSPEAKERAURA,0,31,3,@LAFOO,0,0,0,'','Spell Rainspeaker Canopy Aura targets Lafoo'),
(13,7,@RAINSPEAKERAURA,1,31,3,@MOODLE,0,0,0,'','Spell Rainspeaker Canopy Aura targets Jaloot'),
(13,7,@RAINSPEAKERAURA,2,31,3,@JALOOT,0,0,0,'','Spell Rainspeaker Canopy Aura targets Moodle'),
(13,7,@WOLVARPING,0,31,3,@GOREGEK,0,0,0,'','Spell Wolvar Location Ping targets Goregek the Bristlepine Hunter'),
(13,7,@WOLVARPING,1,31,3,@DAJIK,0,0,0,'','Spell Wolvar Location Ping targets Dajik the Wasp Hunter'),
(13,7,@WOLVARPING,2,31,3,@ZEPIK,0,0,0,'','Spell Wolvar Location Ping targets Zepik the Gorloc Hunter'),
(13,7,@GORLOCPING,0,31,3,@LAFOO,0,0,0,'','Spell Gorloc Location Ping targets Lafoo'),
(13,7,@GORLOCPING,1,31,3,@JALOOT,0,0,0,'','Spell Gorloc Location Ping targets Jaloot'),
(13,7,@GORLOCPING,2,31,3,@MOODLE,0,0,0,'','Spell Gorloc Location Ping targets Moodle'),
(13,7,@DESSAWNRETAINER,0,31,3,@LAFOO,0,0,0,'','Spell Dessawn Retainer targets Lafoo'),
(13,7,@DESSAWNRETAINER,1,31,3,@DAJIK,0,0,0,'','Spell Dessawn Retainer targets Dajik the Wasp Hunter'),
(13,7,@DESSAWNRETAINER,2,31,3,@ZEPIK,0,0,0,'','Spell Dessawn Retainer targets  Zepik the Gorloc Hunter'),
(13,7,@DESSAWNRETAINER,3,31,3,@JALOOT,0,0,0,'','Spell Dessawn Retainer targets Jaloot '),
(13,7,@DESSAWNRETAINER,4,31,3,@MOODLE,0,0,0,'','Spell Dessawn Retainer targets Moodle'),
(13,7,@DESSAWNRETAINER,5,31,3,@GOREGEK,0,0,0,'','Spell Dessawn Retainer targets  Goregek'),
(13,7,@TREASUREPING,0,31,3,@LAFOO,0,0,0,'','Spell Dessawn Retainer targets Lafoo'),
(13,7,@TREASUREPING,1,31,3,@JALOOT,0,0,0,'','Spell Dessawn Retainer targets Jaloot '),
(13,7,@TREASUREPING,2,31,3,@MOODLE,0,0,0,'','Spell Dessawn Retainer targets Moodle'),
(13,7,@DIGGINGFORTEASURE,0,31,3,@GLINTINGDIRT,0,0,0,'','digging for treasure targets glinting dirt'),
(13,7,@MOSSWALKERAURA,0,31,3,@MOODLE,0,0,0,'','Mosswalker village aura targets moodle'),
(13,7,@SPEARBORNAURA,0,31,3,@JALOOT,0,0,0,'','spearborn encampment aura targets moodle'),
(13,7,@MISTWHISPERAURA,0,31,3,@ZEPIK,0,0,0,'','mistwhisper refuge aura targets zepik'),
(13,7,@SAPPHIREHIVEAURA,0,31,3,@DAJIK,0,0,0,'','sapphire hive aura targets dajik'),
(13,7,@SKYREACHPILLARAURA,0,31,3,@DAJIK,0,0,0,'','skyreach pillar aura targets dajik');
Contributor

Pitcrawler commented Apr 4, 2013

AI mismatch error fix

DELETE FROM `creature_ai_scripts` WHERE `creature_id`=28371;
Contributor

Pitcrawler commented Apr 5, 2013

Oh my... what did he do to my conditions?
Please check

SET @LAFOO := 28120;
SET @MOODLE := 28122;
SET @JALOOT := 28121;
SET @CHICKENESCAPEE := 28161;
SET @GOREGEK := 28214;
SET @DAJIK := 28215;
SET @ZEPIK := 28216;
SET @MISTWHISPERLIGHTNINGCLOUD := 28253;
SET @MISTWHISPERLIGHTNINGTARGET := 28254;
SET @GLINTINGDIRT := 28362;
SET @SCAREDSOFTKNUCKLE := 50979;
SET @LIGHTNING := 51172;
SET @FRENZYAURA := 51234;
SET @MISTWHISPERAURA := 51239; 
SET @DIGGINGFORTEASURE := 51405;
SET @TREASUREPING:= 51420;
SET @RAINSPEAKERAURA := 51639;
SET @SPEARBORNAURA := 51642;
SET @MOSSWALKERAURA := 51644;
SET @SKYREACHPILLARAURA:= 51645;
SET @SAPPHIREHIVEAURA := 51651;
SET @WOLVARPING  := 51791;
SET @GORLOCPING  := 51794;
SET @CHICKENLOCATIONPING := 51843;
SET @SCAREDCHICKEN := 51846;
SET @DESSAWNRETAINER := 53163;

DELETE FROM `creature_ai_scripts` WHERE `creature_id`=28371;

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (@LIGHTNING,@SCAREDSOFTKNUCKLE,@FRENZYAURA,@RAINSPEAKERAURA,@WOLVARPING,@GORLOCPING,@DESSAWNRETAINER,@CHICKENLOCATIONPING,@TREASUREPING,@DIGGINGFORTEASURE,@MOSSWALKERAURA,@SPEARBORNAURA,@MISTWHISPERAURA,@SAPPHIREHIVEAURA,@SCAREDCHICKEN,@SKYREACHPILLARAURA);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(13,1,@LIGHTNING,0,31,3,@MISTWHISPERLIGHTNINGTARGET,0,0,0, '', 'Cloud to Lightning hits Mistwhisper Lightning Target'),
(13,1,@LIGHTNING,1,31,3,@MISTWHISPERLIGHTNINGCLOUD,0,0,0, '', 'Cloud to Lightning hits Mistwhisper Lightning Cloud'),
(13,1,@FRENZYAURA,0,31,3,@GOREGEK,0,0,0,'','Spell Frenzyheart Hill Aura targets Goregek the Bristlepine Hunter'),
(13,1,@FRENZYAURA,1,31,3,@DAJIK,0,0,0,'','Spell Frenzyheart Hill Aura targets Dajik the Wasp Hunter'),
(13,1,@FRENZYAURA,2,31,3,@ZEPIK,0,0,0,'','Spell Frenzyheart Hill Aura targets Zepik the Gorloc Hunter'),
(13,1,@RAINSPEAKERAURA,0,31,3,@LAFOO,0,0,0,'','Spell Rainspeaker Canopy Aura targets Lafoo'),
(13,1,@RAINSPEAKERAURA,1,31,3,@MOODLE,0,0,0,'','Spell Rainspeaker Canopy Aura targets Jaloot'),
(13,1,@RAINSPEAKERAURA,2,31,3,@JALOOT,0,0,0,'','Spell Rainspeaker Canopy Aura targets Moodle'),
(13,1,@WOLVARPING,0,31,3,@GOREGEK,0,0,0,'','Spell Wolvar Location Ping targets Goregek the Bristlepine Hunter'),
(13,1,@WOLVARPING,1,31,3,@DAJIK,0,0,0,'','Spell Wolvar Location Ping targets Dajik the Wasp Hunter'),
(13,1,@WOLVARPING,2,31,3,@ZEPIK,0,0,0,'','Spell Wolvar Location Ping targets Zepik the Gorloc Hunter'),
(13,1,@GORLOCPING,0,31,3,@LAFOO,0,0,0,'','Spell Gorloc Location Ping targets Lafoo'),
(13,1,@GORLOCPING,1,31,3,@JALOOT,0,0,0,'','Spell Gorloc Location Ping targets Jaloot'),
(13,1,@GORLOCPING,2,31,3,@MOODLE,0,0,0,'','Spell Gorloc Location Ping targets Moodle'),
(13,1,@DESSAWNRETAINER,0,31,3,@LAFOO,0,0,0,'','Spell Dessawn Retainer targets Lafoo'),
(13,1,@DESSAWNRETAINER,1,31,3,@DAJIK,0,0,0,'','Spell Dessawn Retainer targets Dajik the Wasp Hunter'),
(13,1,@DESSAWNRETAINER,2,31,3,@ZEPIK,0,0,0,'','Spell Dessawn Retainer targets  Zepik the Gorloc Hunter'),
(13,1,@DESSAWNRETAINER,3,31,3,@JALOOT,0,0,0,'','Spell Dessawn Retainer targets Jaloot '),
(13,1,@DESSAWNRETAINER,4,31,3,@MOODLE,0,0,0,'','Spell Dessawn Retainer targets Moodle'),
(13,1,@DESSAWNRETAINER,5,31,3,@GOREGEK,0,0,0,'','Spell Dessawn Retainer targets  Goregek'),
(13,1,@TREASUREPING,0,31,3,@LAFOO,0,0,0,'','Spell Dessawn Retainer targets Lafoo'),
(13,1,@TREASUREPING,1,31,3,@JALOOT,0,0,0,'','Spell Dessawn Retainer targets Jaloot '),
(13,1,@TREASUREPING,2,31,3,@MOODLE,0,0,0,'','Spell Dessawn Retainer targets Moodle'),
(13,1,@CHICKENLOCATIONPING,0,31,3,@GOREGEK,0,0,0,'','Spell chicken ping targets Goregek'),
(13,1,@CHICKENLOCATIONPING,1,31,3,@DAJIK,0,0,0,'','Spell chicken ping targets Dajik '),
(13,1,@CHICKENLOCATIONPING,2,31,3,@ZEPIK,0,0,0,'','Spell chicken ping targets Zepik'),
(13,3,@SCAREDCHICKEN,0,31,3,@CHICKENESCAPEE,0,0,0,'','Scared Chicken targets only chicken escapee'),
(13,1,@MOSSWALKERAURA,0,31,3,@MOODLE,0,0,0,'','Mosswalker village aura targets moodle'),
(13,1,@SPEARBORNAURA,0,31,3,@JALOOT,0,0,0,'','spearborn encampment aura targets moodle'),
(13,1,@MISTWHISPERAURA,0,31,3,@ZEPIK,0,0,0,'','mistwhisper refuge aura targets zepik'),
(13,1,@SAPPHIREHIVEAURA,0,31,3,@DAJIK,0,0,0,'','sapphire hive aura targets dajik'),
(13,1,@SKYREACHPILLARAURA,0,31,3,@DAJIK,0,0,0,'','skyreach pillar aura targets dajik');
Contributor

Pitcrawler commented Apr 5, 2013

Updated

@Pitcrawler Pitcrawler closed this in 4d9eaf0 Apr 5, 2013

Aszune commented Apr 22, 2013

Spell (Id: 53821) listed in spell_target_position expected point to zone 4342 bit point to zone 4356.
Spell (Id: 53821) listed in spell_target_position does not have target TARGET_DEST_DB (17).

Same problem too

Owner

Aokromes commented Apr 22, 2013

Plz open a new ticket with the remaining errors.

@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014

Pitcrawler DB/Conditions: Fix recently introduced startup error, closes #9569 b033b0e
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment