Upgrading to 2.0.12 from 2.0.0-beta217 (failed migrations)

[mutantspew]

Question
I'm having some trouble upgrading from 2.0.0-beta217 to 2.0.12. After downloading the release and running node server it's telling me the migration failed. I'm using PostgreSQL 10.10.

Host Info (please complete the following information):
OS: Ubuntu 18.04.3 LTS
Wiki.js version: 2.0.12
Database engine: PostgreSQL 10.10

When I run node server I get:
`-> % node server

Loading configuration from /var/www/wiki/config.yml... OK
2020-01-16T01:32:53.002Z [MASTER] info: =======================================
2020-01-16T01:32:53.010Z [MASTER] info: = Wiki.js 2.0.12 ======================
2020-01-16T01:32:53.011Z [MASTER] info: =======================================
2020-01-16T01:32:53.011Z [MASTER] info: Initializing...
2020-01-16T01:32:54.207Z [MASTER] info: Connecting to database...
2020-01-16T01:32:54.293Z [MASTER] info: Database Connection Successful [ OK ]
migration file "2.0.0-beta.217.js" failed
migration failed with error: alter table "locales" add column "availability" integer not null default '0' - column "availability" of relation "locales" already exists
2020-01-16T01:32:54.421Z [MASTER] error: Database Initialization Error: alter table "locales" add column "availability" integer not null default '0' - column "availability" of relation "locales" already exists`

[danyright]

Hi,
I have the same issue though using MariaDB instead of Postgresql.
OS: CentOS 7
Node 12.4.0

Same output (when trying to execute the script manually).
I wasn't sure whether to upgrade directly to 2.0.12 or whether I should go through RC first ?

Thanks for your help.
D

[NGPixel]

You should be able to upgrade directly to the latest version, but it can be worth a try.

[danyright]

I just tested with upgrades to v2.0.0-beta.230 & v2.0.0-rc.1 and got the same error.

Is there a way to only copy data and config from the install ?

[danyright]

Any news regarding this ?
Thanks for your help @NGPixel

Regards,
D

[mutantspew]

any updates on this?

[valeriob]

Maybe related #1363