Jump to content

Search the Community

Showing results for tags 'database'.

  • 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
    • Mangos Sharp
    • Third Party Software
    • Website
  • Bug Tracker Archives (Resolved issues)
    • Archived Reports (Zero)(Resolved issues)
    • Archived Tasks (Zero)(Resolved issues)
    • Archived Reports (One)(Resolved issues)
    • Archived Tasks (One)(Resolved issues)
    • Archived Reports (Two)(Resolved issues)
    • Archived Tasks (Two)(Resolved issues)
    • Archived Reports (Three)(Resolved issues)
    • Archived Reports (Five)(Resolved issues)

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
    • Covenant-WoW.com Website - Official Mangos Test Servers
  • 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 !!
  • Other Wow Emu Projects

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 23 results

  1. On updating character2 table to version 22.1.1, faced a trouble with adding Rel21_04_001_update_deprecated_ROW_FORMAT.sql into db. It reports that MySQL can't complete a request "ALTER TABLE groups ROW_FORMAT=DYNAMIC ENGINE=INNODB;" After a search in a Google, I found that there is a kind of troubles with dynamic row format in InnoDB in MySQL 8 (v 8.0.22), and solved a problem by simple removing this string from update file (i.e., row format for this table leaved unchanged, i.e., MyISAM). All other fields changed correctly. Now all works fine, but just reporting to you about this tro
  2. Hello! In Mangos Two (v.21.11.49, db v.21.12.55, WoW 3.3.5 EN), I found a strange bug. On some maps there is almost no mineral veins or herbs (for herbalism). For example, if I trying to find tin ore, there is no this type ore in Hillsbrad Foothills (where must be alot of it according to maps from WowHead). Same thing is for herbs. How this can be fixed?
  3. There are two missing texts in the Earth Sapta (Quest ID 1462 and 1463) quest for Zero, One and Two: UPDATE `quest_template` SET `OfferRewardText`='Take this and remember, it is sacred.' WHERE `entry`=1462; UPDATE `quest_template` SET `OfferRewardText`='I give you one in good faith. You already proved yourself once, but me tinkin\' you should be more careful in the future.' WHERE `entry`=1463; Might have to update locales_quest / MAGNET translations accordingly.
  4. There is a wrong `RequestItemsText` within the quest data of Fire Sapta (Quest ID 1464): UPDATE `quest_template` SET `RequestItemsText`=NULL WHERE `entry`=1464; This text is already correctly set within the `Objectives`.
  5. The quest "Root Samples" (Quest ID 866) activates the collection of "Root Sample" (Item ID 5056) from specific game objects introduced just for this quest. Right now within the database of Zero, One and Two this is set to the loot templates of the standard rather than the specific game objects. (e.g. game objects Silverleaf ID 1617 vs. Silverleaf ID 3725) Since the game objects are placed within the Barrens correctly, this can easily be fixed by removing the item from the currect gameobject_loot_templates and adding it to the loot templates of the quest specific game objects: -- Remov
  6. I have successfully cloned, built, installed the mangostwo project and extracted all of the map data (I think). However, I am hitting a snag on the DB setup. I am using this guide: I've installed mysql-server with sudo apt install mysql-server Then I switched to root and loaded up mysql to do this command (which, BTW, "privileges" is misspelled in the guide: CREATE USER 'mangos'@'localhost' IDENTIFIED BY 'mangos'; GRANT ALL PRIVILEGES ON *.* TO 'mangos'@'localhost' WITH GRANT OPTION; I exited, and did cd /home/mangos/db/ git clone https://github.com/mangosz
  7. Please make mangos run on updated versions of MySQL and MARIA as it is getting harder to obtain the older versions for 64-bit
  8. 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
  9. 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
  10. Hello Does someone have a db query or anything where you can fake /who command and show people players online? Thank you
  11. 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 c
  12. 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
  13. 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)
  14. 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 particu
  15. 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!
  16. 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
  17. 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
  18. 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 Ver
  19. 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?
  20. 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 dat
  21. 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!
  22. 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
  23. 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_l
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use