Start Up Errors (from the log files)

List of start up errors and fixes

I will build the list of fixes here for the errors that are currently appearing in the log files.

[CENTER]ERRORS / FIXED
[COLOR="#B22222"]25[/COLOR] / [COLOR="#008000"]25[/COLOR][/CENTER]


Antz implemented a number of updates that fixed a hell of a lot of errors :D


-- ScriptDev2
----------------

[COLOR="#0000FF"]UPDATE gameobject_template SET ScriptName='go_gordunni_trap' WHERE entry=144050;
UPDATE gameobject_template SET ScriptName='go_pirate_treasure' WHERE entry=142194;
UPDATE gameobject_template SET ScriptName='go_inconspicuous_landmark' WHERE entry=142189;
UPDATE creature_template SET ScriptName='boss_netherspite' WHERE Entry=17367;
UPDATE creature_template SET ScriptName='boss_netherspite' WHERE Entry=17368;
UPDATE creature_template SET ScriptName='boss_netherspite' WHERE Entry=17369;[/COLOR]


-- EventAI
-------------

-- scripting done by SD2
[COLOR="#0000FF"]UPDATE creature_template SET AIName='' WHERE Entry=5764;[/COLOR]
-- incorrect value used, 48 should be used for stand state (was set to 47)
[COLOR="#0000FF"]UPDATE creature_ai_scripts SET action1_type=48 WHERE id=840003;
UPDATE creature_ai_scripts SET action1_type=48 WHERE id=1029903;
UPDATE creature_ai_scripts SET action1_type=48 WHERE id=454207;[/COLOR]


-- World Database
----------------------

-- Developer items (Martin ...)
[COLOR="#0000FF"]UPDATE item_template SET displayid=7016, sheath=3, DisenchantID=0 WHERE entry=17;
UPDATE item_template SET dmg_type2=0, sheath=3, DisenchantID=0 WHERE entry=192;[/COLOR]
-- unused entries
[COLOR="#0000FF"]DELETE FROM gossip_menu WHERE entry IN (8671, 8685, 8689, 8690, 8691, 8706, 8707, 8708, 8709);[/COLOR]

-- entry 6535 unused + text_id 7737 and 7738
-- need to locate which core these are from, if any .... looking like Cata

[SIZE=3][COLOR="#800080"]-- COPY OF REMOVED RECORDS[/COLOR][/SIZE]
-- ===========================
-- *** [COLOR="#FF8C00"]To Be Used If The Records Are To Go Back Into The WOTLK/Three Database[/COLOR] *** --

-- 6535 (gossip_menu entries)
-- '6535', '7737', '0', '1801' -- '6535', '7738', '0', '1802'
-- [COLOR="#FF0000"]INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (6535, 7738, 0, 1802);[/COLOR]
-- [COLOR="#FF0000"]INSERT INTO gossip_menu (entry, text_id, script_id, condition_id) VALUES (6535, 7737, 0, 1801);[/COLOR]


-- 7737 npc_text record entry:
-- '7737', 'The ashes from the burning wickerman radiate magical power.', NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0'

-- 7738 npc_text record entry:
-- '7738', 'The ashes from the burning wickerman radiate magical power. You have already applied the ashes to your face.', NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0'

-- [COLOR="#FF0000"]INSERT INTO npc_text (ID, text0_0, lang0, prob0, em0_0, em0_1, em0_2, em0_3, em0_4, em0_5, lang1, prob1, em1_0, em1_1, em1_2, em1_3, em1_4, em1_5, lang2, prob2, em2_0, em2_1, em2_2, em2_3, em2_4, em2_5, lang3, prob3, em3_0, em3_1, em3_2, em3_3, em3_4, em3_5, lang4, prob4, em4_0, em4_1, em4_2, em4_3, em4_4, em4_5, lang5, prob5, em5_0, em5_1, em5_2, em5_3, em5_4, em5_5, lang6, prob6, em6_0, em6_1, em6_2, em6_3, em6_4, em6_5, lang7, prob7, em7_0, em7_1, em7_2, em7_3, em7_4, em7_5) VALUES (7738, 'The ashes from the burning wickerman radiate magical power. You have already applied the ashes to your face.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);[/COLOR]

-- [COLOR="#FF0000"]INSERT INTO npc_text (ID, text0_0, lang0, prob0, em0_0, em0_1, em0_2, em0_3, em0_4, em0_5, lang1, prob1, em1_0, em1_1, em1_2, em1_3, em1_4, em1_5, lang2, prob2, em2_0, em2_1, em2_2, em2_3, em2_4, em2_5, lang3, prob3, em3_0, em3_1, em3_2, em3_3, em3_4, em3_5, lang4, prob4, em4_0, em4_1, em4_2, em4_3, em4_4, em4_5, lang5, prob5, em5_0, em5_1, em5_2, em5_3, em5_4, em5_5, lang6, prob6, em6_0, em6_1, em6_2, em6_3, em6_4, em6_5, lang7, prob7, em7_0, em7_1, em7_2, em7_3, em7_4, em7_5) VALUES (7737, 'The ashes from the burning wickerman radiate magical power.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);[/COLOR]

-- ===================================
[SIZE=3][COLOR="#800080"]-- END OF COPY OF REMOVED RECORDS[/COLOR][/SIZE]

-- [url]http://www.wowhead.com/quest=29376/a-time-to-build-up[/url]
-- [COLOR="#B22222"][SIZE=3]Cata[/SIZE][/COLOR] !!!!

[COLOR="#0000FF"]DELETE FROM gossip_menu WHERE entry = 6535;
DELETE FROM npc_text WHERE id IN (7737, 7738);[/COLOR]
-- Copy of records made above, just-in-case they do belong in WOTLK, but judging by the link, they are Cata