Feed Podcast Query Too Long
-
Hi, we just started getting “KILLED QUERY (16395 characters long generated in /nas/content/live/dicast/wp-content/plugins/seriously-simple-podcasting/php/classes/handlers/class-feed-handler.php:655)” errors when we try and load our feed podcast page. This means that no podcasts are showing on the feed page (and are not getting pulled into external providers). This started happening in the last week and I believe it’s because of the number of published podcasts we now have.
I did some tracing back and I think the issue is that ssp_episode_ids returns all the ids of published episodes. Thus, when the query is created for the feed page, it has a where query for post__in and then a list of every single published podcast id. Since we now have over 2,770 published podcasts (and counting), the number of characters in the query is too long causing it to be killed (I think by our hosting provider, but maybe by the database).
We have already set the max number of posts for the feed to 200 and that is returning correctly from ssp_feed_max_episodes.
Is there a way to limit the number of ssp_episode_ids that are returned to the query? It seems like it might be possible to limit it to the ssp_feed_max_episodes number (or slightly more) and still return the same episodes depending on when the ordering is done in the query.
Thanks for your help!
You must be logged in to reply to this topic.