Skip to content

Problems migrating miniflux database v1 to v2 #1886

Description

@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!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions