Kodi Community Forum
Smart Playlists are Emptying Themselves - 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 Playlists are Emptying Themselves (/showthread.php?tid=359486)



Smart Playlists are Emptying Themselves - rockbox948 - 2020-12-31

Kodi 18.8
Skin:  Amber
Database:  MariaDB 10.4.17

I recently decided to move to using the database method as the number of Kodi devices I own keeps increasing.  I've been able to trudge through so far until I hit this wall with the smart playlists emptying themselves.

My current file structure is as follows:

Entertainment Folder
* Anime Folder
* Cartoons Folder
* Documentaries Folder
* Movies Folder
* TV Shows Folder
* Music Folder


I have a kid and decided to split out the cartoons from the TV Shows.  Having Batman: The Animated Series right next to Breaking Bad just wasn't going to work.  That split lead to me pulling the anime and documentaries out into their own folders as well.  I thought I could just set up new categories on the Home Menu and link to each of the folders with no issue.  Little did I know that doing so is apparently not possible and that I would need to create smart playlists for each of the folders then add the playlists to the Home Menu.

I followed the process I found describing how to do so and the anime folder/playlist worked great.  Videos were there, the fanart and cover art were all showing up as they should.  I proceeded to follow the same process for cartoons and documentaries.  Kodi updated the libraries and suddenly all of the playlists were empty.  I made no changes. 

I tried changing the rules for the playlist, deleting and remaking the playlist, etc. but now the playlist will not reacquire content.  It is almost like once the playlist is created relating to the folder, it cannot be remade once it empties itself.

I thought this may have been an issue caused by operating outside of the boundaries TV Shows/Movie folder confines.  I tested by making a "Bond" playlist for the James Bond movies in the Movie folder.  The Bond playlist worked great.  Videos were there, the fanart and cover art were all showing up as they should.  I updated the Kodi libraries and suddenly the Bond playlist was empty.

I'm at a loss.

xml:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<smartplaylist type="musicvideos">
    <name>Anime</name>
    <match>all</match>
    <rule field="path" operator="startswith">
        <value>smb://192.168.1.77/Entertainment/Anime/</value>
    </rule>
    <order direction="ascending">title</order>
</smartplaylist>

Note that the playlist type says "musicvideos" as that was the last test I ran to see if that would help.  It didn't.

Any guidance is welcome.  I was going to upload my logs but paste.kodi.tv said it was too long.


RE: Smart Playlists are Emptying Themselves - Karellen - 2020-12-31

It sounds like there is a problem with your MySQL setup.

Can you provide a Debug Log which captures an Update Library. It might reveal errors in the library.


RE: Smart Playlists are Emptying Themselves - rockbox948 - 2020-12-31

(2020-12-31, 04:38)Karellen Wrote: It sounds like there is a problem with your MySQL setup.

Can you provide a Debug Log which captures an Update Library. It might reveal errors in the library.

Thanks for the quick reply.  I tried to use paste.kodi.tv but it gave an error saying the log was too long.  I tried paste.ubuntu.com and there seems to bee an error with their server.  Do you have any other option I could use to get the log to you?


RE: Smart Playlists are Emptying Themselves - Karellen - 2020-12-31

Did you restart Kodi after enabling Debug Mode?

Kodi Paste Site accepts approx 15,000 lines per paste. Maybe split the log in two?


RE: Smart Playlists are Emptying Themselves - DarrenHill - 2020-12-31

Thread moved to the general support section


RE: Smart Playlists are Emptying Themselves - rockbox948 - 2020-12-31

(2020-12-31, 05:38)Karellen Wrote: Did you restart Kodi after enabling Debug Mode?

Kodi Paste Site accepts approx 15,000 lines per paste. Maybe split the log in two?

I actually did not restart so the log I have shows everything I did yesterday.  I'm new to this so bear with me.  If what I have is not what you need, I will restart and get the log then.  The log links are below.  Thanks for your help and your patience=)

Part 1
Part 2


RE: Smart Playlists are Emptying Themselves - Karellen - 2020-12-31

Unfortunately your setup is full of errors.

Update to v18.9 to fix your http errors.

Your MariaDB setup is not working. Check errors at line 190 of your first log. Maybe @Klojum can offer further advice.


RE: Smart Playlists are Emptying Themselves - rockbox948 - 2020-12-31

(2020-12-31, 19:13)Karellen Wrote: Unfortunately your setup is full of errors.

Update to v18.9 to fix your http errors.

Your MariaDB setup is not working. Check errors at line 190 of your first log. Maybe @Klojum can offer further advice.
Thanks for taking a look.  I really appreciate it.  I'll start from scratch with 18.9 and see if that helps.