OK. I recently gave up on support for my old HVR-2250 PCI card and I went and bought a supported HD homerun quad tuner that sits on the network. I am able to see the device and watch TV on android, but it will not stay available in the plex server. I set it up one night and it worked with a tv guide and live tv. The next morning it just seemed to delete itself. I try to reinstall it and I have to manually enter the IP address. This seems to work and then it is just gone again. Can anyone help?. version 1.13.2.5154 server.
Is it just the guide that disappears ? There is a bug that has just been found and is being corrected whereby the guide may get lost if there is a refresh when internet connection is down
could you get logs and screenshots as soon as the problem is seen
See
https://support.plex.tv/articles/201643703-reporting-issues-with-plex-media-server/
https://support.plex.tv/articles/200250417-plex-media-server-log-files/
The problem is that the “live tv” is missing from the side bar on the home screen. The setup goes through and downloads the local tv listings based on my zip code and then the option to “view guide” is not selectable. I close the setup and go to the home screen to find that my live tv is still missing. I have attached a log from tonight and pictures. I hope that this helps.
Plex Media (490 KB)
Thanks for the logs. They show database corruption - with lots of errors like these
Jun 26, 2018 20:21:31.631 [11628] ERROR - SQLITE3:0x826c8db5, 11, database corruption at line 112037 of [fc49f556e4]
Jun 26, 2018 20:21:31.631 [11628] ERROR - SQLITE3:0x826c8db5, 11, database corruption at line 112037 of [fc49f556e4]
Jun 26, 2018 20:21:31.631 [11628] ERROR - SQLITE3:0x826c8db5, 11, database corruption at line 112037 of [fc49f556e4]
The database file is
C:\Users\MVB\AppData\Local\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db
See if it can be repaired. Failing that look for backup copies. See this support article for restore from backup
https://support.plex.tv/articles/202485658-restore-a-database-backed-up-via-scheduled-tasks/
To attempt a repair, follow these instructions
Ensure you have Sqlite tools downloaded
See SQLite Download Page
The download file is the tools one in section Precompiled Binaries for Windows - which at the time of writing this, is
https://www.sqlite.org/2018/sqlite-tools-win32-x86-3240000.zip
Make sure you quit/exit your Plex Media Server so that it is not running.
The following commands are run in a windows command line window
cd C:\Users\MVB\AppData\Local\Plex Media Server\Plug-in Support\Databases
copy com.plexapp.plugins.library.db com.plexapp.plugins.library.db.original
This saved a copy of the corrupt database
suggest you place sqlite3.exe in the same folder and then execute these sqlite3 commands
sqlite3 com.plexapp.plugins.library.db "DROP index 'index_title_sort_naturalsort'"
sqlite3 com.plexapp.plugins.library.db "DELETE from schema_migrations where version='20180501000000'"
sqlite3 com.plexapp.plugins.library.db .dump > dump.sql
sqlite3 com.plexapp.plugins.library.db < dump.sql
Prior to restarting your Plex Media Server, you should also delete or backup and move elsewhere the following two files if they exist alongside the original database:
com.plexapp.plugins.library.db-shm
com.plexapp.plugins.library.db-wal
Thank you for the quick response. I will have to try the repair this weekend. It looks like a complicated task.
Mark.
sa2000
Team Member
June 27
mburchfield:
The problem is that the “live tv” is missing from the side bar on the home screen. The setup goes through and downloads the local tv listings based on my zip code and then the option to “view guide” is not selectable. I close the setup and go to the home screen to find that my live tv is still missing. I have attached a log from tonight and pictures. I hope that this helps.
Thanks for the logs. They show database corruption - with lots of errors like these
Jun 26, 2018 20:21:31.631 [11628] ERROR - SQLITE3:0x826c8db5, 11, database corruption at line 112037 of [fc49f556e4] Jun 26, 2018 20:21:31.631 [11628] ERROR - SQLITE3:0x826c8db5, 11, database corruption at line 112037 of [fc49f556e4] Jun 26, 2018 20:21:31.631 [11628] ERROR - SQLITE3:0x826c8db5, 11, database corruption at line 112037 of [fc49f556e4]
The database file is C:\Users\MVB\AppData\Local\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db
See if it can be repaired. Failing that look for backup copies. See this support article for restore from backup https://support.plex.tv/articles/202485658-restore-a-database-backed-up-via-scheduled-tasks/
To attempt a repair, follow these instructions
Ensure you have Sqlite tools downloaded See https://www.sqlite.org/download.html
The download file is the tools one in section Precompiled Binaries for Windows - which at the time of writing this, is https://www.sqlite.org/2018/sqlite-tools-win32-x86-3240000.zip
Make sure you quit/exit your Plex Media Server so that it is not running.
The following commands are run in a windows command line window
cd C:\Users\MVB\AppData\Local\Plex Media Server\Plug-in Support\Databases copy com.plexapp.plugins.library.db com.plexapp.plugins.library.db.original
This saved a copy of the corrupt database
suggest you place sqlite3.exe in the same folder and then execute these sqlite3 commands
sqlite3 com.plexapp.plugins.library.db "DROP index 'index_title_sort_naturalsort'" sqlite3 com.plexapp.plugins.library.db "DELETE from schema_migrations where version='20180501000000'" sqlite3 com.plexapp.plugins.library.db .dump > dump.sql sqlite3 com.plexapp.plugins.library.db < dump.sql
Prior to restarting your Plex Media Server, you should also delete or backup and move elsewhere the following two files if they exist alongside the original database:
com.plexapp.plugins.library.db-shm com.plexapp.plugins.library.db-wal
It is all windows command line - it is straightforward - you can just copy and paste what i posted
I had a quick question for you. Would it possibly be faster to just uninstall all instances of Plex and the database files and do a clean new installation?
Yes that is an option. It would be using RegEdit to delete a registry area and deleting directories
See https://support.plex.tv/articles/201941078-uninstall-plex-media-server/
Thank you sa2000 for your help. I did decide to do a clean install of PLEX server which repaired a couple of issues that I was having. There was the added time of remapping files and downloading add-ons and metadata, but now my old and new tuners are recognized and working properly.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
