Known issues with podcasts

[madeofpendletonwool]

There are currently known issues with these podcasts. Something with their feeds. They won't add:

• Tested from NPR
• Hacking Postgres

[madeofpendletonwool]

Feel free to comment on this issue with any additional podcasts with issues. I will add them in to dig into

[wessel01]

https://www.thedutchhistorian.nl/geschiedenis/podcast adding this one causes the connection to MySQL to be lost and makes pinepods crash.

[madeofpendletonwool]

@wessel01 Hi there! Could you send me a link directly to the rss feed for that podcast rather than to their webpage? I can't find where an rss feed directly is in order to try adding.

[wessel01]

I found this one: https://feeds.buzzsprout.com/2192816.rss and the one on spotify; https://open.spotify.com/show/7EchOjkrIQUIugJr8QNn2L But I added it via the search button in Pinepods.

[wessel01]

Got another one. Search gave me a result and I selected that one. Searching for it gave me the url below.

https://www.omnycontent.com/d/playlist/33dbd2dc-d464-471d-9feb-abae00330078/02c417da-7875-4b3f-bc76-adfe00ac45fe/8d93de0b-dc66-46df-9e32-adfe00acbe42/podcast.rss

[madeofpendletonwool]

Hi @wessel01, what is the workflow you're expecting to get these to add? Adding those rss feeds you just provided seems to work? I'm able to play the audio and they show up okay in the feed. Even on the newest stable version. Are you expecting them to work in a different way? Am I missing something?

[wessel01]

Thanks for the quick response. I think I made a mistake in this one. It was another one causing the error. I removed both and currently it's working. I do get another error causing the container to stop. But I'll put that in a different issue unless it's already known. I'll try to fix that first before I continue spamming you with podcast that appear to be 'faulty'. Sorry for the inconvenience.

[EldritchGarden]

I have an issue with one podcast that is only showing 64 episodes

The search results show correctly, but after adding only 64 episodes are present. The relevant RSS feed is https://feeds.megaphone.fm/NSR9016694791

I noticed that when I add this podcast, through the the RSS feed link or from search, a 500 server error is logged and it says failed but the podcast is added and only shows 64 episodes.

From my digging it looks like maybe the description for one of the episodes might contain some invalid values or something:

EDIT:

Fixed it :)

If anyone runs into something similar, ensure your database and all tables are using utf8mb4 for the charset and utf8mb4_unicode_520_ci for collation.

[madeofpendletonwool]

Hey @EldritchGarden, thanks for bringing this up and good find for the fix. Are you using Mariadb/Mysql I assume? I do remember running into a similar issue in the past with Maria, which is why we add on those variables in the compose

``
MYSQL_COLLATION_SERVER: utf8mb4_unicode_ci
MYSQL_CHARACTER_SET_SERVER: utf8mb4

[madeofpendletonwool]

I'll try and highlight that this is a requirement more in the readme. I'm certain others have run into similar issues in the past.

[EldritchGarden]

Yes I'm using a dedicated MariaDB server, which doesn't use utf8mb4 by default