Jump to content

Search the Community

Showing results for tags 'database'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Mangos Zero
    • Enhancement Requests (Zero)
    • Tasks (Zero)
  • Mangos One
    • Enhancement Requests (One)
    • Tasks (One)
  • Mangos Two
    • Enhancement Requests (Two)
    • Tasks (Two)
  • Mangos Three
    • Enhancement Requests (Three}
    • Tasks (Three)
  • Mangos Four
    • Enhancement Requests (Four)
    • Tasks (Four)
  • Mangos Five
    • Enhancement Requests (Five)
    • Tasks (Five)
  • Cross-Core
    • Bugs
    • Enhancement Requests
    • Tasks
    • Sub-Modules
    • Eluna
    • Linux
    • Windows
    • Archived Cross-Core/Other Reports
  • Others
    • Mangos VB
    • Third Party Software
    • Website
  • Bug Tracker Archives
    • Archived Reports (Zero)
    • Archived Tasks (Zero)
    • Archived Reports (One)
    • Archived Tasks (One)
    • Archived Reports (Two)
    • Archived Tasks (Two)
    • Archived Reports (Three)
    • Archived Reports (Five)

Categories

  • Development Roadmap
  • Documentation
    • Installation Guides
    • Playerbot AI
    • Standards And Practices
  • Tutorials
    • Advanced
    • Contributing to Mangos
    • Debugging
  • Reference Information
    • ClientFiles
    • Database Info
    • DBC Files
    • Other
    • Packet Info
    • Server Files
    • Server Components

Forums

  • MaNGOS Information
    • Announcements & Releases
  • Community Discussion Areas
    • Introduce Yourself
    • Community Cafe
    • Community Input
    • Community Projects
    • MaNGOS University
  • Community Help and Support
    • Peer to Peer Technical Support
    • Frequently Asked Questions
    • Resources
  • Development & Patch Submissions
    • Development
    • Patch Submissions
  • Eluna LUA Engine
    • Eluna Central
  • International Help & Support
    • International Boards
  • Archived
    • Main Archives
    • Archive of Pre-2012 Forum

Product Groups

There are no results to display.

Categories

  • Mangos Zero
  • Mangos One
  • Mangos Two
  • Mangos Three
  • Addons
    • Classic Addons
  • World Of Warcraft Patches
    • WoW Patches
    • The Burning Crusade Patches
    • Wrath of the Lich King
    • Client Tools Patchers

Blogs

  • getMaNGOS
  • DBC handling for mangos
  • The Road to Zero Release 21
  • Necrovoice's development blog.
  • What the Heck happened to Antz and MaNGOS in 2018 !!

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Core


Skype


Discord


Website URL


AIM


ICQ


Yahoo


Jabber


About Me


Gender


Location


Interests

Found 38 results

  1. Hi!Few weeks ago has been created a project: http://www.wowgaming.orgIt's a WoW resource pool (Db search, wiki, addons etc) subdivided by expansion that currently support wotlk 3.3.5aAll information inside are stored with original data from that specific game version.It's totally Free and Open Source alternative to (dead?) OpenWoW site!Please read this page to understand why and how we can do it.This project can be helpful for:- Wiki and Database search engine for educational Open Source application server projects, such as AzerothCore/TrinityCore/Mangos etc.- Keeping an historical archive of World of Warcraft original data- Discussing and Blogging about newest and oldest WoW Facts wotlk portal (index of all subsite below): http://www.wowgaming.org/wotlk.htmldatabase: https://wowgaming.altervista.org/aowow/addon list: http://www.wowgaming.org/addons-335a-collection/wiki: https://wowgaming.altervista.org/wp/wotlk-home/ Our repositories: https://github.com/wowgame If you want to help us or maintaining another version using our free toolsPlease, Contact us on Discord
  2. Hi. Long time lurker first time poster. I have successfully installed and run a MaNGOS Zero server on my home Ubuntu server now for just about half a year. I see there are beeing updates pushed quite often on the site but I cant find any information on how I update my installation to the latest build. Is there any documentation on how to update an existing Mangos Zero install to the latest build of Mangos Zero? I would appreciate any help
  3. Hello Does someone have a db query or anything where you can fake /who command and show people players online? Thank you
  4. The database table "spell_linked" was introduced as incremental update with Rel21_08_001. With the commit "Updated to expect Rel21_08_012_Commands_update" it was then moved to the base updates. At this point it is meant to be part of the base database (full database), but it is not. If you set up a fresh database today, you're base database will be 21_08_012 (according to db_version table), which is newer and therefore prevents reapplying the incremental update 21_08_001. The table creation for "spell_linked" is missing in the mangosdLoadDB.sql script as well as the corresponding content script inside the FullDB folder. I've checked Rel21_07_019 through Rel21_08_011 to double check if another script is missing. Seems fine. Maybe prior incremental scripts are missing as well?
  5. Hello everyone I wanted to give an update on my most recent working within the Dragonblight before I go away on my much needed vacation. My most recent endeavour to correct the spawn locations of the many Arctic Hare has been a very slow and daunting one. What started in the Dragonblight spilled into the Borean Tundra and Zul'Drak. But I am happy to say that this portion is about 75% complete. In addition to the ever troublesome dust bunn..I mean Arctic Hare, I have poked around with three other things * Smoldering Skeletons now properly display their aura and have had their cosmetic aura added. * Golluck Rockfist of Wyrmrest Temple now has a patrol path * Add Missing Wyrmrest Protector as well as removed a few that should not be there I hope you all enjoyed the update and I will see you all next week
  6. Although it has only been one day from my opening post, I have been working on the Arctic grizzly and Arctic cubs for about two weeks now. I am happy to say 647 waypoints with a total of 776 lines later, they now are working correctly. (As of this writing they still require some scripting) The Arctic Grizzly and cubs now have the following corrections Spawn locations. Way-points. Spawn Locations. Linking - slave/master/flags. 21 duplicates removed between the two. (Moved)
  7. Hello everyone, I thought the work I have been doing on Dragonblight would be a great opportunity to start my first blog. This is the largest and most complex undertaking I have ever taken on here at MaNGOS and wanted you all to be a part of its progress. As a side note and something I would like every reader to keep in mind is that the when I speak of "progress" or "percent completed" it is based on the personal end goals I set for myself when the thought of doing an overhaul on the zone first came to be. So sit back and enjoy some cake. Base Project Outline (In no particular order) 1) Waypoints 1-1) Add missing waypoints 1-2) Update current Waypoints 1-3) Remove incorrect/unused waypoints 2) NPC spawns 2-1) Add missing NPCs 2-2) Remove duplicate NPCs 3) NPC linking 4) Scripting 4-1) db_scripts 4-2) AI_scripts 4-3) Potential for SD3 / Eluna 5) Quests 6) NPC updates 6-1) Faction Updates 6-2) Gossip 6-3) Flags 6-3-1) NpcFlags 6-3-2) UnitFlags 6-3-3) DynamicFlags 6-3-4) ExtraFlags 6-4) miscellaneous Attribute updates 7) Npc cosmetic tweaks 8) Game Objects 8) Data cleanup and submission
  8. Is there some sort of procedure to follow when it comes to updating / using a new version of the Mangos Zero Server? How can I retain all of my DB info / not loose character progress? I apologize if this question has been answered elsewhere..the amount of content on this site is huge and I didn't find anything Also I'm still very new to mangos, so hopefully this doesn't come across as a huge noob question... Thanks!
  9. Heya folks, has there been any development of the AoWoW database explorer for mangoszero ? I can't find any fork that is even remotely in a working condition with the official mangoszero database. I'd like to run a clone of http://db.vanillagaming.org - would there be anyone with the knowledge of how to get there ? Cheers
  10. Hi! If anyone more traveled in these matters could give me some pointers I would be happy. I'm currently running an old repack Mangos for 2.4.3, v18 database I think and it's kinda wonky when I actually decided to play around. So I have been trying to get the v21 to work. For waaaay to many hours now, so asking for help. These are steps I have tried. I downloaded the v21 server files and extractor from this site, extracted and setup the config's is no biggie. After a few attempts with gitcloning the database, i notice when using git to downloaded the clone is missing several files, So I have now downloaded them manually and placed in the database folder for a complete database to install. Also found that the Database installer batchfile included had some errors regarding the updatesfolder so fixed those paths manually so the realm, character and world updates gets installed. there is a bunch of those updates sql files that gives errrors, I have no idea if this is supposed to be ok or not but for the characters DB update, these files gives error when installing: 21000_00_Release_021_Initial.sql and 21000_01_warden_action.sql gets an "Error 1146 at Line 2 : Table 'Realmd.character_db_version' doesn't exist" while Rel21_2_1_match_client_limits.sql *UPDATE FAILED* revision_refractor In the RealmDB update only 20150816_01_db_version.sql , Rel21_1_1_dbdocs_updates.sql and Rel21_1_2_dbdocs_update.sql are installed, the rest of the sql files are either skipped or failed. In the World updates folder, things are weird since there is a folder there thats supposed to be ran first, but if I do that mangosd.exe won't start since it complains about world_db table being wrong, and a quick look at the table reveals that all the updates in the worldfolder has had their names added to the db_version description, good for keeping track, but the server refuses to load if it's not exactly and only database 21,structure 1, content 0, revision_refractor, so to get the server to even start i need to run the files from the Rel20_to_Base_rel21Updates folder. (i also need to run the 20150816_01_db_version.sql in the realm updates too to get it to be what the realmd.exe is expecting. Now the server is startable, and playable but there is a bunch of errors related to Scriptdev2 and pretty much every castermob in instances is bugged and not following a player that moves out of LoS, so i expect i'm doing something horribly wrong. (i also tried to place the files from world/updates/rev21/Rel20_to_BaseRel21_Updates up into the rev21 and changed their names a bit so they'd get loaded in first. but that changed nothing. I apologize for the wall of text and probably incoherent rantings, but I'm stuck now and if anyone has some good ideas on how to get one up and running without all errors on the way, I'd be most thankful. /P
  11. Hey guys, i have a problem with updating worldDB to the right version. The only update that i can not apply is Rel21_2_0_SD2_refactoring.sql.(ERROR 1091 (42000) at line 5: Can't DROP 'ScriptName'; check that column/key exists). Who can help me out here? thx in advance The table `db_version` indicates that your [World] database does not match the expected structure! [A] You have database Version: 21 Structure: 1 Content: 0 Description: revision_refactor [B] You need database Version: 21 Structure: 2 Content: 6 Description: dbdocs updates You must apply all updates after [A] to [B] to use MaNGOS with this database. These updates are included in the database/World/Updates folder.
  12. I'm trying to understand how can I close AQ gates, roots, runes and other content like 4 dragons. I found that I can just add for example 4 dragons to my disables table and they will not spawn, but how it should be with AQ gates, because there is a line in db_scripts table with this script but they still open. Maybe I am missing something?
  13. I dont know what I'm doing wrong, trying now to setup a fresh 3.3.5 server (been using old repacks in the past) to get the latest fixes and all. (This is all regarding to reamd.exe and the realm database, I'm starting from there, but I 100% expect same trouble from character and world database) I have downloaded the rel21 files from this site and ran the InstallDatabases.bat file with no problem, the databases and tables are there when verifying with navicat. Now shit starts hitting the fan. If I try to launch the realmd, it gives a big red error about missing table 'db_version' in the database, which i understand since there is no 'db_version', only a 'realm_db_version' table. So I assume I need to run the updates included. (I -guess- only the files in Rel21? assuming the rel18-rel20 folders are for updating older databases?) But that don't help/work, I execute them in order (might be wrong the table in realm_db_version says 'required_20150722_01_realmcharacters_remove_constraint" suggesting the database is from 20150722, but only applying the files after that don't work either) so I try updating, starting with the oldest file in the Rel21 folder, but the '20150412_02_auth_realmlist.sql' gives errors since it expects the realm_db_version to be 'required_20150412_warden_db_log' which -should- have been changed from the previous sql file. Did a manual table edit and changed it's name, then two more sql updates went in with only two errors regarding posts in realmlist, that was already there (?). The last update '20150722_01_realmcharacters_remove_constraint' went in with error that it couldn't drop the key (since it wasnt there) All updates 'installed' realmD.exe still don't start, naturally, since it expects db_version table, with version 21, stucture 1,content0, and revision_Refractor as description. Am I doing something horribly horribly wrong or is the database terribly broken when cleaninstalling? (had the exact same shit when installing mangos one v21 too) Repacks I have tried several and gotten them to run, but they all generally have oldascrap databases so would like to try with a fresh one. /P
  14. Hi downloaded this bundle (MangosOne_Develop21_Release_x32_Aug2015.zip), did the tutorial on how to setup but I get an error when runing realmd.exe that says: MySQL client library: 5.6.26 MySQL server ver: 5.6.23-log MySQL client library: 5.6.26 MySQL server ver: 5.6.23-log SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, st query ERROR: Table 'realmd.db_version' doesn't exist The table `db_version` in your [Realmd] database is missing or corrupt. [A] You have database Version: MaNGOS can not verify your database version or its existence! You need database Version: 21 Structure: 1 Content: 0 Description: revision_refactor Please verify your database location or your database integrity. The same goes for mangosd.exe MySQL client library: 5.6.26 MySQL server ver: 5.6.23-log MySQL client library: 5.6.26 MySQL server ver: 5.6.23-log SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, st query ERROR: Table 'realmd.db_version' doesn't exist The table `db_version` in your [Realmd] database is missing or corrupt. [A] You have database Version: MaNGOS can not verify your database version or its existence! You need database Version: 21 Structure: 1 Content: 0 Description: revision_refactor Please verify your database location or your database integrity. I have tried diffrent DB versions of mysql 5.7.x, 5.5.37 and 5.6.23 same problem. when I connect with db tool the table is there but not accessible the structure seems to be wrong all other tables are fine (not checked all but ...). I'v tried to use "git clone --recursive h t t p://github.com/mangoszero/database.git -b develop21" , but that db is to new, realmd and mangosd halts with wrong db version/structur/content error, if I manupulate the version table so realmd and mangosd thinks this db is 21/1/0 the realmd starts and mangosd goes as far as it regognize that creatures table contains 78 collums instaed of 70 then halts. any sugestions? Regards /arne
  15. Hey all! I'm new, and I just started building a MaNGOS Zero rel21 server for myself. Some info first: Win Server 2008 R2 MySQL 5.6.28 64bit Compiled with Visual Studio 14 2015 Win64 I used InstallDatabases.bat, but when I run mangosd.exe I get the following text: [color="#FF0000"]The table `db_version` indicates that your [World] database does not match the e xpected structure! [A] You have database Version: 21 Structure: 10 Content: 1 Description: warden_table_redone [b] You need database Version: 21 Structure: 11 Content: 7 Description: Fix BG buffs You must apply all updates after [A] to [b] to use MaNGOS with this database. These updates are included in the database/World/Updates folder.[/color] I guess the batch file didn't give me the latest version? 1: I don't know if I do or don't have the needed files yet. How can I tell? Should they be included when I cloned the database folder with Git? 2: Once I do have the files I need, I might need help importing them. I mean I can run a script and fill out a few questions, but I'm still learning about the whole SQL database thing. Any help would be greatly appreciated!
  16. Reinstalling Mangos after changing over my OS a couple of times. Having trouble with updating the database, specifically the Realm database. This is my feedback: [email protected]:/home/allen/database/Realm/Updates/Rel19# mysql -u root -p mangos < 20140607_Realm_Resync.sql Enter password: ERROR 1146 (42S02) at line 1: Table 'mangos.realmd_db_version' doesn't exist No idea what it's talking about. This is my output when I try to run either realmd or mangosd: SQL: SELECT required_20150420_warden_db_log FROM realmd_db_version LIMIT 1 query ERROR: Unknown column 'required_20150420_warden_db_log' in 'field list' The table `realmd_db_version` in your [REALMD] database indicates that this database is out of date! [A] You have: --> `20150409_Playerbot_and_Warden.sql` You need: --> `20150420_warden_db_log.sql` You must apply all updates after [A] to to use mangos with this database. These updates are included in the sql/updates folder. Please read the included [README] in sql/updates for instructions on updating. And this is my output when I try and rectify the situation: [email protected]:/home/allen/database/Realm/Updates/Rel21# mysql -u root -p mangos < 20150412_01_warden_db_log.sql Enter password: Status Required Version Found Version * UPDATE SKIPPED * required_20150409_Playerbot_and_Warden NULL [email protected]:/home/allen/database/Realm/Updates/Rel21# mysql -u root -p mangos < 20150409_Playerbot_and_Warden.sql Enter password: Status Required Version Found Version * UPDATE SKIPPED * required_20140607_Realm_Resync NULL I'm not the greatest with mysql, and I know some of the guys on here have helped me get it running well before. Just wondering if I could get a hand. Thanks.
  17. hey guys this is the first time i have tried this so sorry for the stupid questions but when i try to cd .. cd database InstallDatabases.bat i keep getting this [email protected] MINGW64 /c/database (release20) $ cd .. [email protected] MINGW64 /c $ cd database [email protected] MINGW64 /c/database (release20) $ InstallDatabases.bat bash: InstallDatabases.bat: command not found how do i fix it? thanks
  18. I am at the last stage of getting a server running but I am running into this error. I obviously need to update the Database but for the life of me can not figure out how, could someone help me with this?
  19. I'm having troubles running mangoszero on the lastest develop21 release. When I run realmd, I'm getting: 21000 [realm-daemon] <Ctrl-C> to stop. Using configuration file ../etc/realmd.conf. Login Database total connections: 2 MySQL client library: 5.6.28 MySQL server ver: 5.6.28-0ubuntu0.15.10.1 MySQL client library: 5.6.28 MySQL server ver: 5.6.28-0ubuntu0.15.10.1 The table `db_version` indicates that your [Realmd] database does not match the expected version! [A] You have database Version: 21 Structure: 1 Content: 0 Description: revision_refactor [b] You need database Version: 21 Structure: 1 Content: 2 Description: dbdocs update You are missing content updates or you have content updates beyond the expected core version. It is recommended to run ALL database updates up to the required core version. These updates are included in the database/Realmd/Updates folder. Added realm id 1, name 'MaNGOS Zero Server #1' When I run mangosd, I'm getting: 21000 [world-daemon] <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| We Love | |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow |_| |_\__,_|_|\_|\___|\___/|___/ ____ For help and support please visit: /_ /___ _ _ ___ Website: https://getmangos.eu / // -_) '_/ _ \ Forum / Wiki: https://getmangos.eu /___\___|_| \___/ Using configuration file ../etc/mangosd.conf. OpenSSL 1.0.2d 9 Jul 2015 (Library: OpenSSL 1.0.2d 9 Jul 2015) Using ACE: 6.3.0 World Database total connections: 2 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.6.28 MySQL server ver: 5.6.28-0ubuntu0.15.10.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.6.28 MySQL server ver: 5.6.28-0ubuntu0.15.10.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 The table `db_version` indicates that your [World] database does not match the expected structure! [A] You have database Version: 21 Structure: 1 Content: 11 Description: Fix last startup errors [b] You need database Version: 21 Structure: 3 Content: 1 Description: Fix SoR paladin You must apply all updates after [A] to [b] to use MaNGOS with this database. These updates are included in the database/World/Updates folder. The server compiled without any troubles, but when I import the SQL I'm getting errors as well. I'm running lastest Ubuntu x32, I tried the importing scripts, but didn't work, so I dropped the databases, connected remotely via my windows machine and executed "InstallDatabases.bat" from "mangos/database" repo. How can I fix this?
  20. Hello, I want to create a Mangos Zero Server. I did it all the right way like its told in the Guide and in the Wiki. Database is created, etc. I compiled the Server in 64-Bit mode, got also 64 Bit Database etc. Settings are all changed and now i want to start the realmd.exe but it only popps on and instant off if i run it. What am i doing wrong? I dont get any Error or something. Best regards
  21. Along last project guide line to have a more synched cores i had an idea to simplify installation process. Now there are several wiki guide and scripts for windows installations (and some for unix but obsolete i think). My idea is to build a Java (OS indipendet) user interface with all options to download core from repos, build it and install database. I've draw a schema of how it will appear: (Antz already told me that SD2 no longer has database installation because it has merged onto world database since last release). The main goal is to have a .conf file in wich store information to be displayed onto GUI and easily managed. I've to start that project from scratch, so if someone of you have ideas to add or improve or something other tell me! Thanks. UPDATES I'm proud to announce the final release! Instruction usages are simple: - For fresh install simply do things inside tabs from first to last. - For custom install or update use the desired tab. Main usages are: - Download with git command all repository (server, database, and LUA scripts) for every four MaNGOS cores. - Install all three databases from scratch or just update one of its. - Build and install source code (with CMAKE commands). - Extract data from WoW client (Map, VMap and MMap). All this features are available for both Windows and Linux systems! Some screenshot to look on how it appear: [ATTACH=CONFIG]264[/ATTACH][ATTACH=CONFIG]261[/ATTACH][ATTACH=CONFIG]262[/ATTACH][ATTACH=CONFIG]263[/ATTACH] To use it, download the ready-to-use files from GitHub: GitHub - Corsol/MaNGOSUI: Mangos Universal Installler into a new folder and run .bat or .sh executable (you may need to edit thoose batch script to use proper java version if you have more than one installed). Remember that need Java JRE 1.7 update 79 or greater (32 or 64 bit). You can customize some configuration stored in config.property file. If you would like to see or modify source code, you can find it in another reposity on GitHub: https://github.com/Corsol/MaNGOSUI-Dev - NetBeans project source code Enjoy!
  22. Hi guys! After some hours spending getting the vanilla server running i get this error: >> Loaded 0 mangos strings. DB table `mangos_string` is empty. Can not continue. Have i missed a sql-script? I am running on Ubuntu server 14.04? greetings thehu Edit: Ok i forgot to mention, i know why it is empty, but i cant run: (always different errors) cd /home/mangos/database bash make_full_WorldDB.sh mysql -u root -p mangos < full_db.sql like said in the wiki. ----------------------------------------------------------------------- $ ./mangosd 21000 [world-daemon] <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| We Love | |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow |_| |_\__,_|_|\_|\___|\___/|___/ ____ For help and support please visit: /_ /___ _ _ ___ Website: https://getmangos.eu / // -_) '_/ _ \ Wiki: MaNGOS Wiki · GitHub /___\___|_| \___/ Using configuration file ../etc/mangosd.conf. OpenSSL 1.0.1f 6 Jan 2014 (Library: OpenSSL 1.0.1f 6 Jan 2014) Using ACE: 6.3.0 World Database total connections: 2 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.5.43 MySQL server ver: 5.5.43-0ubuntu0.14.04.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.5.43 MySQL server ver: 5.5.43-0ubuntu0.14.04.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Character Database total connections: 2 Connected to MySQL database [email protected]:3306/characters MySQL client library: 5.5.43 MySQL server ver: 5.5.43-0ubuntu0.14.04.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/characters MySQL client library: 5.5.43 MySQL server ver: 5.5.43-0ubuntu0.14.04.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Login Database total connections: 2 Connected to MySQL database [email protected]:3306/realmd MySQL client library: 5.5.43 MySQL server ver: 5.5.43-0ubuntu0.14.04.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/realmd MySQL client library: 5.5.43 MySQL server ver: 5.5.43-0ubuntu0.14.04.1 AUTOCOMMIT SUCCESSFULLY SET TO 1 Realm running as realm ID 1 Using World DB: MaNGOSZero Database Rev 21000_17 Using creature EventAI: No EventAI or Scripts available Using DataDir /home/mangos/data/ WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 WORLD: VMap data directory is: /home/mangos/data/vmaps WORLD: MMap pathfinding enabled Loading MaNGOS strings... Loading texts from mangos_string [**************************************************] 100% >> Loaded 0 mangos strings. DB table `mangos_string` is empty. Can not continue.
  23. It appears that I have been loosing not only hair by my entire mind. Been struggling for days trying to get a clean install of Mangos One on a brand new virtual server of Ubuntu 14.04. The compile goes well, and a very successful map extraction. My issue is all around the database import. The first issue it every single set of directions in the Wiki is slightly different and I have tried what appears to be every single one. Here is the issue. While starting to start the realm I get this: SQL: SELECT required_20150409_Playerbot_and_Warden FROM realmd_db_version LIMIT 1 query ERROR: Unknown column 'required_20150409_Playerbot_and_Warden' in 'field list' The table `realmd_db_version` in your [REALMD] database indicates that this database is out of date! [A] You have: --> `20140607_Realm_Resync.sql` You need: --> `20150409_Playerbot_and_Warden.sql` You must apply all updates after [A] to to use mangos with this database. These updates are included in the sql/updates folder. Please read the included [README] in sql/updates for instructions on updating. At this point it is obvious that there are updates missing. After following multiple directions for batch import of both the full database and the updates here is my real question. I get a lot of this type of error: * UPDATE SKIPPED * required_19005_10_mangos_command ERROR 1064 (42000) at line 41527: You have an error in your SQL syntax; Right away it is noticeable that the missing update Rel19 update and I have pulled Rel20. The other appears to be a bugged update. Every attempt to move backwards to get the missing required update points more missing updates. What did I do wrong and what is the correct way to import that full world database? Is it required to install the Rel18 & Rel19 updates if they get pulled? A helpful member sent me a PM and my issue is resolved. All that was needed was this from Rel21: 20150409_Playerbot_and_Warden.sql The rest is pretty much me not really understanding exactly what the messages mean.
  24. I have a really old Mangos install (think 2013) and I'm looking to upgrade it. Is a database like UDB still required for mangos, or is it now included with the release? I don't see anything specifically mentioned in the wiki Thanks
  25. hi, anyone could give me a hand to install updates to the database mangoszero? I tried with mangos universal installer but do not understand how to set it and configure it. The problem is that the installDatabase.bat not install everything for database 21. I state that I have everything installed (git, mysql, cmake, openssl).

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...