excited by new version with a fix for a issue I encountered, I just updated to latest Docker image from previous. But API refuse to start with the following errors.
2023/07/10 20:31:53 No config file found, using default or config from environment variables.
2023-07-10T20:31:53.570807968Z: CRITICAL ▶ migration/Migrate 051 Migration failed: migration 20221113170740 failed: pq: column "list_id" does not exist
info: creating the new user vikunja with 1000:1000
usermod: no changes
Normale docker installation, postgres database, vikunja user has superuser rights.
You could do the migration manually. You’d need to look at the code here and do all the steps manually. It probably crashed mid-way in a previous attempt.
Once you’re done, you need to add 20221113170740 to the migrations table.
Thanks, the migration stopped after column rename but before table rename.
It is possible that this was caused by vikunja database user not having superuser right at the time of first migration attempt? My vikunja database user is “just” the database owner…
You are right about backup, but I just installed the software few days ago for experimenting. But I’m going to setup a backup now.