Server Version#: 1.21.1
Player Version#: 2.2.0 (for LG TV)
Hello!
I searched and searched for 2 days in the forum and I couldn’t find anything similar or anyone facing the same problem.
I had a QNAP TS-453Be that I upgraded to an TS-453D because I found a very good offer. According to QNAP it should be transparent and moving the HDDs should be enough. The reality was not that simple. I needed QNAP support to access my NAS and fix many things. Even when playing from my TVs is working fine, the issues I am facing with PLEX right now are:
Download subtitles is not working anymore (I am using Sub-Zero plugin)
From my PC every time I access the system is asking for my PIN
After watching a movie the movie is not marked as played (also I cannot manually mark a movie as played)
New content is not detected when “scanning library”
If you need any additional information to help me don’t hesitate to let me know. I will be glad to provide more details.
Thanks in advance!
The PIN is because the server is part of a Plex Home.
If you didn’t create it, did you accidentally join someone else’s ?
The other possibility is the server admin account and the PC account are not the same.
Manually marking a movie as played implied database issues.
This is where your logs will be very helpful.
To maximize the info in a single log file grab, would you please.
Restart Plex
Let it sit 2 minutes to stabilize
try to manually mark the movie as played (the error will show in the logs)
And here you can see a screen recording of the actions …
Maybe helps to clarify what I’m trying to describe.
I also noticed that If I try to “DOWNLOAD DATABASE” inside ‘Manage/Troubleshooting’ the file generated is EMPTY
Thanks and kind regards,
Thank you for the logs. I found it immediately (unfortunately).
We can recover but it will take some command line work.
Are you comfortable with that?
What I found is, because of the QNAP issues, your PMS database was corrupted.
Jan 27, 2021 19:31:45.518 [0x7f5857f19780] DEBUG - Captured session 18.
Jan 27, 2021 19:31:45.518 [0x7f5857f19780] DEBUG - Captured session 19.
Jan 27, 2021 19:31:45.519 [0x7f5857f19780] ERROR - SQLITE3:(nil), 11, database corruption at line 79051 of [bf8c1b2b7a]
Jan 27, 2021 19:31:45.519 [0x7f5857f19780] ERROR - SQLITE3:(nil), 11, statement aborts at 11: [SELECT idx, start_block, leaves_end_block, end_block, root FROM 'main'.'fts4_metadata_titles_segdir' WHERE level = ? ORDER BY idx ASC] database disk image is malformed
Jan 27, 2021 19:31:45.519 [0x7f5857f19780] ERROR - SQLITE3:(nil), 11, statement aborts at 171: [UPDATE metadata_items set rating_count=? where library_section_id=? and metadata_type=? and rating_count is null] database disk image is malformed
Jan 27, 2021 19:31:45.520 [0x7f5857f19780] ERROR - Exception inside transaction (inside=1) (../Library/DatabaseMigrations.cpp:209): sqlite3_statement_backend::loadOne: database disk image is malformed
Jan 27, 2021 19:31:45.522 [0x7f5857f19780] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadOne: database disk image is malformed
Jan 27, 2021 19:31:45.577 [0x7f5857f19780] DEBUG - ChangestampAllocator: initialized to 621268
We can swap the damaged one out and put a backup in its place (usually the best way to do this).
I think I can find my way through command line work. Is there any lternative?
In any case. From where you want me to exectute the commands? Telnet/SSH, Virtual Machine running linux, or any other option?
If there is a way to send you a private message I can send you an invitation to share my screen (zoom, Teams, Skype, etc).
THANKS!
Curious fact:
There is an App, that I had already installed, to make that directory visible from inside File Station (the File Manager in QNAP) making this process easier.
You can check it in https://github.com/ukdtom/PMSLibShare/releases
With that was quite easy to restore the old DataBase!!
It seems to be working now!
THANKS A MILLION!
PS: It keeps asking to select the user and input the PIN everytime but I can live with that!
