Search the Community
Showing results for tags ' database'.
Found 23 results
-
Hey, i was wondering if there are any DB chinese locales (such as locales_quest ) available? I checked few db versions from downland section but couldn't find anything usefull.
-
[Mangos One] Wrong Database structure after compiling Mangos One
jaydee posted a question in Archived Help and support
Hi there, I'm new here so let me say at first that i really appreciate your work what you are doing in developing the core. Thanks a lot for that ! My problem is that after i compiled the develop21 release of Mangos One i installed the develop21 release of the database, but I get the following error after starting mangosd.exe: 2016-06-25 13:41:26 ERROR:The table `db_version` indicates that your [Character] database does not match the expected structure! 2016-06-25 13:41:26 ERROR: 2016-06-25 13:41:26 ERROR: [A] You have database Version: 21 2016-06-25 13:41:26 ERROR: Structure: 1 2016-06-25 13:41:26 ERROR: Content: 0 2016-06-25 13:41:26 ERROR: Description: revision_refactor 2016-06-25 13:41:26 ERROR: 2016-06-25 13:41:26 ERROR: You need database Version: 21 2016-06-25 13:41:26 ERROR: Structure: 2 2016-06-25 13:41:26 ERROR: Content: 1 2016-06-25 13:41:26 ERROR: Description: match_client_limits 2016-06-25 13:41:26 ERROR: 2016-06-25 13:41:26 ERROR:You must apply all updates after [A] to to use MaNGOS with this database. 2016-06-25 13:41:26 ERROR:These updates are included in the database/Character/Updates folder. When i install these updates i mess everything up. Which updates do i exactly need to apply to match the exact Structure "2" and Content "1"? Thanks a bunch! JayDee Edit: I used only the character updates and now it seemed to work. Can I ignore this error? 2016-06-25 13:50:01 ERROR:You have not updated the core for few DB [World] updates! 2016-06-25 13:50:01 ERROR:Current DB content is 50, core expects 8 2016-06-25 13:50:01 ERROR:This is ok for now but should not last long. I compiled the latest core ?!? -
I run Develop 21, with the latest release of the database. all updates applied. There is a high droprate for rare (blue) items. If you start killing lvl20+ mobs there is like 30% chance to get a rare drop. Is this database related? or does the core recalculate the droprate? In the .conf file the droprate is set to 1. Example. The item Skycaller - Item - World of Warcraft drops. And i cant even find it in the loot table.
-
First time setting up mangos, followed a few of the guides posted on forums and tried searching the issue. it looks like the database isn't populating correctly. I tried running make_full_WorldDB.sh and InstallDatabases.bat but still didn't work. Any suggestions? Nevermind, the realm folder didn't copy over in the zip. Now I'm having issues getting other people to connect to the server :>
-
Microsoft Windows [versão 10.0.10586] © 2015 Microsoft Corporation. Todos os direitos reservados. C:\Windows\system32>cd c:/mangos c:\MANGOS>mangosd.exe 21000 [world-daemon] <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| We Love the | |\/| / _` | .` | (_ | (_) \__ \ Burning Crusade |_| |_\__,_|_|\_|\___|\___/|___/ ___ For help and support please visit: / _ \ _ _ ___ Website: getMaNGOS | The home of MaNGOS - Home | (_) | ' \/ -_) Wiki: MaNGOS Wiki * GitHub \___/|_||_\___| Using configuration file 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.26 MySQL server ver: 5.6.25-log AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 5.6.26 MySQL server ver: 5.6.25-log AUTOCOMMIT SUCCESSFULLY SET TO 1 Character Database total connections: 2 Connected to MySQL database [email protected]:3306/characters MySQL client library: 5.6.26 MySQL server ver: 5.6.25-log AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/characters MySQL client library: 5.6.26 MySQL server ver: 5.6.25-log AUTOCOMMIT SUCCESSFULLY SET TO 1 Login Database total connections: 2 Connected to MySQL database [email protected]:3306/realmd MySQL client library: 5.6.26 MySQL server ver: 5.6.25-log AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/realmd MySQL client library: 5.6.26 MySQL server ver: 5.6.25-log AUTOCOMMIT SUCCESSFULLY SET TO 1 Realm running as realm ID 1 Using World DB: Version: 21, Structure: 1, Content: 0 Using DataDir ./ WORLD: VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 WORLD: VMap data directory is: ./vmaps WORLD: MMap pathfinding enabled Please check for the existence of map file './maps/0004331.map' Correct *.map files not found in path './maps' or *.vmtree/*.vmtile files in './vmaps'. Please place *.map and vmap files in appropriate directories or correct the DataDir value in the mangosd.conf file.
-
Hey guys, I had to implement my mangos-one to my new Ubuntu 14.04-machine. Last thing to do is to convert my existing databases to the new versions. I realized I was running a pretty old version: Characters: s1699_xxxxx_01_characters_characters Realmd: s1706_xxxxx_01_warden_data_result The required Versions are: Characters: 20001_02_dbdocs-Update Realmd: 20150409_Playerbot_and_Warden The Update-folders on the github-content AND the archived server here on getmangos don't reach enough back to help me. They only go back to: Characters: 19000_Release_019_Initial Realmd: z2424_sxxxx_xxxxx_01_realm_db_version Can anyone tell me where I can find older updates? Or can you just copy the files content here?? That would be great! Thanks in advance!
-
Hi, I recently followed a guide on how to install Mangos and it all went well untill now. Apparently my database is out of date and I have no clue how to fix that. I applied the updates in rel21 and in Rel20_to_BaseRel21_Updates. I got the core and the database from the following guide This is the error I am getting after applying the above updates: 2016-05-03 15:27:21 21000 [world-daemon] 2016-05-03 15:27:21 <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| We Love | |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow |_| |_\__,_|_|\_|\___|\___/|___/ ____ For help and support please visit: /_ /___ _ _ ___ Website: getMaNGOS | The home of MaNGOS - Home / // -_) '_/ _ \ Forum / Wiki: getMaNGOS | The home of MaNGOS - Home /___\___|_| \___/ 2016-05-03 15:27:21 Using configuration file mangosd.conf. 2016-05-03 15:27:21 World Database total connections: 2 2016-05-03 15:27:21 MySQL client library: 5.6.25 2016-05-03 15:27:21 MySQL server ver: 5.6.25-log 2016-05-03 15:27:21 MySQL client library: 5.6.25 2016-05-03 15:27:21 MySQL server ver: 5.6.25-log 2016-05-03 15:27:21 ERROR:The table `db_version` indicates that your [World] database does not match the expected structure! 2016-05-03 15:27:21 ERROR: 2016-05-03 15:27:21 ERROR: [A] You have database Version: 21 2016-05-03 15:27:21 ERROR: Structure: 1 2016-05-03 15:27:21 ERROR: Content: 19 2016-05-03 15:27:21 ERROR: Description: SD3_Updates 2016-05-03 15:27:21 ERROR: 2016-05-03 15:27:21 ERROR: You need database Version: 21 2016-05-03 15:27:21 ERROR: Structure: 11 2016-05-03 15:27:21 ERROR: Content: 7 2016-05-03 15:27:21 ERROR: Description: Fix BG buffs 2016-05-03 15:27:21 ERROR: 2016-05-03 15:27:21 ERROR:You must apply all updates after [A] to to use MaNGOS with this database. 2016-05-03 15:27:21 ERROR:These updates are included in the database/World/Updates folder. Thanks in advance
-
When I try to update the data bases to resolve 2016-04-20 19:00:36 ERROR:The table `db_version` indicates that your [Realmd] database does not match the expected version! 2016-04-20 19:00:36 ERROR: 2016-04-20 19:00:36 ERROR: [A] You have database Version: 21 2016-04-20 19:00:36 ERROR: Structure: 1 2016-04-20 19:00:36 ERROR: Content: 2 2016-04-20 19:00:36 ERROR: Description: dbdocs update 2016-04-20 19:00:36 ERROR: 2016-04-20 19:00:36 ERROR: [b] You need database Version: 21 2016-04-20 19:00:36 ERROR: Structure: 1 2016-04-20 19:00:36 ERROR: Content: 0 2016-04-20 19:00:36 ERROR: Description: revision_refactor 2016-04-20 19:00:36 ERROR: 2016-04-20 19:00:36 ERROR:You are missing content updates or you have content updates beyond the expected core version. 2016-04-20 19:00:36 ERROR:It is recommended to run ALL database updates up to the required core version. 2016-04-20 19:00:36 ERROR:These updates are included in the database/Realmd/Updates folder. 2016-04-20 19:00:36 ERROR:No valid realms specified. I get ERROR 1146 (42S02) at line 4: Table 'realmdzero.realmd_db_version' doesn't exist
-
Hi, I'm trying to start mangosd.exe after running realmd.exe and I get this error: So I decided to try and update the database through the given instruction. 20007_18_Deadmines_Mr_Smite_Corrections.sql imports fine but when I try to execute 20007_01_Rel20_Release_Prep.sql I get this mysql error: I'm running mysql 5.5.49 community edition server on Windows 10 64bit Also is there some place I can find updated documentation about the installation process?
-
Game server does not start, the login server is started, the update added to the database, can not understand the reason, finding used but do not understand, I need to compile again? sorry for my English, have all night can not run server. Please help. Also I have a bottle of water, it's your mad max. 2016-04-22 07:11:14 21000 [world-daemon] 2016-04-22 07:11:14 <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| We Love | |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow |_| |_\__,_|_|\_|\___|\___/|___/ ____ For help and support please visit: /_ /___ _ _ ___ Website: getMaNGOS | The home of MaNGOS - Home / // -_) '_/ _ \ Wiki: MaNGOS Wiki * GitHub /___\___|_| \___/ 2016-04-22 07:11:14 Using configuration file mangosd.conf. 2016-04-22 07:11:14 World Database total connections: 2 2016-04-22 07:11:14 MySQL client library: 5.6.26 2016-04-22 07:11:14 MySQL server ver: 4.1.12a-nt 2016-04-22 07:11:14 MySQL client library: 5.6.26 2016-04-22 07:11:14 MySQL server ver: 4.1.12a-nt 2016-04-22 07:11:14 ERROR:SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1 2016-04-22 07:11:14 ERROR:query ERROR: Unknown column 'structure' in 'field list' 2016-04-22 07:11:14 ERROR:The table `db_version` in your [World] database is missing or corrupt. 2016-04-22 07:11:14 ERROR: 2016-04-22 07:11:14 ERROR: [A] You have database Version: MaNGOS can not verify your database version or its existence! 2016-04-22 07:11:14 ERROR: 2016-04-22 07:11:14 ERROR: You need database Version: 21 2016-04-22 07:11:14 ERROR: Structure: 1 2016-04-22 07:11:14 ERROR: Content: 0 2016-04-22 07:11:14 ERROR: Description: revision_refactor 2016-04-22 07:11:14 ERROR: 2016-04-22 07:11:14 ERROR:Please verify your database location or your database integrity.
-
I'm running Centos 7, installed everything following the centos 7 wiki tutorial but replaced mangosthree with two. Server is updated to the latest version, so is database. Realmd works, but mangosd is giving me errors. [[email protected] bin]$ ./mangosd MaNGOS Two/ (* * Revision 12578 - *) for Linux_x64 (little-endian) [world-daemon] <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| | |\/| / _` | .` | (_ | (_) \__ \ |_| |_\__,_|_|\_|\___|\___/|___/ _____ For help and support please visit: |_ _|_ __ _____ Website: https://getmangos.eu | | \ V V / _ \ Wiki: http://github.com/mangoswiki |_| \_/\_/\___/ Using configuration file /opt/mangos/etc/mangosd.conf. OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 1.0.1e-fips 11 Feb 2013) Using ACE: 5.8.3 World Database total connections: 2 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 10.0.24-MariaDB MySQL server ver: 10.0.24-MariaDB AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/mangos MySQL client library: 10.0.24-MariaDB MySQL server ver: 10.0.24-MariaDB AUTOCOMMIT SUCCESSFULLY SET TO 1 Character Database total connections: 2 Connected to MySQL database [email protected]:3306/characters MySQL client library: 10.0.24-MariaDB MySQL server ver: 10.0.24-MariaDB AUTOCOMMIT SUCCESSFULLY SET TO 1 Connected to MySQL database [email protected]:3306/characters MySQL client library: 10.0.24-MariaDB MySQL server ver: 10.0.24-MariaDB AUTOCOMMIT SUCCESSFULLY SET TO 1 SQL: SELECT required_12546_01_characters_random_battleground FROM character_db_version LIMIT 1 query ERROR: Table 'characters.character_db_version' doesn't exist SQL: SELECT * FROM character_db_version LIMIT 1 query ERROR: Table 'characters.character_db_version' doesn't exist The table `character_db_version` in your [CHARACTER] database is missing or corrupt. MaNGOS can not find the version info needed to check that the db is up to date. This revision of mangos requires a database updated to: `12546_01_characters_random_battleground.sql` Reinstall your [CHARACTER] database with the included sql file in the sql folder. So I get this. Seems like i have to apply characters.sql. Mangosd still doesnt work. I decide to run the 01_characters_random_battleground.sql update, and I get this error [[email protected] characters]# mysql -u root -p mangos < 01_characters_random_battleground.sql Enter password: ERROR 1054 (42S22) at line 1: Unknown column 'required_12487_01_characters_characters' in 'character_db_versio n' Is there something I should do/shouldn't have done? Can I fix it?
-
Hello all, I'm trying to setup my own server and while I've overcome a lot of issues via trial and error I seem to have a issue with the version of my database I've complied. I'm not sure how because I just downloaded the source from Git today. Here's what I see in my server.log file. Any help would be great! Thanks
-
I get a world server crash whenever my char is loaded into the game, I did a fresh build from the latest server dev21 and database dev21 repos under VS2013 update5 with scriptSD3 and eluna included on windows 7 SP1 64bits OS... Extracted the necessary files, namely dbcs, maps, vmaps and mmaps with the builded tools to double check but I got this crash no matter what... Also to test I checkout a version from August 2015 to mimic the offered precompiled binaries, the rev in question is 6f841ba3cc67209b942c781861b7f8b6bc2eccc7, and did a fresh installed with a database that matched that changeset an didnt get the crash I am experiencing with the latest source... So I naturally run out of ideas of what to test and posted here to get some assistance please... -
[Mangos Two] Cannot run Realmd due to errors
marcelo20xx posted a question in Archived Help and support
I downloaded MangosTwo_Develop21_Release_x32_August2015 then installed MySql and run the bat, but I got: 2016-03-29 14:19:15 ERROR:query ERROR: Table 'realm.db_version' doesn't exist 2016-03-29 14:19:15 ERROR:The table `db_version` in your [Realmd] database is missing or corrupt. 2016-03-29 14:19:15 ERROR: 2016-03-29 14:19:15 ERROR: [A] You have database Version: MaNGOS can not verify your database version or its existence! 2016-03-29 14:19:15 ERROR: 2016-03-29 14:19:15 ERROR: [b] You need database Version: 21 2016-03-29 14:19:15 ERROR: Structure: 1 2016-03-29 14:19:15 ERROR: Content: 0 2016-03-29 14:19:15 ERROR: Description: revision_refactor 2016-03-29 14:19:15 ERROR: 2016-03-29 14:19:15 ERROR:Please verify your database location or your database integrity. Went to github and downloaded the zip file of the database tag rev21, still the same problem, what should I do? thanks in advance PS: I downloaded and installed git for windows and the program refuses to clone from the repo with a bunch of errors too... -
[Mangos Zero] mpfans server setup database issue
madmax posted a question in Archived Help and support
As i will be out today another member of the team will need to take this on. This thread is for mpfans: -
[Mangos One] All Dungeon Bosses and Raidbosses HP around 6k
prefix posted a question in Archived Help and support
I'm running the latest branch (develop21) of both server and database for mangosone. Everything else works fine as far as i can tell but every single raid instance or dungeon i go into all the bosses have hp values around 6-7000. I've checked the database for some of the curhealth values and they are much higher and seem accurate. I've tried reinstalling the world database and succesfully installed all the most recent updates. Anyone have an idea what could be wrong? I'm stumped Thanks. Solved! Edit: After looking around the forum for some time i found this post. (Which incidentally has 666 as the ID oO) After inserting this code into my world database all the bosses of Karazhan have the correct values for HP, including mobs which also seemed to have incorrect values. I'm leaving this here so anyone with the same problem can find this fix UPDATE creature_template, creature_template_classlevelstats SET HealthMultiplier = MinLevelHealth/BaseHealthExp0 WHERE creature_template_classlevelstats.Level = MinLevel; -
[Mangos Zero] 20007_01_Rel20_Release_Prep.sql Missing
silent posted a question in Archived Help and support
i cant seem to find this sql anywhere i get this error -
Hey, I really want to create some custom items/replace the already created custom items. When I execute the command in the query (Pastebin) restart the server and add the item, it says retrieving item information. What can I do to fix this, and successfully create custom items?
-
Hello, After successfully installing MangosZero half a dozen times over this month, the latest update has brought with it some new issues. Logs: 2015-08-31 08:06:17 SQL: SELECT version, structure, content, description FROM db_version ORDER BY version DESC, structure DESC, content DESC LIMIT 1 2015-08-31 08:06:17 query ERROR: Unknown column 'structure' in 'field list' 2015-08-31 08:06:17 The table `db_version` in your [World] database is missing or corrupt. 2015-08-31 08:06:17 2015-08-31 08:06:17 [A] You have database Version: MaNGOS can not verify your database version or its existence! 2015-08-31 08:06:17 2015-08-31 08:06:17 You need database Version: 21 2015-08-31 08:06:17 Structure: 1 2015-08-31 08:06:17 Content: 0 2015-08-31 08:06:17 Description: revision_refactor I can confirm I am using Database Version 21, and that the database does indeed exist. Furthermore updates have been applied. Has anyone else encountered this issue? Is there a known workaround or fix? Thanks for you're help! Regards, Magic
-
[Mangos Three] Mangos Three Database is there?
codeman3518 posted a question in Archived Help and support
Is there a temp database full for 4.3.4 or not? 2015-09-03 22:01:05 ERROR:SQL: SELECT required_12752_01_mangos_reputation_spillover_template FROM db_version LIMIT 1 2015-09-03 22:01:05 ERROR:query ERROR: Unknown column 'required_12752_01_mangos_reputation_spillover_template' in 'field list' 2015-09-03 22:01:05 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date! 2015-09-03 22:01:05 ERROR: 2015-09-03 22:01:05 ERROR: [A] You have: --> `12188_01_mangos_vehicle_accessory.sql` 2015-09-03 22:01:05 ERROR: 2015-09-03 22:01:05 ERROR: You need: --> `12752_01_mangos_reputation_spillover_template.sql` 2015-09-03 22:01:05 ERROR: 2015-09-03 22:01:05 ERROR:You must apply all updates after [A] to to use mangos with this database. 2015-09-03 22:01:05 ERROR:These updates are included in the sql/updates folder. -
I was running MangosOne and was out in Skettis and noted that the birds are close to the ground, with few in the air. After reviewing the creature source code and the database, I was still unclear on how to control their movement. Any ideas? Thanks
-
It seems im missing the character database file and when my friend sends me the character database file I have the same problem.
-
When i start mangosd.exe it is closed at once. world-database.txt log: 2015-07-09 19:18:33 SQL: SELECT required_20007_01_Rel20_Release_Prep FROM db_version LIMIT 1 2015-07-09 19:18:33 query ERROR: Unknown column 'required_20007_01_Rel20_Release_Prep' in 'field list' 2015-07-09 19:18:33 The table `db_version` in your [WORLD] database indicates that this database is out of date! 2015-07-09 19:18:33 2015-07-09 19:18:33 [A] You have: --> `20007_18_Deadmines_Mr_Smite_Corrections.sql` 2015-07-09 19:18:33 2015-07-09 19:18:33 You need: --> `20007_01_Rel20_Release_Prep.sql` 2015-07-09 19:18:33 2015-07-09 19:18:33 You must apply all updates after [A] to to use mangos with this database. 2015-07-09 19:18:33 These updates are included in the sql/updates folder. 2015-07-09 19:18:33 Please read the included [README] in sql/updates for instructions on updating. world -server.txt log 2015-07-09 19:38:43 20007 [world-daemon] 2015-07-09 19:38:43 <Ctrl-C> to stop. __ __ _ _ ___ ___ ___ | \/ |__ _| \| |/ __|/ _ \/ __| We Love | |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow |_| |_\__,_|_|\_|\___|\___/|___/ ____ For help and support please visit: /_ /___ _ _ ___ Website: https://getmangos.eu / // -_) '_/ _ \ Wiki: MaNGOS Wiki · GitHub /___\___|_| \___/ 2015-07-09 19:38:43 Using configuration file mangosd.conf. 2015-07-09 19:38:43 World Database total connections: 2 2015-07-09 19:38:43 MySQL client library: 5.5.37 2015-07-09 19:38:43 MySQL server ver: 5.6.25-log 2015-07-09 19:38:43 MySQL client library: 5.5.37 2015-07-09 19:38:43 MySQL server ver: 5.6.25-log 2015-07-09 19:38:43 ERROR:SQL: SELECT required_20007_01_Rel20_Release_Prep FROM db_version LIMIT 1 2015-07-09 19:38:43 ERROR:query ERROR: Unknown column 'required_20007_01_Rel20_Release_Prep' in 'field list' 2015-07-09 19:38:43 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date! 2015-07-09 19:38:43 ERROR: 2015-07-09 19:38:43 ERROR: [A] You have: --> `20007_18_Deadmines_Mr_Smite_Corrections.sql` 2015-07-09 19:38:43 ERROR: 2015-07-09 19:38:43 ERROR: You need: --> `20007_01_Rel20_Release_Prep.sql` 2015-07-09 19:38:43 ERROR: 2015-07-09 19:38:43 ERROR:You must apply all updates after [A] to to use mangos with this database. 2015-07-09 19:38:43 ERROR:These updates are included in the sql/updates folder. 2015-07-09 19:38:43 ERROR:Please read the included [README] in sql/updates for instructions on updating. 20007_01_Rel20_Release_Prep.sql updating isn't applied.
Contact Us
To contact us
click here
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
You can also email us at [email protected]
Privacy Policy | Terms & Conditions