[BUG REPORT WITH SOLUTION] Channels not showing up with WinTV-dualHD

@johnm_ColaSC said:
Says video is unavailable. Perhaps still uploading or privacy is set to Private. I will check back later today to see if video is working. I know youtube used to take a while to “process” the video.

It was set to unlisted… but I’m not sure if that would change anything. I went ahead and changed it to public. Though, if it’s still not working, I’ll just check back later.

@johnm_ColaSC said:
Says video is unavailable. Perhaps still uploading or privacy is set to Private. I will check back later today to see if video is working. I know youtube used to take a while to “process” the video.

Were you ever able to watch it/figure out anything from the logs?

Seems like Plex is seeing most of the channels. From the video I couldn’t seem to get a full list of the Guide Channels you can map to on the right side. Attached are the log entries from where Plex is trying to match up channels it apparently sees on the tuner with Guide Channels available.

@johnm_ColaSC said:
Seems like Plex is seeing most of the channels. From the video I couldn’t seem to get a full list of the Guide Channels you can map to on the right side. Attached are the log entries from where Plex is trying to match up channels it apparently sees on the tuner with Guide Channels available.

If you watch the video, you’ll see that many of the channels are dropped. For example, MTV, TBS, AE, FXNWS, anything HD… They aren’t showing up on the left side. If you check page 2 of this thread, I posted a picture that points it out more so.

I’ve found a way to hack it to work… I’ll post my solution in a moment.

In some cases, when Plex is doing channel scans, it assigns the same channel identifier for multiple channels… This causes many channels that should work to be dropped. I have absolutely no idea why this is happening, and is obviously a pretty serious bug that needs to be fixed. Anyway, luckily for us (that have been posting for help without luck) there is a way to modify the database to get it to work.

1. Start a channel scan and let it complete like normal.

Plex will add the channels to the database, however, it will not add them correctly. But, the scan works well enough that it does get the correct channel number.

2. Download a database browser if you do not already have one.

I used: http://sqlitebrowser.org/

I imagine any database browser will work fine, but I’m not really sure.

3. Open up your plex data store directory, and head for the database.

For me, this was located at C:\Users\MYUSERACCOUNT\AppData\Local\Plex Media Server\Plug-in Support\Databases

The file was then com.plexapp.plugins.library.db. You’ll need to open your SQL browser, and then open this file with it. I just dragged the file in and it worked fine.

After you’ve opened the database, click the browse data tab. Open the table media_provider_resources. On the row with the identifier tv.plex.grabbers.tunerservice scroll to the far right and you’ll see a data column. It should contain xml. For me, it contained…

Here was mine: https://pastebin.com/FyZDqkCv

As you can see, there are many channels with the same identifier. As far as I can tell, this identifier has no other purpose besides for Plex to manage the channels. Just change it so that all of your channels have a different one. Here’s my example:

Here is how I fixed mine: https://pastebin.com/Yw7kKGzK

After doing that, copy your changes back into the database. Then click Apply, save the database and close.

4. Head back to the DVR settings.

Click the option to enable more channels. Your channels should now all be showing up. After you map them to EPG, you just click save. Enjoy using your DVR finally. NOTE: If you click scan again, you will need to repeat all of these steps.

4 Likes

Bumping this because this is still and issue that has not been fixed in an update.

2 Likes

Having this same issue with my Hauppauge tuner, but my HDHR works fine.

@shutchi2 said:
Having this same issue with my Hauppauge tuner, but my HDHR works fine.

Did you see the solution posted?

I did see the manual edit of the db, but the server is remote and I haven’t had time to go in and edit 200 channels. Since the bug has apparently been around for months I was hoping there would eventually be a fix.

Tried your solution, but dont see any channels, assign to the same channel identifier in the db.

Plex find 69, and shows 69 - but missing 3 important channels in the list

@“livøvænget” said:
Tried your solution, but dont see any channels, assign to the same channel identifier in the db.

Plex find 69, and shows 69 - but missing 3 important channels in the list

If you want to post your xml file, I’ll look at it. But… I don’t know if that’ll be very helpful. Plex could be missing them for other reasons too. Are you sure they’re QAM 256 channels?

Thanks for your trick, it solved my issue.

@World177 said:

@“livøvænget” said:
Tried your solution, but dont see any channels, assign to the same channel identifier in the db.

Plex find 69, and shows 69 - but missing 3 important channels in the list

If you want to post your xml file, I’ll look at it. But… I don’t know if that’ll be very helpful. Plex could be missing them for other reasons too. Are you sure they’re QAM 256 channels?

Thanks, but i dont se the missing channels, they are not listet in the xml file.
All channels are in 6875 QAM 64 128 and 256

The last channel Plex find is at Freq:554000 and TV3+ 570000 is missing

I will try to type the missing channel into the xml file :confused:

Succes - just edit the xml file, and added the missing channels :slight_smile:

Edit the channelIdentifier=“triplet://0:219:1” (in my case in 2 places in xml string)
Edit the Name → name=“HBOE
Edit the freq → fr>219000
Edit the Nr → number=“1008.74

Got all information, in my case from NextPVR setting under channels

Has there been any progress on resolving this bug? The WinTV app correctly finds and tunes all of my OTA channels but Plex DVR only finds 8 out of a possible 17. Is there any work around that doesn’t involve manually editing a database file?

@Huge_Midget said:
Has there been any progress on resolving this bug? The WinTV app correctly finds and tunes all of my OTA channels but Plex DVR only finds 8 out of a possible 17. Is there any work around that doesn’t involve manually editing a database file?

As far as I know, this is the only solution that works. I haven’t seen them claim that this issue was fixed in an update.

I am having a similar issue in which some of the channels don’t show up after a scan. I am using an antenna and the scan won’t pick up NBC (5.1, 5.2) and Fox (19.1, 19.2, 19.3). I started using Plex in January and have not been able to get it to pick up these channels since I started. I am currently at the latest version 1.12.1.4885. I can’t get http://sqlitebrowser.org/ to open the database file. It says it is not in a database format. I am running it on Ubuntu 17.10. I can open the file with a text editor vi to see it’s contents. I just can’t change it with that. But when viewing the file, the channels are not listed in there. So it is not an issue with the identifier. I know the channels work because I can view them using other applications and they come in very clear.

This is very frustrating and Plex needs to fix this issue. I would try and add the channels manually as livøvænget did but like I said the sqlitebrowser won’t open the file for some reason. My tuner is Hauppauge wintv-quadHD. But it picks up the channels fine using other apps.

Anyone have any idea why sqlitebrowser can’t open the database file?

I copied the database file to another server and was able to get sqlitebrowser to open it. I will add the missing channels and copy the file back to the Plex server and see if it works. I will update when done. But this is an issue that the Plex team needs to fix. We should not have to manually edit the database to add channels.

A question on how to add the frequency. The identifiers of the existing channels don’t match the frequency. For example here are my frequencies for channels 64:

tune to: 8VSB f=587000 kHz (0:0:0) (time: 04:08.935)
service is running. Channel number: 64:1. Name: ‘WSTR-DT’
service is running. Channel number: 64:2. Name: ‘Antenna’
service is running. Channel number: 64:3. Name: ‘CometTV’
service is running. Channel number: 64:4. Name: ‘TBD’

But here are the identifiers in the database file for those channels:
<Channel channelIdentifier=“triplet://0:2251:3” name=“WSTR-DT”
<Channel channelIdentifier=“triplet://0:2251:4” name=“Antenna”
<Channel channelIdentifier=“triplet://0:2251:5” name=“CometTV”
<Channel channelIdentifier=“triplet://0:2251:6” name=“TBD”

So how would I know that for frequency 587000 kHz that I would put 2251 in the database?

So for the channels that I’m not receiving I know the frequency that they use from my w_scan but don’t know how to tell the database the correct frequency.