I am trying to upgrade from 9.11 ESR to 10.5 ESR. It fails with this error:
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: Error: failed to initialize platform: cannot create store: failed to apply database migrations: driver: mysql, message: failed when applying migration, command: apply_migration, originalError: Error 1064 (42000): 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:
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: SET @preparedStatement = (SELECT IF(
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: (
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: WHERE table_name = ‘RemoteClusters’
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: AND table_schema = DATABASE()
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: AND column_name = ‘DefaultTeamId’
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: ) > 0,
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: ‘SELECT 1’,
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: ‘ALTER TABLE RemoteClusters ADD DefaultTeamId VARCHAR(26) DEFAULT “”;’
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: ));
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: PREPARE alterIfNotExists FROM @preparedStatement;
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: EXECUTE alterIfNotExists;
Jun 29 16:01:08 lockhart-mattermost mattermost[668472]: DEALLOCATE PREPARE alterIfNotExists;
I am running MySQL 8.0.35. I have made sure all database tables are utf8mb4 character set with the recommended collation utf8mb4_0900_ai_ci. This is a self-hosted Mattermost installed via tarball.
Not sure how to proceed. Any thoughts?