1.8.2 executing database upgrades fails due to duplicate column
After installing the 1.8.2 update, attempting to execute the database upgrades fails with DB Error: unknown error. Looks like there is a duplicate column name? Environment is PHP 8.0 / MariaDB 10.5.22.
The error message is:
[Error: Upgrade com.klangsoft.btrmsgtpl to revision 1802]
DB Error: unknown error
After attempting to debug, it looks like there is a duplicate column name?
ALTER TABLE `civicrm_msg_template_revisions` ADD COLUMN `language` varchar(5) NOT NULL DEFAULT '_std_' COMMENT 'Locale of the revision', ADD COLUMN `git_hash` varchar(40) DEFAULT NULL COMMENT 'Commit ID default template changed', ADD COLUMN `notes` varchar(2048) DEFAULT NULL COMMENT 'Notes/commit message for the revision', ADD INDEX (`language`) [nativecode=1060 ** Duplicate column name 'git_hash']