Results 1 to 4 of 4

Thread: Smart playlists showing -1 items

  1. #1
    Join Date
    Jun 2020
    Posts
    2

    Question Smart playlists showing -1 items

    I set up smart playlists for specific actors (as all actors is way too many), and had everything working fine for months. As of about a month ago all of these custom smart playlists started showing empty folders and -1 items. I'm not sure what may have changed.

    They are very simple setups. Here's an example of the properties used:

    Match all of the following rules.

    Artist/Actors contains Adam Sandler.

    Restrict to video files.

    Sort by title (ascending).

    No limit set.


    Why am I suddenly seeing -1 items and empty folders? Default smart playlists work fine, e.g. Recently Added.


    Thanks for your help

  2. #2
    Join Date
    Sep 2009
    Posts
    2,345

    Default

    This could be caused by database corruption. Please enable diagnostic logging http://www.mezzmo.com/wiki/doku.php?id=using_logging&s[]=diagnostic then after restarting Mezzmo try browsing the playlist then check in the log to see if there is a database error reported (look for DBE >)

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

  3. #3
    Join Date
    Jun 2020
    Posts
    2

    Default

    Hi Peter,

    Yep. Quite a few DBE's in the Mezzmo folder. Around 30 or so just viewing one actor's playlist with logging turned on.

    Is there a way to repair the database?

  4. #4
    Join Date
    Sep 2009
    Posts
    2,345

    Default

    You can try going to Maintenance Tools and perform a compact to see if this helps but this may fail because of the errors http://www.mezzmo.com/wiki/doku.php?...enance_tools&s[]=compact. The best approach is to load a backup of the database if you have one as it is not clear if the database damage is limited to just this table or other tables.

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

Similar Threads

  1. Toshiba Smart TV not showing all files
    By Tank in forum Mezzmo Questions and Support
    Replies: 5
    Last Post: 04-12-2018, 08:46 AM
  2. Smart PlayLists and Smart Tv's
    By Corpse in forum Mezzmo Wish List and Feedback
    Replies: 1
    Last Post: 03-07-2017, 03:38 PM
  3. Smart playlist showing deleted files
    By HomerRamone in forum Mezzmo Questions and Support
    Replies: 8
    Last Post: 07-11-2014, 01:15 AM
  4. Smart playlists -- Match all/any
    By jdlk in forum Mezzmo Wish List and Feedback
    Replies: 4
    Last Post: 02-22-2013, 07:58 AM
  5. V2.6 Database showing duplicate Video files under Playlists
    By Bodders-11 in forum Mezzmo Questions and Support
    Replies: 19
    Last Post: 06-01-2012, 09:28 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •