Problems migrating miniflux database v1 to v2

[js32]

Hi guys,

I'm having problems migrating the sqlite database of my old mini flux legacy installation to a news one. I could keep the old installation as it is running smoothly for years but I want to upgrade to Ubuntu 22.04 and mini flux doesn't seem to be compatible with php8, as far as I can tell.

Im running Ubuntu 20.04.6 LTS and followed these guides: Installation, Migration.

I'm running the following command

php scripts/migrate-v2.php --dsn="pgsql:host=localhost;dbname=miniflux;user=miniflux;password=PASSWORD"

and get the following error

* 1 user(s) to migrate
* Migrating user: #1 => #2
* Migrating integrations

SQLSTATE[42703]: Undefined column: 7 ERROR:  column "fever_password" of relation "integrations" does not exist
LINE 18:             fever_password,
                     ^

My next step would be to add a column "fever_password" to the postgresql database table but I am not sure how.

Or is there any other way?

Thanks so much!

[fguillot]

I suggest installing the very first version of Miniflux v2 to migrate from v1. The database schema changed many times between the v2.0.0 and v2.0.44.

[js32]

Hi @fguillot! Thanks for your suggestion! I managed to fix this by deleting line 58 and line 81 in the script.

Meanwhile I've had another problem Not null violation: 7 ERROR: null value in column "changed_at" violates not-null constraintwhich I managed to fix by adding "changed_at" after "starred" in Line 157, one more question mark in line 158 and date('Y-m-d H:i:s') after line 190.

Your solution probably would have been easier :)

Thanks anyway! Maybe I'll try another route when doing the migrations with a docker setup.