cblair91

you say you HAVE TO use the files in /sql/ folder correct? i loaded everything from the udb server and its all working perfect and can connect fine.

Ok, I have seen here that many people are getting stuck on the databases part. I have also, but now I found out how to work it. follow the updates in the correct order!!! Required files are all here: http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Full_DB/ForCleanInstallOnly/ - for first databases http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Full_DB/ Main core http://unifieddb.svn.sourceforge.net/viewvc/unifieddb/trunk/Updates/0.11.5_additions/ - updates Open SQLyog: create the 3 databases: mangos characters realmd ok, now load the mangos.sql from the folder /ForCleanInstallOnly/ Load UDB Core onto that from the /Full_DB/ Load the updates from /0.11.5_additions/ in the following order: [list] * 380_corepatch_mangos_7682_to_7984.sql * 380_updatepack_mangos.sql * 381_corepatch_mangos_7895_to_8029.sql * 381_updatepack_mangos.sql * 382_corepatch_mangos_8030_to_8280.sql * 382_updatepack_mangos.sql [/list] Select characters and load on the database charaters.sql from /ForCleanInstallOnly/ Load the following updates from /0.11.5_additons/ in the following order [list] * 380_corepatch_characters_7682_to_7894.sql * 381_corepatch_characters_7895_to_8029.sql * 382_corepatch_chatacters_8030_to_8280.sql [/list] Select realmd and load the database realmd.sql from /ForCleanInstallOnly/ Load the following updates from /0.11.5_additions/ in the following order [list] * 380_corepatch_realmd_7682_to_7894.sql * 381_corepatch_realmd_7895_to_8029.sql [/list] Once you have loaded all them databases in correctly, make shure your mangosd.conf is set to the correct databases with correct mysql password and username. Load mangosd.exe and it should run smoothly and the end process should look like this once it is done: 2009-08-26 08:38:38 >> Loaded 19 transports 2009-08-26 08:38:38 Deleting expired bans... 2009-08-26 08:38:38 Calculate next daily quest reset time... 2009-08-26 08:38:38 Starting objects Pooling system... 2009-08-26 08:38:39 Starting Game Event system... 2009-08-26 08:38:39 GameEvent 31 "Edge of Madness, Renataki" started. 2009-08-26 08:38:39 WORLD: World initialized 2009-08-26 08:38:39 mangosd process priority class set to HIGH 2009-08-26 08:38:39 2009-08-26 08:38:39 Run realmd.exe and it should look like this if its working: 2009-08-25 23:29:35 Using configuration file realmd.conf. 2009-08-25 23:29:35 Database: 127.0.0.1;3306;root;pombom;realmd 2009-08-25 23:29:35 MySQL client library: 5.0.56 2009-08-25 23:29:35 MySQL server ver: 5.4.1-beta-community 2009-08-25 23:29:35 Added realm "MaNGOS". 2009-08-25 23:29:35 realmd process priority class set to HIGH 2009-08-25 23:29:35

With that error, sometimes microsoft changes that location to

*edit* managed to fix it *edit* When i load the UDB onto my mangos database - i get the following error when i try to load mangosd.exe 2009-08-26 08:09:43 2009-08-26 08:09:43 2009-08-26 08:09:43 Loading Localization strings... 2009-08-26 08:09:43 2009-08-26 08:09:43 >> Loaded 0 creature locale strings. DB table `locales_creature` is empty. 2009-08-26 08:09:43 2009-08-26 08:09:43 >> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty. 2009-08-26 08:09:43 2009-08-26 08:09:43 >> Loaded 0 Item locale strings. DB table `locales_item` is empty. 2009-08-26 08:09:43 2009-08-26 08:09:43 >> Loaded 0 Quest locale strings. DB table `locales_quest` is empty. 2009-08-26 08:09:43 2009-08-26 08:09:43 >> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty. 2009-08-26 08:09:43 2009-08-26 08:09:43 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty. 2009-08-26 08:09:43 2009-08-26 08:09:43 >> Loaded 0 npc_option locale strings. DB table `locales_npc_option` is empty. 2009-08-26 08:09:43 2009-08-26 08:09:43 >> Loaded 0 points_of_interest locale strings. DB table `locales_points_of_interest` is empty. 2009-08-26 08:09:43 >>> Localization strings loaded 2009-08-26 08:09:43 2009-08-26 08:09:43 Loading Page Texts... 2009-08-26 08:09:43 >> Loaded 1625 page texts 2009-08-26 08:09:43 2009-08-26 08:09:43 Loading Game Object Templates... 2009-08-26 08:09:43 ERROR:Error in gameobject_template table, probably sql file format was updated (there should be 39 fields in sql).