jwh1981
Members-
Posts
16 -
Joined
-
Last visited
-
Donations
0.00 GBP
Content Type
Profiles
Bug Tracker
Wiki
Release Notes
Forums
Downloads
Blogs
Events
Everything posted by jwh1981
-
This is the issue: Unknown column 'content_loc0' in 'field list' per: REPLACE INTO `mangos_string` (`entry`, `content_default`,`content_loc0`, `content_loc2`, `source_file`,`source_enum_wrapper`,`source_enum_tag`) VALUES (1701, '%s is Dead - cannot apply aura.', '%s is Dead - cannot apply aura.', '%s est mort - l''aura ne peut pas être appliquée.', 'Language.h', 'MangosStrings', 'LANG_COMMAND_AURAGROUP_CANNOT_APPLY_AURA_PLAYER_IS_DEAD'), (1702, 'Aura from spell %u has been applied to %s.', 'Aura from spell %u has been applied to %s.', 'L''aura du spell %u a été appliquée à %s.', 'Language.h', 'MangosStrings', 'LANG_COMMAND_AURAGROUP_AURA_APPLIED'), (1703, 'Cannot remove aura(s) from %s because the player is dead.', 'Cannot remove aura(s) from %s because the player is dead.', 'Impossible de de retirer le/les aura(s) du joueur %s car il est mort.', 'Language.h', 'MangosStrings', 'LANG_COMMAND_AURAGROUP_CANNOT_UNAURA_DEAD_PLAYER'), (1704, 'All auras have been removed from %s.', 'All auras have been removed from %s.', 'Toutes les auras ont été retirées de %s.', 'Language.h', 'MangosStrings', 'LANG_COMMAND_AURAGROUP_ALL_AURA_REMOVED'), (1705, 'Aura from spell %u has been removedfrom %s', 'Aura from spell %u has been removed from %s', 'L''aura du spell %u a été enlevée de %s.', 'Language.h', 'MangosStrings', 'LANG_COMMAND_AURAGROUP_AURA_REMOVED_FOR_SPELL'); Should be content_loc1 as there is no content_loc0 field in the mangos_string table I changed Rel21_22_001_New_Command_auragroup.sql to content_loc1 and it works fine
-
Hello, I attempted to update my dbZero and I get: ===== Status ===== ===== DB is on Version: ===== * UPDATE FAILED * DB_Cleanup_Pt6 when I run: mysql -u root -p -h192.168.1.20 zero_world < Rel21_22_001_New_Command_auragroup.sql The server (192.168.1.20) is Debian 10 x86_64 with MySQL 5.7.31. This setup worked fine yesterday and I updated my core today and it was required to be on Rel21_22_001_New_Command_auragroup The MySQL logs do not show an error, I only have the response that it failed and its on DB_Cleanup_pt6 Any help would be appreciated!
-
mangos one Various items missing in MangosOne
jwh1981 replied to jwh1981's question in Peer to Peer Technical Support
Very nice, Thanks again for the help I'm going a full level 1-70 playthrough and I'll report any other bugs in new posts. -
mangos one Various items missing in MangosOne
jwh1981 replied to jwh1981's question in Peer to Peer Technical Support
I found a way to get them both working. Heres what I did: 1. I rode the working tram to Iron Forge (the farthest one) 2. Once I made it to Iron Forge, the second tram (which would be the closest one in Stormwind) appeared and I rode it back to Stormwind. 3. Once I made it back to Stormwind, I waited and confirmed that both work now. That appears to have primed whatever logic controls them. -
mangos one Various items missing in MangosOne
jwh1981 replied to jwh1981's question in Peer to Peer Technical Support
I spoke too soon I found that in the Stormwind Deeprun Tram, only the farthest tram appears and works. The closes to the entrance does not appear at all. Very strange. -
mangos one Millys Harvest quest bugged
jwh1981 replied to jwh1981's question in Peer to Peer Technical Support
This was fixed by @antz in -
mangos one Various items missing in MangosOne
jwh1981 replied to jwh1981's question in Peer to Peer Technical Support
@antz I updated the core and database. I can confirm gameobjects are present in the system (I checked mailboxes, treasure chests, and milly's grapes). Thank you for all that you do:) -
mangos one Various items missing in MangosOne
jwh1981 replied to jwh1981's question in Peer to Peer Technical Support
The deep run trams are also missing on MangosOne. I am now on Master (server commit: bb0c091) Edit: I walked through the tram from Stormwind to Ironforge just to make sure -
mangos one Various items missing in MangosOne
jwh1981 posted a question in Peer to Peer Technical Support
I am on the current master branch of MangosOne (server commit 94859bd and database commit 8f41391). I am using Debian 10 x86_64 with MariaDB 10.3.22. I found that some items in the world are missing, such as mailboxes and treasure chests. An example of this is the mailbox in Goldshire or the treasure chests in Echo Ridge next to Northshire Abbey. I will note any other world items missing as I find them, unless of course its a fix that would correct all of them. Thank you for your help -
I am on the current master branch of MangosOne (commit 94859bd) and database (commit ac9dcf7). In the human starting area (Northshire Abbey), the baskets of grapes do not appear for the Milly's Harvest quest after I accept the quest from Milly to retrieve them from the fields occupied by the Defias Brotherhood. I have already extracted a fresh setup of resources to rule out that as the issue. I am on Debian 10 x86_64 with MariaDB 10.3.22. I have been using the getmangos.sh script for installing. I wanted to add that this issue (for mangostwo) also occurs on mangosone, in case its related to this issue?
-
mangos two Object errors on boot up
jwh1981 replied to Spikey's question in Peer to Peer Technical Support
I wanted to add that this also appears to be an issue on mangosone. I tried multiple times to resolve this on Debian 10. I tried both MariaDB 10.3 and MySQL 5.7 (separate VM's) and also regenerating my data files a few times. I wanted to add to this post before I submitted another bug: Milly's Harvest (quest) appears to be broken and her grapes do not appear in the vineyard in the human starting zone (Northshire Abbey). Could that be a symptom of this? Thank you! -
Hmmmm there doesn't appear to be a way to directly cancel your account. I would suggest emailing the admin(s) at [email protected] for help.
-
Actually I figured it out on my own. I just needed to apply: z1807_xxxxx_01_mangos_spell_proc_event.sql and z1809_xxxxx_01_mangos_spell_affect.sql. Issue resolved
-
Hello all, I was able to install Mangos Zero (and have it fully working) on a test machine last week (Ubuntu 10.04 32bit). However, I've been trying since yesterday to get it up and running on a faster computer. The compilation of Mangos Zero, ScriptDev0, and the Zero Database (including a successful import into mysql) work properly. However, after doing the usual edits to the config files, the maps/dbc/vmaps stuff, etc., I get the following error after trying to start mangos-worldd: [0 ms] SQL: SET CHARACTER SET `utf8` Connected to MySQL database [email protected]:3306/zp_world MySQL client library: 5.1.41 MySQL server ver: 5.1.41-3ubuntu12.10 AUTOCOMMIT SUCCESSFULLY SET TO 1 [0 ms] SQL: SET NAMES `utf8` [0 ms] SQL: SET CHARACTER SET `utf8` SQL: SELECT required_z1809_xxxxx_01_mangos_spell_affect_event FROM db_version LIMIT 1 query ERROR: Unknown column 'required_z1809_xxxxx_01_mangos_spell_affect_event' in 'field list' [0 ms] SQL: SELECT * FROM db_version LIMIT 1 The table `db_version` in your [WORLD] database indicates that this database is out of date! [A] You have: --> `z1765_xxxxx_01_mangos_spell_affect.sql` [b] You need: --> `z1809_xxxxx_01_mangos_spell_affect_event.sql` You must apply all updates after [A] to [b] 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. I have googled 'z1809_xxxxx_01_mangos_spell_affect_event.sql' but no results were found. I also confirmed that z1809_xxxxx_01_mangos_spell_affect_event.sql does not exist in server\\sql\\updates. Instead, z1809_xxxxx_01_mangos_spell_affect.sql exists. Has anyone seen this issue before? If so, could I please have some info on how to resolve it?
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
Copyright © getMaNGOS. All rights Reserved.
This website is in no way associated with or endorsed by Blizzard Entertainment®
This website is in no way associated with or endorsed by Blizzard Entertainment®