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.
[code]
ERROR 1062 (23000) at line 11: Duplicate entry '1018206' for key 'PRIMARY'
[/code]
I will try to sort it.
*UPDATE*
It is the following line throwing the error.
[code]
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');
[/code]
*UPDATE*
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.
Recommended Comments
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 accountSign in
Already have an account? Sign in here.
Sign In Now