Workaround: There was an unexpected error when going to settings page

Live TV & DVR
,
1

Server Version#: 1.25.2.5319
Tuner Make/Model: Hauppauge WinTV-dualHD

I found a workaround to the following error when you go to settings. I see many people across the forums are having this issue. I have to give credit to this post as much of the information here came from it but felt condensing the information into a single post might help people. Plex Will No Longer Add HDHomeRun as DVR - #2 by OttoKerner and Unexpected error when going to Live TV & DVR Settings - #35 by Tiebierius

Error when going to ‘Live TV & DVR’ setting:
There was an unexpected error
Please visit our forums if you continue to experience problems.
image

This solution is tailored for windows but should work for any of the other installations.

Do this at your own risk. You can mess your entire installation up and have to rebuild from scratch. Also note this will delete the entire tuner, so it will have to be set back up.

  1. Download the sqlite tools (https://www.sqlite.org/2021/sqlite-tools-win32-x86-3370000.zip) and unzip it.
  2. Stop plex server
  3. Open command prompt. Press the windows key and type cmd.
  4. Change directory to the databases folder. Usually at this location, however, you may have changed it to a custom location.
    a. cd %LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases
  5. Make a backup of the database
    a. copy com.plexapp.plugins.library.db com.plexapp.plugins.library.db.bak
  6. Delete the media provider resources. Note this will delete all tuner data.
    a. Drag the sqlite3.exe into the command prompt.
    b. Paste DELETE FROM media-provider-resources
    c. It will look like this:
    d. C:\Users\USERNAME\Downloads\sqlite-tools-win32-x86-3370000\sqlite3.exe com.plexapp.plugins.library.db "DELETE FROM media_provider_resources"
    e. Verify that there is no errors.
  7. Restart plex
  8. Go to the ‘Live TV & DVR’ setting.

Hopefully this works for you and allows you to add your tuner back.

If you encounter any issues you can delete the entire database and remove the .bak from the copy. This will revert any changes you made with the sqlite tool.

  1. copy com.plexapp.plugins.library.db.bak com.plexapp.plugins.library.db
  2. Type ‘Yes’ to overwrite.
9 Likes
2

Good that you found a way round the problem - but would love to actually see the diagnostics for what the problem was that needed that the table is reset

The table holds DVR info and channels

I see you have cross referenced other threads - but if you have debug server logs of the actual issue and contents of the media_provider_resources table at the time, then that would allow me to look into it

3

THIS is finally the solution/workaround that got me back working. Thank you!

4

Thanks for this… My install is in a Docker, so I had to modify your steps a bit. What I did was share(on unraid)/mount(in windows) my appdata directory where Plex docker container lives, then in windows navigated to the db location. My Docker install in unRAID db locations was (z is appdata)

“Z:\plex\Library\Application Support\Plex Media Server\Plug-in Support\Databases”

From there I manually created the sql command pointing to where I extracted it (moved it to c: root for easier access) running the following command after backing up the db.

"c:\sqlite\sqlite3.exe com.plexapp.plugins.library.db “DELETE FROM media_provider_resources”

Also, I deleted the tv.plex.providers.epg files before restarting plex. After restart, I was able to readd the tuner.

Great work!

1 Like
5

This was the solution I needed. Saved me from uninstalling and doing all sort of extra work. Appreciate the help and direction on this!

6

I have reproduced the problem using an old TiVo lineup id and I have referred it to the Plex Web development team

1 Like
8

@Jimmmy THANK YOU!
I’m in process of cutting the cord and wanted to employ my previously configured DVR in Plex. But kept running into this non-descriptive error.

Server Version: 1.25.2.5319
Tuner: HDHomeRun CONNECT

I tried a bunch of different things and nothing worked. Thank you for the well-written explanation of how to delete the tuner data using sqlite3!

Thanks

10

Thanks, any ETA on a fix for this one? Thanks

11

THANK YOU! You just ended several hours of frustration.

12

I am trying to follow your guide, but getting no change in the result. This sucks I was just trying to work on my DVR and now its totally broken…
I have done this over and over with no change in my results. Can someone help me out here?
Does the Plex team have an ETA for something easier than this?

13

Just wanted to say HUGE THANKS!! this worked for me. I was dreading having to uninstall and reinstall Plex, losing all my watched history, etc. These instructions allowed me to then change my Live TV/DVR settings.

14

Thanks, that’s worked for me too, I’ve had the problem for months and didn’t have a clue how to resolve it!

15

Just want to add I too am having this problem. Tried the workaround to no avail. Anxiously awaiting a fix from Plex.

1 Like
16

A fix for the Unexpected Error when selecting DVR Settings has just been released in hosted Plex Web App version 4.74.1 available through https://app.plex.tv/desktop

See Release Notice

  • Fixed the DVR and LiveTV settings error if DVR has old and no longer existing lineup

With this fix the settings page will load an allow you to delete the old DVR

17

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.