Mangos Error

Results 1 to 21 of 21
  1. #1
    Member DesX is offline
    MemberRank
    Mar 2006 Join Date
    66Posts

    Mangos Error

    I can login, but I once again am recieving errors.

    2006-12-05 18:51:06 ERROR:SQL: UPDATE `account`,`realmcharacters` SET `account`.`online` = 0 WHERE `account`.`online` > 0 AND `account`.`id` = `realmcharacters`.`acctid` AND `realmcharacters`.`realmid` = '1'
    2006-12-05 18:51:06 ERROR:SQL ERROR: Table 'mangos.account' doesn't exist
    2006-12-05 18:51:06 Using DataDir C:\Documents and Settings\u\Desktop\Private World of Warcraft\bloodRepack 2.4/ ...
    2006-12-05 18:51:06 ERROR:SQL: UPDATE `realmlist` SET `icon` = 8 WHERE `id` = '1'
    2006-12-05 18:51:06 ERROR:SQL ERROR: Table 'mangos.realmlist' doesn't exist

    I am sure this would have something to do with it.


  2. #2
    Newbie Tobin is offline
    MemberRank
    Nov 2006 Join Date
    Newfoundland.Location
    21Posts
    You got the realmd DB batched and edited with your IP or the realmlist you have supported from a host site? Along with editing your .conf to match your username/password. Along with just batching the basic two Silver's DBs or have you done something else? Looks like an error with the .conf or whatever you use to batch files/run server info (ex: SQLyog). But I'm not completely sure. Sorry if I'm not too helpful.
    Last edited by Tobin; 06-12-06 at 12:08 AM.

  3. #3
    Member DesX is offline
    MemberRank
    Mar 2006 Join Date
    66Posts
    I have them using my IP

  4. #4
    Newbie Tobin is offline
    MemberRank
    Nov 2006 Join Date
    Newfoundland.Location
    21Posts
    And you've edited your .conf files to match your username/password? What files have you batched into the mangos and realmd DBs? From the sql folder or Silver's DB, either on this forum or the actual SDB forum?

  5. #5
    Member DesX is offline
    MemberRank
    Mar 2006 Join Date
    66Posts
    From the sql folder

  6. #6
    Newbie Tobin is offline
    MemberRank
    Nov 2006 Join Date
    Newfoundland.Location
    21Posts
    Alright, well that has caused a lot of errors for me. What Rev for mangos are you running?
    + Mangos-Files.de You can get the latest from there.
    What I recommend you do is get Revision 2748 and then go http://forum.ragezone.com/world-warc...-166402-2.html Find the post by urbin and under SDB Full Patch get "SDB 0.5.3_305 - 2748 Database --->" You can also get the Revision here if you don't want to go to the the other link I posted.

  7. #7
    Member DesX is offline
    MemberRank
    Mar 2006 Join Date
    66Posts
    I have 2690

  8. #8
    Member DesX is offline
    MemberRank
    Mar 2006 Join Date
    66Posts
    Thing is, I have no idea how I'd update Mangos : (

  9. #9
    Newbie Tobin is offline
    MemberRank
    Nov 2006 Join Date
    Newfoundland.Location
    21Posts
    Basically. You download the Rev. Extract it. Replace all existing Mangos files in the folder you created for it. Thus emptying your DBs and batching the new Silver's DB, mangos.sql and realmd.sql. I noticed you posted a lot of error threads? Lol..

  10. #10
    Member DesX is offline
    MemberRank
    Mar 2006 Join Date
    66Posts
    Yeah. I'm a total nub, that, and including the lack of sleep I get..I run into a lot of problems XD, thank you for your time, friend!

  11. #11
    Newbie Tobin is offline
    MemberRank
    Nov 2006 Join Date
    Newfoundland.Location
    21Posts
    Did you try this? Let me know if it helped you with your troubles? Also go into control panel, Windows Firewall, exceptions, add port. (If you have windows firewall, if not reply and I'll tell you the other way) Add ports 3306, 8080, 8085. UDP and TCP. Meaning you'll create two of the same port; just one UDP and another TCP.

  12. #12
    Member DesX is offline
    MemberRank
    Mar 2006 Join Date
    66Posts
    I'll let you know in just a moment, and, if it does work, I'll give you a big e-hug :3

  13. #13
    Member DesX is offline
    MemberRank
    Mar 2006 Join Date
    66Posts
    So, I don't need to run ad again? Since it seems as though it was already done here..so I can just re-batch everything in sql, configure the mangos/realm stuff accordingly, and call it a day?

  14. #14
    Newbie Tobin is offline
    MemberRank
    Nov 2006 Join Date
    Newfoundland.Location
    21Posts
    Yeah, as long as you got the right dbc and maps files. As in extracted from your WoW folder with ad.exe and dbc from this forum or the easy way. (Won't get into that, might just confuse you) But yes, just replace all existing Mangos files in the folder, even the sql folder. Save the newly downloaded Silver DBs in the C:\ Driver, and empty your DBs through SQLyog and re-batch. Along with editing your Realmlist in realmd and your .conf files.

  15. #15
    Member DesX is offline
    MemberRank
    Mar 2006 Join Date
    66Posts
    I'm getting a weird error, with whenever I try to run add, it simply says, 'Error opening archive .data/patch.mpq-2' What the hell?

  16. #16
    Member DesX is offline
    MemberRank
    Mar 2006 Join Date
    66Posts
    Does this new stuff support a different version of WoW? Those are files from the 1.12.1 patch.

  17. #17
    Newbie Tobin is offline
    MemberRank
    Nov 2006 Join Date
    Newfoundland.Location
    21Posts
    Well they all work on 1.12.1, What version of WoW do you use? Make sure you go ad.exe in your World of Warcraft folder and you create a new folder called Maps.
    Mangos-Files.de Here's a manual I recommend.

  18. #18
    Member DesX is offline
    MemberRank
    Mar 2006 Join Date
    66Posts
    Wtf..whenever I try to run ad in the data folder, it simply gives me an error opening up all the appropriate archives, then it crashes out.

  19. #19
    Newbie Tobin is offline
    MemberRank
    Nov 2006 Join Date
    Newfoundland.Location
    21Posts
    You don't run ad.exe in the data folder. You run it in the normal WoW folder, and make a Maps folder. God you're retarded. No offence. Give me your msn and let me app share. So I can do it myself. You'll keep making the tiny errors that screw the entire thing up. Read the manual I sent you in my last post and completely start over with your server.

  20. #20
    Member DesX is offline
    MemberRank
    Mar 2006 Join Date
    66Posts
    I did do that, I placed the ad.exe into the root directory with a folder in there I made, I named it 'Maps', then I ran the ad.exe and it simply gives me an error reading 'Can not open archive patch-2.mpq, but anyway, my MSN is 'DoomedDes@Gmail.com'

  21. #21
    Newbie Tobin is offline
    MemberRank
    Nov 2006 Join Date
    Newfoundland.Location
    21Posts
    Fix your problem yet?



Advertisement