cblair91

If you do the above instructiosn to the letter you do in fact get the same problem that KGTM stated. When you create a character it will not show up in your character list. You must use the characters and realmd sql dumps from the mangos source folder not the udb folder.The path will look similar to this

new folder\\mangos source\\sql\\characters.sql

new folder\\mangos source\\sql\\realmd.sql

This is in fact how the instructions are given on the udb forum post http://udbforums.org/index.php?topic=12622.0. You will not need to update the characters and realmd databases sicen the latest revision of mangos source is higher thatn the udb 382 update.

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 

I too have that issue. I can't find it in my program files.. i dont think it exists. Does that matter? If so, what do i do? Thanks!

With that error, sometimes microsoft changes that location to

C:/Program Files/Microsoft SDKs/*your sdk*/bin/

*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).