Mangos Two Rev 12578 - Scriptdev errors

[student1]

Hi Auntie Mangos ,

Might need some help figuring this one out.

Downloaded the latest compile for Mangos Two from the download section (12578).

I am able to get everything installed on windows but I run into errors when trying to apply mangos_scriptname_full.sql to my mangos database.

I created a new mangos database, installed the full mangos structure and data using mangos_full_db.sql but when I try to apply the scriptdev2 data over it I get the following error :

[Err] 1146 - Table 'mangos.scripted_event_id' doesn't exist

[Err] DELETE FROM scripted_event_id WHERE id=14797;

[Msg] Finished - Unsuccessfully

--------------------------------------------------

I first ran mangos_scriptname_clear.sql and then mangos_scriptname_full.sql over my freshly installed db.

Mangos loads fine, but it is missing all the scriptdev2 scripts so I get a bunch of errors.

"2014-05-24 14:46:30 Script registering but ScriptName go_father_flame is not assigned in database. Script will not be used.

2014-05-24 14:46:30 Script registering but ScriptName go_black_dragon_egg is not assigned in database. Script will not be used.

2014-05-24 14:46:30 Script registering but ScriptName npc_kernobee is not assigned in database. Script will not be used.

2014-05-24 14:46:30 Script registering but ScriptName npc_netherspite_portal is not assigned in database. Script will not be used.

2014-05-24 14:46:30 Script registering but ScriptName npc_echo_of_medivh is not assigned in database. Script will not be used.

2014-05-24 14:46:30 Script registering but ScriptName npc_king_llane is not assigned in database. Script will not be used.

2014-05-24 14:46:30 Script registering but ScriptName npc_warchief_blackhand is not assigned in database. Script will not be used.

2014-05-24 14:46:30 Script registering but ScriptName npc_human_conjurer is not assigned in database. Script will not be used.

2014-05-24 14:46:30 Script registering but ScriptName npc_orc_warlock is not assigned in database. Script will not be used.

2014-05-24 14:46:30 Script registering but ScriptName npc_human_footman is not assigned in database. Script will not be used.

etc."

Any easy way to load the sd2 scripts into mango or did I miss something?

Thanks!!

[gmy77]

Thanks to student1 to open this post... I have the same problem... and i not find way to install DB... any idea how to proceed ? I standing in front of this problem... unsormontable for me.

Thank you in advance for any help.

[student1]

I believe there was a bug in the sql, table scripted_event was called scripted_event_id I had to rename it to scripted_event and it worked perfectly.

Now that issue is fixed but I noticed a bunch of other errors:

"2014-05-24 21:07:00 ERROR CreatureEventAI: Event 22301 Action1 uses incorrect Target type 1 for event-type 10 (cannot be used OOC)

2014-05-24 21:07:00 ERROR CreatureEventAI: Event 27701 Action1 uses incorrect Target type 1 for event-type 10 (cannot be used OOC)

"

Are these normal?

Thanks

Edit: Answered my own question, this is an unresolved acid issue.

Some other errors on the database would benefit from this fix :

UPDATE creature_template_addon SET auras = REPLACE(auras, '46598', '');

UPDATE creature_template_addon SET auras = REPLACE(auras, ' ', ' ');

UPDATE creature_template_addon SET auras = TRIM(auras);

UPDATE creature_template_addon SET auras = NULL WHERE auras = '';

UPDATE creature_addon SET auras = REPLACE(auras, '46598', '');

UPDATE creature_addon SET auras = REPLACE(auras, ' ', ' ');

UPDATE creature_addon SET auras = TRIM(auras);

UPDATE creature_addon SET auras = NULL WHERE auras = '';

[antz]

Thanks for these updates, I have moved the detail into a tracker post - so that the next updates run will pick these up