Smart playlist misbehaving - Printable Version

Smart playlist misbehaving - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Smart playlist misbehaving (/showthread.php?tid=362143)

Smart playlist misbehaving - slash13 - 2021-04-18

Hi all,

Hope this is in the right forum (wasn't sure if it should be here or in the Confluence/Xonfluence thread?).

I am having a very bizarre issue with one particular smart playlist - any help would be greatly appreciated.

Have not attached a debug log, as it takes several hours to replicate the issue, but happy to follow up with it if it's necessary.

System details: LibreELEC 9.2.6 (kernel: Linux 5.1.16), Kodi 18.9 Leia, Xonfluence skin

Media library details: content in separate folders on NAS - Movies Adults, Movies Teens, Movies Kids, TV Shows Adults, TV Shows Teens, TV Shows Kids

Problematic smart playlist details: "TV Shows Adults" (path contains "TV Shows Adults", path contains "TV Shows Teens", items must match one or more rules)

-------------------------------------------------------------------------------------------------

I recently transferred my media to a new NAS. I updated every single source link and smart playlist and made sure there are no old links left (using the Video Database Cleaner add-on).

Everything works perfectly and as before, except one particular smart playlst. "TV Shows Adults" now only shows the content from "TV Shows Teen" and four shows added to "TV Shows Adults" after the transfer to the new NAS. Nothing from "TV Shows Adults" that was added during with the original transfer to the new NAS is showing in the smart playlist "TV Shows Adults", for some reason.

The entire media collection is showing properly in the overall "TV Shows" section in Kodi and everything plays perfectly, including the entire content of "TV Shows Adults". So the media in question is definitely there and scrapes correctly - it just doesn't get filtered in this particular smart playlist for some reason.

It might help to illustrate with numbers:

The content is as follows: TV Shows Kids (10 items), TV Shows Teens (15 items), TV Shows Adults (20 items, 4 of which are newly added since the transfer). In Kodi, the overall category TV Shows contains 45 items, all correctly scraped and playable. However, the smart playlist "TV Shows Adults", which used to contain 35 items (TV Shows Teens + TV Shows Adults) now only contains 19 items (TV Shows Teens + the 4 recently added items in TV Shows Adults).

So far I have tried:

1) Deleting the smart playlist and recreating from scratch
2) Experimenting with every other option for the smart playlist ("path is", "path starts with", "path does not contain", etc)
3) Deleting the TV Shows Adults file source and re-adding it from scratch
4) Changing the content of TV Shows Adults file source and re-scraping
5) Re-scraping the missing items individually (using the Missing Media add-on and then setting the content for each item individually, ticking the "folder contains single TV Show option)

With options (3), (4) and (5) the "missing" items initially appear in the "TV Shows Adults" smart playlist, but as soon as I update the media library they appear to be getting scraped again, only to start disappearing from the smart playlist one by one. So as the media library is getting "updated" the number of items in the "TV Shows Adults" smart playlist starts dropping from 35 to 19 again. Argh!

Any idea what on Earth is going on and how do I fix this misbehaving smart playlist? I am hoping to avoid having to reinstall Kodi and/or the entire media library from scratch, if at all possible.

Many thanks in advance!

RE: Smart playlist misbehaving - FXB78 - 2021-04-18

You need to post the syntax of your Smart Playlist, without that it's all just guess work.

RE: Smart playlist misbehaving - slash13 - 2021-04-18

(2021-04-18, 14:20)FXB78 Wrote: You need to post the syntax of your Smart Playlist, without that it's all just guess work.

Thanks for the prompt response.

This is the entire content of the "TV Shows Adults" smart playlist (xsp) file - is this helpful?

Playlist.jpg

RE: Smart playlist misbehaving - FXB78 - 2021-04-18

(2021-04-18, 15:53)slash13 Wrote:
(2021-04-18, 14:20)FXB78 Wrote: You need to post the syntax of your Smart Playlist, without that it's all just guess work.

Thanks for the prompt response.

This is the entire content of the "TV Shows Adults" smart playlist (xsp) file - is this helpful?

Playlist.jpg

Yes, thanks. Can you check the side blade & make sure you have it set to All Videos, rather than Watched/Unwatched:

RE: Smart playlist misbehaving - slash13 - 2021-04-18

(2021-04-18, 16:16)FXB78 Wrote:
(2021-04-18, 15:53)slash13 Wrote:
(2021-04-18, 14:20)FXB78 Wrote: Yes, thanks. Can you check the side blade & make sure you have it set to All Videos, rather than Watched/Unwatched:

Yes, it's set to All Videos (the side blade doesn't seem to be available in Xonfluence, but when I switch to Estuary it says "All Videos" and the number of items is 19, i.e. the "original" items continue to be omitted from this playlist for some reason).

RE: Smart playlist misbehaving - slash13 - 2021-04-18

(2021-04-18, 16:41)slash13 Wrote:
(2021-04-18, 16:16)FXB78 Wrote:
(2021-04-18, 15:53)slash13 Wrote:
Yes, it's set to All Videos (the side blade doesn't seem to be available in Xonfluence, but when I switch to Estuary it says "All Videos" and the number of items is 19, i.e. the "original" items continue to be omitted from this playlist for some reason).

As is probably evident from the syntax, it's a very simple playlist, so in theory at least there should be very little that could get messed up. All the other smart playlists I have were created in the exact same way (using the GUI) and continue to work fine.

Could the issue be with the video library instead? Maybe something got corrupted along the way that screws up the filtering of this particular playlist?

RE: Smart playlist misbehaving - FXB78 - 2021-04-18

No idea, what happens if you just have TV Adults in the playlist, does it still just show 4 TV Shows?

RE: Smart playlist misbehaving - slash13 - 2021-04-18

(2021-04-18, 21:15)FXB78 Wrote: No idea, what happens if you just have TV Adults in the playlist, does it still just show 4 TV Shows?

Interesting thought. I just checked and yes - if I remove TV Teens from the playlist the only items left are the 4 recently added shows from TV Adults.

This problem is so weird...

I’m wondering if deleting myvideos.db and restarting Kodi might fix it?

RE: Smart playlist misbehaving - FXB78 - 2021-04-18

(2021-04-18, 22:36)slash13 Wrote:
(2021-04-18, 21:15)FXB78 Wrote: No idea, what happens if you just have TV Adults in the playlist, does it still just show 4 TV Shows?

Interesting thought. I just checked and yes - if I remove TV Teens from the playlist the only items left are the 4 recently added shows from TV Adults.

This problem is so weird...

I’m wondering if deleting myvideos.db and restarting Kodi might fix it?

Would be worth checking that to narrow it down, you could even just temp rename the file so you can restore it if need be.

RE: Smart playlist misbehaving - slash13 - 2021-04-19

(2021-04-18, 23:06)FXB78 Wrote:
(2021-04-18, 22:36)slash13 Wrote:
(2021-04-18, 21:15)FXB78 Wrote: No idea, what happens if you just have TV Adults in the playlist, does it still just show 4 TV Shows?

Interesting thought. I just checked and yes - if I remove TV Teens from the playlist the only items left are the 4 recently added shows from TV Adults.

This problem is so weird...

I’m wondering if deleting myvideos.db and restarting Kodi might fix it?
Would be worth checking that to narrow it down, you could even just temp rename the file so you can restore it if need be.

So I renamed myvideos.db and re-scanned my entire media library. Hey presto, the playlist in question is back to working as it should be. This makes me think it was clearly the database that went corrupt for some unknown reason.

I was hoping to avoid having to re-scan everything, and I never found out what caused the issue in the first place, but everyhing is back to normal now and I guess that's the main thing.

Thanks again for your input!