# Upgrade from 9.11 ESR to 10.5 ESR fails with MySQL database migration query failure

**URL:** <https://forum.mattermost.com/t/upgrade-from-9-11-esr-to-10-5-esr-fails-with-mysql-database-migration-query-failure/23480>\
**Category:** Upgrade\
**Created:** [June 29, 2025, 4:06pm UTC](https://forum.mattermost.com/t/upgrade-from-9-11-esr-to-10-5-esr-fails-with-mysql-database-migration-query-failure/23480 "2025-06-29T16:06:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![joshlockhart](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mattermost.com/joshlockhart/32/9019_2.png) [@joshlockhart](https://forum.mattermost.com/u/joshlockhart)\
**Post date:** [June 29, 2025, 4:06pm UTC](https://forum.mattermost.com/t/upgrade-from-9-11-esr-to-10-5-esr-fails-with-mysql-database-migration-query-failure/23480/1 "2025-06-29T16:06:39Z")

</div>

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?