mattermost upgrade 6.4.2 to 7.3.0 fails with Error 1064 on the k8 cluster using external HA MySQL 8 cluster
Steps to reproduce
upgrade MM 6.4.2 to 7.3.0 on k8 cluster using external MysqlV8 DB
2022/10/11 11:54:18 == update_configurations_sha: migrating ==========================================================
Error: failed to load configuration: failed to initialize: driver: mysql, message: failed when applying migration, command: apply_migration, originalError: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '""' at line 1, query:
SET @preparedStatement = (SELECT IF(
SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'Configurations'
AND table_schema = DATABASE()
AND column_name = 'SHA'
) > 0,
'ALTER TABLE Configurations ADD COLUMN SHA char(64) DEFAULT "";'
PREPARE alterIfNotExists FROM @preparedStatement;
DEALLOCATE PREPARE alterIfNotExists;
Your sql_mode has ANSI_QUOTES enabled, you should see it by running:
show variables like 'sql_mode';
I don’t know how a managed digitalocean SQL cluster works, but if it is managed, ask them to turn it off There also might be a webinterface where you can configure the sql_mode or some other settings. I can send you the command to fix it temporarily (until the next restart of the service), but that will not help you in the long run, so it’s better to look for a permanent solution.