Update fails for Rel21_22_001_New_Command_auragroup.sql / 97e10ce

Hi @jwh1981,

The commited sql file is here : https://github.com/mangoszero/database/commit/97e10cea3d9674e39f3afb83595ad46df959a620
I have applied it with no problem on my mangos zero DB which was up to Rel21_21_014
Can you try to execute what is between line 44 and 78 ? You will get the error message then.

You can also discuss with us on Discord : https://discord.gg/6KNhGG

Thanks

Elmsroth

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

Thank you @jwh1981

I will fix that.

FIX HAS BEEN PUSHED

https://github.com/mangoszero/database/blob/5b8cbf40856cecefbc807250f262932ca1bf9031/World/Updates/Rel21/Rel21_22_001_New_Command_auragroup.sql

Awesome thank you.