Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Library pane is empty - yet again

  1. #1
    Join Date
    Oct 2012
    Posts
    134

    Default Library pane is empty - yet again

    Im seeing repeated instances of the library view being empty. I've had this before many months again and ended up having to rebuild my whole database from scratch because the backup was pretty old.
    (Still no way to automate the backup system )

    For clarity here... the LIBRARY isnt empty - I just cant see it. The window where it should be is empty. I can stream files from it - but obviously as the library window is empty I cant actually do anything such as edit or create playlists.

    It happened again earlier in the week. I sorta got it working again by:
    backing up the database
    uninstall
    reboot
    reinstall
    restored the database.

    All seemed well. But its just done it again.
    I have been having some issues with a USB hub failing in the machine, but I wouldn't have expected this to render the library pane empty.

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

    Default

    Hi,
    you can automate backups using Windows Task Scheduler and a batch file. Create a batch file called backup_mezzmo.bat and set the contents as:

    COPY c:\mymezzmodb\Mezzmo.db c:\mymezzmobackups\Mezzmo_%time:~0,2%%time:~3,2%%t ime:~6,2%_%date:~-10,2%%date:~-7,2%%date:~-4,4%.db

    You will need to change the path to the Mezzmo.db file to match what is in your Options page in Mezzmo for the path to the db.

    Create a scheduled task in Windows and set it to run the backup_mezzmo.bat file.

    The library appears empty when the Library item is missing from the database. You can restore it using an sqlite editor and running:

    INSERT INTO "MGOPlaylist" VALUES(0,'Library',16,'Your collection of music files, video files and photos',-1,0,0,':1:',NULL,NULL,NULL,NULL,0,NULL,0,0,NULL,NU LL,NULL,0,NULL,1,1,0,1,'',NULL,NULL,0);

    If the Music, Video or Photos playlist is also missing you can run the following sql:

    INSERT INTO "MGOPlaylist" VALUES(3,'Music',16,'Playlist for all your music files and music playlists',0,8,61,':4:',NULL,NULL,NULL,NULL,0,NULL ,0,0,NULL,NULL,NULL,1,NULL,2,1,0,1,'',NULL,NULL,0) ;

    INSERT INTO "MGOPlaylist" VALUES(15,'Video',16,'Playlist for all your videos and video playlists',0,10,62,':12:',NULL,NULL,NULL,NULL,0,NU LL,0,0,NULL,NULL,NULL,2,NULL,14,1,0,1,'',NULL,NULL ,0);

    INSERT INTO "MGOPlaylist" VALUES(30,'Photos',16,'Playlist for all your photos and photo slideshows',0,9,63,':20:',NULL,NULL,NULL,NULL,0,NU LL,0,0,NULL,NULL,NULL,3,NULL,20,1,0,1,'',NULL,NULL ,0);

    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
    Oct 2012
    Posts
    134

    Default

    Thanks

    Ill try that to restore if it disappears again. Though ideally stopping it from doing so be a nicer option

  4. #4
    Join Date
    Oct 2012
    Posts
    134

    Default

    This has just happened yet again.

    Remembering that I had posted about it before I looked at the solution.
    Unfortunately I dont have any SQL applications on my media server machine. I did try downloading a SQL editor but when I try to execute the first command as above I get:
    Execution finished with errors.
    Result: attempt to write a readonly database
    At line 1:
    INSERT INTO "MGOPlaylist" VALUES(0,'Library',16,'Your collection of music files, video files and photos',-1,0,0,':1:',NULL,NULL,NULL,NULL,0,NULL,0,0,NULL,NU LL,NULL,0,NULL,1,1,0,1,'',NULL,NULL,0);
    Im not familiar with SQL so I have no idea what the issue is. I did close mezzmo first, then I also tried copying the mezzmo.db file and tried opening that and running the command on the copy and get the same error.

    In any case this isnt really a solution - the solution would be for it not to do this following a reboot - which it has done several times now.

  5. #5
    Join Date
    Sep 2009
    Posts
    2,522

    Default

    When rebooting it is possible that the database is not closed correctly. Mezzmo does cause the Windows shutdown to wait until it has closed the database but it is possible for this to be overridden or if the reboot is unexpected (power loss or restart button) then the database may suffer damage.

    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

  6. #6
    Join Date
    Oct 2012
    Posts
    134

    Default

    Its now happening almost every time I reboot the machine. Which isnt that often but having to backup and restore the database each time I do isnt exactly ideal.

  7. #7
    Join Date
    Sep 2009
    Posts
    2,522

    Default

    Before rebooting the machine can you please try running the Mezzmo application and stop the Mezzmo server then exit Mezzmo to see if the database remains intact after the reboot?

    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

  8. #8
    Join Date
    Oct 2012
    Posts
    134

    Default

    Will do.
    Thanks

  9. #9
    Join Date
    Oct 2012
    Posts
    134

    Default

    Tried this. Didnt help.
    I also tried resetting the database, stopping the server and closing mezzmo. Then I rebooted again - and even with an empty database on restart the pane is empty.

  10. #10
    Join Date
    Sep 2009
    Posts
    2,522

    Default

    If it is happening after stopping the server and exiting Mezzmo then it could be an issue with the drive. Is the Mezzmo database stored in the default location on the main drive?

    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. No TV in Play To.. pane
    By davidlee in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 08-06-2018, 08:21 AM
  2. No TV in Play To.. pane
    By Andy1687 in forum Mezzmo Questions and Support
    Replies: 2
    Last Post: 02-01-2017, 04:54 AM
  3. Replies: 3
    Last Post: 12-11-2015, 08:40 AM
  4. Tutorial: How to start again with an empty Mezzmo library / database
    By Paul in forum Mezzmo FAQs & How To Guides
    Replies: 0
    Last Post: 07-02-2014, 01:09 PM
  5. Search Pane broken
    By Allan Dwyer in forum Mezzmo Questions and Support
    Replies: 3
    Last Post: 06-14-2014, 07:57 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
  •