From 916fc3c86ccbff77fea08e370caf7456eee62e91 Mon Sep 17 00:00:00 2001 From: girst Date: Tue, 31 Oct 2023 13:15:51 +0000 Subject: [PATCH] noshorts: always show videos with undeterminate shorts status i.e, when shorts=NULL (can happen when we can't get metadata). otherwise all videos during the metadata outage (e.g. ip blocked) won't show. --- app/youtube/__init__.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/app/youtube/__init__.py b/app/youtube/__init__.py index d0f5db9..1ddfe60 100644 --- a/app/youtube/__init__.py +++ b/app/youtube/__init__.py @@ -56,7 +56,7 @@ def feed(): OR playlist_videos.playlist_id IN (SELECT channel_id FROM subscriptions WHERE user=? AND type = 'playlist') OR flags.display = 'pinned') AND flags.display IS NOT 'hidden' - AND (flags.display = 'pinned' OR not ? or not shorts) + AND (flags.display = 'pinned' OR not ? or shorts is null or not shorts) ORDER BY (display = 'pinned') DESC, crawled DESC LIMIT 36 OFFSET 36*?""", (token, token, token, settings.get('noshorts', False), page)) -- 2.39.3