Results 1 to 5 of 5

Thread: Multiple movie entries

  1. #1

    Default Multiple movie entries

    I have roughly 1600 movies. The MOGFile table shows I have 3630.

    There are quite a few movies duplicated 2 - 4 times.

    Is there a way to remove these besides deleting them manually from the table?

  2. #2
    Join Date
    Nov 2007
    Location
    Melbourne, Australia
    Posts
    11,639

    Default

    My guess is there are multiple paths for each file - for example, F:\Videos\Troy.mkv and \\NAS\movies\Troy.mkv. Either you have moved your files and re-added them into your Mezzmo library, or Mezzmo has picked up a backup of your files when scanning your drives, or some other scenario that you can probably best explain. Given you are looking at the MGOFile database table, you should be able to find the multiple entries for a particular file and find out what Mezzmo has added into your Mezzmo library. That will help explain what has happened.

    To remove the unwanted files, I'd suggest creating a temporary smart playlist in Mezzmo. Click 'Create Playlist' -> 'Smart Playlist'. On the Smart Playlist Properties dialog, add a rule like: [File Path] [starts with] [F:\Videos] and click OK (where F:\Videos is the path that for the files the you don't want in your Mezzmo library). Now wyou will see a smart playlist listing all these unwanted files. Select all of them (press Ctrl+A) and hit the DEL key to delete them from your Mezzmo library. Once deleted, you can also delete the smart playlist.

    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

    Default

    The multiple paths fixed a couple thousands entries.
    At one time I used the Maintain Library Tool to change all my paths from drive:\ to \\server. Seems it keep both copies.

    Now, the remaining 200 issues:
    Multiple Entires that are the same except for the filesize
    Dual entries that start with \video_ts\vts_01_1.vob and \video_ts\vts_03_1.vob or similar vob files

    Any suggestions on how to fix these ones?

  4. #4
    Join Date
    Nov 2007
    Location
    Melbourne, Australia
    Posts
    11,639

    Default

    You cannot have multiple entries with the exact same file paths. Mezzmo & its database does not let you do this. The remaining 200 entries must be different in their file path in some way. You mention having many related .vob files. They are each video files, so it is OK to have these in your Mezzmo library (although Mezzmo will see these .vob files as a possible DVD rip and will read the accompanying .IFO files to determine the videos within the DVD rip and add them into your Mezzmo library as gapless multi-files).

    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

  5. #5

    Default

    Won't be readable as is but cut&paste into notepad lines it all up

    Same file Paths
    ============


    ID TypeUID File DateAdded PlayCount Size Title ExtensionID Resolved ArtistID AlbumID GenreID Year Month Description Duration Track BitRate CreatorID SampleRate Width Height ColorDepth Ranking AudioCodec VideoCodec ThumbnailID DateLastPlayed FullDate ProtocolInfo ServerName AdditionalInformationID AVContainer AudioChannels Level AlbumArtistID AudioBitrate VideoProfile FrameRate AspectRatio Flags1 Flags2 SubtitlePath MTAPath FileTitle PacketSize StartOffset EndOffset BitsPerVideoSample Disc VideoIdx AudioIdx OnlyStreamPreferredChannels CodecTag IMDB_ID TheTVDB_ID TheMovieDB_ID URL ReleaseDate Tagline BackdropArtworkID ContentRatingID SortTitle
    27 262148 #dv;1:1;0:4635754496;6095|\\server\movies2\#\16 blocks\video_ts\vts_01_1.vob|\\server\movies2\#\16 blocks\video_ts\vts_01_2.vob|\\server\movies2\#\16 blocks\video_ts\vts_01_3.vob|\\server\movies2\#\16 blocks\video_ts\vts_01_4.vob|\\server\movies2\#\16 blocks\video_ts\vts_01_5.vob 1453462816 0 4635754497 16 Blocks 1 1 2006 3 An aging cop is assigned the ordinary task of escorting a fast-talking witness from police custody to a courthouse, but they find themselves running the gauntlet as other forces try to prevent them from getting there. 6095 0 46515348 48000 720 480 0 3 ac3 mpeg2video 41 0 40159.7017708333 -1 mpeg 6 8 448000 4 29.97 16:9 PAR=32:27 0 0 [INVALID_DATA] Vts_01_1 (...) 0 0 4635754496 0 0 0 0 0 [0][0][0][0] tt0450232 2207 38779 For a New York cop and his witness, the distance between life and death just got very short. 19 309 16 Blocks
    1928 524288 #dv;1:1;0:4635901952;6095|\\server\movies2\#\16 blocks\video_ts\vts_01_1.vob|\\server\movies2\#\16 blocks\video_ts\vts_01_2.vob|\\server\movies2\#\16 blocks\video_ts\vts_01_3.vob|\\server\movies2\#\16 blocks\video_ts\vts_01_4.vob|\\server\movies2\#\16 blocks\video_ts\vts_01_5.vob 1453806550 0 4635901953 16 Blocks 4 1 0 0 6095 0 6084859 0 0 0 0 0 -1 0 -1 0 0 0 -99 0 0 [INVALID_DATA] Vts_01_1 (...) 0 0 4635901952 0 0 0 0 0 0 0 1 16 Blocks
    2037 524288 #dv;1:1;0:4635895808;6095|\\server\movies2\#\16 blocks\video_ts\vts_01_1.vob|\\server\movies2\#\16 blocks\video_ts\vts_01_2.vob|\\server\movies2\#\16 blocks\video_ts\vts_01_3.vob|\\server\movies2\#\16 blocks\video_ts\vts_01_4.vob|\\server\movies2\#\16 blocks\video_ts\vts_01_5.vob 1453905264 0 4635895809 16 Blocks 4 1 0 0 6095 0 6084850 0 0 0 0 0 -1 0 -1 0 0 0 -99 0 0 [INVALID_DATA] Vts_01_1 (...) 0 0 4635895808 0 0 0 0 0 0 0 1 16 Blocks


    220 262148 #dv;1:1;8192:4366870528;5852|\\server\movies4\b\ba d teacher\video_ts\vts_01_1.vob|\\server\movies4\b\b ad teacher\video_ts\vts_01_2.vob|\\server\movies4\b\b ad teacher\video_ts\vts_01_3.vob|\\server\movies4\b\b ad teacher\video_ts\vts_01_4.vob|\\server\movies4\b\b ad teacher\video_ts\vts_01_5.vob 1453462878 0 4366862337 Bad Teacher 1 1 2011 6 A lazy, incompetent middle school teacher who hates her job and her students is forced to return to her job to make enough money for a boob job after her rich fiancé dumps her. 5852 0 25709680 48000 720 480 0 2 ac3 mpeg2video 566 0 40998.6934606481 -1 mpeg 2 8 192000 4 30.25 16:9 PAR=32:27 0 0 [INVALID_DATA] Vts_01_1 (...) 0 8192 4366870528 0 0 0 0 0 [0][0][0][0] tt1284575 52449 http://www.areyouabadteacher.com/ 40713 She doesn't give an F. 263 310 Bad Teacher
    2055 524288 #dv;1:1;8192:4367067136;5852|\\server\movies4\b\ba d teacher\video_ts\vts_01_1.vob|\\server\movies4\b\b ad teacher\video_ts\vts_01_2.vob|\\server\movies4\b\b ad teacher\video_ts\vts_01_3.vob|\\server\movies4\b\b ad teacher\video_ts\vts_01_4.vob|\\server\movies4\b\b ad teacher\video_ts\vts_01_5.vob 1453905294 0 4367058945 Bad Teacher 4 1 0 0 5852 0 5970005 0 0 0 0 0 -1 0 -1 0 0 0 -99 0 0 [INVALID_DATA] Vts_01_1 (...) 0 8192 4367067136 0 0 0 0 0 0 0 1 Bad Teacher
    2071 524288 #dv;1:1;8192:4367216640;5852|\\server\movies4\b\ba d teacher\video_ts\vts_01_1.vob|\\server\movies4\b\b ad teacher\video_ts\vts_01_2.vob|\\server\movies4\b\b ad teacher\video_ts\vts_01_3.vob|\\server\movies4\b\b ad teacher\video_ts\vts_01_4.vob|\\server\movies4\b\b ad teacher\video_ts\vts_01_5.vob 1453905687 0 4367208449 Bad Teacher 4 1 0 0 5852 0 5970209 0 0 0 0 0 -1 0 -1 0 0 0 -99 0 0 [INVALID_DATA] Vts_01_1 (...) 0 8192 4367216640 0 0 0 0 0 0 0 1 Bad Teacher


    VOB
    ====


    328 262148 #dv;1:2;8192:2328109056;6687|\\server\movies3\c\ca tch and release\video_ts\vts_02_1.vob|\\server\movies3\c\c atch and release\video_ts\vts_02_2.vob|\\server\movies3\c\c atch and release\video_ts\vts_02_3.vob 1453462916 0 2328100865 Catch and Release 1 1 2006 10 After the sudden death of her fiancé, Gray Wheeler finds comfort in the company of his friends: lighthearted and comic Sam, hyper- responsible Dennis, and, oddly enough, his old childhood buddy Fritz, an irresponsible playboy whom she’d previously pegged as one of the least reliable people in the world. As secrets about her supposedly perfect fiance emerge, Gray comes to see new sides of the man she thought she knew, and at the same time, finds herself drawn to the last man she ever expected to fall for. 6687 0 2782306 48000 720 480 0 3 ac3 mpeg2video 649 0 39210.8898032407 -1 mpeg 6 8 448000 4 30.17 16:9 PAR=32:27 0 0 [INVALID_DATA] Vts_02_1 (...) 0 8192 2328109056 0 0 0 0 0 [0][0][0][0] tt0395495 13668 39010 Life is messy. Love is messier 348 309 Catch and Release
    1937 524288 #dv;2:2;0:2331217920;6687|\\server\movies3\c\catch and release\video_ts\vts_10_1.vob|\\server\movies3\c\c atch and release\video_ts\vts_10_2.vob|\\server\movies3\c\c atch and release\video_ts\vts_10_3.vob 1453806568 0 2331217921 Catch And Release (2/2) 4 1 0 0 6687 0 2788955 0 0 0 0 0 -1 0 -1 0 0 0 -99 0 0 [INVALID_DATA] Vts_10_1 (...) 0 0 2331217920 0 0 0 0 0 0 0 1 Catch And Release (2/2)


    1941 524288 #dv;2:3;0:561149952;1321|\\server\movies3\d\dungeo ns & dragons wrath of the dragon god\video_ts\vts_02_1.vob 1453806570 0 561149953 Dungeons & Dragons Wrath Of The Dragon God (2/3) 4 1 0 0 1321 0 3398334 0 0 0 0 0 -1 0 -1 0 0 0 -99 0 0 [INVALID_DATA] Vts_02_1 0 0 561149952 0 0 0 0 0 0 0 1 Dungeons & Dragons Wrath Of The Dragon God (2/3)
    1942 524288 #dv;3:3;561152000:1029201920;1007|\\server\movies3 \d\dungeons & dragons wrath of the dragon god\video_ts\vts_02_1.vob 1453806570 0 468049921 Dungeons & Dragons Wrath Of The Dragon God (3/3) 4 1 0 0 1007 0 3718370 0 0 0 0 0 -1 0 -1 0 0 0 -99 0 0 [INVALID_DATA] Vts_02_1 0 561152000 1029201920 0 0 0 0 0 0 0 1 Dungeons & Dragons Wrath Of The Dragon God (3/3)
    536 262148 #dv;1:3;8192:3611623424;6284|\\server\movies3\d\du ngeons & dragons wrath of the dragon god\video_ts\vts_01_1.vob|\\server\movies3\d\dunge ons & dragons wrath of the dragon god\video_ts\vts_01_2.vob|\\server\movies3\d\dunge ons & dragons wrath of the dragon god\video_ts\vts_01_3.vob|\\server\movies3\d\dunge ons & dragons wrath of the dragon god\video_ts\vts_01_4.vob 1453462995 0 3611615233 Dungeons & Dragons: Wrath of the Dragon God (1/3) 1 1 2005 1 Due to a curse from his former master Profion, Damodar survived his death by Ridley Freeborn as an undead entity in pursuit of an evil artifact for some hundred years, so that he might be capable of unleashing unstoppable destruction on Izmir and the descendants of those who caused his demise. 6284 0 9922130 48000 720 480 0 2 ac3 mpeg2video 837 0 38842.3571180556 -1 mpeg 6 8 448000 4 29.83 16:9 PAR=32:27 0 0 [INVALID_DATA] Vts_01_1 (...) 0 8192 3611623424 0 0 0 0 0 [0][0][0][0] tt0406728 9288 38353 536 1 Dungeons & Dragons: Wrath of the Dragon God (1/3)

Similar Threads

  1. Almost all media entries gone on Bravia
    By Lowlander in forum Mezzmo Questions and Support
    Replies: 5
    Last Post: 07-23-2012, 06:22 PM
  2. Version 2.5 meta data Genre & Artist with multiple entries and CSV
    By warbstowcross in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 01-10-2012, 08:58 AM
  3. 1080p Movie not sending surround sound to TV, Movie shuts off after 10 mins
    By NetMasterFlex in forum Mezzmo Questions and Support
    Replies: 5
    Last Post: 01-03-2012, 09:26 AM
  4. 1080p Movie not sending surround sound to TV, Movie shuts off after 10 mins
    By NetMasterFlex in forum DownloadStudio Questions and Support
    Replies: 0
    Last Post: 12-23-2011, 03:46 PM
  5. Removing Property Entries?
    By wdvorak in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 08-01-2011, 09:15 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
  •