I set up AntennaPod to sync with PodFetch (Postgres database) using the GPodder API as described by the docs. The login works just fine but whenever I try to sync through the app it fails. Looking at the logs I see this:
podfetch-podfetch-1 | thread 'actix-rt|system:0|arbiter:0' panicked at src/models/subscription.rs:153:26:
podfetch-podfetch-1 | called `Result::unwrap()` on an `Err` value: DatabaseError(Unknown, "column \"deleted\" is of type timestamp without time zone but expression is of type integer")
podfetch-postgres-1 | 2023-11-17 04:49:52.200 UTC [233] ERROR: column "deleted" is of type timestamp without time zone but expression is of type integer at character 109
podfetch-postgres-1 | 2023-11-17 04:49:52.200 UTC [233] HINT: You will need to rewrite or cast the expression.
podfetch-postgres-1 | 2023-11-17 04:49:52.200 UTC [233] STATEMENT: INSERT INTO "subscriptions" ("username", "device", "podcast", "created", "deleted") VALUES ($1, $2, $3, $4, $5)
Is this an error in my set up? Is there a migration I should run first? Or is there a bug in the GPodder API implementation? Happy to give more info if needed. Thanks!
Reproduction
Run PodFetch with Postgres backend. Try to sync using AntennaPod. See error in PodFetch logs.
System Info
Docker (using the provided Docker Compose example), running the `latest` image and the Postgres database.
Describe the bug
I set up AntennaPod to sync with PodFetch (Postgres database) using the GPodder API as described by the docs. The login works just fine but whenever I try to sync through the app it fails. Looking at the logs I see this:
Is this an error in my set up? Is there a migration I should run first? Or is there a bug in the GPodder API implementation? Happy to give more info if needed. Thanks!
Reproduction
Run PodFetch with Postgres backend. Try to sync using AntennaPod. See error in PodFetch logs.
System Info
Used Package Manager
npm
Validations