Jump to content
  • Start Up Errors (from the log files)


    Chucksta
    • Status: Completed
      Main Category: Database
      Sub-Category: sqlupdate
      Version: 0.12.3 Milestone: 20 Priority: Normal
      Implemented Version: 20

    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


    User Feedback

    Recommended Comments

    There is an annoying difference in EventAI action definitions. [B]Zero[/B]:
    ACTION_T_SET_STAND_STATE = 47, // StandState, unused, unused
    ACTION_T_CHANGE_MOVEMENT = 48, // MovementType, WanderDistance, unused
    ACTION_T_SUMMON_UNIQUE = 49, // CreatureId, Target, SpawnId
    ACTION_T_EMOTE_TARGET = 50, // EmoteId, TargetGuid

    [B]Two[/B]:
    ACTION_T_SUMMON_UNIQUE = 47, // CreatureId, Target, SpawnId
    ACTION_T_SET_STAND_STATE = 48, // StandState, unused, unused
    ACTION_T_CHANGE_MOVEMENT = 49, // MovementType, WanderDistance, unused

    I suppose it would be better to unify it throughout the cores, or else this will not be the last ACID/EAI problem of such type.

    Link to comment
    Share on other sites

    Gonna raise a thread specifically for this. There may be a good number of database records affected.

    Two needs to be put in-line with Zero and One, obviously.

    issue raised under
    [url]https://www.getmangos.eu/issue.php?issueid=883[/url]

    ----------------------------------------------------------------
    Marking the issue in this thread as completed :)

    Link to comment
    Share on other sites


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use