Trailers not streaming part 2

[jbinkley60]

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.

Thanks for the update. I personally like the local high quality trailers. If you ever use Kodi I have a feature in the Mezzmo Kodi Addon called Mezzmo Movie Previews where you can select up to 6 previews to play prior to the main movie. They can either be from the current year or the year the movie was released, if you want to have a more original movie time experience. I use this feature often.

I'll post the official 0.0.18 release tomorrow.


Jeff

[spags65]

Jeff,

Ever since implementing conversion python script, I have received the following error of index out of range. I replaced config file to original and rolled back to version 17 python script. I am still receving the same error. How do i sync the index again?

C:\Program Files\MezzmoTrailerChecker>trailer_checker.py trailer
Mezzmo Trailer Checker started - version 0.0.17
Mezzmo check trailer database completed.
Finished getting Mezzmo Trailer records.
Mezzmo Trailer Checker found 15 movies to check trailers.
Found 0 Youtube trailers: Part 1: Days 1-7
list index out of range
There was a problem getting the movie list.
Finished getting Mezzmo Trailer records.
There were no trailers found which need checking.
Mezzmo Trailer Checker completed successfully.

[spags65]

Update. I removed the trailer checker database and reran the script. After about 20 runs, I updated 8 trailers and then started receiving index out of range. I then below away database again and rolled back to python 17 script with config. Ran script around 20 times downloading 8 trailers and then received index error again. Do i need to connect a client to trailer checker database to investigate issue?

[jbinkley60]

Update. I removed the trailer checker database and reran the script. After about 20 runs, I updated 8 trailers and then started receiving index out of range. I then below away database again and rolled back to python 17 script with config. Ran script around 20 times downloading 8 trailers and then received index error again. Do i need to connect a client to trailer checker database to investigate issue?

Sorry for the delay getting back to you. I have been traveling and just got back. I had connectivity issues and couldn't respond while traveling. No, I don't think we need an SQL browser client to troubleshoot this. The Show and CSV export commands are sufficient to look into the database. Based upon the error message and what you have done, this is unlikely to be a version problem but more likely the Trailer Checker is getting something from Mezzmo that it has not accounted for, thus causing the error. It shouldn't be too hard to pin down.

My first question is if the error is always occurring on the same movie: "Part 1: Days 1-7" or across multiple movies ? If so, what would help is seeing the output of a show name or show number for a failing movie and what is in the trailers properties in Mezzmo. Also it would be helpful to get a copy of your logfile when you run the trailer command and get the error. With this I should be able to pin down what is happening. You can send me the logfile snippet in a private message here. I just need a filed run not the whole file.


Thanks,

Jeff

[spags65]

I found the issue. Any database record with trailer for a tv show crash out. Once I added entry for "lastchecked" & "trstatus" script skipped over tv show entries.

[jbinkley60]

I found the issue. Any database record with trailer for a tv show crash out. Once I added entry for "lastchecked" & "trstatus" script skipped over tv show entries.

Ok. That is interesting. I never anticipated that a TV Show would have a trailer, just movies. Yes, adding those fields will force a skip. The TV Shows are in Mezzmo ? If so, can you give me the following info from the Mezzmo properties screen for one which is failing:

• TV Series Name
• Season and Episode numbers
• IMDB
• Trailers

With this I should be able to craft a fix for it. Do you want those You Tube trailers for TV Shows to play or do you want the Trailer Checker to skip them ?


Thanks,

Jeff

[spags65]

Below are entries of mTrailers table from "dateAdded" to "trStatus". If possible, would like trailers associated with tv. I suspect IDMB will only increase attaching youtube trailers to TV shows.

2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 1 12166 8388612 http://www.youtube.com/watch?v=r1d8E9GglvA 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 2 12166 8388612 http://www.youtube.com/watch?v=WIASqPZqnhs 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 3 12166 8388612 http://www.youtube.com/watch?v=a1I7QQcXokY 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 4 12166 8388612 http://www.youtube.com/watch?v=gXdru_rLBfw 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 5 12166 8388612 http://www.youtube.com/watch?v=lBk3n-kz4EU 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 6 12166 8388612 http://www.youtube.com/watch?v=sqS83f-NUww 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 7 12166 8388612 http://www.youtube.com/watch?v=71HpLz-smn0 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 8 12166 8388612 http://www.youtube.com/watch?v=395vXWedOmU 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 9 12166 8388612 http://www.youtube.com/watch?v=brEzYdLrPws 0 2023-10-06 15:52:04 Yes

[jbinkley60]

Below are entries of mTrailers table from "dateAdded" to "trStatus". If possible, would like trailers associated with tv. I suspect IDMB will only increase attaching youtube trailers to TV shows.

2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 1 12166 8388612 http://www.youtube.com/watch?v=r1d8E9GglvA 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 2 12166 8388612 http://www.youtube.com/watch?v=WIASqPZqnhs 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 3 12166 8388612 http://www.youtube.com/watch?v=a1I7QQcXokY 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 4 12166 8388612 http://www.youtube.com/watch?v=gXdru_rLBfw 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 5 12166 8388612 http://www.youtube.com/watch?v=lBk3n-kz4EU 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 6 12166 8388612 http://www.youtube.com/watch?v=sqS83f-NUww 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 7 12166 8388612 http://www.youtube.com/watch?v=71HpLz-smn0 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 8 12166 8388612 http://www.youtube.com/watch?v=395vXWedOmU 0 2023-10-06 15:52:04 Yes
2023-10-04 21:56:47 Sins of the Father E:\o\Sonarr\Only Murders in the Building\Season 3\Only.Murders.in.the.Building.S03E10.1080p.HEVC.x 265-MeGusta.mkv 9 12166 8388612 http://www.youtube.com/watch?v=brEzYdLrPws 0 2023-10-06 15:52:04 Yes

If you click on any of those URLs do they play for you ? I am getting an error that they are no longer available. This is what I suspected may be happening where Mezzmo originally had good URLs when the files were added to your system but now they have been removed from You Tube. This is exactly one of the problems the Trailer Checker will help with in the future, saving a local copy so that if/when they get removed from You Tube you can still play them.

I suspect what is happening is that there are no good URLs for the videos and the script is erring out assuming thee must be at least one good one. Your logfile will help me determine this.


Thanks,

Jeff

[jbinkley60]

Ok. Using one of your trailer URLs I was able to reproduce the issue you are seeing and have a fix. Please try downloading it here. Just replace the trailer_checker.py file. The problem was being caused by the You Tube URLs for your TV shows starting with http:// vs. https:// . Those must be pretty old trailers.

The Trailer Checker will now accept both. Now it will try to download your URLs and will fail because they are no longer available. You'll need to run a "clean name" or "clean number" on each one then the "trailer" command. Please try this and then I'd try a "Get Online Video Metadata" again in Mezzmo to see if there are any new trailers for these. I searched You Tube but can't really tell.


Thanks,

Jeff

[spags65]

Thank you, sir. Now i just need to figure why trailer channel is not being picked up by trailer.py When looking in database, I do not see entries from trailer channel. Any thoughts why would be appreciated.