Arcane-Fire UR1 MaNGOS (2.4.3)

1. 

   Colt45 said Jul 28, 2008 at 11:35 am

   

   I have removed the links until I can create a stable version, thanks to everyone (Bigger thanx to Summonence who worked harder to try and fix the error) who tried to help!

   Link to this comment Reply to this comment

   
   
2. 

   Fate said Jul 28, 2008 at 11:17 am

   

   @SccS
   Patch works perfect for broken “data” field in characters table.

   TO ALL WITH CHARACTERS ISSUES, SEE COMMENT 132 by SccS. This resolves the data issues.
   For other issues, make sure you’re using the correct columns (see posts related to dungeon_difficulty.

   -Fate

   Link to this comment Reply to this comment

   
   
3. 

   Xestrix said Jul 28, 2008 at 10:19 am

   

   rror in creature_template table, probably sql file format was updated (there should be 64 “fields in sql).”

   I received this error after updating to UR1 from the last Reaper-X release :/ Any ideas?

   Link to this comment Reply to this comment

   
   
4. 

   mhs2011 said Jul 28, 2008 at 10:04 am

   

   Very nice job Colt.
   I can’t wait to install it tomorrow.
   i hope it doesnt overwrite my database again. lol.
   if it does, oh well, cuz ill have EVERYTHING backed up!
   Thanks again, great job!

   Link to this comment Reply to this comment

   
   
5. 

   SccS said Jul 28, 2008 at 9:43 am

   

   or this link if the one in my previous post stops working.

   http://rapidshare.com/files/132972438/combined_fix.rar

   Link to this comment Reply to this comment

   
   
6. 

   SccS said Jul 28, 2008 at 9:40 am

   

   @ meows

   try this one m8 its a combined fix from all the above this is what worked for me. all old chars now fully functional.
   http://rapidshare.com/files/132972105/combined_fix.rar.html

   Link to this comment Reply to this comment

   
   
7. 

   SccS said Jul 28, 2008 at 9:31 am

   

   the 6360_characters_characters.sql in the zip IntErlOpr uploaded here Http://rs29.rapidshare.com/files/132771897/sqlfix.zip

   will fix it,

   Link to this comment Reply to this comment

   
   
8. 

   SccS said Jul 28, 2008 at 9:30 am

   

   IntErlOpr | Jul 27, 2008 at 17:19 / 5:19 PM | Links to this comments | Reply

   I beg to differ Summonence, Rikiller that’s what I was referring to in my above post. The 6360_characters_characters.sql in the zip I uploaded fixes the old characters.

   this is correct i applied the fix and still the same, then i ran the 6360_characters_characters.sql and now all working fine phew……

   thanks IntErlOpr

   Link to this comment Reply to this comment

   
   
9. 

   meows said Jul 28, 2008 at 8:03 am

   

   Well I am having the same character issue! =/

   Can someone please post the exact steps to getting the characters to show up again I can make a new one but it says the names are in use Here is a copy of my errors

   CMSG_REALM_SPLIT
   Loading char guid 2 from account 5.
   ERROR: Player #2 have broken data in `data` field. Can’t be loaded.
   Loading char guid 9 from account 5.
   ERROR: Player #9 have broken data in `data` field. Can’t be loaded.
   Loading char guid 21 from account 5.
   ERROR: Player #21 have broken data in `data` field. Can’t be loaded.
   Loading char guid 33 from account 5.
   ERROR: Player #33 have broken data in `data` field. Can’t be loaded.
   Loading char guid 39 from account 5.

   Loading Player Corpses…
   =ERROR: Corpse #707 have broken data in `data` field. Can’t be loaded.

   Thanks
   Cheers .. !Meow!

   Link to this comment Reply to this comment

   
   
10. 

    Milamber said Jul 28, 2008 at 7:37 am

    

    I guess should clarify that I didn’t change ALL the slashes in the whole file, just the ones in the line “DataDir =”

    —Milamber

    Link to this comment Reply to this comment

    
    
11. 

    Milamber said Jul 28, 2008 at 7:34 am

    

    115w.gear | Jul 28, 2008 at 1:21 / 1:21 AM | Links to this comments | Reply

    Mangos.exe prompt:
    Check existing of map file: [sic](lol nice engrish btw)

    “maps/000431.map not found.”

    though I am staring right the file within the correct arcane-fire folder.
    ____________________________

    I had this problem too. The solution was to change the slashes in the mangosd.conf file from “\” to “/”

    i.e. my original – c:\reaper-x\arcane-fire\data – resulted in the missing map error. Once I changed it to c:/reaper-x/arcane-fire/data, it worked like a champ. Obviously, substitute your own path, just change the slashes and try it that way.

    —-Milamber

    Link to this comment Reply to this comment

    
    
12. 

    Summonence said Jul 28, 2008 at 5:40 am

    

    @ coz

    characters

    Link to this comment Reply to this comment

    
    
13. 

    coz said Jul 28, 2008 at 5:17 am

    

    wow im a noob, guys what is the default character database name?

    Link to this comment Reply to this comment

    
    
14. 

    ICE said Jul 28, 2008 at 4:42 am

    

    hey man. i had i problem with loading the mangos. it said i had a few files missing but i have no idea where i would be able to get them? please help

    Link to this comment Reply to this comment

    
    
15. 

    w.gear said Jul 28, 2008 at 3:05 am

    

    @colt

    I’ll give it another shot (this will be attempt number 3) just to verify, but I am going to assume at this point that the files in my wow install dir have been corrupted based on what I’ve seen thus far.

    I’ll just have to repatch it up and see how it goes should I get the same error. Thanks for the help

    Link to this comment Reply to this comment

    
    
16. 

    Checkmate said Jul 28, 2008 at 2:16 am

    

    @colt45 Is the newer stable version with UDB 357 going to be upgradable from 6245?

    Link to this comment Reply to this comment

    
    
17. 

    JB said Jul 28, 2008 at 2:11 am

    

    Hey,
    I had a problem with the characters not showing, applied the fix and now I have a similar problem, just with a different error message.
    SQL ERROR: Unknown column ‘taxi_path’ in ‘field list’
    I’ve searched the net but can’t find anything that would help… Any ideas?
    Thanks.

    Link to this comment Reply to this comment

    
    
18. 

    MMssda said Jul 28, 2008 at 1:52 am

    

    oh nvm..thx bav and cold =)

    Link to this comment Reply to this comment

    
    
19. 

    MMssda said Jul 28, 2008 at 1:51 am

    

    oh ok.. its supposed to make them together to a file whit name of DBC’s & maps..? got that one now. to inside it is only maps..:(?

    Link to this comment Reply to this comment

    
    
20. 

    Bav101 said Jul 28, 2008 at 1:44 am

    

    @MMssda

    heya bud, dont need to download the DBC its easier to get it yourself, get ad.exe from Arcane-Fire\Extraction Tools\DBC’s & Maps and copy it into the root of your wow folder (of course making sure its 2.4.3!) then make 2 folders, maps and dbc open a dos prompt change to the wow folder and type the following,

    ad -e 2 hit enter and it’ll extract the dbc files and all you have to do is copy the folder to where the maps and vmaps are and it should run ok.

    Guys, thanks alot for all your hard work in getting all the kinks worked outof this release, if i wore a hat i’d take it off to ya’s all!

    Link to this comment Reply to this comment

    
    
21. 

    Colt45 said Jul 28, 2008 at 1:39 am

    

    Also im working on a more stable version now, but it will be UDB 357! Sorry!

    Link to this comment Reply to this comment

    
    
22. 

    Colt45 said Jul 28, 2008 at 1:38 am

    

    ….. dude…. the ad.exe extract both your maps and dbcs…. You may have this problem because either the extractor didnt find the file, when copying to your arcane-fire folder it missed that file, or your WoW directory has a corrupt file.

    Link to this comment Reply to this comment

    
    
23. 

    MMssda said Jul 28, 2008 at 1:33 am

    

    please make download link for folder and the stuff in it; DBC :) isnt included in my download, thanks, keep good work up :)

    Link to this comment Reply to this comment

    
    
24. 

    MMssda said Jul 28, 2008 at 1:30 am

    

    i hawe same prob as wgear,
    w.gear | Jul 28, 2008 at 1:21 / 1:21 AM | Links to this comments | Reply

    Mangos.exe prompt:
    Check existing of map file: [sic](lol nice engrish btw)

    “maps/000431.map not found.”

    though I am staring right the file within the correct arcane-fire folder.

    Link to this comment Reply to this comment

    
    
25. 

    w.gear said Jul 28, 2008 at 1:21 am

    

    Mangos.exe prompt:
    Check existing of map file: [sic](lol nice engrish btw)

    “maps/000431.map not found.”

    though I am staring right the file within the correct arcane-fire folder.

    Link to this comment Reply to this comment

    
    
26. 

    redvex said Jul 28, 2008 at 12:58 am

    

    I really wanna thank you guys for the hard work and the quick fixes!!!! Everything is working good now keep up the good work!

    Link to this comment Reply to this comment

    
    
27. 

    MMssda said Jul 28, 2008 at 12:50 am

    

    oh.. there was some error on download or something.. i got no dbc folder.. can some1 put link to download that one ? ? ? thanks

    Link to this comment Reply to this comment

    
    
28. 

    MMssda said Jul 28, 2008 at 12:47 am

    

    btw.. my map folder is DBC’s & Maps, shouldnt they be 2 difrend folders?? or

    Link to this comment Reply to this comment

    
    
29. 

    MMssda said Jul 28, 2008 at 12:34 am

    

    Thanks.. now i got one more problem then im done.. =)when i open mangosd says check existing of map file not existist! etc etc?

    Link to this comment Reply to this comment

    
    
30. 

    coz said Jul 27, 2008 at 11:09 pm

    

    Is the Character problem fixed now, sorry im pushy, Please respond = ]

    Link to this comment Reply to this comment

    
    
31. 

    gokcen said Jul 27, 2008 at 10:57 pm

    

    hi i feel like an idiot whatever i try crashes.
    first i couldn’t extract vmaps it just dosen’t work.then batch file at fresh install didn’t work. i checked mysql no mangos database.
    what can i do i tried different versions is it vista? please help

    Link to this comment Reply to this comment

    
    
32. 

    gokcen said Jul 27, 2008 at 9:57 pm

    

    hi i am totally new at this and way over my head.when i run batch file at the fresh- install it says system can’t find the file then installation complete but when i try to run mangosd it says unknown database mangos
    what can i do please help

    Link to this comment Reply to this comment

    
    
33. 

    Rikiller said Jul 27, 2008 at 9:14 pm

    

    Hmmm.. no luck with anything really.
    All I can suggest at the moment, is if you run a server with WWW connection – Don’t upgrade yet!
    After about a million different fix attempts, I’ve rolled back to 2.4.2 until a stable release is put out.

    Link to this comment Reply to this comment

    
    
34. 

    Wokis said Jul 27, 2008 at 5:34 pm

    

    Thanks.

    Link to this comment Reply to this comment

    
    
35. 

    Ode said Jul 27, 2008 at 5:32 pm

    

    Gheeez! One problem after another. I got to the point where I got my character made but when I try to enter the world everything freezes to the leading screen and the loading bar is not moving at all, so its not loaing any files. How can I fix this?

    Link to this comment Reply to this comment

    
    
36. 

    IntErlOpr said Jul 27, 2008 at 5:19 pm

    

    I beg to differ Summonence, Rikiller that’s what I was referring to in my above post. The 6360_characters_characters.sql in the zip I uploaded fixes the old characters.

    Link to this comment Reply to this comment

    
    
37. 

    Rikiller said Jul 27, 2008 at 5:02 pm

    

    @Heaight
    Yeah that worked to make new characters… .
    Here’s the SQL:
    
TRUNCATE `character_instance`;
TRUNCATE `instance`;

    ALTER TABLE `character_instance`
    DROP KEY `leader`,
    DROP PRIMARY KEY,
    ADD PRIMARY KEY `guid` (`guid`,`instance`),
    DROP COLUMN `map`,
    DROP COLUMN `leader`,
    MODIFY COLUMN `instance` int(11) unsigned NOT NULL default '0',
    ADD COLUMN `permanent` tinyint(1) unsigned NOT NULL default '0';

    ALTER TABLE `instance`
    ADD COLUMN `difficulty` tinyint(1) unsigned NOT NULL default '0' AFTER `resettime`;

    CREATE TABLE `group_instance` (
    `leaderGuid` int(11) unsigned NOT NULL default '0',
    `instance` int(11) unsigned NOT NULL default '0',
    `permanent` tinyint(1) unsigned NOT NULL default '0',
    PRIMARY KEY (`leaderGuid`,`instance`),
    KEY `instance` (`instance`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    CREATE TABLE `instance_reset` (
    `mapid` int(11) unsigned NOT NULL default '0',
    `resettime` bigint(40) NOT NULL default '0',
    PRIMARY KEY (`mapid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    ALTER TABLE `groups`
    ADD COLUMN `difficulty` tinyint(3) unsigned NOT NULL default '0' AFTER `isRaid`;

    ALTER TABLE `characters`
ADD COLUMN `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `map`;


    BUT… there seems to be something wrong with the ‘data’ column. The server is reporting that eg:
    
ERROR: Player #2 have broken data in 'data' field. Can't be loaded.

    Link to this comment Reply to this comment

    
    
38. 

    Haeight said Jul 27, 2008 at 4:49 pm

    

    I setup a few mangos installs in the past few months solely using this website, I did look at compiling my own a few times. Today, motivated me to compile my own mangos.

    I had no issues extracting on a fresh DB, using Arcane-Fire. Everything went smooth until I created my 1st character it didn’t show up after I created it.

    So I learned to compile my own today. I came across a possible answer to this issue fresh install character creation problem. It was mentioned in the UDB forums that 358_corepatch_characters_6241_to_6346.sql
    is not compatible with MaNGOS Rev. 6382

    Since I was in the middle of compiling everything and getting my database up and running I had already d/l 6362_characters.sql as the lateset character svn being used. I finally got everything running w/o a problem.

    I have not tried to use Arcane-Fire again and make the change on the character.sql file in the DB yet.

    Link to this comment Reply to this comment

    
    
39. 

    Shatty said Jul 27, 2008 at 4:40 pm

    

    wow, your great man =] i have been waiting for this! thanks very much! and GREAT job :D

    Link to this comment Reply to this comment

    
    
40. 

    Ode said Jul 27, 2008 at 4:25 pm

    

    Can someone advice me how I set up the database to mysql correctly? I think that is the reason why I can’t get it to work.. I’ve tried to look up posts in the site to find instuctions but I haven’t found them. Or I just didn’t “get it”..

    Link to this comment Reply to this comment

    
    
41. 

    Summonence said Jul 27, 2008 at 4:15 pm

    

    No guys the version thats downloadable has already been tested, and it works, Backup, upgrading and fresh-install. No worries for anyo of you for this. It’s already patched.

    Link to this comment Reply to this comment

    
    
42. 

    SR2 said Jul 27, 2008 at 3:45 pm

    

    IntErlOpr! I tested, and works. :D

    Link to this comment Reply to this comment

    
    
43. 

    IntErlOpr said Jul 27, 2008 at 3:40 pm

    

    I *think* that all you’d have to do it run the 6360_characters_characters.sql patch if you’ve added the dungeon_difficulty column and it would work. Unable to test due to accidentally deleting my 6245 DB and I don’t have the time to re-install right now. Reap, oat or Colt you’d already have it if you’ve downloaded the mangos SVN release.

    Link to this comment Reply to this comment

    
    
44. 

    IntErlOpr said Jul 27, 2008 at 2:31 pm

    

    I don’t know why it works, no time to check anything, just wanted it out there ASAP

    Link to this comment Reply to this comment

    
    
45. 

    IntErlOpr said Jul 27, 2008 at 2:28 pm

    

    This is how I got it working from a character dump using 6245 unsure if a backup would work:

    This is the part in the char dump you need to go to:

    ‘CharNameHere’, ‘1′, ‘8′, ‘26.9513′, ‘4288.28′, ‘90.1167′, ‘530′, ”,

    Search for your char name, The last part after 530 (the map no) is blank, change it to ‘0′. So it’s the 7th piece of data after your character name. That’s the dungeon_difficulty column.

    Go into your MySQL\data\characters directory and delete everything (BACKUP FIRST). Run the characters.sql file included in the zip I link to down the bottom to recreate it. Load your character dump using the loadpdump option in Mangos Server. Then run the 6360 sql patch also included in the zip and it works fine.

    Don’t forget to back-up blah blah blah, sorry it’s messy and probably confusing but it works for me anyway.

    http://rapidshare.com/files/132771897/sqlfix.zip.html

    Link to this comment Reply to this comment

    
    
46. 

    Summonence said Jul 27, 2008 at 1:54 pm

    

    Yes sorry there was a release, its not our fault they weren’t working. I worked hard on this today, to figure out make sure its working stable enough to host your players. Working on fixing other issues in the next day or so.

    Link to this comment Reply to this comment

    
    
47. 

    checkmate said Jul 27, 2008 at 1:41 pm

    

    Thanks for the update and appreciate the extra work. Better to have it just right then not.

    Link to this comment Reply to this comment

    
    
48. 

    Colt45 said Jul 27, 2008 at 12:52 pm

    

    Also if you run a public server I DO NOT reccommend updating yet! It seems there have been alot of errors, but help reporting them so we can fix them helps!

    Link to this comment Reply to this comment

    
    
49. 

    Colt45 said Jul 27, 2008 at 12:51 pm

    

    Also if you already downloaded it you can try the UBD Fix 1 link at the top of the post (the fix may be just a flash and then gone but if it doesnt work then use Navicat to apply FIRST the fix_part1.sql file then the fix_part2.sql file!

    Link to this comment Reply to this comment

    
    
50. 

    Colt45 said Jul 27, 2008 at 12:49 pm

    

    Im about to update the links to the fixed (not %100) but to where u can make, see, and delete your characters!

    Link to this comment Reply to this comment

    
    

Leave a response Click here to cancel reply.

Please read our comment policy | XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Name (Required)

Mail (Required, Will not be displayed to public)

Website (Optional, leave blank if have none)

Comment