[YTDB] Unable to execute Mangos database, NEED HELP!
So i downloaded Mangos and DB files from http://forum.ragezone.com/f436/mango...ngelog-616424/ and proceeded to start setting up my server.
I extracted the Mangos folder onto my Desktop and renamed it after my server. I then extracted the maps, buildings and dbc folders into the Mangos/Server folder the way they were.. "maps", "buildings" and "dbc", From there i installed Sqlyog and MySQL, i executed realmd and characters just fine.. but am unable to execute these files..
When i execute r1567_mangos.sql i get the following error:
Quote:
[Err] 1146 - Table 'mangos.creature_template' doesn't exist
[Err] UPDATE creature_template SET ScriptName='npc_deathstalker_faerleia' WHERE entry=2058;
[Msg] Finished - Unsuccessfully
When i execute r1567_scriptdev2.sql i get the following error:
Quote:
[Err] 1146 - Table 'scriptdev2.script_texts' doesn't exist
[Err] DELETE FROM script_texts WHERE entry IN (-1000553,-1000554);
[Msg] Finished - Unsuccessfully
Is there any reason for this? Have i done something wrong, If so could anyone please guide me on how i could correct and resolve this matter or if there is a fix for this.
If i am executing the wrong files could someone please direct me where to obtain the correct files and/or how to do it briefly.
Thanks, Much appreciated
Re: [YTDB] Unable to execute Mangos database, NEED HELP!
It looks like you havent executed the Full DB, You can find it on the same link you downloaded everything else from, Same goes for ScriptDev..
That should work for you, and then you can apply the updates.
Im using the same as you =D Just taking me like 6 hours to execute the full Mangos Database =(