Guest - Testers are needed for the reworked CDateTime core component. See... https://forum.kodi.tv/showthread.php?tid=378981 (September 29) x
Smart Playlists are Emptying Themselves
#1
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.
Reply
#2
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.
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki)  ||  Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#3
(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?
Reply
#4
Did you restart Kodi after enabling Debug Mode?

Kodi Paste Site accepts approx 15,000 lines per paste. Maybe split the log in two?
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki)  ||  Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#5
Thread moved to the general support section
|Banned add-ons (wiki)|Forum rules (wiki)|VPN policy (wiki)|First time user (wiki)|FAQs (wiki) Troubleshooting (wiki)|Add-ons (wiki)|Free content (wiki)|Debug Log (wiki)|

Kodi Blog Posts
Reply
#6
(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
Reply
#7
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.
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki)  ||  Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#8
(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.
Reply

Logout Mark Read Team Forum Stats Members Help
Smart Playlists are Emptying Themselves0