Arcane-Fire UR1 MaNGOS (2.4.3)
By Colt45 on Jul 26, 2008 in Reaper Mangos
IF YOU HAVE NOT ALREADY APPLIED ARCANE-FIRE THEN DO NOT!!! MAJOR BUG AND WE ARE WORKING OUR BUTTS OFF TO MAKE A STABLE VERSION!!!
Here it is! The Reaper-X customized MaNGOS release UR1 "Arcane-Fire" is now available. UR1 is also a raw copy and if you look below you will find that we will be adding updates as we go! A changelog and what revs Arcane-Fire uses! Also note that Arcane-Fire no longer supports PSDB (sorry for anyone who uses it)!
- ---MaNGOS Rev. 6382
- ---------UDB Rev. 358
- -ScriptDev2 Rev. 512
- --------ACID Rev. 18
UR1 DOESN'T HAVE MANY OF THE EXTRA FEATURES THAT WE SAID WE WOULD LIKE TO HAVE SO BELOW THIS WILL BE LINKS TO NEW FEATURES AND UPDATES THAT WE DIDN'T HAVE TIME TO ADD IN THE FULL RELEASE (WHEN DOWNLOADING THE UPDATES PLEASE READ THE DARN README FILES):
- none
- None
- None
SET UP:
Step 1: Install MySQL using the guide here >>> (MySQL Installation and Configuration)
NOTE: You can get either MySQL 5.0 or 5.1 (It does NOT matter).
Step 2: Download Reaper-X UR1 "Arcane-Fire" (below are list of mirror to file). File have been compressed! These have been updated with UDB Fix 1!
1. No Download
2. No Download
3. No Download
GM COMMAND LIST:
Updated GM Command List for this version
Fresh Install:
Important Note : Fresh installation will overwrite your database!!!
Pictures in this guide have NOT been updated (sorry again)!!!
1. Make sure you have MySQL (5.0 or 5.1) installed and configured correctly on your computer.
2. Extracting Maps, DBC and VMaps from your World of Warcraft installation
YOU NEED TO EXTRACT FOR 2.4.3!!!
3. Run the Arcane-Fire.bat inside the Fresh Install 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)
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 !
Upgrading from 6245 Release:
1. Make sure to RE-EXTRACT your DBC's, Maps, and VMaps, because this release now supports 2.4.3!
2. Go into your WoW Reaper Server Directory, and open Reaper-X-MaNGOS.
3. Open the Folder called “Upgrade” and run Upgrade-2-UR1.bat.
4. Next type in the directory to the Bin Folder where your mysql.exe and mysqldump.exe files are located. (Default is C:\Program Files\MySQL\MySQL Server 5.0\bin)
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.
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 and run the batch file called Arcane-Fire.bat, 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 what 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 ROOT;PASSWORD to your root DB name, likey it’s just root, and YOUR database (DB) password (you should know this)
YOU DO NOT CHANGE THE IP’S!!! Here is a guide to make your server public! Public Setup Guide!
Next open scriptdev2.conf and realmd.conf and edit the info for them to connect to your database as well.
Website RSS Feed
Stumble this post
Bookmark this post on Del.icio.us
Submit this post to Digg
Submit this post to Reddit
Print this
Trackback URL
FINALLY IM DONE!!! :P
Hooray! Good work, fellas.
Oh I dont think I added this in the post but AH Bot rev 78 is included!
Upgrading from 5953 Release? The previous was 6245! Is that good?
can i update from MaNGOS 6245 because this page says Upgrading from 5953
Superb
Fantastic, ty. Just curious, when you do the updates, will there be a new revision, or do I have to check this thread to see when to update?
gonna d/l and try it out
i gonna try this one, thanx man
did you get the "eyes of the beast" bug fix. i really want to try it
hmm, when i run the vmaps it finished extracting but never ran the line
vmap_assembler.exe buildings vmaps splitConfig.txt
just stopped after extracting
i tried just running that byitself and its sitting there as well...
odd never had that problem the 10 other times i've installed mangos
nevermind the above comment, i just skipped it and it works, now just gotta remember how to import my characters (usernames are there just doesnt show the characters even though it says i have 10 made)
This application has failed to start because MSVCR71.dll was not found. Re-installing the application may fix this problem.
Have tried re-installing, same message?
Hey guys, i downloaded this but, when i go to extracct the data, vmaps and maps, some of the extraction tools are not included , can someone help me out on this>?
Argh, there is a problem. I ran the update from 6245, extracted the maps, dbc and vmaps.
Set my data dir, completed the necessary fields in the conf files...
I can connect but there are no characters there.
I checked the database, and the characters are still there, but they just don't show up.
HELP PLZ!!
Interestingly enough, if you try to create a new character, it doesn't show up either.
Same here i am having this problem just installed arcane-fire extracted the DBCs Vmaps etc and i cannot create any characters/none there.
Any idea what's wrong? When i fire up my mangos.exe it says cannot connect to world database 127.0.0.1;3306;root;PASSWORD;mangos
Please mail me.
Thankfully
Ode
Oh yea sorry for double post, I used the fresh install.
Ode, change the PASSWORD to your sql pw
(that should be a given)
Yup, looks like more then just me ran into that character problem - even if a create a new character - it doesnt show up and preimported aren't showing up either
Fixed my problem, so for anyone that had this trouble, I had to copy the msvcr71.dll located in x:\program files\common files\Blizzard Entertainment\world of warcraft and paste it in the folder where MaNGOSD.exe is located.
How can I change the password? I assume you mean mangos password or something like that? becouse when i start realmd it gives same error but password is realmd.
is your password to the database realmd?
Ode,
127.0.0.1;3306;root;;mangos
I have no idea what you meant by those last 2 posts..
Is the database pw same as the pw i used when i installed mysql? And how do i determine my database?
Damn im helples
i can't enter the world, after build the character, what's worry
@Ode
Go to the folder where your MaNGOSD.exe is located, and open up mangosd.conf with notepad. Scan through the text, I think you'll find it.
@treebeard, rikiller
Having the same problem getting a character to show up, in my case a new one. My MaNGOSD.exe displays: SQL ERROR: Unknown column 'dungeon_difficulty' in 'field list' CMSG_REALM_SPLIT.
Not sure if this error message is related to problem, but I'm hoping someone figures out how to fix this soon :)
@Ode
The password you need to put in is the mySQL password you entered when you ran the mySQL config.
Thanks for the replies striike, i did that, replaced the passwords with correct ones but it still says access denied when trying in to database..
My mysql command line client shows that its not using any database (!). The spot where the name of the database should be is empty. Could this be the problem? Can it be solved?
@ Ode
Go up and follow the instructions again. Your either not installing MySQL, to have a database, or you didn't install the tables into the databases correctly, or your just not setting up your conf properly. But reading your posts. your lost when it comes to setting up conf.
Does this have custom zones for leveling, custom world, npc, etc?
2008-07-26 15:56:11 ERROR:SQL: INSERT INTO characters (guid,account,name,race,class,map, dungeon_difficulty, position_x, position_y, position_z,....
Copy from the server.log
Don't know if this helps anyone.
@Striike
Same error in my log.
Where is the DBC extractor?
Well i already updated to 6245.
Can I not run the upgrade?
Could I do a fresh install and then restore my characters without issue?
ad.exe is mixed with the maps extractor now. If you remember from the last repack, they announced they merged them.
Does this have custom zones for leveling, custom world, npc, etc?
Does this have custom zones for leveling, custom world, npc, etc?
Does this have custom zones for leveling, custom world, npc, etc?
will the ad.exe work with the uk version of the game and why iis this release so much smaller than previous??
First of all, give a bit of time for someone to respond, and to be polite don't post the same lien multiple times.
Secondly, custom zones, like ones that aren't in Blizzards servers? I don't believe there is custom zones. and a Custom world? dude, are you programming your own worlds, with maps that work with wow? Im not. NPC, there is way you can create your own npc's.
there used to be 2 different extractors for the dbc one for the uk and one for the us game versions is the new ad.exe going to work with my uk game client???
I was wondering if someone could tell me the size of the vmaps folder in its present form, so far im still waiting for the excract_vmaps thing to finish and so far the vmaps folder is 1.54GB's, i was wondering if someone could tell me how big it is so i know how much longer i have to wait :)
help
Okay i think i am having the same problem as a few of you other guys. I have successfully created the server, got it up, and am able to log into it. When however it try to create a character it does not show up in the character list. I this this may be the problem...
2008-07-26 15:55:58 SQL: SELECT mapid, resettime FROM instance_reset
2008-07-26 15:55:58 query ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: DELETE FROM instance USING instance LEFT JOIN instance_reset ON mapid = map WHERE (instance.resettime '0') OR (NOT instance_reset.resettime IS NULL AND instance_reset.resettime < '1217105758')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL
2008-07-26 15:55:58 SQL ERROR: Table 'characters.group_instance' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('249','4182106432')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('269','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('309','2137088320')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('409','1932157248')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('469','1932157248')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('509','2137088320')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('531','1932157248')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('532','1932157248')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('533','1932157248')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('534','1932157248')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('540','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('542','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('543','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('544','1932157248')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('545','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('546','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('547','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('548','1932157248')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('550','1932157248')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('552','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('553','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('554','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('555','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('556','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('557','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('558','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('560','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('564','1932157248')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('565','1932157248')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('568','2137088320')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('580','1932157248')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: INSERT INTO instance_reset VALUES ('585','1839124800')
2008-07-26 15:55:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 15:55:58 SQL: DELETE FROM instance USING instance LEFT JOIN character_instance ON character_instance.instance = id LEFT JOIN group_instance ON group_instance.instance = id WHERE character_instance.instance IS NULL AND group_instance.instance IS NULL
2008-07-26 15:55:58 SQL ERROR: Table 'characters.group_instance' doesn't exist
2008-07-26 15:55:58 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN instance ON group_instance.instance = instance.id WHERE instance.id IS NULL
2008-07-26 15:55:58 SQL ERROR: Table 'characters.group_instance' doesn't exist
2008-07-26 15:55:58 Spell 33280 listed in `spell_proc_event` does not exist
2008-07-26 15:55:58 Spell 35092 listed in `spell_proc_event` does not exist
2008-07-26 15:55:58 Spell 35093 listed in `spell_proc_event` does not exist
2008-07-26 15:55:58 Spell 35094 listed in `spell_proc_event` does not exist
2008-07-26 15:56:01 Item (Entry: 8498) not correct 20655 display id, must be 44666 (using it).
2008-07-26 15:56:01 Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
2008-07-26 15:56:01 Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
2008-07-26 15:56:01 Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
2008-07-26 15:56:01 Item (Entry: 33808) not correct 47014 display id, must be 51920 (using it).
2008-07-26 15:56:01 Item (Entry: 33868) not correct 47131 display id, must be 51758 (using it).
2008-07-26 15:56:01 Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
2008-07-26 16:00:49 SQL: SELECT mapid, resettime FROM instance_reset
2008-07-26 16:00:49 query ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: DELETE FROM instance USING instance LEFT JOIN instance_reset ON mapid = map WHERE (instance.resettime '0') OR (NOT instance_reset.resettime IS NULL AND instance_reset.resettime < '1217106049')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN characters ON group_instance.leaderGuid = characters.guid LEFT JOIN groups ON group_instance.leaderGuid = groups.leaderGuid WHERE characters.guid IS NULL OR groups.leaderGuid IS NULL
2008-07-26 16:00:49 SQL ERROR: Table 'characters.group_instance' doesn't exist
2008-07-26 16:00:49 SQL: DELETE FROM instance USING instance LEFT JOIN character_instance ON character_instance.instance = id LEFT JOIN group_instance ON group_instance.instance = id WHERE character_instance.instance IS NULL AND group_instance.instance IS NULL
2008-07-26 16:00:49 SQL ERROR: Table 'characters.group_instance' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('249','4182106432')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('269','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('309','2137088320')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('409','1932157248')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('469','1932157248')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('509','2137088320')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('531','1932157248')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('532','1932157248')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('533','1932157248')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('534','1932157248')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('540','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('542','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('543','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('544','1932157248')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('545','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('546','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('547','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('548','1932157248')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('550','1932157248')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('552','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('553','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('554','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('555','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('556','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('557','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('558','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('560','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('564','1932157248')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('565','1932157248')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('568','2137088320')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('580','1932157248')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: INSERT INTO instance_reset VALUES ('585','1839124800')
2008-07-26 16:00:49 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-07-26 16:00:49 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN instance ON group_instance.instance = instance.id WHERE instance.id IS NULL
2008-07-26 16:00:49 SQL ERROR: Table 'characters.group_instance' doesn't exist
2008-07-26 16:00:49 Spell 33280 listed in `spell_proc_event` does not exist
2008-07-26 16:00:49 Spell 35092 listed in `spell_proc_event` does not exist
2008-07-26 16:00:49 Spell 35093 listed in `spell_proc_event` does not exist
2008-07-26 16:00:49 Spell 35094 listed in `spell_proc_event` does not exist
2008-07-26 16:00:52 Item (Entry: 8498) not correct 20655 display id, must be 44666 (using it).
2008-07-26 16:00:52 Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
2008-07-26 16:00:52 Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
2008-07-26 16:00:52 Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
2008-07-26 16:00:52 Item (Entry: 33808) not correct 47014 display id, must be 51920 (using it).
2008-07-26 16:00:52 Item (Entry: 33868) not correct 47131 display id, must be 51758 (using it).
2008-07-26 16:00:52 Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
2008-07-26 16:01:25 Spell (id: 51798) have SPELL_EFFECT_QUEST_COMPLETE for quest 11122 , but quest not have flag QUEST_MANGOS_FLAGS_EXPLORATION_OR_EVENT. Quest flags must be fixed, quest modified to enable objective.
2008-07-26 16:01:26 Spell 16824 listed in `spell_affect` does not exist
2008-07-26 16:01:26 Spell 16824 listed in `spell_affect` does not exist
2008-07-26 16:01:30 SQL: SELECT mainTank, mainAssistant, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, isRaid, difficulty, leaderGuid FROM groups
2008-07-26 16:01:30 query ERROR: Unknown column 'difficulty' in 'field list'
2008-07-26 16:03:30 SQL: INSERT INTO characters (guid,account,name,race,class,map, dungeon_difficulty, position_x, position_y, position_z, orientation, data, taximask, online, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, gmstate, stable_slots, at_login, zone, death_expire_time, taxi_path) VALUES (2, 5, 'Waricild', 1, 1, 0, 0, -8949.95, -132.493, 83.5312, 0, '2 0 25 0 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 100 0 60 0 1000 0 100 0 1 1 16777473 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1156415488 1157234688 1157234688 1053240066 1069547520 49 49 0 1084527177 1086624329 0 0 0 0 0 0 0 0 0 1065353216 0 0 0 0 23 20 22 20 20 0 0 0 0 0 0 0 0 0 0 40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 10240 29 0 0 11 0 0 1076138569 1080332873 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 151128835 33554440 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 38 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 39 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2362 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 1073741824 0 0 0 0 5 1073741824 7 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9 1073741824 11 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 13 1073741824 15 1073741824 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 400 26 65537 0 95 327681 0 44 327681 0 54 327681 0 43 327681 0 162 327681 0 98 19661100 0 413 65537 0 414 65537 0 415 65537 0 433 65537 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 1083892040 0 1084227584 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4294967295 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 70 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ', '2 0 0 8 0 0 0 0 ', 0, 0, 0, 0, 0, 1217106210, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12, 0, '' )
2008-07-26 16:03:30 SQL ERROR: Unknown column 'dungeon_difficulty' in 'field list'
I have tryed everything I could think of to try to fix this but at this point I no longer think it is an error on my part.
my ad.exe keeps crashing any ideas??
Yes im currently talking with Colt45 about the database when creating characters issue. I might have found a fix. Working on that.
@ Napredator
Hey btw, mine is approx 1.79-1.8 Gb in size. You should be almost done now.
Alright, there is a problem when creating a new database, Characters. on the Characters table. there is a missing factor of, `dungeon_difficulty` tinyint(3) unsigned NOT NULL default '0',
Though, i am going to have Colt45 update the repack. So no others will have that issue.
Ok, tested out the new version of the repack im currently building with the new line on the mysql full install, and it working for characters now. I'm looking into the other errors now.
@Summonence+Colt45
Great, thanks for the quick fix guys.
@Summonence
Will the .mod mount command work better in this repack or should we just stick to .aura?
That i haven't tested yet. If you are doing the Fresh-Install of the UDB, that is causing issues. But it seems if you do the upgrade from another version of the repack/UDB it's working.
MUST... HAVE... REPACK....! NEED... WOW!
Hello, i just got a prob whit this.. when i open realmd or mangosd says unable to connect 127.0.0.1 etc ? ? ?? ty for help
Do you have your mangos.conf and realmd.conf setup to connect to your database, look at your last step on the instructions above.
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”
on the mangos.conf file that's where i got that from the PASSWORD means your password for your MySQL database.
@ mmssda
Your probably not setting up your Realmd, Scriptdev2, and/or Mangosd config files up correctly. Make sure you manually put in your database name and password on them. It tells you what to put at the very bottom of the discription on this page.
Ok for while you all wait, please download this:
http://filebeam.com/27083027d07c5c2875c4001da2808600
that file i would like everyone to put into the fresh-install. There you can just overwrite the one in there, and if you run the fresh-install from the bat to install the server. It will allow you to play the game, while we fix the other issues.
Sorry i missed something, thats a zip file you need to extract the characters.sql out of that file.
Yes the file above fixed by Summonence is the correct one!
edit to my lazy comment, it says cloud not connect to mysql database at 127.0.0.1: unknown database mangos
cannot connect to world database 127.0.0.1;3306;root;lol123;mangos
@MMssda
Are you certain you installed the database with the new repack? run Fresh-install with the bat, in Fresh-Install?
@ Everyone that is getting errors
For those that are getting the errors from trying to create/or view characters. Did you happen to run a fresh-install or did you do a upgrade function from the last repack?
I seem to be having trouble getting to that so... if you just want a fix for the character thing to get in the game knowing that something better is coming, try:
C:>mysql -u root -p -D characters
mysql>ALTER TABLE characters ADD COLUMN dungeon_difficulty TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER map;
Huge thanks to these guys for the hard work!
Run this with the character table open in HeidiSQL
ALTER TABLE `characters` ADD `dungeon_difficulty` CHAR(50) NULL AFTER `map`
That will fix the error when creating a toon.
@ Nilrem
Thanks buddy, for the nice comment.
Ok everyone that is trying to still keep his current characters for players etc. Load up your favorite SQL modifying program. I use sqlYOG. Now when your in there connect to the server using your username and password. Load your characters database, in the Queue. Type in
ALTER TABLE characters ADD COLUMN dungeon_difficulty TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER map;
(thanks Nilrem, i didn't feel like typing that until you wrote it in there)
This is insert the column needed for the users to view there characters and make new ones. After this please check to make sure all characters have 0 in that column before you start up the server. Disconnect and start the server. Test it please tell me if this works.
:) Good testings
- Summonence
Sorry yes the line is
ALTER TABLE `characters` ADD `dungeon_difficulty` CHAR(50) NULL AFTER `map`
In any SQL program
@ JaJa
Did you try this out, and is it working for you now?
um what is this fresh install where i get it ;S dont find one ;/
It's in the Fresh-install folder its called. Arcane-Fire.bat
i downloaded the characters.zip and did what the other guy said it works fine now, just couldn't import my saved characters had to start new
thanks.. hmm..i do it and it says like 50 times it doesnt detect mysql something and then installition complete! and..? :S
mangosd keeps saying cloud not connect to mysql database at 127.0.0.1: unknown database 'mangos'
cannot connect to world database 127.0.0.1;3306;root;lol123;mangos ... something i do wrong?
Only other thing i can think of you didn't install them.
what didnt i install?.. i did fresh install.. sry being newb but.. oh well every one learns ;)
im getting some instance reset errors and mail errors and i aloso cant import old characters it says broken data any help please
oh and yes i installed mysql
please try help..if i get a 2.4.3 mangos private working i can donate 20 euro or just thank.. anything, thanks
@MMssda
Got anything that might be blocking port 3306 even internally?
Not sure if they like brand names here, so think antivirus and internet security programs.
@Summonence
Ty, that Char.log got me working.
@MMssda
Make sure you run the Arcane-Fire.bat inside the Fresh install folder.
@Summonence or Colt45
Not a big deal, just an fyi. I am able to create characters, but it won't let me delete one. It goes through the steps, making me spell out "delete," but the character isn't removed. I know I can do it from the MaNGOSD.exe command prompt, just wanted to pass it on.
nice job as usual but any news on the WotLK or if reaper, jared your you colt have a server test for WotLK i'de like to test it out please.
Alright has anyone used the update batch? If so have you had any errors and go here: C:\Arcane-Fire-Backup and tell me if you have all your backup files in there!
I did an upgrade...
The backup files are listed in the Arcane-Fire-Backup directory
did your upgrade work?
@ Summonence, I added the first sql update:
ALTER TABLE characters ADD COLUMN dungeon_difficulty TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER map;and as I read on, it should have been:
ALTER TABLE `characters` ADD `dungeon_difficulty` CHAR(50) NULL AFTER `map`Of course I can't change that now, so what next?
@Rikiller
Did it work tho?
no it didnt
Out of curiosity, if I were to do a fresh install rather than an upgrade, is it possible to import backed up characters and accounts into the database so that nothing is lost?
Hey guys, good job :-D
seems to work well, havn't had any complaints yet anyway ;-)
I do have a question though, even though i can create new chars etc i'm still getting that huge long list of errors regarding the instance cleanup when i start the server off, is that nothing to worry about?
I use navicat to modify my database
not sure how u do that modify to be able to import my old characters..any one else use navicat can help?
thanks
Alright it looks like ALOT of people are having some serious issues that are hard to explain, so if you would like I can use LogMeIn (Oatman used to use this method for me before I joined the team!)! LogMeIn is a free download that allows someone else with your password and autentication key (that you create) to access your computer! http://www.LogMeIn.com is the website, and if you want me to help fix any errors you may have e-mail me at Colt45-Musick@hotmail.com after you created your LogMeIn account and downloaded LogMeIn!
@Rikiller
Yes I believe so, but it would be very tricky tho (like in the above post) if I were to use LMI I could probably do it.
@Colt45
I have a better option for you, please email me rikiller@me.com for details...
@me.com !?!?!?!
Is everyone having problems with upgrading? I don't want to make the push to upgrade if this is a problem for most people. BTW been using Reaper team packs for a while now almost the beginning and am very very pleased with the results. No problems at all thus far :)
Also many thanks to Colt45 and Oatman. Good Job well done.
upgrade/fresh install both work if u do the file move after you're done
the dll & character file
Colt help me please, im having a problem, when i make a character, it doesnt show up on the Character selection screen, can you help me out?
Ok the fix works for making new characters but i get errors from the data section on all previously made characters. I tried upgrade and then full install with the Summonence fix and still all my players chars will not load any adivice for importing them back into the database succesfully would be appreciated.
Im about to update the links to the fixed (not %100) but to where u can make, see, and delete your characters!
Also if you already downloaded it you can try the UBD Fix 1 link at the top of the post (the fix may be just a flash and then gone but if it doesnt work then use Navicat to apply FIRST the fix_part1.sql file then the fix_part2.sql file!
Also if you run a public server I DO NOT reccommend updating yet! It seems there have been alot of errors, but help reporting them so we can fix them helps!
Thanks for the update and appreciate the extra work. Better to have it just right then not.
Yes sorry there was a release, its not our fault they weren't working. I worked hard on this today, to figure out make sure its working stable enough to host your players. Working on fixing other issues in the next day or so.
This is how I got it working from a character dump using 6245 unsure if a backup would work:
This is the part in the char dump you need to go to:
'CharNameHere', '1', '8', '26.9513', '4288.28', '90.1167', '530', '',
Search for your char name, The last part after 530 (the map no) is blank, change it to '0'. So it's the 7th piece of data after your character name. That's the dungeon_difficulty column.
Go into your MySQL\data\characters directory and delete everything (BACKUP FIRST). Run the characters.sql file included in the zip I link to down the bottom to recreate it. Load your character dump using the loadpdump option in Mangos Server. Then run the 6360 sql patch also included in the zip and it works fine.
Don't forget to back-up blah blah blah, sorry it's messy and probably confusing but it works for me anyway.
http://rapidshare.com/files/132771897/sqlfix.zip.html
I don't know why it works, no time to check anything, just wanted it out there ASAP
I *think* that all you'd have to do it run the 6360_characters_characters.sql patch if you've added the dungeon_difficulty column and it would work. Unable to test due to accidentally deleting my 6245 DB and I don't have the time to re-install right now. Reap, oat or Colt you'd already have it if you've downloaded the mangos SVN release.
IntErlOpr! I tested, and