(edited for formatting) Hello- I am upgrading from 5.19.1 to 5.25.5. This is an existing mattermost server that’s been upgraded several times before without issue. After performing the upgrade procedure as per documentation, when I attempt to start mattermost, it fails with this error- Oct 19 17…

This may be an issue related to the character type that is set for the column DefaultChannelGuestRole. I get this from the text that says "DefaultChannelGuestRole used in key specification without a length," which makes me think that the character set is either not set correctly, or not valid. Would…

Error on upgrade - failed to create index

Troubleshooting

dmdmdm November 5, 2020, 9:54pm 7

Hello all

I am writing to confirm that converting DefaultTeamGuestRole and DefaultChannelGuestRole to varchar(64) fixed the issue and let me upgrade without any problems.

Thank you for the assistance

David

2 Likes

Topic		Replies	Views
Mattermost not reachable after upgrade to 5.4.0 Troubleshooting	4	2803	June 29, 2020
[solved] Mattermost server doesn't work after instalation.Failed to create index Error 1071 Troubleshooting	6	2165	April 25, 2020
Update from 5.28 to 5.35.2: SQL-ERROR Troubleshooting	14	2126	January 12, 2022
Upgrading from 5.25.0 Mattermost SQL Error Creating Database tables Troubleshooting	22	2274	March 9, 2021
Upgrading 5.31.1 Upgrade	1	345	July 19, 2023

Error on upgrade - failed to create index

Related topics