Page 2 of 6 FirstFirst 1234 ... LastLast
Results 11 to 20 of 55

Thread: Trailers not streaming part 2

  1. #11
    Join Date
    Jun 2012
    Posts
    976

    Default

    Quote Originally Posted by spags65 View Post
    This is 400 trailers that the path needs to be corrected in the database. I do have some experience with databases. Is it as easy as connecting with sql client to the database? If so, I may need schema to figure out where the files paths need to be corrected. More than likely, you will create a query a whole lot quicker.
    Yes, it is as simple as pointing an SQL tool at the Mezzmo database. I use DB Browser for SQLite. The table is the MGOFileExtras table the File column. I just finished the bulk update to convert files from mp4 to mkv. I'll do some more testing but it is looking good.

    So I am clear on your need you need files with:

    E:\o\trailerstrailer_file_name

    to read:

    E:\o\trailers\trailer_file_name

    correct ?


    Let me see what I can do. I may have something tomorrow. I don't think the safe way here is to try and do it all with SQL alone but a combination of SQL and Python.

    Please let me know if you can test mkv trailer download for a movie or two and they play on your Roku device. If so, I'll release the newer version tomorrow with the bulk update capability and hopefully a fix for your path issue.


    Thanks,

    Jeff

  2. #12
    Join Date
    Jun 2012
    Posts
    976

    Default

    Quote Originally Posted by spags65 View Post
    This is 400 trailers that the path needs to be corrected in the database. I do have some experience with databases. Is it as easy as connecting with sql client to the database? If so, I may need schema to figure out where the files paths need to be corrected. More than likely, you will create a query a whole lot quicker.
    I've completed all of the v0.0.18 coding for the mkv feature and have created a special version which has the path fix you are looking for. You can download the special version here.

    I'd start by fixing the path for your 400 trailers. The steps are:

    1. Backup your Mezzmo database
    2. Stop the Mezzmo server service and GUI
    3. Run the trailer checker with the "fix path" command. It should look like "trailer_checker.py fix path"
    4. Run the same "fix path" command a second time and it should say there are no paths to fix
    5. You should see a screen display as it fixes the paths with a summary telling you how many it fixed
    6. Restart the Mezzmo GUI and server service
    7. Either check in Mezzmo of run a CSV export in the trailer checker to ensure the paths are fixed

    Once you have this fixed and working properly you can use the bulk adjust format utility to change mp4 trailers to mkv and update the trailers you have already downloaded in mp4 format. The steps to do bulk adjustments are:

    1. Backup your Mezzmo database
    2. Stop the Mezzmo server service and GUI
    3. Run the trailer checker with the "adjust format 1" command. It should look like "trailer_checker.py adjust format 1"
    4. This will adjust the format of the newest trailer in the Trailer Checker database.
    5. You should see a screen display as it adjusts the output format with a summary telling you how many it modified
    6. Restart the Mezzmo GUI and server service
    7. Check in the Mezzmo properties for the movie with the trailer which was modified and ensure it is in MKV format. Also check your trailer folder to ensure the file is now an MKV file and the MP4 file is gone.
    8. Try playing the trailer which was modified with your Roku device
    9. Once you are sure it is working you can do larger batch conversions by changing the number "trailer_checker adjust format 10"

    You can do up to 200 at a time. I'd suggest starting less than that in smaller chunks.


    Thanks,

    Jeff
    Last edited by jbinkley60; 09-29-2023 at 12:05 AM.

  3. #13
    Join Date
    May 2016
    Posts
    30

    Default

    Jeff,

    Trailers are now downloading in MKV. Thank you. Just need to figure out how to do bulk changes.

    Thank you.
    Last edited by spags65; 09-28-2023 at 11:52 PM.

  4. #14
    Join Date
    Jun 2012
    Posts
    976

    Default

    Quote Originally Posted by spags65 View Post
    Jeff,

    Trailers are now downloading in MKV. Thank you. Just need to figure out how to do bulk changes.

    Thank you.
    Great. I presume they are playing OK on your Roku device ? If you have any questions on the instructions above, just let me know. FYI, I begin some travels on Sunday so turnaround time on responses will be slower.


    Thanks,

    Jeff

  5. #15
    Join Date
    May 2016
    Posts
    30

    Default

    When using adjust number switch, movies are not updating from mp4 to mkv. Is there an additional switch I should be using to convert to mkv?

    C:\Program Files\MezzmoTrailerChecker>trailer_checker.py adjust number 2
    Mezzmo Trailer Checker started - version 0.0.18 mkv test
    Mezzmo check trailer database completed.
    Number of trailers found: 1
    Found 1 trailers with requested movie(s) numbers to adjust
    No adjustments needed for: E:\o\trailers\ytube_Conquest_of_the_Planet_of_the_ Apes_1972__Trailer_HD_1080p.mp4
    Mezzmo Trailer Checker completed successfully.

    C:\Program Files\MezzmoTrailerChecker>
    Last edited by spags65; 09-29-2023 at 01:34 AM.

  6. #16
    Join Date
    Jun 2012
    Posts
    976

    Default

    Quote Originally Posted by spags65 View Post
    When using adjust number switch, movies are not updating from mp4 to mkv. Is there an additional switch I should be using to convert to mkv?

    C:\Program Files\MezzmoTrailerChecker>trailer_checker.py adjust number 2
    Mezzmo Trailer Checker started - version 0.0.18 mkv test
    Mezzmo check trailer database completed.
    Number of trailers found: 1
    Found 1 trailers with requested movie(s) numbers to adjust
    No adjustments needed for: E:\o\trailers\ytube_Conquest_of_the_Planet_of_the_ Apes_1972__Trailer_HD_1080p.mp4
    Mezzmo Trailer Checker completed successfully.

    C:\Program Files\MezzmoTrailerChecker>
    Right now v0.0.18 doesn't allow converting a movie by number or name to mkv. By name and by number are just for frame rate and audio level adjustments. The "adjust format 10" command will convert the newest 10 trailers you have in your system to mkv. I really intended the "adjust format" to be part of a bulk convert activity, allowing up to 200 trailers at a time.

    I can add being able to selectively adjust the format by movie name or number but that may take a bit of time.

    Did you try the "fix path" command and, if so, did it work properly ?


    Thanks,

    Jeff
    Last edited by jbinkley60; 09-29-2023 at 02:19 AM.

  7. #17
    Join Date
    May 2016
    Posts
    30

    Default

    I receive following output for command adjust format 10. Am I missing something?

    C:\Program Files\MezzmoTrailerChecker>trailer_checker.py adjust format 10
    Mezzmo Trailer Checker started - version 0.0.18 mkv test
    Mezzmo check trailer database completed.

    The valid trailer adjust options are: number and frame

    Mezzmo Trailer Checker completed successfully.

    C:\Program Files\MezzmoTrailerChecker>

  8. #18
    Join Date
    Jun 2012
    Posts
    976

    Default

    Quote Originally Posted by spags65 View Post
    When using adjust number switch, movies are not updating from mp4 to mkv. Is there an additional switch I should be using to convert to mkv?

    C:\Program Files\MezzmoTrailerChecker>trailer_checker.py adjust number 2
    Mezzmo Trailer Checker started - version 0.0.18 mkv test
    Mezzmo check trailer database completed.
    Number of trailers found: 1
    Found 1 trailers with requested movie(s) numbers to adjust
    No adjustments needed for: E:\o\trailers\ytube_Conquest_of_the_Planet_of_the_ Apes_1972__Trailer_HD_1080p.mp4
    Mezzmo Trailer Checker completed successfully.

    C:\Program Files\MezzmoTrailerChecker>
    Ok, an update to my previous message above. I have uploaded a new version which will allow adjusting the format by movie number but not by name.

    The command structure is like this:

    Command: trailer_checker.py adjust format 20
    Action: Adjusts trailer format on the newest 20 trailers

    Command: trailer_checker.py adjust format 20 number
    Action: Adjusts trailer format on movie number 20 in the Trailer Checker database

    I hope this is what you were looking for.


    Thanks,

    Jeff

  9. #19
    Join Date
    Jun 2012
    Posts
    976

    Default

    Quote Originally Posted by spags65 View Post
    I receive following output for command adjust format 10. Am I missing something?

    C:\Program Files\MezzmoTrailerChecker>trailer_checker.py adjust format 10
    Mezzmo Trailer Checker started - version 0.0.18 mkv test
    Mezzmo check trailer database completed.

    The valid trailer adjust options are: number and frame

    Mezzmo Trailer Checker completed successfully.

    C:\Program Files\MezzmoTrailerChecker>
    That looks like the original test version before i added the bulk update / adjust capability. Use the special version for right now and once you confirm that is good that is good I'll post an official v0.0.18 version and you can delete the other test versions.


    Thanks,

    Jeff

  10. #20
    Join Date
    May 2016
    Posts
    30

    Default

    Update works. Thank you. I am almost finished changing the in correct pathes in mezzmo. Once finished, i will run a sync command and then update. Almost done.

    Thank you. Thank you.

Similar Threads

  1. Trailers not streaming
    By spags65 in forum Mezzmo Questions and Support
    Replies: 2
    Last Post: 09-08-2023, 10:27 AM
  2. Season/Episode AND part naming
    By spoid in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 09-07-2014, 11:30 AM
  3. Trailers
    By goingmad in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 07-01-2014, 07:05 AM
  4. Metadata for multi-part movies
    By Synn in forum Mezzmo Questions and Support
    Replies: 4
    Last Post: 02-25-2013, 09:36 AM
  5. Part of the dialog window is invisible
    By Konstant in forum DownloadStudio Questions and Support
    Replies: 2
    Last Post: 03-09-2012, 08:29 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
  •