Server Version#: 1.24.3.5033
Player Version#: 4.63.0 (PlexWeb)
Tuner Make/Model: Silicon Dust HDHomeRun Connect Quatro
Guide/Lineup name: Local Broadcast Listings (96 Channels)
Using XMLTV?: No
Channel number/Name:
Hey all!
I had an issue where my guide data would try to update, but would just spin at initializing or whatever the first message in the process is. It happened out of nowhere and never did resolve itself. Eventually all of the guide data became empty because it was no longer updating. I tried several things to fix it but nothing I tried resolved the issue.
I thought at that point I would just destroy the DVR configuration and create it again, hoping it would resolve the original issue. Through impatience and that task being stuck at initializing, I don’t think the DVR config was ever completely destroyed, so I got into a state where I couldn’t reconfigure it.
I found the following threads very helpful in trying to cleanup the DVR config:
https://forums.plex.tv/t/plex-will-no-longer-add-hdhomerun-as-dvr/285118/4
https://forums.plex.tv/t/the-device-is-in-use-with-an-existing-dvr/516905
https://support.plex.tv/articles/201100678-repair-a-corrupt-database-1-22-0/
These threads led me to execute the following commands:
./Plex\ SQLite “/mnt/zfs-cache/appdata/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db” “DROP index ‘index_title_sort_naturalsort’”
./Plex\ SQLite “/mnt/zfs-cache/appdata/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db” “DELETE from schema_migrations where version=‘20180501000000’”
./Plex\ SQLite “/mnt/zfs-cache/appdata/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db” “PRAGMA integrity_check”
./Plex\ SQLite “/mnt/zfs-cache/appdata/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db” .dump > dump.sql
mv /mnt/zfs-cache/appdata/plex/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db /mnt/zfs-cache/tmp/plex/com.plexapp.plugins.library.db.original.2
./Plex\ SQLite “/mnt/zfs-cache/appdata/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db” < dump.sql
./Plex\ SQLite “/mnt/zfs-cache/appdata/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db” “PRAGMA integrity_check”
./Plex\ SQLite “/mnt/zfs-cache/appdata/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db”
DELETE FROM media_provider_resources;
.quit
chown nobody:users /mnt/zfs-cache/appdata/plex/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db
These all seem to work great and allow me to rediscover my tuner and begin setting up the DVR again, but when I deselect the channels I don’t want and click next, I get the following:
I can’t ever get past that… anyone have any ideas before I rebuild from scratch?
Thanks all!
