All playlists throw error 500

[paulmorabito]

Hi, all of my playlists including ones that I have made throw an error 500 when trying to view. The playlist I created also has zero episodes even though many meet the criteria. There is nothing in the logs to indicate an error. I am happy to provide additional details as needed. Many thanks.

[madeofpendletonwool]

Hmm... Do you have debug mode enabled in your compose file. If not do so, then open a playlist on the web side and monitor the container logs. If there's any kind of error it should be logging it. So I'm almost certain there should be something. I haven't been able to replicate your issue so I'll need that error that should be appearing with debug enabled.

[paulmorabito]

logs here:

2026-01-10T22:11:53.670389Z  INFO request{method=GET uri=/api/data/verify_key version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=0 ms status=200
2026-01-10T22:11:53.671018Z  INFO request{method=GET uri=/api/data/get_server_default_language version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=0 ms status=200
2026-01-10T22:11:53.678945Z  INFO request{method=GET uri=/api/data/get_server_default_language version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=0 ms status=200
2026-01-10T22:11:53.679525Z  INFO request{method=GET uri=/api/data/public_oidc_providers version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=1 ms status=200
2026-01-10T22:11:53.680546Z  INFO request{method=GET uri=/api/data/verify_key version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=0 ms status=200
2026-01-10T22:11:53.680822Z  INFO request{method=GET uri=/api/data/get_available_languages version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=1 ms status=200
2026-01-10T22:11:53.681201Z  INFO request{method=GET uri=/api/data/self_service_status version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=2 ms status=200
2026-01-10T22:11:53.695992Z  INFO request{method=GET uri=/api/data/get_theme/2 version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=2 ms status=200
2026-01-10T22:11:53.696235Z  INFO request{method=GET uri=/api/data/get_user_language?user_id=2& version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=1 ms status=200
2026-01-10T22:11:53.703063Z  INFO request{method=GET uri=/api/data/get_theme/2 version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=1 ms status=200
2026-01-10T22:11:53.704534Z  INFO request{method=GET uri=/api/data/get_time_info?user_id=2& version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=2 ms status=200
2026-01-10T22:11:53.708963Z  INFO request{method=GET uri=/api/data/get_pinepods_version version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=0 ms status=200
2026-01-10T22:11:53.710978Z ERROR request{method=GET uri=/api/data/get_playlist_episodes?user_id=2&playlist_id=10& version=HTTP/1.0}: pinepods_api::error: API Error: 500 - Database error: error occurred while decoding column "PodcastIDs": mismatched types; Rust type `core::option::Option<alloc::string::String>` (as SQL type `VARCHAR`) is not compatible with SQL type `BLOB`
2026-01-10T22:11:53.711052Z  INFO request{method=GET uri=/api/data/get_playlist_episodes?user_id=2&playlist_id=10& version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=2 ms status=500
2026-01-10T22:11:53.711059Z ERROR request{method=GET uri=/api/data/get_playlist_episodes?user_id=2&playlist_id=10& version=HTTP/1.0}: tower_http::trace::on_failure: response failed classification=Status code: 500 Internal Server Error latency=2 ms
2026-01-10T22:11:53.714644Z  INFO request{method=GET uri=/api/data/get_time_info?user_id=2& version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=1 ms status=200
2026-01-10T22:11:53.716199Z  INFO request{method=GET uri=/ws/api/tasks/2?api_key=p0hLRnnXi9GO7sMO07XZAbDyR9KtpNK0cQnful6gj7KL0sqUNCJP6bDB61kOnhvX version=HTTP/1.1}: tower_http::trace::on_response: finished processing request latency=1 ms status=101
2026-01-10T22:11:53.717791Z  INFO request{method=GET uri=/api/data/get_user_language?user_id=2& version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=1 ms status=200
2026-01-10T22:11:53.728842Z  INFO request{method=POST uri=/api/data/get_unmatched_podcasts version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=2 ms status=200
2026-01-10T22:11:53.729636Z  INFO request{method=GET uri=/api/data/get_user_language?user_id=2& version=HTTP/1.0}: tower_http::trace::on_response: finished processing request latency=1 ms status=200

looks like its this line specifically:

pinepods_api::error: API Error: 500 - Database error: error occurred while decoding column "PodcastIDs": mismatched types; Rust type `core::option::Option<alloc::string::String>` (as SQL type `VARCHAR`) is not compatible with SQL type `BLOB`

I'm running my own mariadb if that helps and latest version via docker.

[paulmorabito]

I tried:

ALTER TABLE Podcasts MODIFY COLUMN PodcastIDs TEXT;

And got other SQL errors so I guess a migration script has not run during setup. For context, I started with a fresh install.

I re-created everything using Postgres this time and its all fine.

[RianBrand]

I am not sure if this is related, but I am currently also getting a "Server returned error: 500" on Fresh Releases https://try.pinepods.online/playlist/4

It seems all other playlists are loading and the Fresh Releases thumbnail on the website shows 5 episodes.