Reaper-X UR1 Arcane-Fire for WoW Client (2.4.3)
By Colt45 on Aug 1, 2008 in Reaper Mangos
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 (make sure that when you apply updates, you apply them in order as listed)! A changelog and what revs Arcane-Fire are also below uses!
NOTE: Arcane-Fire no longer supports PSDB!!!
Revs:
Changelog:
Plus lots more fixes!
THE NAVICAT DOWNLOAD IS ONLY RECCOMENDED FOR EXPERIENCED USERS AND PEOPLE WHO HAVE PROBLEMS INSTALLING THE DATABASES!!!
Navicat Guide Download (These are not updated! You must update them yourself!):
Full Arcane-Fire Download (These are not updated! You must update them yourself!):
--------------------------------------------------------------
BUG FIXES:
- Bug Fix 1 (Thanks to Oatman's hard work!)
Apply Bug Fix 1 if you are having problems with creature templates, etc.
- None
- None
We Currently DO NOT have a guide for this release so please either use the guide located here:
- Reaper-X MaNGOS Installation Guide (Writen by Reaper-X Himself)
Let me know if there are any bugs!!!
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
Facebook
Last.fm
Twitter
YouTube
woot, first?!?!!?!
Trying it as an update first then if no dice i'll do a fresh install... and see if i can restore the previous db
Great work guys, i'm off to test out this new repack!
Thx for the release,
Wanna ask a question (Newbie to this)
Im getting a error : ERROR:Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql).
My previous version worked , dont what I did wrong
Thx :)
I tried using the already extracted files from last update (the other UR1) everything worked fine until I tried starting MaNGOS, does this mean I have to re-extract vmaps, dbc and Maps from this release?
6th nice work
@ Ash
Yeah, same problem
#Ash
I got the same error message as you, and mangos stopped loading up after displaying the message.
" Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql). "
Btw, Before ANYONE ELSE POSTS ISSUES. READ THE GUIDES! Colt45 created guides that CAME WITH the repack.
c:\NAVICAT ARCANE-FIR\GUIDE\
If your doing a upgrade or fresh-install. Read the flipping guide. There at are few patches you need to still install. They FIX the issues.
Thanks Summonence :D didnt know I had to insert a lot of files from Navicat...
the RapidShare Downloads dont work for me anyone else??
I got a error in Character Upgrade from UDB.
Query:
ALTER TABLE `character_pet` DROP COLUMN `Commandstate`
Error occured at:2008-08-01 13:54:57
Line no.:2
Error Code: 1091 - Can't DROP 'Commandstate'; check that column/key exists
Can someone help me?
Did everything the guide told me and I still get that damn character_template shit
Everyone getting SQL field errors on the creature tables.....you might be using an old mangos/realmd .exe file. Make sure you update shortcuts on your desktop if that's where you're launching it from. You might be using one from 5953 or 6245 or something.
realmd is rev6407 and mangosd is rev 6399...mb mangosd must be rev6407 too?
PS. i'm getting the same error "ERROR:Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql)."
PPS. and this too "Error Code: 1091 - Can't DROP 'Commandstate'; check that column/key exists"
to Sythus: i was trying with mangosd from this repack...
aint it easier using the instal guide from the other Arcane Fire release? (http://www.reaper-x.com/2008/07/26/arcane-fire-ur1-mangos-243/)
or is the guide wrong/allso buged? :p
to Nikolaibroxz n/c
are u blind? read! "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!!!"...
First off, Great work every update. Here are the errors I get from this release.
=Spell 33280 listed in `spell_proc_event` does not exist
Spell 35092 listed in `spell_proc_event` does not exist
Spell 35093 listed in `spell_proc_event` does not exist
Spell 35094 listed in `spell_proc_event` does not exist
==================================================== 100%
>> Loaded 23788 item prototypes
Item (Entry: 8498) not correct 20655 display id, must be 44666 (using it).
Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
Item (Entry: 33808) not correct 47014 display id, must be 51920 (using it).
Item (Entry: 33868) not correct 47131 display id, must be 51758 (using it).
Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
Loading Creature templates...
Error in creature_template table, probably sql file format was updated (there sh
ould be 65 fields in sql).
same problem here... creature_template table error
seems like newer version of mangos is needed) *i just guess so*
anyway gj and thx for your work :)
DAMNIT!!!! Why is it always the similar problems!!! Ill have an update out soon!
Umm... Wasthat really colt that posted that?
Also I havn't done any of the arcane releases but my strong guess would be that hes using a 2.4.3 mangos server with a 2.4.2 database. These errors will be typical just ignore them.
I cant find the guide summonenece was talking about, lol, at all!
@ Daniel
No they are both the same rev (trust me) it just says something differant in the MaNGOSD.exe file :D
the guides are only in the NAVICAT Download!
so there's not possible to fix this really fast? :P your last UR1 worked but I removed it because this one was "fixed"
Im fixing this as soon as possible
hi i installed the database sucefull but i try to install gm island vendor and it gives me an error in dbusername i out:
root
in password:
my pass
in database:
i put mangos and dont work
i put realmd and dont work
i put characters and dont work
any help will be greatfull
I'm getting the same MySQL Error as others (Error in creature_template table, probably sql file format was updated (there sh
ould be 65 fields in sql).)
I ran all the navicat updates, to no avail.
I'm probably missing something, but I grabbed both the full repack and the navicat repack (since the guide was only in the navicat release).
I decompiled the most current release of WoW (2.4.3) so I have all the latest maps etc. the db install (from the repack) went flawlessly so I'm a bit confused what I'm doing wrong. I'd pick it apart myself, but I'm remote connected to my house from the office.
any helpful suggestions would be greatly appreciated!
@ Oatman
i think we cant ignore it cuz it just stop's loading after "ERROR:Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql)."
however i make work your last arcane-fire release with other character db :P so thx for your work!
PS. i was trying many times to make this release work...and cant((( I've tried several times fresh install and tried to upgrade from 6245 and in anycase i'm getting the "creature_template" error when loading mangos, and "Error Code: 1091 - Can't DROP 'Commandstate'; check that column/key exists" when trying to apply one of the "fixes" from "NAVICAT" download :) hope you will fix it and we will enjoy your releases as always :D
No AuctionBot? My players REALLY REALLY miss that lol =D
I think i know why, I believe its because the "AD.exe" is not extracting the proper DBC files and after looking through the DBC file folder im not seeing a "creature_template.dbc". Could this possibly be caused by "AD.exe" missing the proper line of code that extracts "creature_template.dbc"?
~Further explained~
Heh, the only reason I said what I said above is because in previous versions of MaNGOS I've found the "creature_template.dbc" file.
@ Garrett
that's possible, but it seems like there's an error in the mysql db, not with files being found. I could be wrong though, so you may be right, I'm just pointing out what my guess is. :)
@behindspace
You could very well be right as well, and hopefully they will post back with a solution soon :D
I agree! I'm hoping that I can get this up and running before I get home today, so I can fiddle around with my pvt server before I have raid tonight!
I love MaNGOS for the sheer fact that I can play a non-serious game (one man raid on BT? what? ROFL!)
and I've been waiting to be able to one man Sunwell too! LOL!
so, hopefully they figure out what's up and can implement a hotfix (I'll take a single .sql file and use it, since I'm pretty comfortable with MySQL, comes from being a php developer for my day job)
but yeah, I hope they can figure out what our problem is, and get out a hotfix when hey can (I'm not gonna demand one for today, but when they get it done, that will pwn!)
my ad.exe dosnt work it keeps crashing just after starting the db extraction help please
Guys I know what the problem is!
I'll release a patch file to fix this release in a few moments!
@ Oatman
YOU RULE!!!!! Thanks sooooo much!
I've got a couple of other errors on mangos boot (before it halts with the creature_table error) I copied the txt out of the command line window, is there any way I can send you the text document?
Also, is there a way to use this build without forcing all my players to upgrade there client? I tried running it with 2.4.2 data, but it bombs out due to a dbc being broke. I dont want my clients to have to upgrade, as i have no way of pushing the update out to them via an update server or anything.
Thanks for any advice on the matter.
@ hustlebird
you can send them the 2.4.2 to 2.4.3 update .exe, or have them add the patchlist url back into the realmlist.wtf file, either way will work, as you don't have to have a valid account to have the program patch itself (I don't think you do anyways, but I've got a working account, so I dunno what it does without a blizzard subscription)
hope that helps!
halp
why dont my posts show up??????????
I have 2 problems:
1, i got character_template table, 65 thingi
2, i can do this in the Fresh install guide 4. Now right click on your Connection name and go to "Execute Batch File"
-execute both the "001.sql" and the "002.sql" files here. Then restart Navicat.
PLz help me!!!
Was the patch file put up as the download yet?
Here is my fix to Arcane Fire!!!!
WAHOO!!!
http://www.mediafire.com/?erdflsmkogj
If you are still having issues after this update please extract your own DBC's. Nothing will work without my patch though because it is 100% vital!
Also you will still get some errors in the consule since I am not 100% perfect I have fixed 95% of the errors though so leave me alone! :P
Just kidding I am always willing to help. I'm getting better at this stuff ever since I started the WotLK Pack.
THANKS OATMAN :D
Thanks Oatman! The Link has been added under BUG FIXES as Bug Fix 1 in the post!
i got this error but i well see if work but thanks for the fix
http://img172.imageshack.us/my.php?image=errood2.jpg
#pedro9933
If my fix doesnt work then that means Colt did some serious scrambleing with the SQL.
it works sorry for the other post the mangosd file dont give any error thanks oatman.
keep the good work
i played the game for a little i dont see any error (only the error saying my addons are out of date :P)
i cant create any new characters with this new update i already have placed the fix and now new characters can be created
is only here or its a bug?
I am getting this error:
Loading Creature templates...
Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql)
This from a fresh install by the way. Please help
h00ray! it works (even publicly, I set it up so I could log in from the office, ROFL!)
many thanks to the dev team for making this release! now I can finally create my gear and raid sunwell solo! Kil'jaedan stands no chance against my gnome of fury and punishment!
OH! the one thing I was wondering still, I know in the older releases that Warlock's Minions didn't follow when set to follow, has this been fixed, or will I have to summon/banish them as needed?
@boondox26
Oatman released a fix for this a few minutes ago, you can read the above posts, or go her eto download his hotfix:
http://www.mediafire.com/?erdflsmkogj
a lot of us were having the same issue :-) and it's all better now!
again, HUGE THANKS TO OATMAN FOR THE FIX!!!!
Just telling you in your fix
it still has
set /p choice=
if %choice%==1 goto freshinstall
if %choice%==8 goto leave
while
if %choice%==8 goto leave
should be
if %choice%==2 goto leave
not a major issue, but just letting u know :>
I am going to test the fix now:D
I hope it worksxD
Salute!
@Oatman's 1:39 a.m. post
Thanks for the "patch" lol just got done downloading it, hopefully it works
WOOHOOO it works THANK YOU!!!
yeah good work
Guys, grats on the release and everything, but there was somethin i've noticed.
during install theres an option to install the optional GM island vendors, havn't seen them for a while so i tried to install them and got a message saying there was a file missing or something, so i did a lil digging... the batch file used to install is looking for something called "vendors.sql" which i'm assuming would just import in and all would be cool, is it possible you have a copy of this that would work hanging around in a folder somewhere getting digitally dusty?
Srry... crap... I always forget something... I don't have a GM Island vendors file that is compatible with this release so if anyone has one that is compatible let me know and I will be sure to add and update!
#Aznex
Yep your right! I was wanting to release it fast I never tested the batch file. Anyhow its not that big of a deal you just click x to get out of it.
Is this just my problem? When I go to make a character, it doesn't save it, and when I go to the SQL db editor and go into 'Characters' and then the characters box, it shows that there are no characters...hrm
did you follow the guide in the navicat guide
Great job on that fix Oatman. And you guys doing this release outstanding! I know you all lost alot of sleep on this. I enjoy your work.
"Srry... crap... I always forget something... I don't have a GM Island vendors file that is compatible with this release so if anyone has one that is compatible let me know and I will be sure to add and update!"
It's getting caught up on the dropped civilian
well i was just wondering if you can help ya guys out i got a version of 2.4.3 working on my mac os x intell and and was working on one for a windows version in mac no errs so i was wondering if i can backup my data base and send it to ya all when done it will have project silvermoon and ubd data base check it and see if it might work for you all
I'm no pro at this stuff, but for some reason, I can't get the tables in my character db created. all the others are fine, but char is empty... any thoughts? Sorry if this is kinda vague or whatever.
Same problem here.
Damn… I thought the „Reply” link will insert nickname of person, I'm replying :-) I'm sorry :-)
Same problem here as Gosszilla has.
#Daniel
lol, i dint mean that it would be easier to use the
---->RELEASEGUIDE<----
that is on the page there! tough when i think about it reaper-x own guide may be yust as good, just that its alitle outdated, some things changed etc.
sry late comment, havent been on the site for a while ;p
lol, wtf... my comment got smashed together in the middle >_<
well what i ment to say was that it would be easier to use the guide on the other release, (the bugged one) just not use the RELEASE just the GUIDE since the guide reaper-x got (http://www.reaper-x.com/2008/01/30/reaper-mangos-installation-upgrade-guide/)
is outdated and some things have changed when it comes to setting the server up :p
btw... this was meant as a comment on what Daniel said,
"to Nikolaibroxz n/c
are u blind? read! "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!!!"..."
its allowed to use you head right because if you READ what i said: "aint it easier using the INSTAL GUIDE from the other Arcane Fire release?"
u will see that i said use the GUIDE no the RELEASE
tough, the reaper-x guide aint that much outdated its just that this release is the same as the buged one (well just that this one dont got the bug) ^_^
Can't create characters!!!
Yeah having the same issure, cant create characters on the character screen
Colt45 i've been doing some research and some tinkering regarding the GM island vendors and the custom vendors for Org and SW is it ok to mail you please dude cuz i need a lil help, plus it'll take alot of explaining of what i've found and done etc?
Ok dude scratch what i asked b4, i think i've got it all sorted, can i mail you the code i used so you can check, verify its all working and distribute?
When i use .learn all_myclass on my shaman i recive some bug with unstopable healing
Fresh server, fresh files and scripts. I can start RealmD and MaNGOSD fine. Created new account and password. Open WOW.exe and can log in and choose my new realm. I get "Logging into game server" when I choose my realm. It then pops back to the realm selection. I choose my realm, and again, get "logging into game server". Anyone else experiencing this?
Had to make some fixes to the "fix" file. Some of the SQL statements were causing errors. Like table does not exist or columnt does not exist etc.
These errors show up when you run the fix batch file. Simply modify each sql statement that is doesn't like. If it says that it doesn't like a create statement because it already exists then try using modify. Some I simply deleted from the file. I can now save characters and the site works great.
Seems like the fix just needs a bit more time spent on it to weed out these items.
Nevermind about my comment and the "looping realm" question. Like I said, I'm a newb. I searched for awhile and never found anything. Finally, after posting this I found it. I had to change my realmd.realmlist ip.
Hmmz... when I run the fresh install thing it says "mysql not recognized as an executable or batch file"... what's gone wrong?
Thanks everything works fine for me :)
I got the server to work with the bug fix, however...I can not keep my weapons from vanishing for no reason. I make warp slicer, and infinity blade, equip them, then if I goto another area of the game (zone), they just vanish from inventory. WTF?
@manchine those are temp weapons anyways, u can't really keep em for a long time - not really worth fixing
if u dont know wut i mean, lookup the vael fight on bosskillers.com
err sorry not vael, Kael haha
Ok, thanks Bigmarky. I was wondering what was up with that because it's only certain weps that do that. Thanks for the info. =)
Speaking of the Kael'Thas fight, anyone know why the server would crash when he tries to use Gravity Lapse? =(
actually now that i think about it, they might have fixed that in the patch
ppl were killing kaelthas on purpose then using the weapons in other instances to buff dps
so no worries
WTB WOTLK P.SERVER!!!!
any one no when you going to work on the wotlk beta server
Awesome Release,,, Thank you
is there any custom vendors for this release, or gm island vendors
:D
Hi
First of all I want to thank you for your guides, it helped me a lot, and I got a question about the vmaps, I am running this server trough remote and I put a hard drive trough the USB but that hard drive broke, but when I let vmaps extract it searches for that path and gives me an error... is there a way to change its path to another folder?
Thanks a lot,
yours
@speedy
I've got a set of GM island and Org and SW vendors, there a lil out of date cuz they were intended for 2.4.2 i'm just waiting for Colt to get back to me then we can iron out any probs i havn't found / fixed then maybe see about getting a link maybe?
why do you always tell people to use navicat why not sqlyog or heidisql? they both work very well
because Navicat also works very well?
Just a quick question, when I load Mangos it shows Acid Rev 17 not Rev 18, is there any reason for this or am I missing something.
Well, I got passed the character creation problem by doing a fresh install of the 6245 release, and then upgrading to Arcane-Fire. I haven't had any problems other than that, Thanks for the new release!!! O.o now I can save the friends list instead of it disappearing every time I log out. Hope that vendor pack is updated soon, I really don't want to make my own lol.
@bav101
thx :D
Just thought I would throw this out there for the releases to follow. Would love to see this patch put in. The AH bot is the best though thanks for including it.
http://www.mangosproject.org/forum/index.php?showtopic=27897&st=0
@everyone lost w/o vendors..
don't forget, u can just use atlasloot ui mod
and .itemset commands
Anywhere we can go to DL the 2.4.3 maps and dbs? I'm still having problems with ad.exe, it hates Vista or something.
ad.exe dosnt work for me either and im on xp
Hi,
First of all, thanks for keeping this going, and all the great work you do!
I'm having this problem when I try run realmd.exe:
2008-08-04 08:34:37 Using configuration file realmd.conf.
2008-08-04 08:34:37 MaNGOS/0.12.0-SVN (Revision 6407) (Win32,little-endian) (realm-daemon)
2008-08-04 08:34:37 to stop.
2008-08-04 08:34:37 Database: 127.0.0.1;3306;root;8oj7rcd;mangos;realmd
2008-08-04 08:34:37 MySQL client library: 5.0.56
2008-08-04 08:34:37 MySQL server ver: 5.0.51a-community-nt
2008-08-04 08:34:37 ERROR:SQL: SELECT id, name, address, port, icon, color, timezone, allowedSecurityLevel, population FROM realmlist WHERE color 3 ORDER BY name
2008-08-04 08:34:37 ERROR:query ERROR: Table 'mangos.realmlist' doesn't exist
2008-08-04 08:34:37 ERROR:No valid realms specified.
I've done a fresh install, about 3 times, and i can't figure out what i'm doing wrong. Any help would be great.
Thanks
@Sykohtyk
heya dude, humor me for a second, edit your realmd.conf so that you have the line
LoginDatabaseInfo = "127.0.0.1;3306;root;yourpassword;realmd;mangos
and lemme know what happens?
I instaled fine new Arcane-Fire and seems all work fine,but anyone noticed that aprentice riding should be at lvl 30,NPC still offering only at lvl 40?? so somebody could tell me if this happening on your server too or no pls?
@dmp yeah its lvl 40 on mine too
@bav
OMG GG. Thanks, that was so stupid, mine had the line
LoginDatabaseInfo = "127.0.0.1;3306;root;yourpassword;mangos;realmd
well, don't i feel like a noob.
@ Sykohtyk
Basically dude heres what happened when it read that line it said IP address... check..... port...... check..... username... password...... check.... look in mangos db for realm info.......... OMG OMG
to some progs something like that wouldn't matter cuz it would skip to the next database and check that, but it doesn't seem clever enough to say ok dude so its not here we'll skip to the next.
Oh and between me and you and no one else.. i made the same mistake when i first setup a mangos server ;-)
@Bav
Thanks dude, appreciate it!
Maybe I'll spend some time learning it a little better, or just actually reading everything now.
I want to appologize in advance if this is listed somewhere. I did search for it, but the answer seemed to consistantly elude me.
I can't seem to get this to work over public. I went to No-IP, set everything up, but when it comes to connecting, externally, no one can connect. They say they can log in, but it won't connect to the server on their side. As far as i recall, everything is setup up accordingly and i can access it from the host computer...
please help...
Hi all, i got a problem updating to UR1 arcane for 2.4.3
First of all, I tried to copy the dbc and vmaps tools named "ad.exe" to the WOW folder as usual and when is showing extracting for a few secs, an error comes out saying "Ms C++ debug assertion failure and quite a long file names and unable to extract the files anymore. As i know that the extract map should basically have 2 files , ad.exe and extract-map.bat->this file is missing in the arcane pack.
Could anyone please explain to me how to solve this issues or there is something im doing wrong. Thanks in advance.
Alright I have officially opened a NEW E-mail account for Reaper-X related problems! I have IM inlcuded for faster response! But if I say that I am busy then I am busy and I will try to get back to you ASAP! The Email is Reaper-X-Support@live.com
The above email can also be used to suggest things and/or send files to help problems or just for fun (like gm island vendors, etc.)
i downloaded firanes spawns in gm island for patch 2.4.2 and modified a bit in it so them work in 2.4.3 now! i'm gonna upload them now so the link is coming soon.
Here are the full working vendors in gm island!
http://www.mediafire.com/download.php?yykamamwwnd
i swear every release there's at least 200ppl that never change the pw but post, what is wrong.
sigh, either way still patiently waiting for a wotlk reaper server, the ones i play on are temporary
im having trouble making characters i have my server up, i go into my realm and when make a guy it doesnt show up in my list. it shows up in my char.log file that i have guys made so idk what im doing wrong any help would make my day.and thank you for your hard work.
So, small question: Is this version stable+working properly?
its working stable with no problems on my system Pitje
any updates on wotlk yet becasue its been a while since any site admin or moderator has touched it or answered any questions
Hey there guys, thanks again for a new update, its all working great for me, except one thing, when I connect to my own server, I kick all the other players off! It’s a bit of a pain and I can’t figure out what I changed since the last patch (I could connect without any problems before I updated). If anyone has a solution to this problem, I would really love to hear it!
So to sum it up, people can connect to my server online, and everything is stable for them until I connect, then they all get kicked and cant log back on. I can enter the server fine, but at this point, everyone is lagged and awaiting the DC. I done a fresh sql install with this patch.
@chris
Heya Bud, couple of questions for you, if you log in as another account does it do it then? and did you reimport character and account info when you reinstalled?
Hey there Bav, thanks for the fast reply. It kicks me no matter what account I try to use and no, the char info from the previous patch wasnt updated. The strange thing is, it was working fine a few hours ago! :(
sorry, that should read "it kicks everyone else, no matter what account I use"
Even when I make a new account.
@Chris
no worries dude, my gut reaction would have been some the char data you imported for your account was corrupt.... but ok... anything changed in the last few hours? and have you tried my personal favourite (being a IT tech) switching it off and on again?
I did have a few connection problems with my router earlier, and reset it, but after that I set it back up the exact same way as before with the correct ports forwarded, dmz enabled and the firewall disabled. Maybe I should try the "Hammer" trick
@chris
the old Kinetic maintenance?
Thats the one! haha
its a good techneque used it a few times myself ;-)
but anyway best thing i can suggest is take your server offline, uninstall mysql delete the folder from program files, and reinstall, once thats done create 2 user one for you one for a mate and see what happens.. best i can suggest perhaps one of the others can come up with something else :-/
I might just need to try that. Thanks for the help, I cant think of anything else to do myself. I probably killed the database when installing my old custom armor and vendors etc. I had a bunch of errors.
Personally Chris i'd try everything b4 you've added any of the custom stuff and added your old character information, because if it works ok it would point to something corrupt.
Your welcome anyway mate.
I have tried to extract only the ad.exe file to WOW directory and once i run the ad.exe files, there is a error message box below screenshots:-
http://i5.photobucket.com/albums/y159/nctspawn/others/visualc-error.jpg
Last time i thought it was suppose to have ad.exe and extract-map.bat files but new Arcane pack only have ad.exe
I hope someone could help me on this.
Thanks in advance.
i got it working now,all i did was reinstall mysql and set it up all over agian and it worked.now i can play 2.4.3 =).thanks again for the work you put into this.
After reinstalling my SQL database its all working fine, and letting me join without kicking everyone else. I just need to add my custom stuff again.
Any news on a working vendor pack yet? or should I just start making my own again :(
@Chris
Weiss935 has his own that theres a link to download custom vendors so if you scroll up you can download them, i've sent some to Colt45 to add in, but i'm not sure if they are now, hey ho, on mine i've got vendors in SW / Org and Gm island, which all appear to be working as intended with no errors on startup, so they'll be available soonish i'm guessing.
@Chris
actually mate, thinking on, i dont have many users atm on my server, i let a mate and his guild on and they dont use it much atm, wanna test out my vendors? send me an email if you do and i'll send them, got no errors on my server btw k_hanby@hotmail.com
ok great, will add you to msn now :D
When ad failed on me, i simply used the 'map_extract' from the last version. worked like a charm...once i pointed my datadir to the right place...lol.
those of you out there who use public (playing from work, allowing others on your non-lan server) please refer to comment 116...i need help. ty.
http://vfkcentral.com
Anybody got any vendors yet?
how do we install the gm island vendors?
Ok, new issue. I have properly configered my ports...according to the site, both ports are accepting just fine. so the outside connection might be strictly connected to him using vista.
however, now i have a new problem. never had this before.
I connect, log in, choose my character. it looks like it is loading, than says disconnection from server and kicks me back to login.
i didn't upgrade from 6245, but did a fresh install. i don't remember importing the accounts and characters, but they were there.
can some1 please tell me what i did wrong?
please?
Hey guys great job on the new server for 2.4.3 it rocks I went in to it my self and tweeked it a bit for my liking but other than that it seems sound as a rock so far. I been running it for a few days now and I haven't had a crash yet. My server reached 30 users on just the 2.4.3 version I guess they liked it. Thanks guys Just to let ya know I am still around if you guys need any help with stuff just let me know.
Hi, great job on this update!
No major issues at the moment, but I am having the problem a few others mentioned with the 'Apprentice' mounts still only available for lvl 40+ and also the cost still unchanged.
Any advice on how to fix this will be much appreciated. Thanks.
Keep up the good work!
To anyone having issues with characters not showing up after creation, here is a quick and dirty fix:
I noticed in the server log a failed SQL insert. I used navicat to create two new fields in the characters.characters table, dungeon_difficulty and death_expire_time.
I did a fresh install from 59xx release, so I'm guessing these didn't get fixed.
It appears to work fine if you add these two fields in as text values. You can do this by right clicking the table in navicat, selecting design view, right clicking, and inserting.
Good luck!
Hey guys,
Need someone to help me with something, i'm modifying the code to take account for the mount changes, but i've a problem I have no idea what the mount cost should be cuz i dont play retail wow anymore i closed my account down, while changing the cost for some of the mounts to 30g which i was told from a mate that was the price of all the mounts now i noticed that a couple were set lower than that to begin with, would some kind soul who still plays retail mind checking the prices of the mounts please, then i can finish off and see about getting this out to ppl.
thanks,
Bav
Hi Bav,
To learn the Apprentice riding skill it costs 35gold, and then and an additional 10gold for the mount.
There are quite a few variations in costs depending on many different things.
Have a look at http://www.wowwiki.com/Mount which should give you all the info you need.
Look forward for a fix.
Thanks for your help!
@Naz
Thanks for your help dude i'll get on it now.
Nice info about riding skills ,but do you have aprentice riding at lvl 30 in Arcane client? Arcane realese is very nice,mostly I only miss don t know how could I set aprentice riding at lvl 30,so any tips I would happy hear pls :)
Right. Major problem: I did a fresh install with the fixed characters.sql; then, i imported my old characters; then i realized i forgot to run the fix, so i did. Now, when i log in, i can see all my chars, but when i try to play i get disconnected when its done loading: "query ERROR: Unknown column 'death_expire_time' in 'field list'
Ill try reimporting my chars again, ill check back if it doesnt work.
Well... that didnt work, now all my chars are gone again. I regret applying this -.- esp since reverting to 2.4.2 is a major pain due to errors related to credits.html
Well... that didnt work, now all my chars are gone again. I regret applying this, since reverting wow to 2.4.2 is a pain due to errors related to credits.html
I think i got it fixed; did a fresh install, added my old chars, applied the fix and added two column to the characters table: Death_expire_timer and Dungeon_difficulty, now checking for bugs.
All working, except i got no mobs in heroic dungeons.
I have a minor problem. Why are some of the mobs/NPCs moving so fast? I'm sorry if this question has been already asked/answered.
Good job im using this right now
The player disconnecting bug is back, when I log onto my server, everyone connected gets kicked!
*tears hair out*
Applied the fix, Kael'thas still crashes server on Gravity Lapse.
And I thought he couldn't get any more evil...
Hey guys just wanted to give you an update on the mount problem, I've officially given up I ran into a problem where i change the price and lvl and required lvl of the mount and it still says you need to be level 40, i asked on the mangos forum if anyone knew where else it pulls the info from and tbh they are about as useful as a sexually transmitted disease, i was told "i'm sorry we dont support repacks" to which i replied i dont want support on the repack i just need to know where else it pulls the info from, to which i was told "i'm sorry we dont support repacks" so i'm incredibly pee'd off and as far as i'm concerned they are a complete waste of space.
Hey, ok. My MaNGOSD.exe is crazy.
It came up with errors:
table "character.caracter" does not exist
table "character.guild_bank_item" does not exist.
Loading MaNGOS strings ...
SQL: SELECT entry, content_default FROM mangos string
=================================100%
>>Loaded 0 mangos strings. DB table "mangos_string" is empty. Cannot continue.
um help?
I tried it again, and it crashed on me. So now i have a folder for crash logs.
HELP PLEASE!!
Try using the Bugfix, maybe it works. At least it worked for me.
I did BUgFix1 and still nothing.
hi. i ve just 1 problem. i use nevicated install and i ve got some errors at 007.sql. (fresh install to characters)
(execute batch files types)
exists
[Err] -- 6291
ALTER TABLE `character_pet` DROP COLUMN `Commandstate`;
[Err] 1091 - Can't DROP 'last_honor_date'; check that column/key exists
[Err] -- 6297
ALTER TABLE characters
CHANGE `logout_time` `logout_time` bigint(20) unsigned NOT NULL default '0',
DROP `last_honor_date`,
DROP `last_kill_date`;
[Err] 1060 - Duplicate column name 'death_expire_time'
[Err] -- 6298
ALTER TABLE characters
ADD COLUMN death_expire_time bigint(20) unsigned NOT NULL default '0' AFTER zone;
[Err] 1054 - Unknown column 'bones_flag' in 'corpse'
[Err] -- 6326
ALTER TABLE corpse
ADD COLUMN corpse_type tinyint(3) unsigned NOT NULL default '0' AFTER bones_flag;
[Err] 1054 - Unknown column 'bones_flag' in 'where clause'
[Err] UPDATE corpse
SET corpse_type = 1 WHERE bones_flag = 0;
[Err] 1091 - Can't DROP 'bones_flag'; check that column/key exists
[Err] ALTER TABLE corpse
DROP bones_flag;
[Err] 1061 - Duplicate key name 'idx_type'
[Err] -- 6335
ALTER TABLE corpse
ADD KEY idx_type (corpse_type);
[Msg] Finished - Unsuccessfully
@Dan
you try a fresh install?
Newb question, I'm new at this and all...but I'm trying to install the GM island vendors, and I can't remember what the MaNGOS/World db name...
is there a default or anything?
Help? lol
@Jay the answer for which you seek you have already answered it yourself... confused yet? yeah i am too, the default is Mangos dude, but Colt forgot to include it in the distro i think, or he may have updated it cuz i passed over a copy of the code that has GM Island and ORG and SW vendors which i spent blood sweat and tears (not really) fixing to work with 2.4.3, look for something called vendors.sql if you've got it cool, turn to page 40 and dont read on, if not turn to page 153 and drop me a mail my email addy should be in one of the previous posts and i'll drop a copy with some really hard instructions on how to get it to work. But it might not be for a few cuz i need sleep.
@Bav
Okay, I sent you an email. I tried to install the GM island vendors but it didn't work, so I'll be waiting for your reply.
yes. i even re installed WoW and TBC, patched it up to 2.4.3 and still i get errors.
Ok, I am a n00b to the reaper version of the server. I d/l 6245 and did a complete install, however, when I run reaper-x-mangos.bat there is no option to config my server. Am I missing something here?
Alright, applied common sense to the .cfg files, but have a new error.
when I run the mongosd.exe file I get a map error
c:\data/maps/0004331.map in non-compatible version
I extracted the maps over again and same result.
Any clues?
Alright, common sense prevails again.
Next damn issue. I get this error -
c:\data/dbc/spell.dbc (exsist, but have 216 fields instead 213)
I am bonifide stuck here...I have double and tripple checked everything.
Help would be appriciated
Ok, found a link explaining the issue..
http://forums.reaper-x.com/topic/how-to-find-out-if-make-the-client-and-server-are-same-version#post-6475
I need this broken to the barney level for me.
Why do I need to roll back the ver? I thought this was the 2.4.3 ver...
do i have to keep my client at that ver to play on the private server?
once i roll back I am assume I will need to re-extract the dbc files
Ok, I found a link explaining the error
http://forums.reaper-x.com/topic/how-to-find-out-if-make-the-client-and-server-are-same-version#post-6475
Now i need it broken to the barney level for me.
Why roll back my client to extract the dbc files?
Do I need to keep it rolled back?
ok, found a link to resolve this, but have questions...
Why roll back the client?
Do I need to keep my client from re-updating through the auto-loader?
i just reinstalled MySQL and all that jazz. Im currently on the matrix looking stuff. So i will see if it works after that and report back here and give my results. I have had a server before. It was on an older computer and i used navicat. navicat is the biggest pain in the ass, but it worked after 2 weeks. so i hope this wont take that long.
ok. it worked! but i got the creature error. but i have the bug fix. i will run that and report back!
ok. i did everything. set up an account, and stuff, but when i logged in it said "Unable to connect" why?? i was so close! :'(
ok. my new issue is connecting to game server. i have looked for this realmd.realmlist and i think you are all fooling me because i cannot find it.
People can u uplod ArcaneFireUR1 FIX.zip somewhere else because it says "There are no servers avalible .....Like its renamed or moved...PLZ I NEED IT OR Send on my e mail BataIver@yahoo.com
@Bedak
I've sent you an e-mail with this file, I hope you 'll receive it.
@Dan
The file that you're looking for should be called realmlist.wtf It's in the "root" of your WoW install folder IF and only IF you've connected to a wow server before. It's not there upon a fresh install. Just create a normal text file and change it's name to the one you're looking for then edit it in notepad or wordpad to point to the server you wish to connect to.
The line would look similar to this:
set realmlist your.gameserver.com
...
i have a problem...see
some required *.dbc files not found or not compatible:
./dbc/spell.dbc (exist, but have 216 fields instead 213)wrong client version dbc file?
help me ^^
tnks!!!
sorry...let me clarify... the address after the set realmlist should be the address of your wow server. If it's on the same machine as the one you're playing from, it should be 127.0.0.1 Or if your server is on another machine on your network then enter it's IP there.
The one I gave in the above example is if it's a server that's on the internet.
2008-08-08 19:25:04 ERROR:
Some required *.dbc files (1 from 55) not found or not compatible:
./dbc/Spell.dbc (exist, but have 213 fields instead 216) Wrong client version DBC file?
@Sannja
It means you patched your WoW to the 2.4.3 client.
This is where I am. According to another post on in the forums you need to "unpatch" your WoW and then google the update to where you need to be.
to unpatch your WoW
Step 1. Go into the "Data" folder in your World of Warcraft directory.
Step 2. Delete the file "patch.mpq".
Step 3. Open the "repair" in your World of Warcraft directory.
If anyone could help us out the the updates to get wow back where we need it, it would be appriciated.
ok. my realmlist.wtf says:
set realmlist 65.12...(my ip)
and its been like that. Also, my realmd.conf says the whole 65.12...(my ip);3306;root;Pass deal.
and it still gets stuck at Logging into game server.
Reaper,
I've been reading your posts regarding dual Realmd (2+ servers) and I seem to have lost some in the translations lol can you perhaps repost it using a newer version ??
Colt45, i really need your help. Tomorrow is my last day of summer. so i need this working by tonight.
My issue is I can get all the way up to right after picking the realm. then it gets stuck in a loop saying "Logging on to Game Server" then it just opens up the list of realms. (MaNGOS being the only one) I have changed my realmlist.wtf to:
set realmlist 65.12.178.100
AND
set realmlist 127.0.0.1
Both giving me the same outcome.
Also, i have medaled with the realmd.conf to say 65.12.178.100 and also the 127.0.0.1.
Same goes for ScriptDev2.conf and mangosd.conf.
Can you please help me? If you dont know the settings they should be, can you do a filefront or something with everything exept the rather large game. and maps, vmaps, and so on.
Thanks,
Daniel
ok, can anyone please explain the patch requirements for the client so we don't get all of these errors.
Call me the n00b from hell, but I am not quite understanding it.
Most errors can be solved by contacting me at Reaper-X-Support@live.com (I also have IM for those who have it also!)!!!
Anyone know if there is a way to increase the rate at which the Warlock Season 3 Helmet Wing effect appears?
THX it work Big THX!! JUST 1 More thing i really need...Its how to enable arenas and BG to work...?
i have 2.4.3 version :P
Installed yesterday on a test PC (not on live server), using fresh install.
Seems to go smootly, no errors after Oathman's Bug Fix 1.
Great work, guys ;)
Looks like UDB have a loooooot of new updates on their new release, hope you guys will update to that version as soon as you can :D
woohooo
yeap saw the new UDB too,hope you guys soon release new update too :)you doing awesome job for us !
But can some1 tell me where how can i have working areas and BG on my Lan server...I have internetcaffe.......
um, my Heroic dungeons are empty... What can I do about this?
keep up the good work (Y)
ok. until i can get mine working, can i be a GM/Admin on someones server? I want to make houses and events, and custom items. So if you want any of that, email me.
kakashisq7@hotmail.com
or IM me at the same address.
@Q_bert,,,
tnqx my friend...
^^
After some fiddling around it works like a charm!
Some notes i wrote down during install where i made some mistakes which others may like to avoid
- The fix from oatman should be applied after the SQL DB has been created (for fresh install this is after running arcane-fire.bat)
- The characters table needs editing to avoid empty templates during startup (ref. comment solocommand above)
a. run navicat
b. connect to database (localhost, root, password)
c. navigate to characters.tables.characters
d. select designtable
e. add field dungeon_difficulty as text
- as always both mangosd.conf and realmd.conf require a manual password update when the password from SQL is not mangos. also don't forget to change to the correct datadir path.
DataDir = "C:\Reaper\Repack Arcane-Fire\Repack Arcane-Fire\Data"
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"
Hi Everyone
I have this problem when i try to start server
2008-08-10 11:27:39 SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = '1')
2008-08-10 11:27:39 SQL ERROR: Table 'mangos.account' doesn't exist
2008-08-10 11:27:39 SQL: UPDATE characters SET online = 0
2008-08-10 11:27:39 SQL ERROR: Table 'mangos.characters' doesn't exist
2008-08-10 11:27:39 SQL: UPDATE realmlist SET allowedSecurityLevel = '0' WHERE id = '1'
2008-08-10 11:27:39 SQL ERROR: Table 'mangos.realmlist' doesn't exist
2008-08-10 11:27:40 SQL: SELECT MAX(guid) FROM characters
2008-08-10 11:27:40 query ERROR: Table 'mangos.characters' doesn't exist
2008-08-10 11:27:40 SQL: SELECT MAX(id) FROM character_pet
2008-08-10 11:27:40 query ERROR: Table 'mangos.character_pet' doesn't exist
2008-08-10 11:27:40 SQL: SELECT MAX(guid) FROM item_instance
2008-08-10 11:27:40 query ERROR: Table 'mangos.item_instance' doesn't exist
2008-08-10 11:27:40 SQL: SELECT MAX(id) FROM auctionhouse
2008-08-10 11:27:40 query ERROR: Table 'mangos.auctionhouse' doesn't exist
2008-08-10 11:27:40 SQL: SELECT MAX(id) FROM mail
2008-08-10 11:27:40 query ERROR: Table 'mangos.mail' doesn't exist
2008-08-10 11:27:40 SQL: SELECT MAX(id) FROM item_text
2008-08-10 11:27:40 query ERROR: Table 'mangos.item_text' doesn't exist
2008-08-10 11:27:40 SQL: DELETE FROM character_inventory WHERE item >= '1'
2008-08-10 11:27:40 SQL ERROR: Table 'mangos.character_inventory' doesn't exist
2008-08-10 11:27:40 SQL: DELETE FROM mail_items WHERE item_guid >= '1'
2008-08-10 11:27:40 SQL ERROR: Table 'mangos.mail_items' doesn't exist
2008-08-10 11:27:40 SQL: SELECT MAX(guid) FROM corpse
2008-08-10 11:27:40 query ERROR: Table 'mangos.corpse' doesn't exist
2008-08-10 11:27:40 SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'
2008-08-10 11:27:40 SQL ERROR: Table 'mangos.auctionhouse' doesn't exist
2008-08-10 11:27:40 SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'
2008-08-10 11:27:40 SQL ERROR: Table 'mangos.guild_bank_item' doesn't exist
2008-08-10 11:27:41 SQL: DELETE FROM corpse WHERE corpse_type = '0'
2008-08-10 11:27:41 SQL ERROR: Table 'mangos.corpse' doesn't exist
2008-08-10 11:27:41 SQL: UPDATE realmlist SET icon = 1 WHERE id = '1'
2008-08-10 11:27:41 SQL ERROR: Table 'mangos.realmlist' doesn't exist
2008-08-10 11:27:44 SQL: SELECT id, map, resettime FROM instance WHERE resettime > 0
2008-08-10 11:27:44 query ERROR: Table 'mangos.instance' doesn't exist
2008-08-10 11:27:44 SQL: SELECT mapid, resettime FROM instance_reset
2008-08-10 11:27:44 query ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 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 < '1218378464')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance' doesn't exist
2008-08-10 11:27:44 SQL: DELETE FROM character_instance USING character_instance LEFT JOIN characters ON character_instance.guid = characters.guid WHERE characters.guid IS NULL
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.character_instance' doesn't exist
2008-08-10 11:27:44 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-08-10 11:27:44 SQL ERROR: Table 'mangos.group_instance' doesn't exist
2008-08-10 11:27:44 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-08-10 11:27:44 SQL ERROR: Table 'mangos.instance' doesn't exist
2008-08-10 11:27:44 SQL: SELECT id FROM instance
2008-08-10 11:27:44 query ERROR: Table 'mangos.instance' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('249','1218772800')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('269','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('309','1218600000')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('409','1218945600')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('469','1218945600')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('509','1218600000')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('531','1218945600')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('532','1218945600')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('533','1218945600')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('534','1218945600')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('540','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('542','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('543','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('544','1218945600')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('545','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: SELECT id FROM instance
2008-08-10 11:27:44 query ERROR: Table 'mangos.instance' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('546','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('547','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('548','1218945600')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('550','1218945600')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('552','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('553','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('554','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('555','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('556','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('557','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('558','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('560','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('564','1218945600')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('565','1218945600')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('568','1218600000')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('580','1218945600')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: INSERT INTO instance_reset VALUES ('585','1218427200')
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.instance_reset' doesn't exist
2008-08-10 11:27:44 SQL: DELETE FROM character_instance USING character_instance LEFT JOIN instance ON character_instance.instance = instance.id WHERE instance.id IS NULL
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.character_instance' doesn't exist
2008-08-10 11:27:44 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN instance ON group_instance.instance = instance.id WHERE instance.id IS NULL
2008-08-10 11:27:44 SQL ERROR: Table 'mangos.group_instance' doesn't exist
2008-08-10 11:27:51 Item (Entry: 8498) not correct 20655 display id, must be 44666 (using it).
2008-08-10 11:27:51 Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
2008-08-10 11:27:51 Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
2008-08-10 11:27:51 Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
2008-08-10 11:27:51 Item (Entry: 33808) not correct 47014 display id, must be 51920 (using it).
2008-08-10 11:27:51 Item (Entry: 33868) not correct 47131 display id, must be 51758 (using it).
2008-08-10 11:27:51 Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
2008-08-10 11:27:51 SQL: SELECT id, text FROM item_text
2008-08-10 11:27:51 query ERROR: Table 'mangos.item_text' doesn't exist
2008-08-10 11:28:09 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-08-10 11:28:16 SQL: SELECT MAX(id) FROM character_pet
2008-08-10 11:28:16 query ERROR: Table 'mangos.character_pet' doesn't exist
2008-08-10 11:28:16 SQL: SELECT position_x, position_y, position_z, orientation, map, data, time, corpse_type, instance, guid FROM corpse WHERE corpse_type 0
2008-08-10 11:28:16 query ERROR: Table 'mangos.corpse' doesn't exist
2008-08-10 11:28:23 SQL: SELECT itemguid,item_template FROM auctionhouse
2008-08-10 11:28:23 query ERROR: Table 'mangos.auctionhouse' doesn't exist
2008-08-10 11:28:23 SQL: SELECT COUNT(*) FROM auctionhouse
2008-08-10 11:28:23 query ERROR: Table 'mangos.auctionhouse' doesn't exist
2008-08-10 11:28:23 SQL: SELECT guildid FROM guild
2008-08-10 11:28:23 query ERROR: Table 'mangos.guild' doesn't exist
2008-08-10 11:28:23 SQL: SELECT arenateamid FROM arena_team
2008-08-10 11:28:23 query ERROR: Table 'mangos.arena_team' doesn't exist
2008-08-10 11:28:23 SQL: SELECT mainTank, mainAssistant, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, isRaid, difficulty, leaderGuid FROM groups
2008-08-10 11:28:23 query ERROR: Table 'mangos.groups' doesn't exist
2008-08-10 11:28:23 SQL: SELECT id,messageType,sender,receiver,itemTextId,has_items,expire_time,cod,checked,mailTemplateId FROM mail WHERE expire_time < '1218378503'
2008-08-10 11:28:23 query ERROR: Table 'mangos.mail' doesn't exist
2008-08-10 11:28:23 SQL: DELETE FROM mail WHERE expire_time < '1218378503' AND has_items = '0' AND itemTextId = 0
2008-08-10 11:28:23 SQL ERROR: Table 'mangos.mail' doesn't exist
2008-08-10 11:28:24 SQL: SELECT MAX(id) FROM instance
2008-08-10 11:28:24 query ERROR: Table 'mangos.instance' doesn't exist
2008-08-10 11:28:25 SQL: SELECT MAX(time) FROM character_queststatus_daily
2008-08-10 11:28:25 query ERROR: Table 'mangos.character_queststatus_daily' doesn't exist
2008-08-10 11:28:25 SQL: DELETE FROM ip_banned WHERE unbandate<=UNIX_TIMESTAMP() AND unbandatebandate
2008-08-10 11:28:25 SQL ERROR: Table 'mangos.ip_banned' doesn't exist
2008-08-10 11:28:26 SQL: UPDATE realmlist SET color = 0, population = 0 WHERE id = '1'
2008-08-10 11:28:26 SQL ERROR: Table 'mangos.realmlist' doesn't exist
2008-08-10 11:29:16 SQL: SELECT 1 FROM account WHERE username='HUNTER'
2008-08-10 11:29:16 query ERROR: Table 'mangos.account' doesn't exist
2008-08-10 11:29:16 SQL: INSERT INTO account(username,sha_pass_hash,joindate) VALUES('HUNTER',SHA1(CONCAT(UPPER('HUNTER'),':',UPPER('hunter'))),NOW())
2008-08-10 11:29:16 SQL ERROR: Table 'mangos.account' doesn't exist
2008-08-10 11:29:16 SQL: INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM account, realmlist WHERE account.id NOT IN (SELECT acctid FROM realmcharacters)
2008-08-10 11:29:16 SQL ERROR: Table 'mangos.realmcharacters' doesn't exist
2008-08-10 11:29:39 SQL: UPDATE realmlist SET color = 2 WHERE id = '1'
2008-08-10 11:29:39 SQL ERROR: Table 'mangos.realmlist' doesn't exist
2008-08-10 11:29:39 SQL: UPDATE account SET online = 0 WHERE online > 0 AND id IN (SELECT acctid FROM realmcharacters WHERE realmid = '1')
2008-08-10 11:29:39 SQL ERROR: Table 'mangos.account' doesn't exist
2008-08-10 11:29:39 SQL: UPDATE characters SET online = 0
2008-08-10 11:29:39 SQL ERROR: Table 'mangos.characters' doesn't exist
What wrong?? plz help me friends
tks all
Well... this problem i found the question
but i have another one =S
when i create count and loggin whit him, i can create character...u create normal but u finish, character dont show for u loggin..
(Sry my English, im Brazilian :P)
Plz Help me
tks all
@Dan
not sure if anyone else has responded to you but, I think I see your problem...your realmd.cfg should look something like this:
LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd"
LogsDir = "C:\WowServer\Logs"
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "192.168.0.2"
The BindIP should be set to the internal IP of your server, the IP int he loginDatabaseInfo line should be 127.0.0.1 and should only be changed if you are running MySQL on another machine on your internal network. Your 65.12.178.100 would be the external IP of your cable or DSL modem. This is what the outside world would connect to.
Now...if you do not have a router or other pc's on a network at your house, your client would also be running on the same machine as the server and you'd need to use the 127.0.0.1 for your client. otherwise, if it's another PC on your network, use the internal IP of the PC that your server is runing on. same one that you set your bindIP line to in the realmd.cfg.
hope that helps.
I'm playing around with the UR1 release, but have hit a couple of bumps on the road. Maybe some of you have a similar problem or can direct me to where I made a mistake.
Here's the details:
Fresh installed UR1 and the patch - yep, I saw the creature template issue - nothing unexpected.
When I try to run mangosd and ralmd they just quit without any logs or error messages. - Soo, I think, SSE instruction set is a no go for me, as I have a pretty old dedicated server (AMD Duron!) that I use. So I opted for a recompile of the entire project.
Recompiled using Visual Studio 2005 (VC80).
mangosd is MaNGOS/0.12.0-SVN (Revision 6446) (Win32,little-endian)
realmd is MaNGOS/0.12.0-SVN (Revision 6446) (Win32,little-endian)
MySQL server ver: 5.0.51b-community-nt
I've extracted the maps and dbc myself using the tools from previous releases i.e. I used an older ad.exe with the 2.4.3 database.
When I try to connect from a clean install of the client (fully patched of course), I can't see the realm I created, but login works.
If I change the Config.wtf to include SET realmName "myrealmname" then it tries to connect, but I am thrown back to the select realm which is empty.
The last world.log entries are:
SERVER:
SOCKET: 764
LENGTH: 17
OPCODE: SMSG_REALM_SPLIT (0x038B)
DATA:
FF FF FF FF 00 00 00 00 30 31 2F 30 31 2F 30 31
00
SERVER:
SOCKET: 764
LENGTH: 1
OPCODE: SMSG_CHAR_ENUM (0x003B)
DATA:
00
I do get some DBErrors in the startup process which might point to the problem, hence I am working my way through eliminating some of those too.
My server is separate from my client, but the server runs both the sql and the realmd and mangosd daemons.
My current projected plans are extracting the dbc and maps again, using the latest tools. And recompile realmd and mangosd using VC90.
It'll take a few hours before I get to that point, but if someone could spot an obvious mistake, please hit me with a stick.
Stumpyy
well...i have another problem =(
now, i can run server but, when i try create character (Hunter, rogue, etc), when i finish char, the char dont show me for i loggin in the server, its dont create..
(Sry for my English, Im BRazilian =S )
What solution for this?? =(
Tks all
Extracting the dbc, maps and vmaps did not yeld any difference. Compiling using the vc90 did however show a completely different exe file. Huge size difference.
Everything, including the log files, however give the exact same result.
I can login through Realmd.exe - I can get in contact with mangosd.exe (with set realmname) but am thrown back to realm select, which is blank ...
Could it be that sse is indeed required in some wierd module - and why doesnt that generate an invalid instruction exception. - Perhaps I should try to run the entire thing on a more recent cpu (got a few AMD X2 64).
I'll try to switch environment but keep the database server as a dedicated.
Another update ... /sigh
Tried running Realmd on the server, mysql on the server, mangosd on the client - same result and logfiles
Tried running realmd, mangosd on the client and the mysql on the server - same result and logfiles.
Even tried the original builds running on the client with the mysql being external - exactly the same result (the originals do work on the amd x2 64).
I'm out of ideas. ...
Stumpyy
Just ran update and needed patch, as everyone pointed out. The patch ran ok, but with one error message at the end:
ERROR 1060 (42S21) at line 48: Duplicate column name 'dungeon difficulty'
Hope this helps debugging...
(oh, and had to "CTL C" to exit, LOL)
Is there a chance someone can make a guide? I'm not understanding how to install this release, so used to reading the previous guide but all the steps have changed and what not and now I'm confused.
Yeah, I've got to agree with Bear. So much stuff has changed since the prior releases that a new guide would be helpful. Since extracting all the maps and stuff seems to have changed an updated guide for that would help too.
got the same error as robmacloud, ran the fix and it seemed to be OK, But I have the same issue as Stumpy I can log in but get kicked back to realm select I have the Mangos realm but when I select it it flashes logging into realm and kicks me back out. I did extract my DBs and Maps for my client and all seemd to be well. If I cancel it dumps me to character select with no characters and no button to create character.
@will
Hi, I had the same problem... I fixed it by going to the fresh install folder, opend the arcane fire.bat, chosen option 1 and installed it again, worked for me. hope it works for you to
cheers
Yes, I am figuring it's a problem with the database layout - haven't reached a point where I have anything working yet, but I hope I will get there soon.
My problem is I can't use the prebuild executables, due to my lack of an SSE instruction set. So I am building a new exe file and as a result I am most likely using a different version than what Colt45 made.
No worries though. I'm starting over and trying this again, this time I'm going to make sure the database is not showing any errors and going to make sure that my client is running without any firewall.
I did try one of the "competition" projects, and made it work a little better, though I still didn't get beyond the character create. Just to prove to myself that firewalls shouldn't be the issue. - another 12 hours spend fiddling.
oh, btw! Reaper/Colt45 - great documentation and desciptions, it's easy to work from the instructions for me.
I'll be back later when I've got another one running.
The problem is I wish to keep my accounts and characters a fresh install will wipe them wont it?
yeah, i have the same problem as will.. there are no tables inside "characters", so when i go to create a character, it freaks out and says "CHARACTERS.CHARACTERS DOESN'T EXIST OMG OH NO" and then no characters show up because there's no place to put them. i would appreciate it if someone could post the solution to this in the comments to make it easier for others because i think a lot of other people have been having this problem as well.
Update and HUGE smile :))
MaNGOS/0.12.0-SVN (Revision 6455) (Win32,little-endian)
works now.
I recreated the entire setup, including extraction of maps, dbc and vmaps, as well as recompiling to the latest MaNGOS release available.
I still seem to have the exact same errors in the database sections, but it seems the server is indeed running.
One other small difference - I removed a space from within my realm name - could that be the cause of the initial problem. - it's possible at least. Anyway, up and running, thanks for at least listening to my griefing.
ok, I have about pounded my head off a wall and am posting for help. I had a runnig 2.4.3 three days ago. I went to make it live and did something wrong. Now I get the no characters problem. New at this with new server nothing to lose by wiping and staring over but not sure where everything is kept.
@stumpyy
good to hear,could you pls post link where you could download? Or is there other site where Reaper already realese new revision?
People.... Reaper-X-Support@live.com is a free and helpful email account that you may feel free to ask ANY questiona nd we will respond as quickly as possible!
The release I have created is done through the recompile of the source as described by Reaper-X.
What I did was to install the arcane fire download and the patch supplied, then I downloaded the entire source and recompiled with the SSE flag not set, using the VC 2008 iso installed image.
I then extracted all dbc, maps and created vmaps for the collision detect using the tools from the arcane fire download.
I was forced to do this, due to my server being a little old, Duron 850 Mhz CPU with Windows 2000 Server and 768 MB Memory.
It works very nice. I have an internal LAN ping of 19 and don't seem to have any lag issue. Of course, I am still just playing around, and haven't had any users on-line, just a few testers.
Stumpyy
I uploaded the .dbc files for those who are having problems with it.
http://wowdesktops.com/dbc.zip
I hope this helps.
Hey guys first time user and having some issues at the cmd prompt install of arcane-fire. I tried following the steps per older guides and found some files aren't there like mpqe another thing is when I when run the arcane-fire install part and press (1) and enter it follows the steps and gets to "press any key to install" or something like that but I get "cannot find the specified files" error repeated then another "press any key" with a "let me know if you get any errors" can anyone help the noob???
I just wanted to let everyone know that I am planning on having my first Repack of WotLK Tonight!
Quick question, does anyone have the sql for the Season 4 "Armored Nether Drake"?
Hey guys, uhm i have a problem like 65% of every npc is dead... and wont respawn, and everyone in instances are also dead, so i cant raid or spawn any events or nothing... can someone plz help me?
Okay, I got it installed, got the new maps,dbc, and vmaps copied over, and got mangos started(had to use the fix). I restored my character data and logged in, all my chars were there on the realm, but then when I logged in, the mangos came up with a series of log errors about hte character and DC'd me, when I logged in again, the realm SAID 10 characters, but I can't see any of them, and the mangos server is showing an error log about coding for the characters and then "will no be displayed" next to each and every one of them. I can't even create a new character, it does the same thing. any advice? (i know i'm a little vague, I'm at work right now so I can't look at the server to give exact error, hoping maybe you've seen this and know what I'm talking about)
oh, and get that WotLK up :) I got the beta downloaded and wanna start messing around as a GM. muahaha
Okay so I tried to do this whole update thing and evidently I did a lot wrong. So I am trying to do the fresh install now. For whatever reason my MySQL is going FUBAR on me. No matter what I cannot start the service anymore, i've uninstalled it many times and reinstalled it per the guide. Running Vista64Ultimate and it worked for a few weeks so far until I tried to do this update, any ideas?
Mike
Okay I finally figured out even uninstalled MySQL through Add/Remove programs left some remnants, I just had to delete all SQL related stuff and then reinstall. Works great now, thanks for the new release guys!!
Hey m8tes.
Im having a problem with my Sql files.
it says "error in creature template table, probably
sql file format was updated (there sould be 65 fields in sql"
ps:sorry. i pressed submit comment with some buttom.
@Mixudjinn the bugfix takes care of that, i had same issue.
-
I am having a new issue now, for some reason all computers that connect to my server including the game on the localhost can put in user/pass and game will go through connecting, authenticating, etc but then just hang on Connected. game isn't frozen but when I look at mangosd it doesn't show any activity at all. Is this an issue with the realmd? the mangosd? MySQL? Just to help with troubleshooting I already uninstalled SQL and deleted everything to do with SQL and then reinstalled whole thing, matrix code and all. then just restored my characters.
I will admit this was after I was trying to install the Mangos Front End website thing from their page... since then i've deleted all traces of that mess too. Any help would be greatly appreciated.
what is the bugfix?? :S
i got it fixed with bugfixer. thx
small problem not sure if I'm doing something wrong or if there's a step I overlooked. Installed on a linux machine using wine and using mysql5.0 and I'm connecting to that server from a different machine. Realmd loads everything up correctly Mangosd loads up fine. I opened the ports on the router and linux firewall. realmlist in the game file is set to the server's ip. When I run the game it goes to the realmlist and it shows up but when I click on the MaNGOS realm it goes back to the realmlist screen and I can't get passed it. any ideas?
@sloppy
That sounds very similar to the same issue i'm having. Still doesn't explain why it worked one day and then next it went to what you're experiencing...
im very new to this,thank you very much for the clients.
but i just installed this client and when i start mangosd.exe I get this message:
Check existing of map file './maps/0004331.map': not exist!
Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmap
s'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correc
t the DataDir value in the mangosd.conf file.
I got the VMAPS folder inside the Mangos folder just as the readme says, anyone who can solve the problem?
->nib
Solution:
Move your maps, vmaps, and dbc folders from your wow directory to your Mangos Data directory.
Then, go in your mangos.conf file and find the DataDir = "." and replace it with it's actual location for example:
DataDir = "C:\MaNGOS\Repack-Arcane-Fire\Data"
Yea I did that but didnt work. Now i just moved the folders into the folder with mangosd.exe, and typed DataDir = "." now i works just fine. But something that has irritated me for some time. I don't remember if it's possible to add Training points or loyalty to pets? If anyone knows I would be thankful
The characters info wont load. Looking at it with SQLyog, its completely empty. I try to "Restore from SQL dump" using \Fresh-Installcharacters.sql and SQLyog produces the following error log:
Query:
CREATE TABLE `arena_team` (
`arenateamid` int(10) unsigned NOT NULL default '0',
`name` char(255) NOT NULL,
`captainguid` int(10) unsigned NOT NULL default '0',
`type` tinyint(3) unsigned NOT NULL default '0',
`EmblemStyle` int(10) unsigned NOT NULL default '0',
`EmblemColor` int(10) unsigned NOT NULL default '0',
`BorderStyle` int(10) unsigned NOT NULL default '0',
`BorderColor` int(10) unsigned NOT NULL default '0',
`BackgroundColor` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`arenateamid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Error occured at:2008-08-25 20:06:43
Line no.:34
Error Code: 1005 - Can't create table '.\characters\arena_team.frm' (errno: 121)
Please help.
ok, so i DL'd the updated version of the GMIsland vendors, however, i don't know what to do with the .sql file. if someone can email me to let me know how to do it, i'd be happy. yay.
sereicikas@hotmail.com
hi,
ive got an error wen i start up mangos:
2008-08-26 18:49:58 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-08-26 18:49:58 WORLD: VMap data directory is: data/vmaps
2008-08-26 18:49:58 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-08-26 18:49:58 ERROR:Map file 'data/maps/0004331.map' is non-compatible version (outdated?). Please, create new using ad.exe program.
2008-08-26 18:49:58 ERROR:Correct *.map files not found in path 'data/maps' or *.vmap/*vmdir files in 'data/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
ive tried to run ad.exe again but didnt work.
so, can you fix this??
I am running a server with about 10 people on it, so I really love the AHBot. I recently updated my server to Reaper-X UR1 Arcane-Fire for WoW Client (2.4.3) and it works well. The only problem I seem to have, is that AHBot is no longer filling my AH. I have it set to create 50000 items every hour, but it only seems to generate about 7000 or so, and it's the same exact number every time. I had this number noted somewhere, but can't find it. So I'm wondering, how do I fix this?
I like may others am having problems with ad.exe. This is my first time with MaNGOS. This is WinXP SP 2 with WoW client 2.4.3. I have MySQL running and loaded. I have copied the provided ad.exe program to the WoW installation directory and created a maps directory. When I run ad.exe, I get a Visual C++ debug assertion failed message. The assertion occurs in read.c, line number 144. There are no output files in the maps directory.
I have tried downloading and running the previous version of ad.exe. That version runs to 41% completion, creates 642 output files, and fails.
Where can I get a version of ad.exe that works with WoW client 2.4.3?
Thanks.
Hey I just need help in setting up My scriptdev2 database, because i got the error for the creature_template and i ran the arcane fire UR1 thing and when i get to scriptdev2 database Name it says
scriptdev2
The system cannot find the file specified.
The system cannot find the file specified.
Done
If you see any error message just let me know
press any key to continue . . .
For this having trouble with character creation and missing characters.characters table so this:
Get rid of everything you installed, start afresh. When you uninstall MySQL, make sure you delete the entire program directory AND the MySQL InnoDB Datafiles (located by default in windows C:\MySQL InnoDB Datafiles).
The last bit was getting me.
Hope this helps.
Hey Guys
well where can i start
first of all i still have the error
"Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql)."
still dont have a clie how to fix this and i have tried the bug fix but then i get the error
"'mysql' is not a recognized as an internal or external command, operable program or batch file"
"'mysql' is not a recognized as an internal or external command, operable program or batch file"
"Done"
"If you see any error messages just let me know"
"Press any key to continue . . . "
dont have a clue how to sort that but i then excute it then nothing happens, it goes back to the main screen with 1 arcane fix" and 2 exit.
i actually dont have a clue this time, ive fully updated all map, vmap and dbc files, ive changed the realmd and mangosd conf files for it to find the server but i still have this error.
if anyone can help please reply here or more helpfully email me "g.r.stevenson@talk21.com"
thanks for any help you can provide
ok guys all sorted :D
kind of a noob mistake in the patch at the top it said the whole C:\program files.... thing and it said 5.1 for MySQL and i copied that but my version was 5.0
really silly mistake
thanks anyways guys :D
Draenai female mage seems to be bugged, I get random crashes after creating one. Anyone else had this issue? I was specific because I can duplicate the effect everytime, have not tried diff Draenai class, race, gender combos yet.
hi when i go to run the install batch file and when i type 1 then enter (for the install) its says ERROR:1045 (28000): access denied for user -p@localhost (using password: NO)when it trys to execute the .SQL files. and i really dont want to have to do this the long way. please help.
please help me. i gave it the right mysql password and i know it works cause i can connect to it on navicat. please help THX
I keep getting error when applying patch
ERROR 1050 (42S01) at line 31: Table 'group_instance' already exists
how fix?
I'm getting this when I try and create an Item.
Item (Entry: 50000) not correct (not listed in list of existed items).
Yes I know the item never existed, and when I try .additem 50000 I never get it but if i try and create an existing item, i get it. :(
any help out there?
I'm having an issue with quest scripts, have found 2 quests so far just in Westfall that normally things are supposed to happen during the quest, such as the Defias Traitor thing. Nothing happens however so you can't complete the quest. Any suggestions?
Everytime I go and start mango's it starts ok but then dumps with this error...Any ideas would be helpful
Revision: 6407
Date 4:9:2008. Time 0:1
//=====================================================
*** Hardware ***
Processor: Intel(R) Pentium(R) 4 CPU 2.40GHz
Number Of Processors: 1
Physical Memory: 523280 KB (Available: 69876 KB)
Commit Charge Limit: 1280240 KB
*** Operation System ***
Microsoft Windows Server 2003 Standard Edition (Version 5.2, Build 3790)
//=====================================================
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 0047B4AC 01:0007A4AC C:\WoW\MaNGOS\MaNGOSD.exe
Registers:
EAX:00000000
EBX:0213FFF8
ECX:009C9004
EDX:00000000
ESI:0213FFF8
EDI:00000000
CS:EIP:001B:0047B4AC
SS:ESP:0023:0A7BCAF4 EBP:0A7BCB0C
DS:0023 ES:0023 FS:0038 GS:0000
Flags:00010202
Hi i have a problem when i start Mangos it gives me this :
Using configuration file mangosd.conf.
Reaper-X UR1 Arcane-Fire
Goto http://www.reaper-x.com for more info!
Press to stop.
ARCANE-FIRE
http://www.Reaper-X.com
------------------------------------------
Thanks to the Reaper-X Team:
-Reaper
-Oatman
-Colt45
------------------------------------------
Uses Revs:
-MaNGOS 6399
-SD2 525
-UDB 358
-ACID 18
-AH Bot 79
Arcane-Fire Continue...
World Database: 127.0.0.1;3306;root;mangos;mangos
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.0.56
MySQL server ver: 5.0.67-community-nt
AUTOCOMMIT SUCCESSFULLY SET TO 1
Character Database: 127.0.0.1;3306;root;mangos;characters
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.0.56
MySQL server ver: 5.0.67-community-nt
AUTOCOMMIT SUCCESSFULLY SET TO 1
Login Database: 127.0.0.1;3306;root;mangos;realmd
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.0.56
MySQL server ver: 5.0.67-community-nt
AUTOCOMMIT SUCCESSFULLY SET TO 1
Realm running as realm ID 1
Using UDB 0.10.3 (358) for MaNGOS rev. 6346 with SD2 SQL for rev. 502
Using DataDir C:\Users\Bender\Desktop\Repack Arcane-Fire\Data\
WORLD: VMap support included. LineOfSight:0, getHeight:0
WORLD: VMap data directory is: C:\Users\Bender\Desktop\Repack Arcane-Fire\Data\v
maps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds
Loading MaNGOS strings...
==================================================== 100%
>> Loaded 509 MaNGOS strings
Initialize data stores...
==================================================== 100%
>> Loaded 55 data stores
Using Autodetected DBC Locale (0).
Loading InstanceTemplate
==================================================== 100%
>> Loaded 51 Instance Template definitions
Loading SkillLineAbilityMultiMap Data...
>> Loaded 7025 SkillLineAbility MultiMap
Cleaning up instances...
=SQL: SELECT mapid, resettime FROM instance_reset = 50%
query ERROR: Table 'characters.instance_reset' doesn't exist
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 > Initialized 0 instances
Packing instances...
SQL: INSERT INTO instance_reset VALUES ('409','1935613248')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
= SQL: INSERT INTO instance_reset VALUES ('469','1935613248')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('509','2140544320')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
=============SQL: INSERT INTO instance_reset VALUES ('531','1935613248')
====SQL ERROR: Table 'characters.instance_reset' doesn't exist=
================SQL: INSERT INTO instance_reset VALUES ('532','1935613248')
================== 100%
>> Instance numbers remapped, next instance id is 600
Loading Localization strings...SQL ERROR: Table 'characters.instance_reset' does
n't exist
=SQL: INSERT INTO instance_reset VALUES ('533','1935613248')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('534','1935613248')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('540','1842580800')
=SQL ERROR: Table 'characters.instance_reset' doesn't exist
====================SQL: INSERT INTO instance_reset VALUES ('542','1842580800')=
====SQL ERROR: Table 'characters.instance_reset' doesn't exist=
============SQL: INSERT INTO instance_reset VALUES ('543','1842580800')=
===SQL ERROR: Table 'characters.instance_reset' doesn't exist=
======== 100%
SQL: INSERT INTO instance_reset VALUES ('544','1935613248')>> Loaded 0 MaNGOS lo
cale strings. DB table `mangos_string` contains no localization.
SQL ERROR: Table 'characters.instance_reset' doesn't exist
= SQL: INSERT INTO instance_reset VALUES ('545','1842580800')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('546','1842580800')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('547','1842580800')= 0
=
===SQL ERROR: Table 'characters.instance_reset' doesn't exist=
=====================SQL: INSERT INTO instance_reset VALUES ('548','1935613248')
====SQL ERROR: Table 'characters.instance_reset' doesn't exist=
=====================SQL: INSERT INTO instance_reset VALUES ('550','1935613248')
= 100%
>> Loaded 0 creature locale strings. DB table `locales_creature` is empty.
SQL ERROR: Table 'characters.instance_reset' doesn't exist
=SQL: INSERT INTO instance_reset VALUES ('552','1842580800')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('553','1842580800')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('554','1842580800')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
=======SQL: INSERT INTO instance_reset VALUES ('555','1842580800')=
===SQL ERROR: Table 'characters.instance_reset' doesn't exist=
==========SQL: INSERT INTO instance_reset VALUES ('556','1842580800')=
====SQL ERROR: Table 'characters.instance_reset' doesn't exist==
======================SQL: INSERT INTO instance_reset VALUES ('557','1842580800'
== 100%
>> Loaded 0 gameobject locale strings. DB table `locales_gameobject` is empty.SQ
L ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('558','1842580800')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
=SQL: INSERT INTO instance_reset VALUES ('560','1842580800')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('564','1935613248')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('565','1935613248')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
========SQL: INSERT INTO instance_reset VALUES ('568','2140544320')=
===SQL ERROR: Table 'characters.instance_reset' doesn't exist=
==============SQL: INSERT INTO instance_reset VALUES ('580','1935613248')=
===SQL ERROR: Table 'characters.instance_reset' doesn't exist=
=============SQL: INSERT INTO instance_reset VALUES ('585','1842580800')=
===SQL ERROR: Table 'characters.instance_reset' doesn't exist=
== 100%
>> Loaded 0 Item locale strings. DB table `locales_item` is empty.
SQL: DELETE FROM group_instance USING group_instance LEFT JOIN instance ON group
_instance.instance = instance.id WHERE instance.id IS NULL
SQL ERROR: Table 'characters.group_instance' doesn't exist
==================================================== 100%
>> Loaded 0 Quest locale strings. DB table `locales_quest` is empty.
==================================================== 100%
>> Loaded 0 Quest locale strings. DB table `locales_npc_text` is empty.
==================================================== 100%
>> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.
Loading Page Texts...
==================================================== 100%
>> Loaded 1389 page texts
Loading Game Object Templates...
==================================================== 100%
>> Loaded 13616 game object templates
Loading Spell Chain Data...
==================================================== 100%
>> Loaded 1919 spell chain records
Loading Spell Elixir types...
==================================================== 100%
>> Loaded 98 spell elixir definitions
Loading Spell Learn Skills...
>> Loaded 78 Spell Learn Skills from DBC
Loading Spell Learn Spells...
==================================================== 100%
>> Loaded 14 spell learn spells + 500 found in DBC
Loading Spell Proc Event conditions...
=Spell 33280 listed in `spell_proc_event` does not exist
Spell 35092 listed in `spell_proc_event` does not exist
Spell 35093 listed in `spell_proc_event` does not exist
Spell 35094 listed in `spell_proc_event` does not exist
==================================================== 100%
>> Loaded 959 spell proc event conditions
Loading Aggro Spells Definitions...
==================================================== 100%
>> Loaded 89 aggro generating spells
Loading NPC Texts...
==================================================== 100%
>> Loaded 4357 npc texts
Loading Item Random Enchantments Table...
==================================================== 100%
>> Loaded 28408 Item Enchantment definitions
Loading Items...
==================================================== 100%
>> Loaded 23788 item prototypes
Item (Entry: 8498) not correct 20655 display id, must be 44666 (using it).
Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
Item (Entry: 33808) not correct 47014 display id, must be 51920 (using it).
Item (Entry: 33868) not correct 47131 display id, must be 51758 (using it).
Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
Loading Item Texts...
==================================================== 100%
>> Loaded 0 item pages
Loading Creature Model Based Info Data...
==================================================== 100%
>> Loaded 16891 creature model based info
Loading Equipment templates...
==================================================== 100%
>> Loaded 1874 equipment template
Loading Creature templates...
Error in creature_template table, probably sql file format was updated (there sh
ould be 65 fields in sql).
please see what you can do
Has anyone tried to get this working on an SQL 2005 database?
I got this working using the mysql from an older repack rather than have mysql installed on my PC. I over wrote it with the new database. Now i can run the server off my 250G external hard disk.
A couple of small problems tho.
When i log into the server the realm list is blank unless i go and edit the conf.wtf file in the WOW folder and SETrealmname "MYREAMNAME". I thought that should be picked up dynamically (as it does the SETRealmlist ""). The file is not write protected.
I also had problems getting it to accept users. Three character usernames had the same effect as above, where i couldn't see a realm to log into. Had me scratching my head because i had both problems at the same time and thought it was a connection problem. Is there a lower limit to the length of the username?
Apart from that everything works a treat. Top job guys.
can someone give me a link to a proper working FULL 2.4.3 <> database as im having a lot of errors with it . im using Navicat btw so if u can give me a working batch file will be great
*** for the previous post i need the Character database
I still can't figure out how to extract this, noone STILL hasn't made a guide for this? It would be a great help, the entire process has changed and its confusing =/
I was just wondering.. when I summon a pet with a warlock, he has 245 stamina at level 46, but when you mouse over it, it says Increases Health by 0. All other stats work fine. he has 3k health and 1.9k mana. anyone have any thoughts?
Okay, I'm new to mangos. I'm trying to get this ironed out, but I'm not experienced with MySQL and the navicat download didn't come with the executable file in it.
The guides pointed to are so old that this version has deviated from them almost completely. The first step in the guide is spot on, but from there it's a massive 'wtf'.
I've gotten to setting up the mangos server itself but can't figure it out. So can somebody help me out here? My current file structure is as follows.
C:-
.WoW\
..daemon\
...SQL\
....002_acid_428_mangos.sql
....002_acid_428_scriptdev.sql
....358_corepatch_characters_6241_to_6346.sql
....358_corepatch_mangos_6241_to_6346.sql
....358_updatepack_mangos.sql
....Arcane-Fire.bat
....characters.sql
....create_database_sd2.sql
....create_mysql.sql
....mangos_full_scripts.sql
....mangos_old_spells.sql
....mangos_optional_generic_creature.sql
....Quice.sql
....realmd.sql
....scriptdev2_structure.sql
....UDB_0.10.3_Core_6240_SD2_473.sql
..data\
...maps\
....too many to list
...dbc\
....too many to list
...vmaps\
....too many to list
...buildings\
....too many to list
..SDB\
...the same files that are in the sql folder
.Arcane-Fire.bat
.Char.txt
.DBErrors.txt
.dbghelp.dll
.libeay32.dll
.libmySQL.dll
.mangosd.conf
.MaNGOSD.EXE
.MaNGOSScript.dll
.msvcr71.dll
.realmd.conf
.Realmd.txt
.RealmD.exe
.scriptdev2.exe
.Server.txt
Now, I KNOW that some of those files are in multiple places when they shouldn't be, but I'm reasonably sure that it would still work even with them in multiple places.
If somebody could take the time (and I know it's a lot of time for some, but it only really took me about 5 minutes to type all that out so PLEASE take the time) to type out their file structure just like that for me, I would be very pleased. Also, if somebody could tell me how edit my .conf files to get it pointed where I need it pointed I would be very appreciative.
currently they look like this:
mangosd.conf:
RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "C:\ProgramFiles\MySQL\MySQL Server 5.0\bin;3306;root;*********;realmd"
WorldDatabaseInfo = "C:\ProgramFiles\MySQL\MySQL Server 5.0\bin;3306;root;*********;mangos"
CharacterDatabaseInfo = "C:\ProgramFiles\MySQL\MySQL Server 5.0\bin;3306;root;*********;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"
-----------------------------------------------
realmd.conf:
LoginDatabaseInfo = "C:\Program Files\MySQL\MySQL Server 5.0\bin;3306;root;Lifebl00d;realmd"
LogsDir = ""
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "0.0.0.0"
PidFile = ""
LogLevel = 0
LogTime = 0
LogFile = "Realmd.log"
LogTimestamp = 0
LogFileLevel = 0
LogColors = ""
UseProcessors = 0
ProcessPriority = 1
RealmsStateUpdateDelay = 20
WrongPass.MaxCount = 0
WrongPass.BanTime = 600
WrongPass.BanType = 0
---------------------------------------
It keeps telling me that
Could not connect to MySQL database at {path}: Unknown MySQL server host {path} 11004
cannot connect to database.
If somebody could email me screens of their folders and config files (with passwords blacked out) I would really appreciate it.
AzraeltheWicked@gmail.com
okay, I've got my previous problems figured out after a bit of tinkering. Now I'm having a couple of problems.
when i try to run MaNGOSD.exe I get this (and yes I know that I'm supposed to run the fix so read further)
Loading Creature templates...
Error in creature_template table, probably sql file format was updated (there should be 65 fields in sql).
so I came back here and noted the fix which I then applied and got this:
scriptdev2
'mysql' is not recognized as an internal or external command,
operable program or batch file.
'mysql' is not recognized as an internal or external command,
operable program or batch file.
so I went and checked my SQL folder to find that there isn't a scriptdev2 file. The only scriptdev2 file is scriptdev2.conf in the WoW folder under C:
any assistance would be greatly appreciated.
also found these
>> Loaded 7025 SkillLineAbility MultiMap
Cleaning up instances...
=SQL: SELECT mapid, resettime FROM instance_reset = 50%
query ERROR: Table 'characters.instance_reset' doesn't exist
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 > Initialized 0 instancesSQL: INSERT INTO instance_reset VALUES ('546','1842926
400')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
Packing instances...
SQL: INSERT INTO instance_reset VALUES ('547','1842926400')
SQL ERROR: Table 'characters.instance_reset' doesn't exist=
SQL: INSERT INTO instance_reset VALUES ('548','1935958848')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('550','1935958848')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('552','1842926400')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('553','1842926400')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('554','1842926400')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('555','1842926400')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('556','1842926400')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('557','1842926400')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('558','1842926400')
=======OR: Table 'characters.instance_reset' doesn't exist = 0%
SQL: INSERT INTO instance_reset VALUES ('560','1842926400')
SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('564','1935958848')
SQL ERROR: Table 'characters.instance_reset' doesn't exist=========
SQL: INSERT INTO instance_reset VALUES ('565','1935958848')
=========SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('568','2140889920')
=========SQL ERROR: Table 'characters.instance_reset' doesn't exist
SQL: INSERT INTO instance_reset VALUES ('580','1935958848')=========
SQL ERROR: Table 'characters.instance_reset' doesn't exist
=QL: INSERT INTO instance_reset VALUES ('585','1842926400')========= 100%
SQL ERROR: Table 'characters.instance_reset' doesn't exist
>> Instance numbers remapped, next instance id is 600
SQL: DELETE FROM group_instance USING group_instance LEFT JOIN instance ON group
_instance.instance = instance.id WHERE instance.id IS NULL
SQL ERROR: Table 'characters.group_instance' doesn't exist
Loading Localization strings...
@ AzraeltheWicked
From what i can see of your directory structure, you've installed mangos to your WOW folder. Its probably better to put that folder outside the WOW client so you don't get the two confused.
If you extract everything to C:\ You should have Repack Arcane-Fire directory as the top directory then Data, Extraction Tools, Fresh-Install, Mangos, Quice Tool, and Update directories inside. You have already extracted the Vmaps, Bindings and DBC folders so put them all in the Mangos folder.
Go to Fresh-Install folder and run the Arcane-Fire.bat and choose Installation (option1)
You need to type in the full path to your mysql bin folder as shown in the example it gives you. Even if yours is the same you must type it in. Same with the username and password. If you do this right it will install your database and you will get a DOS box flashing like mad with data.
Then go to the Update folder and run the Arcane-Fire Update. Give the details again in this (same as Install). It also asks for the mangos, character, realmd and ScriptDev2 folders. If you haven't altered the database from the fresh install then type in those names as given, as they are the tables in the database. If successful that should install.
After that, you should be able to start up my sql, mangosd and realmd. You will need to create a user for in game play using the mangosd DOS window. Just type create 'username' 'Password'. Then you just need to point your realmlist in the WOW folder to 127.0.0.1 and play.
@ AzraeltheWicked
I assumed you had created the folders Maps, Vmaps, bindings and DBC. If you haven't you need to create those first. Look in the Extraction Tools folder for instructions to make the Vmpas, maps and Bindings folders.
Unfortunatley, the DBC tools are not included in the reaper pack. You will need to get those off the Mangos web site, under the downloads section.
Just put all those folders you create in the Mangos folder.
actually from what I can tell the ad.exe file created both the maps and the dbc files for me. I've got them both placed properly and they're both filled with files.
I don't exactly understand what I'm looking for or what I need to do, but I've done all of the steps you gave.
I placed all of the stuff in the file structure the way it was when I listed it (removed arcane-fire from the top folder and ran it in the sql folder and got a window full of the 'matrix shit' (I actually lol'd). So far as I can tell I have everything set up alright. Realmd works perfectly. The only problems I have are that, when running the fix it gives me errors when it gets to the scriptdev2 entries it gives me the two mysql errors above, and when running mangosd it gave me the list of errors above. the first large block was from near the top and the second small block was the creature_template error which should be fixed by the fix (except that the fix gives me the two mysql errors).
Okay think i'm figure out why I dont have any scripts for quests, when I load my mangos.exe somewhere it there it says it's trying to connect to the scriptdev2 but then it says
17:07:58
17:07:58 SD2: ScriptDev2 initializing (Revision [530] 2008-07-31) (Win32)
17:07:58
17:07:58 SD2: Using configuration file ScriptDev2.conf
17:07:58 SD2: Using locale 0
17:07:58
17:07:58 Could not connect to MySQL database at localhost: Access denied for use
r 'mangos'@'localhost' (using password: YES)
17:07:58 SD2: Unable to connect to Database
I looked into the scriptdev2.conf file, the user pass port all that seems correct.
Any suggestions?
@ AzraeltheWicked
You could try running the fix from a DOS window. You will need to CD to the directory where the arcanefix.sql's are located. Then enter (substitute username and password for yours):
mysql -u username -p password -v -D mangos < "ArcaneWorldFix.sql"
and
mysql -u username -p password -v -D characters < "ArcaneCharactersFix.sql"
@Tweexter
There are only 2 files that need to be changed for usernames and passwords. Those are mangosd.conf and realmd.conf. Make sure the usernames ans passwords in those files match your database.
If you are sure that they are correct, log on to your DB with the navicat or SQLYog and test the connection with the details you are giving.
Thanks Davey for response I got it working, for some odd reason the username was set to mangos instead of root in scriptdev2.conf
-
Still on the issue of quest scripts not happening though. Starting to really impact the game too, like the level 30 warrior quest to get berzerker stance. You get a quest and when you stand on a grate stuff is supposed to happen but nothing.
WHen I try to create Gm Island vendors it asks what my data base name and all that is, what to I tyoe in?
I just used navicat to install it to the mangos table. haven't checkit yet tho.
@Tweexter
I have only tried a small portion of the game so far. I have lvled a druid to 70 then went to get the aquatic forms and bear forms. On previous releases, and different EMU's, this hasn't worked at all, but it works fine on this version. I've tried Strathome instance and there are some bugs. In Hyjal summit Archimonde isn't there .. you have to spawn him. I gues there will be lots of errors as a go through but hopefully these will be fixed in future updates.
Anyone having a problem where the MOBs don't move along thier normal path, or at all? Anything I'm missing or is this normal?
Thanks again to those of you that make this possilbe!
Hi all love the work been using it for awhile now i did a fresh install of this one everything went fine except when i run the mangosd.exe i get the following
Realm running as realm ID 1
Using UDB 0.10.3 (358) for MaNGOS rev. 6346 with SD2 SQL for rev. 502
Using DataDir data/
WORLD: VMap support included. LineOfSight:0, getHeight:0
WORLD: VMap data directory is: data/vmaps
WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapId
s, vmap.ignoreSpellIds
Check existing of map file 'data/maps/5301243.map': not exist!
Correct *.map files not found in path 'data/maps' or *.vmap/*vmdir files in 'dat
a/vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or
correct the DataDir value in the mangosd.conf file.
here is the part of my config
RealmID = 1
DataDir = "data"
LogsDir = "logs"
LoginDatabaseInfo = "127.0.0.1;3306;root;pass;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;pass;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;pass;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"
not sure why its giving me this error i followed the right steps im sure of it pls help thank you
I think it may be your DataDir. Try typing in the exact path. (I.E. "c:\mangos\data")
I had a similar problem and that fixed it.
just a quick question. when i try to install option 6 of the installer (install the optional gm island vendors) the user name for data base and pasword is the one i use to log on to SQLyog right? also where would my mangos/world database name be?
If you haven't changed anything it will be mangos. The GM island vendors SQL didn't come with the download though. you will need to download it separately. there is a link for it on post 121.
To install it you need to put it in the Arcane-Fire.Bat and rename the file you download to vendors.sql
* same folder as Arcane-Fire.Bat
thanks alot Davey. you are the man! worked like a charm.
Awesome work, guys. I've been running the server for over a month now and toying with the SQL editors attempting to correct minor issues, but there's one that I just can not seem to conquer.
I don't know if it's just my install, but stealth does not seem to work for any race as a rogue. Anyone else having this problem or does anyone know of a solution?
I appreciate your time and thank you for the server! I love it!
Please, someone help me out here, WoW Vendetta does not load anything with SQL batch files into Arcane Fire, if you have a fix to this, please let me know.
ALSO, I cannot find a way to allow the use of the .npc name (name here) command or the subname, is there a way to turn this on, or edit it in the DB and if so, please hit me up!
KillBullGuild@gmail.com
http://img378.imageshack.us/my.php?image=hunterbugoc2. jpg
I guess this can't be solved :P
Whenever you enter combat as Hunter, and the target runs away you shoot with your bare hands (or weapons)
2008-09-21 20:36:57 SQL: UPDATE characters SET online = 0
2008-09-21 20:36:57 SQL ERROR: Table 'characters.characters' doesn't exist
2008-09-21 20:36:57 SQL: SELECT MAX(guid) FROM characters
2008-09-21 20:36:57 query ERROR: Table 'characters.characters' doesn't exist
2008-09-21 20:36:57 SQL: SELECT MAX(id) FROM character_pet
2008-09-21 20:36:57 query ERROR: Table 'characters.character_pet' doesn't exist
2008-09-21 20:36:57 SQL: SELECT MAX(guid) FROM item_instance
2008-09-21 20:36:57 query ERROR: Table 'characters.item_instance' doesn't exist
2008-09-21 20:36:57 SQL: SELECT MAX(id) FROM auctionhouse
2008-09-21 20:36:57 query ERROR: Table 'characters.auctionhouse' doesn't exist
2008-09-21 20:36:57 SQL: SELECT MAX(id) FROM mail
2008-09-21 20:36:57 query ERROR: Table 'characters.mail' doesn't exist
2008-09-21 20:36:57 SQL: SELECT MAX(id) FROM item_text
2008-09-21 20:36:57 query ERROR: Table 'characters.item_text' doesn't exist
2008-09-21 20:36:57 SQL: DELETE FROM character_inventory WHERE item >= '1'
2008-09-21 20:36:57 SQL ERROR: Table 'characters.character_inventory' doesn't exist
2008-09-21 20:36:57 SQL: DELETE FROM mail_items WHERE item_guid >= '1'
2008-09-21 20:36:57 SQL ERROR: Table 'characters.mail_items' doesn't exist
2008-09-21 20:36:57 SQL: SELECT MAX(guid) FROM corpse
2008-09-21 20:36:57 query ERROR: Table 'characters.corpse' doesn't exist
2008-09-21 20:36:57 SQL: DELETE FROM auctionhouse WHERE itemguid >= '1'
2008-09-21 20:36:57 SQL ERROR: Table 'characters.auctionhouse' doesn't exist
2008-09-21 20:36:57 SQL: DELETE FROM guild_bank_item WHERE item_guid >= '1'
2008-09-21 20:36:57 SQL ERROR: Table 'characters.guild_bank_item' doesn't exist
2008-09-21 20:36:57 SQL: DELETE FROM corpse WHERE corpse_type = '0'
2008-09-21 20:36:57 SQL ERROR: Table 'characters.corpse' doesn't exist
2008-09-21 20:36:58 SQL: SELECT id, map, resettime FROM instance WHERE resettime > 0
2008-09-21 20:36:58 query ERROR: Table 'characters.instance' doesn't exist
2008-09-21 20:36:58 SQL: SELECT mapid, resettime FROM instance_reset
2008-09-21 20:36:58 query ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36: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 < '1222043818')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance' doesn't exist
2008-09-21 20:36:58 SQL: DELETE FROM character_instance USING character_instance LEFT JOIN characters ON character_instance.guid = characters.guid WHERE characters.guid IS NULL
2008-09-21 20:36:58 SQL ERROR: Table 'characters.character_instance' doesn't exist
2008-09-21 20:36: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-09-21 20:36:58 SQL ERROR: Table 'characters.group_instance' doesn't exist
2008-09-21 20:36: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-09-21 20:36:58 SQL ERROR: Table 'characters.instance' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('249','1222488000')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('269','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('309','1222315200')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: SELECT id FROM instance
2008-09-21 20:36:58 query ERROR: Table 'characters.instance' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('409','1222660800')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('469','1222660800')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('509','1222315200')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('531','1222660800')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('532','1222660800')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('533','1222660800')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('534','1222660800')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('540','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('542','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('543','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('544','1222660800')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('545','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('546','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: SELECT id FROM instance
2008-09-21 20:36:58 query ERROR: Table 'characters.instance' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('547','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('548','1222660800')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('550','1222660800')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('552','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('553','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('554','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('555','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('556','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('557','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('558','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('560','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('564','1222660800')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('565','1222660800')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('568','1222315200')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('580','1222660800')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: INSERT INTO instance_reset VALUES ('585','1222142400')
2008-09-21 20:36:58 SQL ERROR: Table 'characters.instance_reset' doesn't exist
2008-09-21 20:36:58 SQL: DELETE FROM character_instance USING character_instance LEFT JOIN instance ON character_instance.instance = instance.id WHERE instance.id IS NULL
2008-09-21 20:36:58 SQL ERROR: Table 'characters.character_instance' doesn't exist
2008-09-21 20:36:58 SQL: DELETE FROM group_instance USING group_instance LEFT JOIN instance ON group_instance.instance = instance.id WHERE instance.id IS NULL
2008-09-21 20:36:58 SQL ERROR: Table 'characters.group_instance' doesn't exist
2008-09-21 20:37:47 Item (Entry: 8498) not correct 20655 display id, must be 44666 (using it).
2008-09-21 20:37:47 Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it).
2008-09-21 20:37:47 Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it).
2008-09-21 20:37:47 Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it).
2008-09-21 20:37:47 Item (Entry: 33808) not correct 47014 display id, must be 51920 (using it).
2008-09-21 20:37:47 Item (Entry: 33868) not correct 47131 display id, must be 51758 (using it).
2008-09-21 20:37:47 Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it).
2008-09-21 20:37:47 SQL: SELECT id, text FROM item_text
2008-09-21 20:37:47 query ERROR: Table 'characters.item_text' doesn't exist
2008-09-21 20:37:58 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-09-21 20:37:59 SQL: SELECT MAX(id) FROM character_pet
2008-09-21 20:37:59 query ERROR: Table 'characters.character_pet' doesn't exist
2008-09-21 20:37:59 SQL: SELECT position_x, position_y, position_z, orientation, map, data, time, corpse_type, instance, guid FROM corpse WHERE corpse_type 0
2008-09-21 20:37:59 query ERROR: Table 'characters.corpse' doesn't exist
2008-09-21 20:38:04 SQL: SELECT itemguid,item_template FROM auctionhouse
2008-09-21 20:38:04 query ERROR: Table 'characters.auctionhouse' doesn't exist
2008-09-21 20:38:04 SQL: SELECT COUNT(*) FROM auctionhouse
2008-09-21 20:38:04 query ERROR: Table 'characters.auctionhouse' doesn't exist
2008-09-21 20:38:04 SQL: SELECT guildid FROM guild
2008-09-21 20:38:04 query ERROR: Table 'characters.guild' doesn't exist
2008-09-21 20:38:04 SQL: SELECT arenateamid FROM arena_team
2008-09-21 20:38:04 query ERROR: Table 'characters.arena_team' doesn't exist
2008-09-21 20:38:04 SQL: SELECT mainTank, mainAssistant, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, isRaid, difficulty, leaderGuid FROM groups
2008-09-21 20:38:04 query ERROR: Table 'characters.groups' doesn't exist
2008-09-21 20:38:04 SQL: SELECT id,messageType,sender,receiver,itemTextId,has_items,expire_time,cod,checked,mailTemplateId FROM mail WHERE expire_time < '1222043884'
2008-09-21 20:38:04 query ERROR: Table 'characters.mail' doesn't exist
2008-09-21 20:38:04 SQL: DELETE FROM mail WHERE expire_time < '1222043884' AND has_items = '0' AND itemTextId = 0
2008-09-21 20:38:04 SQL ERROR: Table 'characters.mail' doesn't exist
2008-09-21 20:38:05 SQL: SELECT MAX(id) FROM instance
2008-09-21 20:38:05 query ERROR: Table 'characters.instance' doesn't exist
2008-09-21 20:38:05 SQL: SELECT MAX(time) FROM character_queststatus_daily
2008-09-21 20:38:05 query ERROR: Table 'characters.character_queststatus_daily' doesn't exist
Haveing this problem somebody help plz....
Any plans to update this and add a guide anytime soon? I tried to use this to update from Mangos 6245 and lost all of my character data, so a guide would be very helpful. Thanks
Hello everyone. I 'd like to say 'good work!' but I can't just yet.
I have tried everything to install this particular version but failed everytime, the mangosd.exe results in error:
I have tried updating my existing installation (6245) to this one with the reaper-arcane pack, no luck, tried again with the navicat pack, still no luck.
tried fresh install with both, nothing.
Then tried removing mysql 5.0 and installed from scratch with mysql 5.1. Then retried everything with the arcane file pack, still nothing.
Mangosd.exe complains that the table Characters.characters does not exist, which is silly really. I must say i am a little dissappointed. I can go back to the old version of course, i still have my databases packed away but have to re-extract data from 2.4.2 WoW.
Guys a guide is necessary i m sorry to say. I know ur doing 10000 projects at the same time, but when u post and give guidelines u have to check ur pointing at the right direction. For example the bat file in the navicat pack does not exist. Then u say we have to apply updates but ur very foggy as how to do it. I tried what seemed logical but i have no way of knowing if m doing it right.
U are publishing something so my point is u should publish it right. Not in a hurry to satisfy the more experiences users who will probably compile mangos themselves anyway.
I ve tried a lot of reapex-x versions and have some experience in solving the little problems as how to put the server online, or the ones with the realm loop, etc. My type of user can help the really beginner type user. But we are left a little in the dark here.
Hope u can have a break and look into this.
Thanks
is there any word on the next release its been almost 2 months
@Davey Baby | Sep 8, 2008 at 22:40 / 10:40 PM
so u mean that u must first do fresh install and then update? Whats the point ? If u update does it not mean that u already have 6245 version and u want to update to arcane fire? At least I get confirmation for it from the messages inside the bat file.
The version of mysql doesn't seem to make a difference. I got this working with a mysql dump in a much earlier repack and just overwrote the data.
All you need to do is make sure your mysql is running, then run the install using Arcane-fire.bat from the fresh install folder. Then run the Arcane fire UR1 ~fix~.bat. Do you get any errors when you run either of these?
The rest is the same as any install. ie create the maps etc and put them in the mangos folder.
By the way .. its a Fresh install, and you are applying a fix not an update. The fix corrects errors in the database you are installing.
@Davey Baby | Oct 1, 2008 at 15:51 / 3:51 PM
I have tried to do a fix after the fresh install. It still complains about not finding certain tables (i think characters.characters again). The fresh install itself of course does not complain (i doupt it checks anything beyond the basics - path, etc)
I would really like someone who has completed this intall to let me know exactly how he did it, all the steps (after the maps, vmaps & dbc extratction).
I wonder if it is something to do with your user autorities in your database. If you use Navicat to look at the database after you have created it, then go to MANAGE USERS and make sure your profile has all authority to the database. Then try the fix again.
Have you tried running the fix from a DOS window. You will need to CD to the directory where the arcanefix.sql's are located. Then enter (substitute username and password for yours):
mysql -u username -p password -v -D mangos < "ArcaneWorldFix.sql"
and
mysql -u username -p password -v -D characters < "ArcaneCharactersFix.sql"
@Davey Baby | Oct 2, 2008 at 22:26 / 10:26 PM
I don't understand what difference that will make but i will and tell u the outcome
@Davey Baby | Oct 2, 2008 at 22:26 / 10:26 PM
I have tried ur suggestion after a fresh install and discovered that my password after the -p option was interpreted by the mysql server as the database name, so instead i tried
mysql -u username -p -v -D mangos < "ArcaneWorldFix.sql" which resulted in the server asking me for the password.
Did the same with the second command and the fix was completed with no errors.
After that i was finally able to launch realmd and mangosd, with only minor errors (something about wrong display ids) which were handled by the mangos exe with no other issues.
I was able to log in fine.
I will try again the update procedure, applying the fix after a succesfull update and will post the outcome.
IT SEEMS MY PROBLEM WAS IN THE FIX BAT FILE! APPARENTLY THE COMMANDS ISSUED WERE NOT CORRECTLY INTERPRETED BY MY SYSTEM.
So everyone having similar issues take that into consideration.
Thanks Davey you helped me out!
update does not work at all i m afraid.. so i have lost my chars .. again..
Character copying? I have seen and downloaded copycat and it's web equivalent which seems to download my character files from the wowarmory to pdump files which supposedly Reaper Mangos can import, however when I try to do exactly that I get it apparently failing with an error "SQL ERROR: Data truncated for column 'orientation' at row 1" and it doesn't seem to have imported as much data as what is in the pdump file. Not to mention the toons are still not available in an account on my Reaper Mangos server. Is there equivalent Character Copy you have here Reaper, or is there a way I can mod the other Mangos version to achieve a result. I am wanting to essentially replicate some Live WOW guilds of ours for RAID strategy testing.
Hi everyone. I've been having a world of problems trying to get this (and any) release to work. But I finally did it... The following guide is a bit of an
overkill, but it works.
So this is MY guide for you :)
-----------------------------------------------
Get the following files.
1) MySQL Server 5.0
-Get the free edition.
-Install it as per instructions elsewhere.
-If you need help with this let me know and I'll throw a quick guide together.
2) SQLyog - Community edition
-Install it
3) TortoiseSVN (http://tortoisesvn.tigris.org/)
-Install (get it from the download page)
-Create a folder called "Sources"
-In "Sources" create folder "MaNGOS"
-Right click the "MaNGOS folder and from the menu select "SVN checkout..."
-paste "https://mangos.svn.sourceforge.net/svnroot/mangos/trunk" in the top box. (URL repository)
-Click "OK"
That will download the newest release of MaNGOS (this will be needed later)
4) Get Full Arcane-Fire Download and the Fix (top of this web page)
-Extract "Repack Arcane-Fire.exe"
-Edit "realmd.conf" as follows:
LoginDatabaseInfo = "127.0.0.1;3306;yourusername;yourpassowrd;realmd"
For example, mine is:
LoginDatabaseInfo = "127.0.0.1;3306;root;Str4ng3l0ve;realmd"
-Edit "mangosd.conf" as follows:
At this line:
DataDir = "."
Change it to:
DataDir = "wherever the arcane-fire data folder is"
For example, mine is:
DataDir = "C:\Documents and Settings\blackmagic\Desktop\Downloads\Repack Arcane-Fire\Data"
Also, change the folowing to reflect your user/password setup:(mine is an example)
LoginDatabaseInfo = "127.0.0.1;3306;root;Str4ng3l0ve;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;Str4ng3l0ve;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;Str4ng3l0ve;characters"
5) Get the vender island pack ("GM Island Vendors Full made by Firane and modified by weiss935.sql")
-See post 121
-rename it to "GM vendors.sql"
Ok... That's it for the files needed and the basic setup. Now the meat and potatos :)
Step 1 - Getting the Map and DBC's
-Put the ad.exe file from the "Repack Arcane-Fire\Extraction Tools\DBC's & Maps" folder and put it in the "C:\Program Files\World of Warcraft" folder.
-Run ad.exe
-Have a coffee...
-Put the resulting folders "dbc" and "maps" in the data folder of the arcane-fire folder:
C:\Documents and Settings\blackmagic\Desktop\Downloads\Repack Arcane-Fire\Data
Step 2 - Modifying the "Arcane-Fire.bat" file
******I want to thank the origional authors of this repack for an excellent job well done. However...*******
-Right click "Arcane-Fire.bat" and select edit.
-Erase everything.
-Copy the following modifications and paste it.
(This assumes you are using MySQL Server 5.0 in the default installation location. Change the path accordingly)
copy everything between the dashed lines:
---------------------
@echo off
:start1
set mysqlpath="C:\Program Files\MySQL\MySQL Server 5.0\bin"
set upw=mangos
path=%mysqlpath%;%systemroot%;%systemroot%\system32
goto menu
:menu
cls
echo Choose your destination :
echo [ FRESH INSTALL]
echo [ 1 ] Installation
echo [ 8 ] Exit
echo.
set /p choice=
if %choice%==1 goto freshinstall
if %choice%==8 goto leave
echo %choice% is incorrect
echo.
pause>nul
goto menu
:freshinstall
cls
echo.
echo What is your MySQL database USERNAME ? (Most likely "root")
echo.
set /p mangosusr=
echo What is your database PASSWORD ?
echo.
set /p mangospw=
echo.
echo Your databases will be set to default in this release!!!
echo (example: MaNGOS Database will be named MaNGOS)
echo.
echo PRESS ANY KEY TO INSTALL
pause>nul
set myoption=-v
mysql -u%mangosusr% -p%mangospw% %myoption% < "create_mysql.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% < "create_database_sd2.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D RealmD < "realmd.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D Characters < "characters.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D ScriptDev2 < "scriptdev2_structure.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "UDB_0.10.3_Core_6240_SD2_473.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D Characters < "358_corepatch_characters_6241_to_6346.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "358_corepatch_mangos_6241_to_6346.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "358_updatepack_mangos.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "mangos_full_scripts.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "mangos_optional_generic_creature.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "mangos_old_spells.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "002_acid_428_mangos.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D ScriptDev2 < "002_acid_428_scriptdev.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "Quice.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "ArcaneWorldFix.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D Characters < "ArcaneCharactersFix.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS nul
echo.
echo.
echo Done
echo.
echo If you see any error message just let me know
echo.
pause
exit
-----------------------------
-save and exit
Step 3 - Moving Files Around
-Extract "ArcaneFireUR1 FIX.zip"
-Put all the files in the "Fresh-Install" folder
-Put the "GM vendors.sql" file in the "Fresh-Install" folder
Step 4 - Installing the Databases
-Open "Arcane-Fire.bat"
-Press 1
-Put in the user name and password
-Have another coffee :)
Step 5 - Fixing a problem BEFORE you encounter it ;)
-Here is a problem many of you have been having. You can't create a character. This will solve the problem.
-Open "SQLyog" that you installed earlier.
-Make sure that the "MySQL host address" is "localhost"
-User name is "root" or whatever you have been using
-Password, again, whatever you have been using
-Port is "3306"
-Hit Connect
-On the left hand side it shows "root@localhost"
-right click "characters"
-select "Restore from SQL dump..."
-Where it says "File to execute" go to the folder that you downloaded the MaNGOS source code to and select the "characters.sql" file
-Mine was: "C:\sources\MaNGOS\sql\characters.sql"
-Hit "Execute"
-Now you can close SQLyog
Step 6 - Hoping to the almighty that it works
-From the MaNGOS folder run "RealmD.exe"
-If it runs ok continue on...
-Now run "MaNGOSD.exe"
-There may be a few errors, but don't let that bother you right now...
-At the "mangos>" prompt type the following and hit enter after each line:
create 3 3
setgm 3 3
setbc 3 1
-Now you have a gm account called "3" with a password "3"
-Start WOW and use "3" for account and "3" for password
-Create a character and play.
I believe that this should work for most of you. Good luck.
I need to fix a booboo...
Step 2 - Modifying the "Arcane-Fire.bat" file
******I want to thank the origional authors of this repack for an excellent job well done. However...*******
-Right click "Arcane-Fire.bat" and select edit.
-Erase everything.
-Copy the following modifications and paste it.
(This assumes you are using MySQL Server 5.0 in the default installation location. Change the path accordingly)
copy everything between the dashed lines:
---------------------
@echo off
:start1
set mysqlpath="C:\Program Files\MySQL\MySQL Server 5.0\bin"
set upw=mangos
path=%mysqlpath%;%systemroot%;%systemroot%\system32
goto menu
:menu
cls
echo Choose your destination :
echo [ FRESH INSTALL]
echo [ 1 ] Installation
echo [ 8 ] Exit
echo.
set /p choice=
if %choice%==1 goto freshinstall
if %choice%==8 goto leave
echo %choice% is incorrect
echo.
pause>nul
goto menu
:freshinstall
cls
echo.
echo What is your MySQL database USERNAME ? (Most likely "root")
echo.
set /p mangosusr=
echo What is your database PASSWORD ?
echo.
set /p mangospw=
echo.
echo Your databases will be set to default in this release!!!
echo (example: MaNGOS Database will be named MaNGOS)
echo.
echo PRESS ANY KEY TO INSTALL
pause>nul
set myoption=-v
mysql -u%mangosusr% -p%mangospw% %myoption% < "create_mysql.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% < "create_database_sd2.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D RealmD < "realmd.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D Characters < "characters.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D ScriptDev2 < "scriptdev2_structure.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "UDB_0.10.3_Core_6240_SD2_473.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D Characters < "358_corepatch_characters_6241_to_6346.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "358_corepatch_mangos_6241_to_6346.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "358_updatepack_mangos.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "mangos_full_scripts.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "mangos_optional_generic_creature.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "mangos_old_spells.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "002_acid_428_mangos.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D ScriptDev2 < "002_acid_428_scriptdev.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "Quice.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "ArcaneWorldFix.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D Characters < "ArcaneCharactersFix.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS nul
echo.
echo.
echo Done
echo.
echo If you see any error message just let me know
echo.
pause
exit
-----------------------------
-save and exit
Whoever the moderator is, feel free to remove post 303. For some reason I wasn't able to paste the following lines properly:
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "ArcaneWorldFix.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D Characters < "ArcaneCharactersFix.sql"
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "GM vendors.sql"
Hmmm... I realize that my last post was not clear. The Arcane-fire.bat file that I first posted had an error. The last "mysql" line was wrong. Please change it to read:
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "GM vendors.sql"
Any questions?
is there a way to make the server a free for all pvp server? I want to make it so horde can kill other horde and alliance can kill other alliance members.
is there a way to make the server a free for all pvp server? I want to make it so horde can kill other horde and alliance can kill other alliance members.
I hope Colt, or Oatman release Arcane-Fire 2 soon.
Anyone getting this error?
2008-10-10 20:33:41 Using DataDir ./
2008-10-10 20:33:41 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-10-10 20:33:41 WORLD: VMap data directory is: ./vmaps
2008-10-10 20:33:41 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-10-10 20:33:41 ERROR:Check existing of map file './maps/0004331.map': not exist!
2008-10-10 20:33:41 ERROR:Correct *.map files not found in path './maps' or *.vmap/*vmdir files in './vmaps'. Please place *.map/*.vmap/*.vmdir files in appropriate directories or correct the DataDir value in the mangosd.conf file.
Is Kalecgos bugged for any one else. The Portals wont spwan for me. Any one got a fix?
Exept for that an awsom reles :)
I believe that you have misplaced your map files.
If you follow my guide above (post 304 and 307) it will work.
Your maps and dbc folder should be in the data folder within the arcane-fire directory.
I reread my post and I realized that I made a booboo...
To fix the missing MAP files do the following:
-Edit "mangosd.conf" as follows:
At this line:
DataDir = "."
Change it to:
DataDir = "wherever the arcane-fire data folder is"
For example, mine is:
DataDir = "C:\Documents and Settings\blackmagic\Desktop\Downloads\Repack Arcane-Fire\Data"
Save the file and exit.
Now run Mangosd.exe again.
Hi duddadu,
I did that and it didnt work, not at my computer atm but will try your guide when I get chance.
Any other ideas?
Cheers
Jason
OK got the maps thing sorted but for some reason I cannot add new items like the legendary bow from KJ also KJ doesnt spawn.
also can not add the new t6 gear but can loot it??
Any ideas guys??
Thanks
Jase
oh 1 more thing the vendors on GM island havnt spawned i copied your guide duddadu but i dnt think I did it right :S
Cheers
Jase
I did a complete wipe of MaNGOS on my system and followed my guide to put everything back. For me, everything worked...
The important line for adding the vendors is:
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "GM vendors.sql"
you need to make sure that you renamed the file:
GM Island Vendors Full made by Firane and modified by weiss935.sql
to
GM vendors.sql
Then make sure that the mangosd.conf has the following line:
mysql -u%mangosusr% -p%mangospw% %myoption% -D MaNGOS < "GM vendors.sql"
Again, see the above posts :)
Hello, again.
Anyone else at all having issues with stealth not working? :)
I'm assuming that the great lack of response to my last post means "no". If so, do the minds at this sight recommend a fresh install?
I like may others am having problems with ad.exe. This is my first time with MaNGOS. This is WinXP SP 2 with WoW client 2.4.3. I have MySQL running and loaded. I have copied the provided ad.exe program to the WoW installation directory and created a maps directory. When I run ad.exe, I get a Visual C++ debug assertion failed message. The assertion occurs in read.c, line number 144. There are no output files in the maps directory.
I have tried downloading and running the previous version of ad.exe. That version runs to 41% completion, creates 642 output files, and fails.
Where can I get a version of ad.exe that works with WoW client 2.4.3?
Thanks.
Never mind I fixed it... >,<
Well now that Wow 3.0.2 is out .... I'll have to wait till someone finds a way to emulate the new server setup... sigh...
Hey! Does any1 know if the arena works ?? Or Do u still get stuck in the middle of the sky ??
Plz reply asap !! :D
Great server, everything working tip top. Just curious if anyone's found a Vista Gadget that would keep track of how many people are on your server or maybe other features too. I'm okay with HTML but Javascript I never got around to learning so gadget building isn't on my resume.. lol
hey reaper do u kno if there will b a release for 3.0.2 since thay did sumthing to make it where u cant change the realm list or that if like me u have 2 WoW files that way u can update 1 and not the other this new patch updates both
Have you tried editing the realmlist.wtf file in Your_WOW_Directory\data\enUS (or replace enUS with your WoW version) because the realmlist.wtf got moved there :)
as for 3.0.2 mangos tecms25 (from forums) have released it (although there's no automatic method to import it, and he said that it's unstable *i haven't tested it yet) :)
http://forums.reaper-x.com/topic/new-mangos-for-302-patch
Will next reaper - X be MAngos or Trinity Based ?
page failed to load when i posted this the first time, so this one is shorter in detail:
running 6245 - everythign ran fine, but no ahbot.
upgraded to ArcaneFireReaper, added fix - everything broke
backed up characters (using reaper.bat) and uninstalled everything, reinstalled, added fix, restored characters, everything still broke.
uninstalled everything, backed up nothing, done completely clean install, added fix, everything still broke.
Mangosd.exe is crashing now. Before it was just errors in mangos, now it's completely crashing:
Revision: 6407
Date 27:10:2008. Time 22:46
//=====================================================
*** Hardware ***
Processor: AMD Sempron(tm) Processor LE-1100
Number Of Processors: 1
Physical Memory: 2063536 KB (Available: 1488588 KB)
Commit Charge Limit: 4002316 KB
*** Operation System ***
Microsoft Windows XP Professional Service Pack 3 (Version 5.1, Build 2600)
//=====================================================
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 0047B4AC 01:0007A4AC C:\mangos\MaNGOSD.exe
Registers:
EAX:00000000
EBX:021406E0
ECX:009C9004
EDX:00000000
ESI:021406E0
EDI:0012C510
CS:EIP:001B:0047B4AC
SS:ESP:0023:0B08CAF0 EBP:0B08CB08
DS:0023 ES:0023 FS:003B GS:0000
Flags:00010206
Well, Its running now. Slightly shakey. The first character I made on it, now can not do anything clickable. I can run and jump but spells and items, it just says "Interrupted" on the screen.
I made a second character, and it is working fine. Im just going to leave the dummy character there (was for AHBOT) and see how this rolls. When the next release comes out, I'll just likely backup characters and do fresh install again.
Thanks Oatman, Reaper, Colt45 for the hard work!
Ok,
It works about... 30% of the time, I just finished turning on lvl 3 logging of EVERYTHING so maybe i can find some more detail as to why. But what's happening is that after you log in, it takes you to the character screen. There's a 75% chance, it just sits at "retrieving character list". If you make that 25% and get in, you're good.
If you're making a character, it works first time every shot. You make the character, and hit OK. It says it saves, it even shows in my MANGOSD screen:
Character : soandsoname stats at time of save:
INT:
STR:
blah blah blah and so on. But it refreshes the wow screen and takes you to retrieving character list again. Sometimes it works, sometimes it sticks you there. If you get stuck, it will not even show your character in the CHARACTERS database CHARACTERS table.
2 things:
A) The RealmD database, Realmlist table, the last option is Population. When you get stuck, it saves that entry as 0.1 : Sometimes, it may or may not be connected, but closing the mangosd and realmd applications and manually setting that back to 0 and restarting the two applications has granted atleast good luck at getting it to work right.
B) If that doesn't work, its restart RealmD and MangosD again, and again, until I am able to connect.
Mind you from my above 2 posts, this is a clean install (3x). Im using SQL 5.0 community edition. XP Pro SP3. 2Gigs of DDR2 PC4200, 2.28Ghz Proc. I don't recall the MB and such from here, I'm at work.
I'm going to host the log's here soon through a text file hosting provider, and after a couple days of the error logs building up, maybe there will be some usefull information.
Everything loaded ok...and i used the Arcane Fix program....but when i loaded everything up....i have no creatures or NPC's in most Area's....any idea's why?
i'm still getting the 0004331.map error, out of date
modified the .conf files
could it be something to do with the version of wow
i have 2.4.3 (8606) installed ....?
and i've installed UR1 Arcane fire...
any help would be good
Reaper, is there a command to lengthen spawntime for the entire game or a given area? I am tired of battling to the objective only to have to battle the entire way back to town. Is there a spawntime column in the data model somewhere that I can just modify to suit my purpose? Thanks in advance, Mac
Please, someone know how to enable arenas and BG to work...?
Thanxs!!
why do i keep getting dc when i logg in? it worked before for me to play but now it doesnt after i tried to make public but took it away.. help?
Any idea when a new, updated x-pack will be prepared? Also, would it be possible to teach us how to set up our server with the single player game mode that has been created on the Mangos website?
HELP ME I GET PROBLEM ALWAYS PLS HELP:
ERROR IS:
Error in creature_template table, probably sql file format was updated (there should be 63 fields in sql).
FTW !
Firstly, Id like to thank the team for the work they have done so far, you guys are great!
Secondly, when will there be a new x-pack available?
Thirdly, some/small advice, for those who travel alot or move the thier servers allot, useing microsoft virtual pc(or any other) is verry usefull for the mangos server, especially when going to lans
User revs:
-MaNGOS 6399
-SD2 525
-UDB 358
-ACID 18
-AH Bot 79
Arcane-Fire Continue...
World Database: 127.0.0.1;3306;root;mangos;mangos
Could not connect to MySQL database at 127.0.0.1: Acess denied for user 'root'@'localhost'
Cannot connect to world database 127.0.0.1;3306;root:mangos;mangos
Help please?
It should be
World Database: 127.0.0.1;3306;root;yourpassword;mangos
If mangos is your password, though, I'm stumped.
After we defined our scope and formulated exclusions, we have to describe applicable QMS processes per ISO 9001 Standard. This task is quite simple. We just need to transform the standard from a set of requirements into your company’s commitment to satisfy those requirements with the appropriate level of details. It also may be a good idea to include in your quality manual a table of contents, company information, procedure index, manual-standard corresponding table and others. We will discuss these elements later in the book.
Very nice site!