Summary I’m trying to upgrade our self hosted server from v5.26.1 to 5.34.2 and the server is reporting errors when starting: {"level":"error","ts":1620821782.9717069,"caller":"sqlstore/store.go:170","msg":"Failed to apply database migrations.","error":"migration failed: syntax error at or near \"…

You should upgrade to at least PostgreSQL version 10.x (older versions are no longer supported Important Upgrade Notes — Mattermost 5.34 documentation ) and then you can follow the suggestions below to fix the error. Connect to your postgresql instance and delete the data in the migrations table lik…

Upgrade problem from 5.26.1 to 5.34.2

Troubleshooting

nickolasdeluca (Nickolas Deluca) May 12, 2021, 10:30pm 3

Worked like a charm. Thanks a lot!

Topic		Replies	Views
Database migration problem when upgrading from 4.8.0 to 5.37 (solved) Troubleshooting	0	800	July 30, 2021
Update from 5.28 to 5.35.2: SQL-ERROR Troubleshooting	14	2128	January 12, 2022
Error on upgrade - failed to create index Troubleshooting	7	951	November 7, 2020
Upgrade from 5.39.2 to 6.x Troubleshooting	1	745	August 28, 2022
Database migration Troubleshooting	3	4077	January 6, 2022

Upgrade problem from 5.26.1 to 5.34.2

Related topics