Reaper-X » Emulators » Freeware » Guide » How To » MMORPG » Misc. Games » Software » Tutorials » Creating WoW Private Server the easier way (perhaps)

Creating WoW Private Server the easier way (perhaps)

Update : You can browse this site software category if you’re looking for my mangos release or my custom mangos release … btw i’d suggest you to get my mangos release first because it has been tested with WoW 2.2.3 and will be updated frequently (even easier than anything written on this old post because i already include everything you need to run your own wow private server except for mysql program of course)

Or you can also look at the recent software section located at the footer section of this website to see the new update to my mangos release :)

This is the old version of my WoW Private Server Guide, the new version that gives you a detailed step (with images) can be found at below links :

  1. Installing MySQL
  2. Setting up the Mangos
  3. Just in case you want to create lan party
  4. Setting up the webserver to put registration page

Maybe my previous post about creating WoW private server is a little bit confusing for some people and that’s why i create another post on how to set up world of warcraft private server once again but this time … i promise it is not going to be confusing like before :D … and actually i should be thanking everyone who put comments on my previous post, because of their comments i was able to get new topics for my blog … hahaha

Okay and that’s all on the introduction part … now let’s start the guide, but before that please keep this in mind, this guide tested with 1.12.1 World of Warcraft Client (known as WoW Classic) non modified in any part and tested to work with Mangos Revision 3462, but this guide can also be used if you’re going to create The Burning Crusade server although you’ll need to get different database dump from someone else, and of course getting the newer mangos release :

Required Software

1. Mangos Revision 3462 : The mangos release is compiled by Maxi and this release also include the following patches :

  • ScriptDev2 R34
  • Honor 0.71
  • MCH 1.5c

And just like i said to make thing easier, i upload this mangos release (just in case Maxi reading this, and he does not want me to upload his file here … let me know immediately so i can remove it … because i already forgot where i get his release) .. i think it is from his userbeam / beam something folder

2. Complete SDB with Changesets 156 : Because there’re problem for some people when importing each changeset, i decided to release the SDB used by me … and this SDB updated till changesets 156

But i also include, the create database, and realmd database to make thing even easier

3. MySQL : Essential program, the above 2 files can not be used if you dont have this installed :)

4. Map & DBC Extractor : This is tested to work with World of Warcraft Client version 1.12.1 and Mangos Revision 3459 and Revision 3462 only

But just as i said before, to make thing simpler. I’ve uploaded the DBC Files (maps not included because the file size is bigger than i thought, and my connection speed is nothing compared to all of you) .. and that means all you have to do is just using the ad.exe / map extractor to extract the WoW Maps

Mirror to download the above files if you’re having problem with Megaupload :

  • Complete SDB Dump for Mangos 3462 WoW Classic
  • Mangos 3462 by Maxi
  • World of Warcraft 1.12.1 DBC Files

Let’s Start

I assume you’ve already downloaded the required software and already installed it (for more in-depth WoW Mangos installation please refer to my previous post)

1. Install the MySQL Software and configure it accordingly, in this example MySQL installed in C:\MySQL and using the default root password which is blank

2. Extract the Complete Database file somewhere in your harddisk, and you’ll see there’re 3 files :

  • create-database.sql
  • realm-database-full.sql
  • mangos-full-for-rev3462.sql

Run it by using this command (this time i make sure to use the default path instead of using command which is already set in environment variable path) from Start Menu => Run => cmd (this cmd can only be used in Windows XP) or command (Win9x) => and change to the extracted directory :)

  1. C:\MySQL\bin\mysql.exe -u root < create-database.sql
  2. C:\MySQL\bin\mysql.exe -u root -D realmd < realm-database-full.sql
  3. C:\MySQL\bin\mysql.exe -u root -D mangos < mangos-full-for-rev3462.sql

Note : The create database will also drop your realmd and mangos database if it is found .. i do this in order to make thing easier (how many times did i say this words in this post) lol

Yet another Note : Extract the database into the same path where your MySQL bin located, or if you already extracted it somewhere adjust the path like below for example :

C:\MySQL\bin\mysql.exe -u root < X:\where_SDB_extracted\create-database.sql

3. Put the downloaded DBC Directory somewhere, in this example C:\WoW\Data\DBC

4. Copy the ad.exe into your WoW installation directory also create directory called maps and run it .. and wait till finished and move the maps directory into C:\WoW\Data\maps

5. Extract the Mangos file somewhere, for example C:\WoW\Mangos. And open the mangosd.conf and edit the DataDir into something like below

DataDir = “C:/WoW/Data”

If you’re using the example path given in this guide, you can use the above datadir configuration

6. Run the mangosd.exe and realmd.exe …. and you’re finished :D configuring the server

7.I’m sorry i forgot to write the last step in this post (thanks to GreekSoul). Now since you’ve finished configuring the server all you have to do now is configuring the client (WoW game) to connect to your server instead of using the default / official server. And it can be done by open the realmlist.wtf in your WoW Game directory and change the realmlist into 127.0.0.1 … and you’re all set

Common Question

I create this part thanks to all the commenters before … especially to metaltildea, PepsiG, Xtonic, luke, Venomz, etc

Q : hay me again it works but the CMD thing it says that the thing u wrote up dosnt exist on the second time
so it wont make the directory :(

A : If you tried to run the mysql command directly without setting it to use the env. variable path, you’ll get that error message … also CMD only work in Windows 2K (correct me if i’m wrong because i already forget about it) and Windows XP (guaranteed to work)

Q : I forget about the signs that dont let me post it.. ERROR 1045 (28000): Access denied for user `username @ localhost` (using password: NO)

A : That error message means, you’re trying to use wrong password for a username, username does not exist, etc .. but in this case, you’re trying to use non existent username (because it was an example)

Q : ERROR 2017 (HY000): Can’t open named pipe to host: . pipe: mysql (2)

A : If you’re trying to use named pipe (this mysql feature only can only be used on NT series such as Windows XP) and you havent configured mysql to do so .. you’ll get that message … to fix it you just have to put below line into you my.ini file (do not forget to restart the mysql service after you done)

enable-named-pipe

Q : Can i import the official data from Blizzard server into my mangos server ?

A : The answer is no, because … blizzard is using different server software which is not available to public .. and no one have access to their server :P ..

Q : my add.exe wont run in my wow map

A : Did you create the maps folder first ? if you did not create it you’ll get an error message. Also you’ll need to run it in your root directory of your WoW installation directory

Q : I can’t run ad.exe or MPQE

A : Im sure there’re missing runtime in your windows system, try downloading and installing below 2 files first and see if it’s fixes the problem or not

- Microsoft .NET 2 Runtime
- Microsoft Visual C++ 2005 Redistributable Package

Q : ERROR 1264 at line 294: Out of range value adjusted for column ‘waittime’ at row 1

A : You’re trying to insert value higher than the allowed value specified in your mysql table … but in this case, this error message seems strange, because i have no problem importing the SDB files including it’s changesets … and that’s why i create this post and upload my database dump :)

Q : I want to be a GM in my mangos server

A : Look at the step #10 in my in-depth explanation on setting up mangos server (do not copy paste the text directly because it’ll give you error message) … and if you get other error message just leave comment here :)

Q : What are the GM Commands ?

A : After making your account to be a GM account, type this ingame .commands and you’ll see available commands to use

Q : My friends can’t connect to my server ?

A : Try checking your configuration especially at port configuration, and make sure there’s no conflict

Okay that’s all for now … i’ll be sure to update this post / create new post if i found something new from you :)

Tags: Apachedatabaseemulatorgamegm commandsGuidemangosmegauploadmysqlPHPprivate serverserverSoftwarewarcraftwebserverWindowsworld of warcraftwow

Leave a Comment

Comments Navigation 1 2 3 4 5 6 ... 9
  1. JeremiahMan said Jun 19, 2007 at 8:05 pm

    Probably when you re imported the files it might have changed something

  2. JeremiahMan said Jun 19, 2007 at 8:02 pm

    HEY BIG BOIS Using DataDir @MANGOSD_DATA@/ That means you need to open up mangosd.conf and edit that to where ever your WoW Data folder is ex: C:\World of warcraft\data

  3. BIGBOS said Jun 18, 2007 at 8:00 pm

    2007-06-18 15:59:47 Database: 127.0.0.1;3306;mangos;mangos;realmd
    2007-06-18 15:59:48 ERROR:SQL: SELECT `id`, `name`,`address`,`port`,`icon`,`color`,`timezone` FROM `realmlist` ORDER BY `name`
    2007-06-18 15:59:48 ERROR:query ERROR: Table ‘realmd.realmlist’ doesn’t exist
    2007-06-18 15:59:48 ERROR:No valid realms specified.

  4. BIGBOS said Jun 18, 2007 at 7:56 pm

    2007-06-18 15:48:32 World Database: 127.0.0.1;3306;mangos;mangos;mangos
    2007-06-18 15:48:32 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
    2007-06-18 15:48:32 Realm running as realm ID 1
    2007-06-18 15:48:32 ERROR:SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `account`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = ‘1′
    2007-06-18 15:48:32 ERROR:SQL ERROR: Table ‘realmd.account’ doesn’t exist
    2007-06-18 15:48:32 Using DataDir @MANGOSD_DATA@/
    2007-06-18 15:48:32 ERROR:Check existing of map file ‘@MANGOSD_DATA@/maps/0004331.map’: not exist!
    2007-06-18 15:48:32 ERROR:Correct *.map files not found in path ‘@MANGOSD_DATA@/maps’. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.

  5. BIGBOS said Jun 18, 2007 at 7:55 pm

    I set data dir this way ( DataDir=C:\wow\data ) and I reimported the sql files :

    C:\MySQL\bin\mysql.exe -u root

  6. BIGBOS said Jun 18, 2007 at 7:53 pm

    I set data dir this way ( DataDir=C:\wow\data )
    and I reimported the sql files : C:\MySQL\bin\mysql.exe -u root 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = ‘1′
    2007-06-18 15:52:35 ERROR:SQL ERROR: Table ‘realmd.account’ doesn’t exist
    2007-06-18 15:52:35 Using DataDir @MANGOSD_DATA@/
    2007-06-18 15:52:35 ERROR:Check existing of map file ‘@MANGOSD_DATA@/maps/0004331.map’: not exist!
    2007-06-18 15:52:35 ERROR:Correct *.map files not found in path ‘@MANGOSD_DATA@/maps’. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.

    :( :( :( :( :( :( :( :(

  7. Reaper-X said Jun 18, 2007 at 5:41 pm

    # Blasphemy

    ahahaha .. im sorry if i didnt answer, im sure i miss that question :)

    to get 1.12.1 client (i assume you’ve installed the previous update) … you just need to search it using google here’s an example :

    http://www.google.com/search?q=1.12.1+client

    it’ll give you the result (btw it seems that 1.12.1 client words are famous since i dont use any other keywords after it) :P

    # BIGBOS

    There are two errors from that log

    1. realmd.account doesn’t exist

    Solution : reimport the sql files (to make thing easier, reimport all the sql files)

    2. @MANGOSD_DATA@/maps/0004331.map

    Solution : you didnt change the datadir in the mangosd.conf, you need to change it and adjust it to your data path

    # Divinity

    That error message means you dont have InnoDB configured on your mysql installation, try reconfigure mysql

    if you use the mysql server instance config wizard enable the transaction database :)

    note: mysql server instance wizard automatically installed when you install mysql 5, if it doesnt exist try downloading the 40++ MB (full mysql) instead of the small version

  8. Divinity said Jun 18, 2007 at 8:21 am

    batch proudly presented by
    ▄▄▄▄ ▄▄▄▄▄▄▄███████
    █▓▓▓▐ ▄▄▄▄▄▄█▓▓▓▓▓▓█▓▓▓▓▓▓█
    █▓▓▓▐ █▓▓▓▓▓▓▐▓▓ ▓▓█▓▓▓▓▓▓▓█
    █▓▓▓▐ █▓▓▄▄▓▓▐▓▓▓▓▓▓█▓▓ ▓▓█
    █▓▓▓▐ █▓▐ ▌▓▐▓▓▄▓▓█▐▓▓ ▓▓█
    █▓▓▓▐ █▓▐ ▌▓▐▓▓▌▌▓▓█▓▓ ▓▓▓█
    █▓▓▓▐▄▄▄▄█▓▓▀▀▓▓▐▓▓▌▌▓▓█▓▓▓▓▓▓▓█
    █▓▓▓▓▓▓▓▓▓█▓▓▓▓▓▐▓▓▌▌▓▓█▓▓▓▓▓▓▐
    █▓▓▓▓▓▓▓▓▓█▀▀▀▀▀█▓▓▌▌▓▓█▄▄▄▄▄▄▀
    ▀▀▀▀▀▀▀▀▀ ▀▀ ▀▀▀
    █▀▀▀▀▀▀▀▀▀▄▄▄▄▄▄▄ ▄▄ ▄▄▄
    █░░░░░░░░░█░░░░░░░█░░█ █░░▐
    █░░░░░░░░░█░░ ▐░░█░░░█░░░▐
    ███░░░▐███░░ ▐░░█░░░░░░░▐
    █░░░▐ █░░ ▐░░█░░███░░▐
    █░░░▐ █░░░░░░░█░░█ █░░▐
    █░░░▐ ███████ ███ █░░▐
    █░░░▐ █░░▐
    ████ █░░█
    ▄ ▄▄░░▐
    ─────────────── ▐░▄▄▄░░▀▀▀
    [LorD TOm] ▐░░░▀▀
    ─────────────── ▀▀▀
    070617 21:20:11 InnoDB: Operating system error number 32 in a file operation.
    InnoDB: Some operating system error numbers are described at
    InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html

    InnoDB: File name .\ibdata1
    InnoDB: File operation call: ‘open’.
    InnoDB: Cannot continue operation.
    Press any key to continue . . .

    What do i do i cant figure it out…much help appreciated….

  9. BIGBOS said Jun 17, 2007 at 8:56 pm

    sory for the boder but how to adjust my mySQL ??? :(

  10. BIGBOS said Jun 17, 2007 at 8:52 pm

    and how to adjust my mySQl ???

    sory for the boder :(

  11. BIGBOS said Jun 17, 2007 at 8:51 pm

    and how to adjust my mySQl ???

  12. BIGBOS said Jun 17, 2007 at 8:48 pm

    2007-06-12 19:59:59 World Database: 127.0.0.1;3306;mangos;mangos;mangos
    2007-06-12 19:59:59 Login Database: 127.0.0.1;3306;mangos;mangos;realmd
    2007-06-12 19:59:59 Realm running as realm ID 1
    2007-06-12 19:59:59 ERROR:SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `account`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = ‘1′
    2007-06-12 19:59:59 ERROR:SQL ERROR: Table ‘realmd.account’ doesn’t exist
    2007-06-12 19:59:59 Using DataDir @MANGOSD_DATA@/
    2007-06-12 19:59:59 ERROR:Check existing of map file ‘@MANGOSD_DATA@/maps/0004331.map’: not exist!
    2007-06-12 19:59:59 ERROR:Correct *.map files not found in path ‘@MANGOSD_DATA@/maps’. Please place *.map files in the directory pointed by this path or correct the DataDir value in the mangosd.conf file.

    These are my maps folder is on place

  13. Blasphemy said Jun 17, 2007 at 8:09 pm

    I have seen the question asked, but never an answer given, where can we get the 1.12.1 client? I have a copy of the game somewhere, but is there somewhere we can download that version of the client?

  14. Reaper-X said Jun 17, 2007 at 7:06 pm

    # BIGBOS

    open the server.log in your mangos directory and look for the error message as for the rest you just need to adjust everything based from that error message ;)

    common error message :

    Q : map not found / anything related to map
    A : extract map from your wow installation using ad.exe

    Q : Mysql related error
    A : adjust your mysql username (this is the most common problem i’ve seen from various email i get) or adjust the database and username accordignly

    # Brutus

    Which SDB you’re using ? it seems you’re not using compatible SDB / WoW Database version designed for the mangos version / revision you’re running

    # Gregory

    MySQL 5.x Community edition should do the job ;)

    # underdeath

    Depending on your wow version and mangos revision that error message could means :

    - You’re setting up WoW TBC server using and try to connect to the TBC server using WoW Classic .. and you’ll get that error message

    - Another program / you modified WoW data (if you didnt edit anything then you dont need to worry about this)

  15. underdeath said Jun 17, 2007 at 9:10 am

    when i log in i get the error:

    Unable to validate game version. This may be caused by file corruption or the interference of another program. Please visit http://www.blizzard.com/support/wow/ for more information and possible solutions to this issue.

  16. Gregory said Jun 17, 2007 at 4:35 am

    hello
    I was just wondering which mysql do u download my friend?

  17. Brutus said Jun 16, 2007 at 11:22 pm

    Hi Reaper-X,

    I opened the database with SQLyog when i count the collums in Item_template i have only 122 items in it. Mangosd.exe asks more rules.

    Greetz Brutus

  18. Brutus said Jun 16, 2007 at 11:01 pm

    Hi Reaper,

    Im trying for to days now to start a wow server. when I run MangosD.exe i get the following error:

    Loading Items…
    Error in `item_template` table, probably sql file format was updated (there shou
    ld be 134 fields in sql).

    Firts i was running version 1.12.0 on mij server now i updated it tot 1.12.1 but it still gives me this error. Hopefully you can help me.

    Thnx Brutus

  19. BIGBOS said Jun 16, 2007 at 6:51 pm

    how to fix it ???????

  20. Reaper-X said Jun 16, 2007 at 6:17 pm

    # Tjikijiki

    The most important program is of course the mysql because mangos will not work without it :)

    as for creating GM account you just need to do the same step like importing the mysql with the exception this time you’re going to run different command

    # BigBoss

    What problem ? mangos process close itself ?

    mangos process close itself automatically = incorrect configuration / database

  21. BIGBOS said Jun 16, 2007 at 5:28 pm

    Then I delete all and started all over and it got worse :(

  22. BIGBOS said Jun 16, 2007 at 5:27 pm

    I have the same problem :(

  23. Tjikijiki said Jun 15, 2007 at 12:01 am

    So If I restart my PC (normal startup), what programs do I need to start to host a server? Clicking on Mangosd.exe and realmd.exe? When I do that, Mangosd opens, runs stuff, then disappears really quickly, but no errors. Realmd opens and stays, the text says:

    Database: 127.0.0.1;3306;mangos;mangos;realmd
    Added Realm “ReaperX”.
    realmd process priority class set to HIGH

    Is there anything else I need to run?

    I need to set my server to accept players off of my network, what do I do to allow them?

    Finally, I didn’t understand you instructions on how to create GM accounts and player accounts, can you spell it out to a newb like me?

    Thanks so much

  24. JeremiahMan said Jun 14, 2007 at 11:56 pm

    Hey Mike make sure you extract the DBC files in the right order

  25. JeremiahMan said Jun 14, 2007 at 11:54 pm

    Little Stu try uninstalling Mysql…. Do this by going to Start menu Mysql Mysql Server instance config and stop the instance running. After that Go to My computer Control panel Uninstall/addprograms and uninstall it from their. After that go to Mycomputer C Drive and where ever you installed mysql and delete what ever it left behind after it was uninstalled. After Deleting it then you should just reinstall it. I had to do it about 3 times to get it to work right. Are you using Windows Vista?

  26. JeremiahMan said Jun 14, 2007 at 11:49 pm

    Hey gum drops I had the same problem when I was setting up the server. The way I corrected this was Uninstalling EVERYTHING! THE MYSQL, MANGOS DELETING THE MAPS ETC. Get ride of all the files. Some times you might have dupilicate files and for some reason it messes up everything. After you get ride of everthing……………..By of course uninstalling then going through Directory’s and deleting the files that were left behind. Then Just redo everything and you should be good!

  27. Smithy said Jun 14, 2007 at 6:27 pm

    Yay, made my server, problem is I cant connect :S, when i type in info, it says Users: 0 (Max: 0) I am assuming this is why I cant connect… help please

  28. Gumdropps said Jun 14, 2007 at 5:04 pm

    Ok, let me apologize in advance if I fail to clarify my problem.

    I am currently having the following problems:

    1. I attempted to run MangosD.exe; it started and closed in roughly 1 second. I went through all of these posts (on this and the old topic) and the repeated response is “check your log”, so I did. The only error reads

    ERROR:Check existing of map file ‘“C:/WoW/Data”/maps/0004331.map’: not exist!

    So, naturally, I went to my directory and checked it out. The file does indeed exist. I’m looking right at it.

    2. This is most likely directly related to problem (1), but, when I attempt to run WoW (I put a seperate installation of classic WoW to test the self-server waters and see if this way my kinda thing or not) it gets an error (even if i use the gamemaster username/password) that reads something along the lines of:

    “Unable to validate game version. This may be caused by file corruption or the interference of another program” (and then gives the wow error web address)

    So once again, I searched these posts. The common solution listed here is that it is related to TBC patch, but the version I am running for this server experiment is the 1.12 one (busted out the discs and the old patches and everything.) and not TBC at all.

    -Is this error because I have 2 folders of WoW, one pure and with TBC for use on the WoW servers, and this classic one for use for this one; or is this error because of problem #1, the suddenly shutting down mangosd.exe that for some unknown reason can’t find the map file that actually is there??

    3. I cannot make a GM account in Mysql if my life depended on it. I’m simply not grasping the problem, when I type the insert into ‘account’ line and then the values data it, instead of processing it, starts a new line that begins in
    “>
    Though after reading more of this post it doesn’t seem to be that big a deal as long as I use the Gamemaster/Gamemaster thing that comes with Mangos (should I be graced enough to get it to work x_x)

    Sorry for the long post, I await your response, it’s not the end of the world if you can’t respond soon (but I must admit these errors are ticking me off some)

    -Gumdropps-

  29. Chris said Jun 13, 2007 at 11:56 am

    Errm i have Error 1044 when trying to connect to make a gm file. it says: ERROR 1044 : Access denied for user ‘ ‘@’localhost’ to database ‘realmd’

  30. Mike said Jun 13, 2007 at 11:10 am

    2007-06-13 00:01:04 World Database: 127.0.0.1;3306;root;mangos;mangos
    2007-06-13 00:01:04 Login Database: 127.0.0.1;3306;root;mangos;realmd
    2007-06-13 00:01:04 Realm running as realm ID 1
    2007-06-13 00:01:04 Using DataDir C:\Program Files\World of Warcraft\Data\
    2007-06-13 00:01:04 Initialize data stores…
    2007-06-13 00:01:05
    2007-06-13 00:01:05 >> Loaded 32 data stores
    2007-06-13 00:01:05
    2007-06-13 00:01:05 Using Autodetected DBC Locale (0).

    2007-06-13 00:01:05 Cleaning up instances…
    2007-06-13 00:01:05
    2007-06-13 00:01:05 >> Initialized 0 instances, deleted 0 old instances
    2007-06-13 00:01:05 Packing instances…
    2007-06-13 00:01:05
    2007-06-13 00:01:05 >> Instance numbers remapped, next instance id is 1
    2007-06-13 00:01:05 Loading Game Object Templates…
    2007-06-13 00:01:05 ERROR:`gameobject_template` table is empty!

    2007-06-13 00:01:05 >> Loaded 0 game object templates
    2007-06-13 00:01:05
    2007-06-13 00:01:05 Loading Spell Chain Data…
    2007-06-13 00:01:05
    2007-06-13 00:01:05 >> Loaded 1329 spell chain records
    2007-06-13 00:01:05 Loading Spell Learn Skills…
    2007-06-13 00:01:05
    2007-06-13 00:01:05 >> Loaded 40 spell learn skills + found in DBC 76
    2007-06-13 00:01:05 Loading Spell Learn Spells…
    2007-06-13 00:01:05
    2007-06-13 00:01:05 >> Loaded 36 spell learn spells + found in DBC 6011
    2007-06-13 00:01:05 Loading Spell Proc Event conditions…
    2007-06-13 00:01:05 >> Loaded 819 spell proc event conditions
    2007-06-13 00:01:05
    2007-06-13 00:01:05 Loading Aggro Spells Definitions…
    2007-06-13 00:01:05 >> Loaded 53 aggro generating spells
    2007-06-13 00:01:05
    2007-06-13 00:01:05 Loading NPC Texts…
    2007-06-13 00:01:05
    2007-06-13 00:01:05 >> Loaded 0 npc texts
    2007-06-13 00:01:05 Loading Items…
    2007-06-13 00:01:05 ERROR:Error in `item_template` table, probably sql file format was updated (there should be 134 fields in sql).

    I seem to get many errors, especially with item_template.. I am running version 2.0.12 TBC. Anyone know the solution to this? I also have 0.6.4 SDB and the latest version of Mangos. Thanks in advanced.

  31. Smithy said Jun 13, 2007 at 4:51 am

    Hey JeremiahMan, sorry I forgot to look back on here… My Email address is smith257@hotmail.co.uk (I have MSN Messenger as well).

  32. Little Stu said Jun 13, 2007 at 3:05 am

    Firstly, thanks a lot JeramiahMan coz that problem is now solved, but now, guess what, there is another, it now says: “ERROR 2003 : Can’t connect to MySQL server on ‘localhost’ “

  33. JeremiahMan said Jun 13, 2007 at 2:52 am

    If you have spaces in your Directory (ex: C:\Program Files\) Make sure you put the spaces. Also Make sure after you type the -root Put In C:/(where ever you extracted the Realm-database.sql) I recommend you put it in your sql\Bin Directory on your hard drive.

  34. Little Stu said Jun 13, 2007 at 1:26 am

    Ok, I downloaded everything fine, i installed MySQL to the directory: C:\MySQL but now i’m stuck and so confused!
    When i typed in what it said to in cmd box, it says it cant find the file specified, i checked that everything was typed in correctly and that the directory i was typing was right, and they both were, if anyone can help me fix or get around this problem plz let me know.
    Thanks.

  35. JeremiahMan said Jun 13, 2007 at 12:36 am

    http://www.wowstatus.net/serverlist_c_up.php Go here Tumadre there are plenty of playable servers

  36. tumadre said Jun 12, 2007 at 10:57 pm

    So does anyone have a server im able to actually play on up and running? if so i-m me or email

    litefrombelow@aim.com

  37. JeremiahMan said Jun 12, 2007 at 10:47 pm

    Smithy whats your email Ill send you Screen shots

  38. Smithy said Jun 12, 2007 at 5:08 am

    Ok, I’m really stuck, been trying to do this now for over 3 hours, how do I do this MySQL thing!?!?! I have all the SQL files etc in the correct place, could someone please just tell me EXACTLY what I have to type…?

  39. paladin112 said Jun 12, 2007 at 12:54 am

    reaper-x: cant u make an server and make all of the nooby’s (including me) gm.;)

  40. BIGBOS said Jun 11, 2007 at 8:07 pm

    I tink I didnt make step 5 corect . I opened the file with notepad and copy DataDir = “C:/WoW/Data” below . I dad corect ??? PLS help me were I goed rong !!! email me : big_bos_@abv.bg

    5. Extract the Mangos file somewhere, for example C:\WoW\Mangos. And open the mangosd.conf and edit the DataDir into something like below

    U made step 2 to add data base and now my realmd. exe closes :( PLS HELP SOON HELP

    it was working :( email me or anser me PLS : big_bos_@abv.bg
    DataDir = “C:/WoW/Data”

    If you’re using the example path given in this guide, you can use the above datadir configuration

    I am waiting :P HELP my realm exe works and the surver works fine PLS help I cant play :(
    And oter thing pls more simple I am a BIG NOOB at making servers :)
    10x in advance

  41. JeremiahMan said Jun 11, 2007 at 7:45 pm

    Tyler What is your email address, for some reason it wont let me type what I want to say in here.

  42. JeremiahMan said Jun 11, 2007 at 7:44 pm

    Hmm for some reason when I put the

  43. JeremiahMan said Jun 11, 2007 at 7:42 pm

    C:\mysql\bin\mysql.exe -u root

  44. JeremiahMan said Jun 11, 2007 at 7:40 pm

    hmm my post didnt go all the way should look like
    C:\mysql\bin\mysql.exe -u root

  45. JeremiahMan said Jun 11, 2007 at 7:38 pm

    Hey Tyler If your stuck on that step it actully should look like this

    C:\MySQL\bin\mysql.exe -u root

  46. Pureblood said Jun 11, 2007 at 9:41 am

    Hello. when we talk about mySQL means SQL Server 2005 Standard Edition – 32-bit?
    im sorry about this question, is just that im not familiar with this

  47. BIGBOS said Jun 11, 2007 at 1:49 am

    U made step 2 to add data base and now my realmd. exe closes :( PLS HELP SOON HELP

    it was working :( email me or anser me PLS : big_bos_@abv.bg

  48. BIGBOS said Jun 11, 2007 at 12:39 am

    I am waiting :P HELP my realm exe works and the surver works fine PLS help I cant play :(
    And oter thing pls more simple I am a BIG NOOB at making servers :)
    10x in advance

  49. BIGBOS said Jun 10, 2007 at 10:14 am

    I tink I didnt make step 5 corect . I opened the file with notepad and copy DataDir = “C:/WoW/Data” below . I dad corect ??? PLS help me were I goed rong !!! email me : big_bos_@abv.bg

    5. Extract the Mangos file somewhere, for example C:\WoW\Mangos. And open the mangosd.conf and edit the DataDir into something like below

    DataDir = “C:/WoW/Data”

    If you’re using the example path given in this guide, you can use the above datadir configuration

  50. BIGBOS said Jun 10, 2007 at 10:13 am

    PLS HELP ME !!! How to create acount normal from mangosd.exe ???

    I treid to open it but it clouses . Tell me how to create a acount PLS ???

Comments Navigation 1 2 3 4 5 6 ... 9

Trackbacks/Pingbacks