Episodes incorrectly ignored due to duplicate titles

[batinicaz]

I am using the latest version of PinePods (0.8.2).

I subscribe to a number of sports podcasts that tend to re-use similar titles e.g. named after the game that was most recently played. This means that a feed that has many years worth of episodes has multiple episodes with the same title.

There is no error or log message I just see that the refresh reports "0 new episodes".

I am no developer and don't know rust, so I could be well off here. But I wanted to try to give a useful bug report so I went digging to see if I could find where the problem might be, and I think it might be in: https://github.com/madeofpendletonwool/PinePods/blob/main/rust-api/src/database.rs

During feed refresh it does:

SELECT episodeid FROM "Episodes"
WHERE podcastid = $1 AND (episodetitle = $2 OR episodeurl = $3)

If I follow this correctly then I think that means a new episode with the same title as any existing episode is silently treated as an update rather than a new episode even if it has a completely different URL. So I think flipping that OR to an AND is all that is needed?

Hopefully this is vaguely right/helpful!