VirtualTV plugin

[Luke 42077]

43 minutes ago, pünktchen said:

Not a single reaction from the devs in 10 days - very disappointing!

Please make sure to tag us when an issue in here needs our assistance, otherwise it’s hard for us to tell from a glance. Thanks.

[pünktchen 1409]

12 minutes ago, Luke said:

Can you show a screenshot of where you clicked resume? Live streams don’t generally have a resume button.

It has nothing to do with live tv. Please read the bug report of the user in the Apple forum section.

 

12 minutes ago, Luke said:

Please make sure to tag us when an issue in here needs our assistance, otherwise it’s hard for us to tell from a glance. Thanks.

It's a general problem with the Apple TV app that by coincidence happens when using my plugin. So i'm not in charge. Just help your users when they are reporting problems.

[Chronosnr1 0]

First of all thanks for this plugin that is really great, only I have a question if I do something wrong compared to the preview image. I can only select the main folders and no subfolders is that what you wanted?

[Chronosnr1 0]

24 minutes ago, Chronosnr1 said:

First of all thanks for this plugin that is really great, only I have a question if I do something wrong compared to the preview image. I can only select the main folders and no subfolders is that what you wanted?

[pünktchen 1409]

4 hours ago, Chronosnr1 said:

First of all thanks for this plugin that is really great, only I have a question if I do something wrong compared to the preview image. I can only select the main folders and no subfolders is that what you wanted?

It should only display the folders of a library and not the library itself. Judging by your image it seems to work correctly, because i guess both F:\Filme and H:\Filme are folders of the same movie library.

[HorsePDF 13]

Hello,

I have loved using this plugin so far. 

I hit an issue a few months back where VirtualTV stopped working all together though and wasn't able to get it to work even after uninstalling the plugin, cleaning up various configuration files and reinstalling it.

I now have it reinstalled and I created a channel but I see when I try to have the guide created, I hit the following exception

SQLitePCL.pretty.SQLiteException: Error: no such column: ListItems.ListItemOrder - select A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.SortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.OriginalTitle,A.CriticRating,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.ExternalId,A.SeriesPresentationUniqueKey,A.ThreeDFormat,A.RemoteTrailers,A.SortIndexNumber,A.SortParentIndexNumber,A.IndexNumberEnd,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex,(Select ShareLevel from UserItemShares join AncestorIds2 on AncestorIds2.AncestorId=UserItemShares.ItemId where UserItemShares.UserId=11 and UserItemShares.ShareLevel not null and AncestorIds2.ItemId=A.Id order by Distance limit 1) as ShareLevel from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And UserDatas.UserId=11 where A.Type=8 AND Coalesce(ShareLevel, 0) > 0 Group by A.PresentationUniqueKey ORDER BY ListItems.ListItemOrder ASC
SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, ReadOnlySpan`1& tail)
at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
at Emby.Server.Implementations.Data.SqliteItemRepository.QueryItemsInTransaction[T](InternalItemsQuery query, IDatabaseConnection db, String[] columnsToSelect, Boolean filterColumns, String[] groupBy, Func`5 rowReaderFn, String methodName)
at Emby.Server.Implementations.Data.SqliteItemRepository.GetItems(InternalItemsQuery query)
at Emby.Server.Implementations.Library.LibraryManager.QueryItems(InternalItemsQuery query)
at VirtualTV.Services.TVService.TVService.GetEpisodesFromPlaylists(VirtualChannel virtualChannel)
at VirtualTV.Services.TVService.TVService.GetEpisodes(VirtualChannel virtualChannel)
at VirtualTV.Services.TVService.TVService.GetLibraryItems(VirtualChannel virtualChannel)
at VirtualTV.Services.TVService.TVService.SetProgramItems(VirtualChannel virtualChannel, DateTimeOffset programStartDate, Int32 programEndOverhead)
at VirtualTV.Services.TVService.TVService.GetProgramFromFileCache(VirtualChannel virtualChannel, DateTimeOffset programStartDate)
at VirtualTV.Services.TVService.TVService.GetProgramItems(VirtualChannel virtualChannel, DateTimeOffset programStartDate, DateTimeOffset programEndDate, Boolean programPreview)
at VirtualTV.Services.TVService.TVService.GetPrograms(String channelId, DateTimeOffset programStartDate, DateTimeOffset programEndDate, Boolean programPreview)
at VirtualTV.VirtualTVTuner.GetProgramsInternal(TunerHostInfo tuner, String tunerChannelId, DateTimeOffset programStartDate, DateTimeOffset programEndDate, CancellationToken cancellationToken)
at MediaBrowser.Controller.LiveTv.BaseTunerHost.GetProgramsAsync(TunerHostInfo tuner, ChannelInfo tunerChannel, DateTimeOffset startDateUtc, DateTimeOffset endDateUtc, CancellationToken cancellationToken)
at Emby.LiveTV.EmbyTV.GetProgramsAsync(ChannelInfo channel, List`1 listingsProviders, DateTimeOffset startDateUtc, DateTimeOffset endDateUtc, CancellationToken cancellationToken)
at Emby.LiveTV.LiveTvManager.RefreshEmbyChannelsInternal(IProgress`1 progress, CancellationToken cancellationToken)
Source: SQLitePCL.pretty
TargetSite: SQLitePCL.pretty.IStatement PrepareStatement(System.String, System.ReadOnlySpan`1[System.Byte] ByRef)

It seems as though I am missing something from my database schema. I have copied my library database, executed this query and get the same error but if I remove the final part:

ORDER BY ListItems.ListItemOrder ASC

Then the query does complete. 

I do not see a table called ListItems in my database - is this created by VirtualTV?

Has my database skipped an upgrade step or something, are upgrade steps idempotent and could I execute them again? Any suggestions beyond starting a whole fresh Emby install?

I'm on Emby 4.8.10.0, running on linux in docker.

[Junglejim 385]

15 hours ago, HorsePDF said:

Hello,

I have loved using this plugin so far. 

I hit an issue a few months back where VirtualTV stopped working all together though and wasn't able to get it to work even after uninstalling the plugin, cleaning up various configuration files and reinstalling it.

I now have it reinstalled and I created a channel but I see when I try to have the guide created, I hit the following exception

SQLitePCL.pretty.SQLiteException: Error: no such column: ListItems.ListItemOrder - select A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.SortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.OriginalTitle,A.CriticRating,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.ExternalId,A.SeriesPresentationUniqueKey,A.ThreeDFormat,A.RemoteTrailers,A.SortIndexNumber,A.SortParentIndexNumber,A.IndexNumberEnd,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex,(Select ShareLevel from UserItemShares join AncestorIds2 on AncestorIds2.AncestorId=UserItemShares.ItemId where UserItemShares.UserId=11 and UserItemShares.ShareLevel not null and AncestorIds2.ItemId=A.Id order by Distance limit 1) as ShareLevel from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And UserDatas.UserId=11 where A.Type=8 AND Coalesce(ShareLevel, 0) > 0 Group by A.PresentationUniqueKey ORDER BY ListItems.ListItemOrder ASC
SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, ReadOnlySpan`1& tail)
at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
at Emby.Server.Implementations.Data.SqliteItemRepository.QueryItemsInTransaction[T](InternalItemsQuery query, IDatabaseConnection db, String[] columnsToSelect, Boolean filterColumns, String[] groupBy, Func`5 rowReaderFn, String methodName)
at Emby.Server.Implementations.Data.SqliteItemRepository.GetItems(InternalItemsQuery query)
at Emby.Server.Implementations.Library.LibraryManager.QueryItems(InternalItemsQuery query)
at VirtualTV.Services.TVService.TVService.GetEpisodesFromPlaylists(VirtualChannel virtualChannel)
at VirtualTV.Services.TVService.TVService.GetEpisodes(VirtualChannel virtualChannel)
at VirtualTV.Services.TVService.TVService.GetLibraryItems(VirtualChannel virtualChannel)
at VirtualTV.Services.TVService.TVService.SetProgramItems(VirtualChannel virtualChannel, DateTimeOffset programStartDate, Int32 programEndOverhead)
at VirtualTV.Services.TVService.TVService.GetProgramFromFileCache(VirtualChannel virtualChannel, DateTimeOffset programStartDate)
at VirtualTV.Services.TVService.TVService.GetProgramItems(VirtualChannel virtualChannel, DateTimeOffset programStartDate, DateTimeOffset programEndDate, Boolean programPreview)
at VirtualTV.Services.TVService.TVService.GetPrograms(String channelId, DateTimeOffset programStartDate, DateTimeOffset programEndDate, Boolean programPreview)
at VirtualTV.VirtualTVTuner.GetProgramsInternal(TunerHostInfo tuner, String tunerChannelId, DateTimeOffset programStartDate, DateTimeOffset programEndDate, CancellationToken cancellationToken)
at MediaBrowser.Controller.LiveTv.BaseTunerHost.GetProgramsAsync(TunerHostInfo tuner, ChannelInfo tunerChannel, DateTimeOffset startDateUtc, DateTimeOffset endDateUtc, CancellationToken cancellationToken)
at Emby.LiveTV.EmbyTV.GetProgramsAsync(ChannelInfo channel, List`1 listingsProviders, DateTimeOffset startDateUtc, DateTimeOffset endDateUtc, CancellationToken cancellationToken)
at Emby.LiveTV.LiveTvManager.RefreshEmbyChannelsInternal(IProgress`1 progress, CancellationToken cancellationToken)
Source: SQLitePCL.pretty
TargetSite: SQLitePCL.pretty.IStatement PrepareStatement(System.String, System.ReadOnlySpan`1[System.Byte] ByRef)

It seems as though I am missing something from my database schema. I have copied my library database, executed this query and get the same error but if I remove the final part:

ORDER BY ListItems.ListItemOrder ASC

Then the query does complete. 

I do not see a table called ListItems in my database - is this created by VirtualTV?

Has my database skipped an upgrade step or something, are upgrade steps idempotent and could I execute them again? Any suggestions beyond starting a whole fresh Emby install?

I'm on Emby 4.8.10.0, running on linux in docker.

I'm running emby 4.8.10 in docker within omv and it runs great here.. Strange!

[pünktchen 1409]

On 10/4/2024 at 5:44 PM, HorsePDF said:

I do not see a table called ListItems in my database - is this created by VirtualTV?

Has my database skipped an upgrade step or something, are upgrade steps idempotent and could I execute them again? Any suggestions beyond starting a whole fresh Emby install?

The missing table "ListItems" isn't created by the plugin and unfortunately i don't know anything about the inner working of the database, but as your database seems to be broken anyway, you could make a backup of your database and try to create the missing table:
 





Ps. Beside your database problem, playlist selection in my plugin seems also to be broken 

[HorsePDF 13]

Hey,

I am very sorry, I was not paying enough attention. The issue is not that the table is missing, it appears that it is the fact that the query does not actually join the ListItems table.

Is this query something written by your plugin or is it internal to Emby?

On another note, I changed off playlist and onto Rules again - the issue I was having previously was that all my channels had no content displaying anymore and would just flash a black screen twice a second.

So the strangest thing, I was previously using Tags to assign content to channels, and in some more troubleshooting I found that none of my TV shows had Tags set anymore (previously there were more than a dozen). I have no idea what caused the Tags to be removed, but I have been able to recreate my TV channels now by re-applying the Tags.

Thanks for the help

[Chronosnr1 0]

hey, i don't know if this topic has already been here, but i have a question. Is it possible to use the plugin for longer than 6 hours? I was always kicked out after 6 hours even though the playback settings say 120 hours. Maybe I understand the settings wrong

[hjason7812 34]

i am sure this plugin is awesome but from what i see and have used it has way to many things to put into the program to mess up. this should be simple to use and not have a million different things you can screw up lol. it should be where you put in a channel a logo and a name genre and select a genre of movies music or shows for that channel then save and it works. so why are there so many things you have to select and it ends up not working anywys all it does it play a black screen for a few seconds and then crashes emby nothing else..

[pünktchen 1409]

On 10/6/2024 at 12:33 PM, HorsePDF said:

The issue is not that the table is missing, it appears that it is the fact that the query does not actually join the ListItems table. Is this query something written by your plugin or is it internal to Emby?

The actual query against the database is internal to Emby. Beside the fact that currently most options in relation to playlist do not return anything, i don't get any error in my log. So it must be something with your database i guess. I'll repair the playlist condition type this week and then we should have another look at your issue.

 

On 10/6/2024 at 12:33 PM, HorsePDF said:

I was previously using Tags to assign content to channels, and in some more troubleshooting I found that none of my TV shows had Tags set anymore (previously there were more than a dozen). I have no idea what caused the Tags to be removed

If your tags where not locked, maybe the library setting "After the initial import, automatically refresh metadata from the internet" has cleared them out? The plugin isn't doing this.

[pünktchen 1409]

15 hours ago, Chronosnr1 said:

hey, i don't know if this topic has already been here, but i have a question. Is it possible to use the plugin for longer than 6 hours? I was always kicked out after 6 hours even though the playback settings say 120 hours. Maybe I understand the settings wrong

Where did you set the 120 hours? The correct place is under Playback Settings -> Max. hours of items to queue for Continuous and Playlist Playback.

[pünktchen 1409]

12 hours ago, hjason7812 said:

i am sure this plugin is awesome but from what i see and have used it has way to many things to put into the program to mess up. this should be simple to use and not have a million different things you can screw up lol. it should be where you put in a channel a logo and a name genre and select a genre of movies music or shows for that channel then save and it works. so why are there so many things you have to select

There are so many options because users have requested them. But you don't have to use them all. Like you said a name, logo and genre condition is sufficient for a channel.

 

12 hours ago, hjason7812 said:

it ends up not working anywys all it does it play a black screen for a few seconds and then crashes emby nothing else

From other posts of you, i can see you are an Roku user. "Playlist Playback" will not work with Rokus for a WAN connection and results in a 60 seconds black video. But this is not something you should blame the plugin for. Blame Roku for their super restrictive app policies or yourself for buying such crippling devices.

Anyway, nobody is forcing you to use this plugin. If you still want to try it and it doesn't work, just come here and ask for help (which you didn't do yet) or do not use it at all, but do not come here to only complain.

[PuffyToesToo 346]

12 hours ago, hjason7812 said:

i am sure this plugin is awesome but from what i see and have used it has way to many things to put into the program to mess up. this should be simple to use and not have a million different things you can screw up lol. it should be where you put in a channel a logo and a name genre and select a genre of movies music or shows for that channel then save and it works. so why are there so many things you have to select and it ends up not working anywys all it does it play a black screen for a few seconds and then crashes emby nothing else..

This is one of, if not THE best Emby plugin IMO. The various options have been entirly our fault as users because we want them. Not every option needs to be filled out. Also, I have a Roku and while it isn't as smooth as perhaps other options - I've used the plugin from day one with it. There are lots of people, including the creator, willing to help you out if you ask us.

[jli 1]

1 hour ago, pünktchen said:

There are so many options because users have requested them. But you don't have to use them all. Like you said a name, logo and genre condition is sufficient for a channel.

 

From other posts of you, i can see you are an Roku user. "Playlist Playback" will not work with Rokus for a WAN connection and results in a 60 seconds black video. But this is not something you should blame the plugin for. Blame Roku for their super restrictive app policies or yourself for buying such crippling devices.

Anyway, nobody is forcing you to use this plugin. If you still want to try it and it doesn't work, just come here and ask for help (which you didn't do yet) or do not use it at all, but do not come here to only complain.

Haha, well done Pünk... well done. 

[Chronosnr1 0]

7 hours ago, pünktchen said:

Where did you set the 120 hours? The correct place is under Playback Settings -> Max. hours of items to queue for Continuous and Playlist Playback.

Like you already listed: 

[pünktchen 1409]

56 minutes ago, Chronosnr1 said:

Like you already listed: 

Okay. Playlist or Continuous Playback? What client?

[Chronosnr1 0]

7 hours ago, pünktchen said:

Okay. Playlist or Continuous Playback? What client?

It was on an Windows Client which is also the server.

I'll continue to observe it, maybe these were just isolated cases, i'll let you know if it happens more often

[new_german_guy 1]

@Chronosnr1I've been using these settings on my Windows server for a few months. and everything runs like clockwork. Maybe you can try selecting 6 hours in the settings instead of 120. In my opinion, there are no disadvantages to this.

[new_german_guy 1]

 

@pünktchen
thank you again for your great work. Can you already predict when the next update for your plugin will be released? 

Edited October 8, 2024 by new_german_guy

[HorsePDF 13]

On 10/7/2024 at 3:39 PM, pünktchen said:

The actual query against the database is internal to Emby. Beside the fact that currently most options in relation to playlist do not return anything, i don't get any error in my log. So it must be something with your database i guess. I'll repair the playlist condition type this week and then we should have another look at your issue.

 

If your tags where not locked, maybe the library setting "After the initial import, automatically refresh metadata from the internet" has cleared them out? The plugin isn't doing this.

Thanks, maybe the tags not being locked were the issue.

 

By the way, is the code for this plugin in Github so that people can contribute to it or do debugging ourselves?

[pünktchen 1409]

On 10/8/2024 at 8:20 AM, new_german_guy said:

 

@pünktchen
thank you again for your great work. Can you already predict when the next update for your plugin will be released? 

Later today.

[pünktchen 1409]

On 10/9/2024 at 10:12 AM, HorsePDF said:

By the way, is the code for this plugin in Github so that people can contribute to it or do debugging ourselves?

No.

[pünktchen 1409]

New version 2.1.0.0 in the plugin catalogue:

Channels:

• Added option to selectively enable channels for specific users
• Added option to create copies of existing channels
• Added option to always play the very first unwatched episode of tv shows (it's within the sorting options: ... Ordered Episodes Playback)
• Added option to balance the number of episodes of each tv show in the guide data up to the specified percentage of the tv show with the most episodes
• Splitted Include/Exlude named Movies/TVShows into separate inputs
• Added option to select multiple bumpers folder (currently only main folders of home videos & photos libraries)
• Fixed some issues around Collection and Playlist channel conditions

The plugin should not auto update, so a manual download from the catalog is required.
As usual, you should clear your browser cache before opening the plugin config page.
Because of the changes some of your channel settings will get lost!