jwh1981

Sorry I completely forgot to mention I am on Debian 12 with GCC 12.2.0

I confirmed today that this still exists for MangosOne (TBC) as of the latest commit: 4daa549ca0ca540562b6b858fb746276a307fbe9

Awesome thank you.

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

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?