Plex not disovering HDHomeRun

[samraby]

Server Version#: 1.41.7.9749
Player Version#:
Tuner Make/Model: HD HomeRun Connect
Guide/Lineup name:
Using XMLTV?:
Channel number/Name:

I have had issues with plex tuning to channels and upgrading the EPG.

I’ve removed all of the tv.plex.providers.epg.cloud files in local app data and restarted plex.

now plex is not discovering the tuner . looking in the logs I see:

[Req#26a/Grabber] The device was already discovered at http://10.2.10.174, updating URI

[Req#5a91] DVR:Device: Testing grabber HDHomerun device device://tv.plex.grabbers.hdhomerun/12317D41 at http://10.2.10.174:80

[Req#5a91/HCl#99d] HTTP requesting GET http://10.2.10.174:80/lineup_status.json

[HttpClient/HCl#999] HTTP/1.1 (0.0s) 200 response from GET http://10.2.10.174:80/discover.json

But when I’m in the tuner setup window its just hanging on this

[pshanew]

By manually deleting those EPG files you’ve left you server in an inconsistent state. It’s already identified the tuner and associated it with a DVR, but you’ve removed the backing data for the DVR itself.

To correct this you’ll likely need to make some database modifications to fully remove the DVR and tuner. Here are the steps (this is off the top of my head but should be correct).

1. Delete the existing DVR in Plex’s server settings, if it’s still there.

2. Stop Plex Media Server.

3. In a command-prompt window, navigate to the Plex data directory (the same one from which you deleted the files previously).

4. Run the following command (assumes you installed PMS in the default location, adjust as necessary):
   "C:\Program Files\Plex\Plex Media Server\Plex SQLite.exe" com.plexapp.plugins.library.db "DELETE FROM media_provider_resources;"

   Running this after should return no rows:

   "C:\Program Files\Plex\Plex Media Server\Plex SQLite.exe" com.plexapp.plugins.library.db "SELECT * FROM media_provider_resources;"

5. Start PMS and attempt to configure a new DVR.

I hope it goes without saying that you should back up the database file in the command above before modifying it via a query . Personally, I’d back up the entire Plex data directory.

[samraby]

Hi there @pshanew

Thanks for the support.

i tried this but sadly I get :

Error: in prepare, no such table: media_provider_resources

[pshanew]

Are you sure you’re in the correct directory? It should be:
C:\Users\your_user\Plex\Plex Media Server\Plug-in Support\Databases

And the filename for the database is:
com.plexapp.plugins.library.db
I noticed that the forum formatted the filename with a dash in it; it shouldn’t be there.

Make sure to include the quotes around the path for the Plex SQLite.exe executable and the queries.

[MadEyeB]

I want to start with Plex has been a great service for my family for many years and given the nature of software I totally get these things happen.

I’m having the exact same issue. My Plex setup has been running great for years on my NAS but one of the recent updates caused the OTA TV tuner to stop working. When I removed it from the interface as part of troubleshooting, I get the below error when I attempt to re-add

My HDHomerun Extend TV tuner is fine and reachable from every other scenario I could test (PC browser, VLC on a phone, TV app, etc) I attempted the listed troubleshooting around restarting, shutting down and deleting the media_provider_resources entry using DB Browser and confirmed the entry is gone but there appears to still be references. You can see in the screen cap even with the entry deleted my Plex instance is still looking for an old reference. Interestingly if I setup a clean test instance of Plex I can get the HDHomerun to show up immediately no problem so this does appear to be something about the upgrade process, possibly for long-running installs.

It would be great if someone with Plex could point us to another location this reference is coming from? Thanks