Custom Search
Reaper-X UR1 Arcane-Fire for WoW Client (2.4.3)
Posted by Colt45 Aug 1 2008 1:48 pm
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!!!
Leave a response
Connect with me
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 . . .
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.
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?
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??
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
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.
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
->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”
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?
@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…
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?
i got it fixed with bugfixer. thx
what is the bugfix?? :S
@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.
sql file format was updated (there sould be 65 fields in sql”
ps:sorry. i pressed submit comment with some buttom.
Hey m8tes.
Im having a problem with my Sql files.
it says “error in creature template table, probably
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!!
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
oh, and get that WotLK up :) I got the beta downloaded and wanna start messing around as a GM. muahaha
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)
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?
Quick question, does anyone have the sql for the Season 4 “Armored Nether Drake”?
I just wanted to let everyone know that I am planning on having my first Repack of WotLK Tonight!
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 uploaded the .dbc files for those who are having problems with it.
http://wowdesktops.com/dbc.zip
I hope this helps.
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
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!
@stumpyy
good to hear,could you pls post link where you could download? Or is there other site where Reaper already realese new revision?
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.
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.
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.
The problem is I wish to keep my accounts and characters a fresh install will wipe them wont it?
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.
@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
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.
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.
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.
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)
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
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.
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
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 (0×038B)
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 (0×003B)
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
@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.
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
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
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”
@Q_bert,,,
tnqx my friend…
^^
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.
um, my Heroic dungeons are empty… What can I do about this?
keep up the good work (Y)
But can some1 tell me where how can i have working areas and BG on my Lan server…I have internetcaffe…….