whenever i click on the settings for the dvr section it goes to an error page. i think if i remove the tuner it will fix things but i cant get it through the interface.
where is the information for the tuner store in the plex directory so i can edit it out, or at least disable it.
You will need to remove an entry in the media_providers_resources table.
how would i go about deleting the table required? i thought it would be stored elsewhere
Don’t delete the table, just one entry.
ok well i got sqlite3 to open the database, i used .table and it showed the table you mentioned, but im not sure how to list what is next in that table or what to delete
What is the output from:
SELECT * FROM media_provider_resources
at first i got nothing but i added a ; to the end and it spit out this: 1|4|4|0|1|tv.plex.grabbers.hdhomerun|livetv|http://192.168.1.22:34400|device://tv.plex.grabbers.hdhomerun/2022-01-N993-5DRGB6|at%3AcanTranscode=0&at%3AdeviceAuth=xteve&at%3AdeviceId=2022-01-N993-5DRGB6&at%3Amake=Golang&at%3Amodel=xTeVe&at%3AmodelNumber=2%2E2%2E0&at%3Asource=1&at%3Asources=1&at%3Athumb=%2F%3A%2Fresources%2Fdvr%2Fdevice-generic-560%2Epng&at%3Atitle=My%20Guide&at%3Atuners=1&pr%3AtranscodeDuringRecord=0&pv%3AchannelMapping=MTE4MD0xMTgw&pv%3AchannelMappingByKey=MTE4MD0xMTgw&pv%3AchannelsEnabled=1180|2022-01-25 20:14:54|2022-01-25 15:53:43|2022-01-25 20:38:56|
4||1|1|1|tv.plex.harvesters.dvr|||7379fd39-0b5d-4af4-b246-d91597ff03cf|at%3Acountry=can&pv%3Alanguage=eng&pv%3Alineup=lineup%3A%2F%2Ftv%2Eplex%2Eproviders%2Eepg%2Exmltv%2Fsrv%2Fraid1%2Fxteve%2Exml%23My%2520Guide&pv%3AlineupTitle=My%20Guide||2022-01-25 19:52:20|2022-01-25 19:52:20|
5|4|3|1|1|tv.plex.providers.epg.xmltv|livetv||e42b80f4-b2a7-4be4-bf34-f410045bc951|pv%3AlastChunkEndedAt=1644278400&pv%3ArecentChannels=1%3D1180&pv%3AtimeOfLastRefresh=1643141174||2022-01-25 19:52:20|2022-01-25 20:06:14|
Yes, please check for my typos 
Delete from media_provider_resources where id="1";
well it deleted the tuner. thank you for that help on that. but sadly i started up the server again and it still goes to the error page on the settings for the tuners. hopefully with a new update the server will fix itself
You previously had or still have xteve setup, it is probably hanging on the xmltv line so the more drastic is to just delete all the entries “delete from media_provider_resources;” and then setup the dvr.
that got it, thank you very much. appreciate all the help you have given me.
Command line method for deleting DVR setup.
Stop your Plex Media Server
sudo systemctl stop plexmediaserver.service
Find your database
sudo find / -name com.plexapp.plugins.library.db
cd to location of your database, should only be one.
cd 'output from above, quotes required'
Copy the db to backup file
cp com.plexapp.plugins.library.db com.plexapp.plugins.library.db.bak
Delete the DVR info
/usr/lib/plexmediaserver/Plex\ SQLite com.plexapp.plugins.library.db
You should now see a sqlite> prompt. Delete the rows from media_provider_resources
sqlite> Delete from media_provider_resources; {hit enter}
sqlite>.quit {hit enter}
Start Plex
sudo systemctl start plexmediaserver.service
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
