ncarlier / readflow

readflow is a news-reading (or read-it-later) solution focused on versatility and simplicity.
https://about.readflow.app
GNU Affero General Public License v3.0
413 stars 33 forks source link

Migration issue in docker image #39

Closed Michaelpalacce closed 2 years ago

Michaelpalacce commented 2 years ago

Trying to run readflow with docker but I am getting the following error:

{"level":"warn","version":1,"time":1641044388,"message":"Migrating Database..."} {"level":"warn","version":2,"time":1641044391,"message":"Migrating Database..."} {"level":"warn","version":3,"time":1641044392,"message":"Migrating Database..."} {"level":"warn","version":4,"time":1641044393,"message":"Migrating Database..."} {"level":"warn","version":5,"time":1641044393,"message":"Migrating Database..."} {"level":"warn","version":6,"time":1641044393,"message":"Migrating Database..."} {"level":"warn","version":7,"time":1641044393,"message":"Migrating Database..."} {"level":"warn","version":8,"time":1641044394,"message":"Migrating Database..."} {"level":"warn","version":9,"time":1641044394,"message":"Migrating Database..."} {"level":"warn","version":10,"time":1641044394,"message":"Migrating Database..."} {"level":"fatal","error":"pq: syntax error at or near \"VALUE\"","time":1641044394,"message":"Unable to apply migration"}

ncarlier commented 2 years ago

Wich version of PostgreSQL are you using?

Michaelpalacce commented 2 years ago

9...I just realized you are targeting 14+, maybe add this as a requirement?

ncarlier commented 2 years ago

PostgreSQL 9 is no more supported. Readflow should work fine with PosgreSQL 10 to 14.