Jump to content
  • Patch 20003_08 duplicate entry

    • Status: Completed
      Main Category: Database
      Sub-Category: sqlupdate
      Version: 2.0.11 Milestone: 20 Priority: High
      Implemented Version: 0.20

    Patch 20003_08 duplicate entry

    Alright, I created a fresh DB after dropping the old one. I then used "mangosdLoadDB.sql" to create the core tables. Then I went into "FullDB" and applied all of the SQL files there. After that I went into the "Updates/Rel20" directory and started applying updates, starting with 20003_05. 20003_08 has a duplicate entry when applied.
    ERROR 1062 (23000) at line 11: Duplicate entry '1018206' for key 'PRIMARY'
    I will try to sort it.


    It is the following line throwing the error.
    INSERT INTO `creature_ai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES ('1018206', '10182', '31', '0', '100', '1', '-3564.712646', '2095.848877', '41.744026', '0', '41', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Rexxar - (TBC Rokaro) Despawn at end of route');


    20003_09 is also related to Rexxar and also fails to apply. Are these already in the core DB setup? The ones after this applied just fine.

    User Feedback

    Recommended Comments

    20003_08 and 20003_09 are in the Rel20 core DB. Although, they should be named 20005_01 and 20005_02, as the 2nd (Misha) relies on the first (Rexxar), and neither relies on any of the previous scripts.

    For anyone who has cloned the latest Rel20, they do not need to apply those scripts. They were both merged with the database only a matter of a few hours after being committed.

    I know nothing about the 20003_05 one.

    EDIT: I just checked the database, having cloned it for a fix in another thread, and the names do start with 20005_01 and 20005_02. I'll now clone the database via the main repo, and see what I get.
    git clone --recursive git://github.com/Chuck5ta/database -b Rel20

    EDIT again: Well, that's weird, now they show as 20003_08 and 20003_09
    git clone --recursive git://github.com/mangoszero/database -b Rel20

    Link to comment
    Share on other sites

    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

  • 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