Clear all DVR settings and start again Windows Plex Server

Server Version#: 4.100.1
Player Version#: N/A
Tuner Make/Model: HDHomerun TECH 4
Guide/Lineup name: N/A
Using XMLTV?: N/A
Channel number/Name: N/A

Hi All.

Having a few issues with liveTV-DVR on my windows plex server. Most basically I want to purge all settings and start from scratch setting up the DVR. If I delete the DVR then select setup DVR and select the tuners some of the tuners list 168 channels still(I want these gone). However I do not seem to be able to remove them and when I do a rescan I get no results. However I know the tuners are working because I don’t do a rescan some of these channels actually tune and I get watchable TV.

Is there a settings file or something I can delete? to clear all settings in the DVR.

Lastly it only gives me DVB-T europe (all frequency)when it try to rescan the tuners with known channels. However if I select a tuner without the channels it give be the ability to tune DVB-T Australia (this is correct for me) but I still get no results with this but no error staying check your antenna etc.

I know that is confusing.

To delete any traces of old DVR and tuners, you need to edit the Plex database directly.
Start like you would want to repair the database, as described here https://support.plex.tv/articles/repair-a-corrupted-database/

But instead of committing any of the SQL commands in the above article, only put

DELETE FROM media_provider_resources;

in there. This will empty out the table media_provider_resources.
Then close the SQL prompt and restart your server.

1 Like

Thanks. Hopefully that will fix it up. Will give it go over the next few days.

Tried the command via Plex SQLite seems to not do anything not sure if this is because it is in transient in-memory database. No commands seem to work even .help .exit

maybe im missing something.

You need to perform it while the server is shut down.

Not sure what gives you the idea. It isn’t by default.

the server is shut down.

I’m trying to run the same command to clear out the DVR and tuners. Server is shutdown. Does the …> mean that it is running the SQL command? Should I be more patient and give it some time? Waiting a few minutes before trying .quit and .exit.

Image 419

You can try and look at the table in question with a tool like https://sqlitebrowser.org/ to see if it’s indeed emptied.

Looks like it is not empty. Can I stop Plex and use this SQLite browser to remove both, or not recommended?

You can try that. But I’d save a backup copy of the unchanged db file, incase something gets destroyed.

That worked great using the DB Browser to clear. Just right clicked each row and deleted. Then write changes. Thanks!

Did not fix my issues with XMLTV I’m having, but I will create another thread for that.

Doesn’t the table have underscores not dashes.

Once you get into the sqlite shell, type .tables to list all the tables.

:doh:
You are absolutely right.
Sorry, @B1gJ1mmy! Please try again with underscores insterad of dashes in the table name.

underscores! I did work that out eventually last night.

I was able to clear it in the end after a little bit of stuffing around.

Left is tuning last night as it was around 12:45am when I finished and I had to be up at 7.

Thanks for the help. I feel like i learned a little about SQLite so that’s a bonus.

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