Reaper MaNGOS 5931 with ScriptDev 412|Server Compatible With 2.4.2 (UDB ONLY!)

PLEASE DO NOT USE THE FRESH INSTALL TOOL IT IS BROKEN IN THIS RELEASE. IF YOU WANT TO BE ABLE TO USE THIS RELEASE DOWNLOAD THE 5472 RELEASE AND THEN USE THE UPGRADE TOOL IN THIS RELEASE. THE PROBLEM IS I FORGOT TO INCLUDE SOME SQL AND PEOPLE ARE GETTING CREATURE.ADDON ERRORS AND ALOT OF VARIOUS SQL ERRORS. I APPOLOGIZE SINCERELY.

NOTE: THIS IS SAFE HOWEVER IF YOU ARE USING THE UPGRADE TOOL! SO IF YOUR UPGRADING FROM THE PREVIOUS RELEASE IT WILL WORK ITS JUST THE FRESH INSTALL THAT IS BUGGED UP!

Sorry Included an Old Map Extractor Heres the Updated Link!

~~https://mangos.svn.sourceforge.net/svnroot/mangos/trunk/contrib/map_extractor/ad.exe~~

Well looks like its FINALLY TIME for another Reaper MaNGOS Release so that you all can get your servers updated with the latest features and to use the new 2.4.2 client. I spent a couple of hours getting this release ready and I think I finally have gotten it right.

Also as a Side-Note PSDB is NOT included in this release due to the fact that their organization at their site is horrible and they are unclear on how to upgrade from an older database. So you guys will have to get Reaper to tell me or a PSDB Dev to instruct me on how to upgrade or else you guys will not have a PSDB Database.

New Features:

Don’t even ask! There is so many bug fixes/new features its not even funny. It would take me hours to type it all up because of how much has been added since the last release!

About Oatman:

Btw just to let you all know my name is Jared (Oatman) and I am good partners with Reaper and I help him release some of the WoW Releases! For all of you that have been wondering Reaper has just made a move from his previous city and sometime during that move he visited a doctor and he has a medical condition referred to as Vertigo. Some of you may be aware of this while others are not. Feel free to search Google for what it is. I would like to advise you that he is ok but his doctor told him to stay away from the computer for the time being.

SunWell

REQUIREMENTS:

1. MySQL Database and the Guide on how to Install MySQL

2. World of Warcraft Client version 2.4.2

3. Updated DBC’s, VMAP’s, and MAPS Updated for 2.4.2!
DBC’s are already included as part of this release!

4. Reaper-Mangos Server :
~~Reaper Mangos 5931 SD2 412 (UDB ONLY) FULL | 18.29 MB | File Beam~~
~~Reaper Mangos 5931 SD2 412 (UDB ONLY) FULL | 18.29 MB | Rapidshare~~
~~Reaper Mangos 5931 SD2 412 (UDB ONLY) FULL | 18.29 MB | Mega Upload~~
~~Reaper Mangos 5931 SD2 412 (UDB ONLY) FULL | 18.29 MB | Media Fire~~

Fresh Install:
Important Note : Fresh installation will overwrite your database

1. First you’ll need to install MySQL

2. Extracting Maps, DBC and VMaps from your World of Warcraft installation
(You can safely ignore the Patch-2, or any not found xxx-2 message)–This only happens if your extracting from patch 2.4.0

3. Run the reaper-x-mangos.bat inside the reaper-x-mangos folder, and you’ll see something like below image for an example, and then you just need to write the full path to your mysql installation directory (where mysql.exe and mysqldump.exe can be found) ;)

MySQL Input Directory

4. Selection Option 1 by pressing “1&Prime on the keyboard and pressing enter.
Note: This will wipe out any previous versions of WoW you have in your database.

6. After finished with all of the above process, all you have to do now is just open the realmlist.wtf file in your World of Warcraft installation directory (the default location can be found at C:\Program Files\World of Warcraft) using Notepad, Wordpad, or your favorite text editor and then …

Replace :

set realmlist us.logon.worldofwarcraft.com
set patchlist us.version.worldofwarcraft.com

With :

set realmlist 127.0.0.1

and then save it and close realmlist.wtf File.

7. Now you just need to run mangosd.exe and realmd.exe from your mangos directory and then the next step would be creating your own username with your desired password for your own WoW server account as shown on below image followed by typing setgm to give yourself a GM level account

By the way, if you can’t see what you should type inside the mangosd window from the above image, actually you just need to type :

create username password

to create the account

setgm username 1-3

to give yourself GM Access at certain level (3 is the highest level and should only be used on your account while normal player is 0)

8. Finally if you have Burning Crusade client installed and want to be able to create Burning Crusade specific character, all you have to do is just type :

setbc username 1

to enable burning crusade expansion for your account :)

Optional :
If you want to change the server name into something else, you can use the reaper-x-mangos.bat to adjust it :)

Upgrading from 5472 Release:

1. Re-extract vmaps, maps and dbc because this version no longer supports the old World of Warcraft 2.3.3 installation and only supports the new 2.4.2

2. Go into your WoW Reaper Server Directory, and open reaper-eazy-mangos. Next I recommend opening the batch file and backing up your character data. This is optional though.

3. Open the Folder called “Upgrade” and run reaper-x-upgrade.bat.

4. Next type in the directory to the Bin Folder where your mysql.exe and mysqldump.exe files are located.

5. Then make sure that you are upgrading from the latest previous version or else you WILL corrupt your database and possibly lose your character data.
Upgrade Warning

Guide on how to Edit Mangos.Conf
Thanks for the Mangosd.conf edit guide Jeremy!

First off make sure that you have your MySQL running before doing anything.

You need to go back into the reaper folder (C:\Reaper-X-Easy-MaNGOS\reaper-eazy-mangos)
And run the batch file called reaper-x-mangos, there is an option there to setup your LAN or IP for use, This new batch file does correctly setup your DB to the IP you enter in this batch file. Once you’ve done that, if you haven’t gone back in to edit the config files in your reaper folder mentioned above, you need to do that, there is a section in there with this.

# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = “C:\Reaper-X\data”

This is an example of waht it may look like. You need to change this to the path where you put your data folder with the maps, vmaps, and dbc’s.

Second, …

# Database connection settings for the world server.
# Default: hostname;port;username;password;database
# .;somenumber;username;password;database – use named pipes at Windows
# Named pipes: mySQL required adding “enable-named-pipe” to [mysqld] section my.ini
# .;/path/to/unix_socket;username;password;database – use Unix sockets at Unix/Linux
# Unix sockets: experimental, not tested
LoginDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;realmd”
WorldDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;mangos”
CharacterDatabaseInfo = “127.0.0.1;3306;ROOT;PASSWORD;characters”

Above, you need to change the MANGO;MANGOS to your root DB name, likey it’s just root, and YOUR batabase (DB) password (you should know this)

YOU DO NOT CHANGE THE IP’S here or in the realmd file, ONLY THROUGH THAT BATCH FILE, i mentioned above. (that file does it for you)

Next open scriptdev2.conf and realmd.conf and edit the info for them to connect to your database as well.

Hope you enjoy this release if you have any questions feel free to post them as a comment below!

Comments Navigation « Previous 1 2 3 4 5 6 Next »

DeathGuy said May 25, 2008 at 12:29 am

I get this when extracting DBCs

Output directory: .
Fatal: Could not locate MPQ archive patch-enUS-3.MPQ
MPQ-Extractor v1.4 by WRS powered by ShadowFlare MPQ API Library v1.08

Output directory: .
Fatal: Could not locate MPQ archive patch-enUS-4.MPQ
Press any key to continue . . .

Link to this comment Reply to this comment
Raver said May 25, 2008 at 12:19 am

Well i tried the other releases and i made it public with wamp.

Link to this comment Reply to this comment
Sirelewop said May 25, 2008 at 12:13 am

do you know how to make this server version public w/ hamachi?

Link to this comment Reply to this comment
Wii said May 25, 2008 at 12:12 am

Thank you for the explanation Oatman. Since I kinda messed up my upgrading and since I don’t care too much about saving my previous toons I tried to go for a fresh install instead.

However I get the error that two other people have mentioned before too:
ERROR 1136 (21S01) at line 187: Column count doesn’t match value count at row 1.

I haven’t seen anyone mention a solution to this. Any ideas?

Link to this comment Reply to this comment
Raver said May 25, 2008 at 12:07 am

After the “fresh installation” process is finished it gets an error: “ERROR 1136 at line 187:
Column count doesn’t match value count at row 1″. Any idea what’s the cause ??

Link to this comment Reply to this comment
Moocow said May 25, 2008 at 12:00 am

uhh hi..this is my first time attempting to make a private server so sorry if i seem like a complete noob

but i have a few problems

At step 4 it asks a bunch of questions, and for the first one i cant remember when/ if i made a MySQL database so i cant exactly put down a real database username.

I also tried to answer the questions with the answeres that say “most likely root” etc, but at the end it comes up

‘mysql’ is not recognised as an internal or external command, operable program or batch file

any help here would be appreciated =D

Link to this comment Reply to this comment
HiOatman said May 24, 2008 at 11:55 pm

Did you come up with any solution for the creature_template_addon yet Oatman?

Link to this comment Reply to this comment
Raver said May 24, 2008 at 11:51 pm

I didn’t update my database. I selected fresh install.

Link to this comment Reply to this comment
Oatman said May 24, 2008 at 11:49 pm

#Wii

If you want to update your database all your suppost to do is just run the update tool… It will update everything for you. The only reason for a backup is if you want to make backups of your database. You NEVER use it to update though. So basically if you were back on the old 2.3.3 version all u do is run the reaper-x-update.exe file in the Update folder and it does all of it for you.

#T

I am not sure if what that poster is telling you to do is safe. If your doing it his way there won’t be any NPC’s or ANYTHING…

#Raver

I think you updated your database the way I said not to.

#Dranith

Once again more proof that I did it correctly. I appreciate your support! :D

Link to this comment Reply to this comment
Dranith said May 24, 2008 at 11:46 pm

Tested all day now and works very good :) Works much better than previous versions. Just like Oatman said, the new raid instance is empty, but you can look around in there and see how dam long that is ;) Keep up good working Oat!

Link to this comment Reply to this comment
Raver said May 24, 2008 at 11:45 pm

Ok, i downloaded the new ad.exe and it doesn’t give me the out of date error anymore. But it gives me another one:”error loading creature data” “DB table `creature` is empty and : “ERROR in creature_template_addon table… there should be 8 files in SQL”.
Please help.

Link to this comment Reply to this comment
Wii said May 24, 2008 at 11:44 pm

Hello Oatman,

To quote you: “I think the reason you guys are getting errors if your upgrading is because your doing a backup then a update then a restore. THAT IS A BIG NO NO! What yoru doing is your updating but at the same time replacing your update with old crusty files and if you’ve done that you just crashed your database.”

I’m sorry for being a horrible noob with these things, but could you enlighten me what the correct way to restore your old database would be then? Even a link to an old guide would be something. I can’t seem to find anything on the matter, apologies.

Link to this comment Reply to this comment
Needhelp!!! said May 24, 2008 at 11:31 pm

NEVERMIND, ive tryed to run mangosd again and now it stopping at :

Loading game object templates…
Error in game object_template tables, probably sql file format was updated (there should be 33 fields in sql).

Please help:(

Link to this comment Reply to this comment
T said May 24, 2008 at 11:27 pm

i also had the creature template problem, it was fixed by following this posters advice -

http://www.reaper-x.com/2008/05/22/reaper-mangos-5931-with-scriptdev-412server-compatible-with-242-udb-only/#comment-116427

and Oatman you are 100% when u said “this release is 100% working if you actually know what your doing” it runs great as far as i can tell so far, nice work man keep it up

Link to this comment Reply to this comment
HiOatman said May 24, 2008 at 11:25 pm

Fresh Install :)

Link to this comment Reply to this comment
Needhelp!!! said May 24, 2008 at 11:25 pm

Hi, am getting this error when am trying to run mangosd :

ERROR:Could not connect to MySQL database at 127.0.0.1: Can’t create TCP/IP socket (10050)

Ive extracted everything, and all… :( but am getting this…

Please help me ! i really want to play!

Link to this comment Reply to this comment
Oatman said May 24, 2008 at 11:24 pm

#HiOatman (HEHE)

Can you tell me if this was a fresh install or upgrade and if it was an upgrade was ur previous database UDB or PSDB?

Link to this comment Reply to this comment
HiOatman said May 24, 2008 at 11:21 pm

I’ve been havinbg trouble setting your new repack up for like 5 hours now, it stops on Creature_template_addon and when I try to log in I cant create a character anyways, can anyone link me a new “Creature_template_addon.sql” please! :P

Link to this comment Reply to this comment
Oatman said May 24, 2008 at 10:58 pm

Also as a side note I have decided to help anyone via LogMeIn and prove to them that this release is 100% working if you actually know what your doing.

Link to this comment Reply to this comment
Oatman said May 24, 2008 at 10:56 pm

#SiegeLink

Yea… but they would work in the older areas before Isle of Quel Danas and the island itself has the quests and npcs already.

Link to this comment Reply to this comment
Oatman said May 24, 2008 at 10:53 pm

#1 If you guys would have read the comments I said only to download this if you would like to Beta Test it mainly because this is such a huge update and there will most likely be errors. I said wait until there was a go ahead.

#2 For all those with map errors I am sorry I posted the wrong AD.exe and used an out of date one. You can find the updated AD.exe in:
https://mangos.svn.sourceforge.net/svnroot/mangos/trunk/contrib/map_extractor/ad.exe

#3 For all of you who arn’t aware… If you even think you can upgrade your PSDB to UDB you got another thing coming. Like I said UDB is far ahead of PSDB mainly because PSDB was helping the ascent version of PSDB for so long. If someone will make a tutorial on how to do this I’d be glad to release a fix for it.

#4 The Trojan/EXE Error Rumors:

Let me tell you something… I know for a solid fact that this is a trojan free program. The only reason your getting this error about a trojan is because it was a bat file that was converted to a exe. Its doing this because the exe is trying to get into your MySQL and Windows thinks that it is a risk behavior. If you want a Virus software that actually knows what its doing then get AVG.

#5 This only works with 2.4.2 (Read the Instructions……)

#6 Apparently it works fine because I have some comments on users that have UPGRADED and thats even working. Upgrading is where I thought most of these bugs were coming from. I think the reason you guys are getting errors if your upgrading is because your doing a backup then a update then a restore. THAT IS A BIG NO NO! What yoru doing is your updating but at the same time replacing your update with old crusty files and if you’ve done that you just crashed your database.

#7 Btw I included ScriptDev2 but totally forgot ACID sorry that was my fault and I’ll have that in another release or you can apply it off of the SD2 website. http://scriptdev2.com

Link to this comment Reply to this comment
lol said May 24, 2008 at 10:19 pm

Siegelink is right I think ,Oatman you just have to wait.
Because the site http://www.mangos-fae.info/download.php?list.7 .. are still using MaNGOS Revision 5898 + ScriptDev2 Revision 407

That kind of wierd that you got 5931,am i right?

Link to this comment Reply to this comment
lol said May 24, 2008 at 10:15 pm

ummh.. de DB suxs..

Link to this comment Reply to this comment
lol said May 24, 2008 at 10:14 pm

HERE NOOB OF A Jeremy…
# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = “C:\Reaper-X\data”

do only..
DataDir = “data”

Link to this comment Reply to this comment
Hip-Hop said May 24, 2008 at 9:57 pm

What the hell is wrong! I can’t even install the damn database! It stops at this: ERROR 1136 at line 187: Column count doesn’t match value count at row 1.
I want some answers! Must I take back to ver 2.3.3 Mangos to play properly! I want to see all the new stuff, but it seems that I can’t!

Link to this comment Reply to this comment
Bob said May 24, 2008 at 9:49 pm

I’ve got the new ad.exe eand deleted the old .maps But after re-using ad.exe I still got the same problem with the 0004331.map’

Link to this comment Reply to this comment
RealMethuselah said May 24, 2008 at 9:28 pm

Can’t someone post a link to extracted Maps and Vmaps?

Link to this comment Reply to this comment
BaDBoY said May 24, 2008 at 9:27 pm

what the hell can happend with 2.3.3 repack i dont have any problem for the first time i do it without errors and now errorrr and errror suck that errors

Link to this comment Reply to this comment
SiegeLink said May 24, 2008 at 9:26 pm

James
You should update your mangos with the two update packs provided here :

http://www.udbforums.org/UDB-0101-Baby-Crocolisk-is-published-t7058.html

Link to this comment Reply to this comment
BaDBoY said May 24, 2008 at 9:24 pm

heh yeah i am funny i like error s :D you know ? heh
_________________________________________
I´m Kidding !

Link to this comment Reply to this comment
SiegeLink said May 24, 2008 at 9:23 pm

How the hell can this server work ?. The UDB database is only updated for 2.4.1

I compiled Mangos 5937 with Scriptdev2 414 and udb 0.10.1 , Its starts but the npc’s are not giving quests because the quest’s templates have changed for 2.4.2

Link to this comment Reply to this comment
lol said May 24, 2008 at 9:04 pm

he is gonna spam us with trojans xD

Link to this comment Reply to this comment
lol said May 24, 2008 at 9:03 pm

ya???

Link to this comment Reply to this comment
Dudex said May 24, 2008 at 8:57 pm

can you please publish troijan free Reaper-x-mangos.bat cos there is like 5 troijans on this current one

Link to this comment Reply to this comment
lol said May 24, 2008 at 8:51 pm

Btw Oatman why you used old ad?
lol i didn’t believe you get online with this
I hope that PSDB is coming :D

Link to this comment Reply to this comment
lol said May 24, 2008 at 8:43 pm

BaDBoY =D very funny xD whahah
but i have used that ad.exe from.. https://mangos.svn.sourceforge.net/svnroot/mangos/trunk/contrib/map_extractor/ad.exe
and.. still the same error
map files not found in path ‘C:\wow\data\maps’ or *.vmap/*vmdir files in ‘C:\wow\data\vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
so !@#$?! w00t

Link to this comment Reply to this comment
merijn said May 24, 2008 at 8:42 pm

u can add meon msn tes_6@msn.com plz say tha ur oatman :)

GReetz

Link to this comment Reply to this comment
merijn said May 24, 2008 at 8:38 pm

hee oat euh my profile= http://projectsilvermoon.net/index.php?showuser=21851 and here u can see that i am in my name is factionwars http://projectsilvermoon.net/index.php?showtopic=10743 by the way we need more scripters , c++

greetzz

Link to this comment Reply to this comment
James said May 24, 2008 at 7:52 pm

u need to use the new ad.exe

AND I NEED HELP WITH THE CREATURE_TEMPLATE_ADDON it says its empty and then it says there should be 8

I NEED YOUR HELP
Thx james

Link to this comment Reply to this comment
Darkfire said May 24, 2008 at 7:49 pm

ok I used the new ad.exe and that’s work fine but after the first load, he got dbc error

I want to use 2.3.3 what should I need to do ? I need to extract DBC again ?

Link to this comment Reply to this comment
BaDBoY said May 24, 2008 at 7:31 pm

heh i must change my root pass word :D

Link to this comment Reply to this comment
BaDBoY said May 24, 2008 at 7:30 pm

Look me errors i must fix that evil
2008-05-24 14:17:08 SQL: SELECT version FROM db_version LIMIT 1
2008-05-24 14:17:08 query ERROR: Table ‘mangos.db_version’ doesn’t exist
2008-05-24 14:17:08 SQL: SELECT MAX(guid) FROM characters
2008-05-24 14:17:08 query ERROR: Table ‘characters.characters’ doesn’t exist
2008-05-24 14:17:08 SQL: SELECT MAX(guid) FROM creature
2008-05-24 14:17:08 query ERROR: Table ‘mangos.creature’ doesn’t exist
2008-05-24 14:17:08 SQL: SELECT MAX(id) FROM character_pet
2008-05-24 14:17:08 query ERROR: Table ‘characters.character_pet’ doesn’t exist
2008-05-24 14:17:08 SQL: SELECT MAX(guid) FROM item_instance
2008-05-24 14:17:08 query ERROR: Table ‘characters.item_instance’ doesn’t exist
2008-05-24 14:17:08 SQL: SELECT MAX(guid) FROM gameobject
2008-05-24 14:17:08 query ERROR: Table ‘mangos.gameobject’ doesn’t exist
2008-05-24 14:17:08 SQL: SELECT MAX(id) FROM auctionhouse
2008-05-24 14:17:08 query ERROR: Table ‘characters.auctionhouse’ doesn’t exist
2008-05-24 14:17:08 SQL: SELECT MAX(id) FROM mail
2008-05-24 14:17:08 query ERROR: Table ‘characters.mail’ doesn’t exist
2008-05-24 14:17:08 SQL: UPDATE characters SET online = 0
2008-05-24 14:17:08 SQL ERROR: Table ‘characters.characters’ doesn’t exist
2008-05-24 14:17:08 SQL: DELETE FROM character_inventory WHERE item >= ‘1′
2008-05-24 14:17:08 SQL ERROR: Table ‘characters.character_inventory’ doesn’t exist
2008-05-24 14:17:08 SQL: SELECT MAX(id) FROM item_text
2008-05-24 14:17:08 query ERROR: Table ‘characters.item_text’ doesn’t exist
2008-05-24 14:17:08 SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = ‘1′)
2008-05-24 14:17:08 SQL ERROR: Table ‘realmd.account’ doesn’t exist
2008-05-24 14:17:08 SQL: UPDATE realmlist SET allowedSecurityLevel = ‘0′ WHERE id = ‘1′
2008-05-24 14:17:08 SQL ERROR: Table ‘realmd.realmlist’ doesn’t exist
2008-05-24 14:17:08 SQL: SELECT MAX(guid) FROM corpse
2008-05-24 14:17:08 query ERROR: Table ‘characters.corpse’ doesn’t exist
2008-05-24 14:17:08 SQL: DELETE FROM mail_items WHERE item_guid >= ‘1′
2008-05-24 14:17:08 SQL ERROR: Table ‘characters.mail_items’ doesn’t exist
2008-05-24 14:17:08 SQL: DELETE FROM auctionhouse WHERE itemguid >= ‘1′
2008-05-24 14:17:08 SQL ERROR: Table ‘characters.auctionhouse’ doesn’t exist
2008-05-24 14:17:08 SQL: DELETE FROM guild_bank_item WHERE item_guid >= ‘1′
2008-05-24 14:17:08 SQL ERROR: Table ‘characters.guild_bank_item’ doesn’t exist
2008-05-24 14:17:18 SQL: SELECT version FROM db_version LIMIT 1
2008-05-24 14:17:18 query ERROR: Table ‘mangos.db_version’ doesn’t exist
2008-05-24 14:17:18 SQL: SELECT MAX(guid) FROM characters
2008-05-24 14:17:18 query ERROR: Table ‘characters.characters’ doesn’t exist
2008-05-24 14:17:18 SQL: SELECT MAX(guid) FROM creature
2008-05-24 14:17:18 query ERROR: Table ‘mangos.creature’ doesn’t exist
2008-05-24 14:17:18 SQL: SELECT MAX(id) FROM character_pet
2008-05-24 14:17:18 query ERROR: Table ‘characters.character_pet’ doesn’t exist
2008-05-24 14:17:18 SQL: SELECT MAX(guid) FROM item_instance
2008-05-24 14:17:18 query ERROR: Table ‘characters.item_instance’ doesn’t exist
2008-05-24 14:17:18 SQL: SELECT MAX(guid) FROM gameobject
2008-05-24 14:17:18 query ERROR: Table ‘mangos.gameobject’ doesn’t exist
2008-05-24 14:17:18 SQL: SELECT MAX(id) FROM auctionhouse
2008-05-24 14:17:18 query ERROR: Table ‘characters.auctionhouse’ doesn’t exist
2008-05-24 14:17:18 SQL: SELECT MAX(id) FROM mail
2008-05-24 14:17:18 query ERROR: Table ‘characters.mail’ doesn’t exist
2008-05-24 14:17:18 SQL: SELECT MAX(id) FROM item_text
2008-05-24 14:17:18 query ERROR: Table ‘characters.item_text’ doesn’t exist
2008-05-24 14:17:18 SQL: SELECT MAX(guid) FROM corpse
2008-05-24 14:17:18 query ERROR: Table ‘characters.corpse’ doesn’t exist
2008-05-24 14:17:18 SQL: UPDATE characters SET online = 0
2008-05-24 14:17:18 SQL ERROR: Table ‘characters.characters’ doesn’t exist
2008-05-24 14:17:18 SQL: DELETE FROM character_inventory WHERE item >= ‘1′
2008-05-24 14:17:18 SQL ERROR: Table ‘characters.character_inventory’ doesn’t exist
2008-05-24 14:17:18 SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = ‘1′)
2008-05-24 14:17:18 SQL ERROR: Table ‘realmd.account’ doesn’t exist
2008-05-24 14:17:18 SQL: UPDATE realmlist SET allowedSecurityLevel = ‘0′ WHERE id = ‘1′
2008-05-24 14:17:18 SQL ERROR: Table ‘realmd.realmlist’ doesn’t exist
2008-05-24 14:17:18 SQL: DELETE FROM mail_items WHERE item_guid >= ‘1′
2008-05-24 14:17:18 SQL ERROR: Table ‘characters.mail_items’ doesn’t exist
2008-05-24 14:17:18 SQL: DELETE FROM auctionhouse WHERE itemguid >= ‘1′
2008-05-24 14:17:18 SQL ERROR: Table ‘characters.auctionhouse’ doesn’t exist
2008-05-24 14:17:18 SQL: DELETE FROM guild_bank_item WHERE item_guid >= ‘1′
2008-05-24 14:17:18 SQL ERROR: Table ‘characters.guild_bank_item’ doesn’t exist
2008-05-24 14:18:32 SQL: SELECT version FROM db_version LIMIT 1
2008-05-24 14:18:32 query ERROR: Table ‘mangos.db_version’ doesn’t exist
2008-05-24 14:18:32 SQL: SELECT MAX(guid) FROM characters
2008-05-24 14:18:32 query ERROR: Table ‘characters.characters’ doesn’t exist
2008-05-24 14:18:32 SQL: SELECT MAX(guid) FROM creature
2008-05-24 14:18:32 query ERROR: Table ‘mangos.creature’ doesn’t exist
2008-05-24 14:18:32 SQL: SELECT MAX(id) FROM character_pet
2008-05-24 14:18:32 query ERROR: Table ‘characters.character_pet’ doesn’t exist
2008-05-24 14:18:32 SQL: SELECT MAX(guid) FROM item_instance
2008-05-24 14:18:32 query ERROR: Table ‘characters.item_instance’ doesn’t exist
2008-05-24 14:18:32 SQL: SELECT MAX(guid) FROM gameobject
2008-05-24 14:18:32 query ERROR: Table ‘mangos.gameobject’ doesn’t exist
2008-05-24 14:18:32 SQL: SELECT MAX(id) FROM auctionhouse
2008-05-24 14:18:32 query ERROR: Table ‘characters.auctionhouse’ doesn’t exist
2008-05-24 14:18:32 SQL: UPDATE characters SET online = 0
2008-05-24 14:18:32 SQL ERROR: Table ‘characters.characters’ doesn’t exist
2008-05-24 14:18:32 SQL: DELETE FROM character_inventory WHERE item >= ‘1′
2008-05-24 14:18:32 SQL ERROR: Table ‘characters.character_inventory’ doesn’t exist
2008-05-24 14:18:32 SQL: SELECT MAX(id) FROM mail
2008-05-24 14:18:32 query ERROR: Table ‘characters.mail’ doesn’t exist
2008-05-24 14:18:32 SQL: SELECT MAX(id) FROM item_text
2008-05-24 14:18:32 SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = ‘1′)
2008-05-24 14:18:32 SQL ERROR: Table ‘realmd.account’ doesn’t exist
2008-05-24 14:18:32 SQL: UPDATE realmlist SET allowedSecurityLevel = ‘0′ WHERE id = ‘1′
2008-05-24 14:18:32 SQL ERROR: Table ‘realmd.realmlist’ doesn’t exist
2008-05-24 14:18:32 query ERROR: Table ‘characters.item_text’ doesn’t exist
2008-05-24 14:18:32 SQL: DELETE FROM mail_items WHERE item_guid >= ‘1′
2008-05-24 14:18:32 SQL ERROR: Table ‘characters.mail_items’ doesn’t exist
2008-05-24 14:18:32 SQL: DELETE FROM auctionhouse WHERE itemguid >= ‘1′
2008-05-24 14:18:32 SQL ERROR: Table ‘characters.auctionhouse’ doesn’t exist
2008-05-24 14:18:32 SQL: SELECT MAX(guid) FROM corpse
2008-05-24 14:18:32 query ERROR: Table ‘characters.corpse’ doesn’t exist
2008-05-24 14:18:32 SQL: DELETE FROM guild_bank_item WHERE item_guid >= ‘1′
2008-05-24 14:18:32 SQL ERROR: Table ‘characters.guild_bank_item’ doesn’t exist
2008-05-24 14:18:54 SQL: SELECT version FROM db_version LIMIT 1
2008-05-24 14:18:54 query ERROR: Table ‘mangos.db_version’ doesn’t exist
2008-05-24 14:18:54 SQL: SELECT MAX(guid) FROM characters
2008-05-24 14:18:54 query ERROR: Table ‘characters.characters’ doesn’t exist
2008-05-24 14:18:54 SQL: SELECT MAX(guid) FROM creature
2008-05-24 14:18:54 query ERROR: Table ‘mangos.creature’ doesn’t exist
2008-05-24 14:18:54 SQL: SELECT MAX(id) FROM character_pet
2008-05-24 14:18:54 query ERROR: Table ‘characters.character_pet’ doesn’t exist
2008-05-24 14:18:54 SQL: SELECT MAX(guid) FROM item_instance
2008-05-24 14:18:54 query ERROR: Table ‘characters.item_instance’ doesn’t exist
2008-05-24 14:18:54 SQL: SELECT MAX(guid) FROM gameobject
2008-05-24 14:18:54 query ERROR: Table ‘mangos.gameobject’ doesn’t exist
2008-05-24 14:18:54 SQL: SELECT MAX(id) FROM auctionhouse
2008-05-24 14:18:54 query ERROR: Table ‘characters.auctionhouse’ doesn’t exist
2008-05-24 14:18:54 SQL: SELECT MAX(id) FROM mail
2008-05-24 14:18:54 query ERROR: Table ‘characters.mail’ doesn’t exist
2008-05-24 14:18:54 SQL: SELECT MAX(id) FROM item_text
2008-05-24 14:18:54 query ERROR: Table ‘characters.item_text’ doesn’t exist
2008-05-24 14:18:54 SQL: UPDATE characters SET online = 0
2008-05-24 14:18:54 SQL ERROR: Table ‘characters.characters’ doesn’t exist
2008-05-24 14:18:54 SQL: DELETE FROM character_inventory WHERE item >= ‘1′
2008-05-24 14:18:54 SQL ERROR: Table ‘characters.character_inventory’ doesn’t exist
2008-05-24 14:18:54 SQL: SELECT MAX(guid) FROM corpse
2008-05-24 14:18:54 query ERROR: Table ‘characters.corpse’ doesn’t exist
2008-05-24 14:18:54 SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = ‘1′)
2008-05-24 14:18:54 SQL ERROR: Table ‘realmd.account’ doesn’t exist
2008-05-24 14:18:54 SQL: UPDATE realmlist SET allowedSecurityLevel = ‘0′ WHERE id = ‘1′
2008-05-24 14:18:54 SQL ERROR: Table ‘realmd.realmlist’ doesn’t exist
2008-05-24 14:18:54 SQL: DELETE FROM mail_items WHERE item_guid >= ‘1′
2008-05-24 14:18:54 SQL ERROR: Table ‘characters.mail_items’ doesn’t exist
2008-05-24 14:18:54 SQL: DELETE FROM auctionhouse WHERE itemguid >= ‘1′
2008-05-24 14:18:54 SQL ERROR: Table ‘characters.auctionhouse’ doesn’t exist
2008-05-24 14:18:54 SQL: DELETE FROM guild_bank_item WHERE item_guid >= ‘1′
2008-05-24 14:18:54 SQL ERROR: Table ‘characters.guild_bank_item’ doesn’t exist

and server errors :D

2008-05-24 14:18:54 Using configuration file mangosd.conf.
2008-05-24 14:18:54 MaNGOS daemon /0.11.0-SVN (Revision 5931) (Win32)
2008-05-24 14:18:54 to stop.

MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM http://www.mangosproject.org
MMMMMM

Created By: Reaper-X.com and Oatman!
Revision: Reaper-X MaNGOS 5931
2008-05-24 14:18:54 Daemon PID: 2708

2008-05-24 14:18:54 World Database: 127.0.0.1;3306;root;mypass;mangos
2008-05-24 14:18:54 MySQL client library: 5.0.56
2008-05-24 14:18:54 MySQL server ver: 5.0.51b-community-nt
2008-05-24 14:18:54 Character Database: 127.0.0.1;3306;root;2pato2;characters
2008-05-24 14:18:54 MySQL client library: 5.0.56
2008-05-24 14:18:54 MySQL server ver: 5.0.51b-community-nt
2008-05-24 14:18:54 Login Database: 127.0.0.1;3306;root;2pato2;realmd
2008-05-24 14:18:54 MySQL client library: 5.0.56
2008-05-24 14:18:54 MySQL server ver: 5.0.51b-community-nt
2008-05-24 14:18:54 Realm running as realm ID 1
2008-05-24 14:18:54 ERROR:SQL: SELECT version FROM db_version LIMIT 1
2008-05-24 14:18:54 ERROR:query ERROR: Table ‘mangos.db_version’ doesn’t exist
2008-05-24 14:18:54 Using unknown world database.
2008-05-24 14:18:54 Using DataDir C:\wow\data\
2008-05-24 14:18:54 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-05-24 14:18:54 WORLD: VMap data directory is: C:\wow\data\vmaps
2008-05-24 14:18:54 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-05-24 14:18:54 ERROR:SQL: SELECT MAX(guid) FROM characters
2008-05-24 14:18:54 ERROR:query ERROR: Table ‘characters.characters’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: SELECT MAX(guid) FROM creature
2008-05-24 14:18:54 ERROR:query ERROR: Table ‘mangos.creature’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: SELECT MAX(id) FROM character_pet
2008-05-24 14:18:54 ERROR:query ERROR: Table ‘characters.character_pet’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: SELECT MAX(guid) FROM item_instance
2008-05-24 14:18:54 ERROR:query ERROR: Table ‘characters.item_instance’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: SELECT MAX(guid) FROM gameobject
2008-05-24 14:18:54 ERROR:query ERROR: Table ‘mangos.gameobject’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: SELECT MAX(id) FROM auctionhouse
2008-05-24 14:18:54 ERROR:query ERROR: Table ‘characters.auctionhouse’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: SELECT MAX(id) FROM mail
2008-05-24 14:18:54 ERROR:query ERROR: Table ‘characters.mail’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: SELECT MAX(id) FROM item_text
2008-05-24 14:18:54 ERROR:query ERROR: Table ‘characters.item_text’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: UPDATE characters SET online = 0
2008-05-24 14:18:54 ERROR:SQL ERROR: Table ‘characters.characters’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: DELETE FROM character_inventory WHERE item >= ‘1′
2008-05-24 14:18:54 ERROR:SQL ERROR: Table ‘characters.character_inventory’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: SELECT MAX(guid) FROM corpse
2008-05-24 14:18:54 ERROR:query ERROR: Table ‘characters.corpse’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = ‘1′)
2008-05-24 14:18:54 ERROR:SQL ERROR: Table ‘realmd.account’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: UPDATE realmlist SET allowedSecurityLevel = ‘0′ WHERE id = ‘1′
2008-05-24 14:18:54 ERROR:SQL ERROR: Table ‘realmd.realmlist’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: DELETE FROM mail_items WHERE item_guid >= ‘1′
2008-05-24 14:18:54 ERROR:SQL ERROR: Table ‘characters.mail_items’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: DELETE FROM auctionhouse WHERE itemguid >= ‘1′
2008-05-24 14:18:54 ERROR:SQL ERROR: Table ‘characters.auctionhouse’ doesn’t exist
2008-05-24 14:18:54 ERROR:SQL: DELETE FROM guild_bank_item WHERE item_guid >= ‘1′
2008-05-24 14:18:54 ERROR:SQL ERROR: Table ‘characters.guild_bank_item’ doesn’t exist
2008-05-24 14:18:54 ERROR:Map file ‘C:\wow\data\maps/0004331.map’ is non-compatible version (outdated?). Please, create new using ad.exe program.
2008-05-24 14:18:54 ERROR:Correct *.map files not found in path ‘C:\wow\data\maps’ or *.vmap/*vmdir files in ‘C:\wow\data\vmaps’. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.

Link to this comment Reply to this comment
emerald dreamerq said May 24, 2008 at 7:04 pm

hi Jared, shaddowsong i think

i hope your friend will be ok

thank you for your release]

Link to this comment Reply to this comment
HiOatman said May 24, 2008 at 6:44 pm

Hi,

What’s wrong if I get error when trying to start up mangos.exe? :

***.map is non-compatiable version (outdated?)
it asks me to make new ad.exe (done)
it says its put in the wrong directory but I dont think thats the case…..

Help!!!

Link to this comment Reply to this comment
Darkfire said May 24, 2008 at 6:28 pm

I tryied with the version 2.3.3, and this definately doesn’t work with this version =S Or I need to extract map with the new ad.exe ?

Link to this comment Reply to this comment
Wolfboy said May 24, 2008 at 5:32 pm

oh and also, can we get or is there an updated gm command list?

Link to this comment Reply to this comment
Hip-Hop said May 24, 2008 at 5:32 pm

That’s maybe because the Database is UDB. If it was Silvermoon all NPC’s will be active!

Link to this comment Reply to this comment
Lee BeZaro said May 24, 2008 at 5:31 pm

Hi, I’m new to this site and tried to install this new version of the Server.

I’m a newbie, so I’ll probably get flamed for this, but i’m really stuck :( and would like some help, when I run ‘reaper-x-mangos’. and press 1 so it does a clean install it asks me for root usernames, chracters files, ScriptDev…something. Am I supposed ot have these already? so anyway I put in the default things and install it, but when I tried to run mangos to run the server it’s like ‘can’t connect’ :(

Really need help.
Thanks for Reading.

Link to this comment Reply to this comment
mgas23 said May 24, 2008 at 5:13 pm

thx for the link…

but now i have a new problem

ERROR:>> Loaded 0 creature. DB table `creature` is empty.
Loading Creature Addon Data…
ERROR:Error in creature_template_addon table, probably sql file format was updated (there should be 8 fields in sql).

Link to this comment Reply to this comment
Wolfboy said May 24, 2008 at 5:12 pm

well I got my server running almost no problem, but the sunwell raid zone is empty for me….unless I’m dumb and am doing something wrong in the instance itself

Link to this comment Reply to this comment