I don’t know what that image is supposed to tell me about the library you are trying to create.
Ok. Why do you think it’s Malformed? What does Malformed mean?
It means corrupt. like i just said. I can’t tell you how it got that way
You can see thats the “add folder” popup when creating a new library. That folder is linked to the folder on the server that contains the file via a path I created within the Unraid docker. It’s the exact same technique I used for Photos and it works just fine.
I’ve given you the choices on what you can try to do with your database. If you don’t know how to follow the directions on how to do them, then I suggest starting from scratch. I also suggest following the naming guides for movies in the links that were provided.
This is extremely frustrating. I don’t like this texting and waiting. I feel like if we were talking over the phone, we’d have this figured out in no time.
I don’t understand why you think my database is corrupt? How would you know that? All that sounds very complicated. It would be nice to have someone talk me though it.
If I may augment here?
Dec 13, 2022 18:33:49.526 [0x1522a2674b38] DEBUG - No match for hash.
Dec 13, 2022 18:33:49.531 [0x1522a2674b38] DEBUG - Added new metadata item (The Patriot) with ID 25948
Dec 13, 2022 18:33:49.531 [0x1522a2674b38] ERROR - SQLITE3:0x80000001, 11, database corruption at line 81887 of [1b256d97b5]
Dec 13, 2022 18:33:49.531 [0x1522a2674b38] ERROR - SQLITE3:0x80000001, 11, statement aborts at 11: [SELECT idx, start_block, leaves_end_block, end_block, root FROM 'main'.'fts4_metadata_titles_icu_segdir' WHERE level = ? ORDER BY idx ASC] database disk image is malformed
Dec 13, 2022 18:33:49.531 [0x1522a2674b38] ERROR - SQLITE3:0x80000001, 11, statement aborts at 178: [update metadata_items set updated_at=null,guid=?,hash=? where id=?] database disk image is malformed
Dec 13, 2022 18:33:49.532 [0x1522a2674b38] ERROR - Exception inside transaction (inside=1) (/data/jenkins/server/3521777883/Library/MetadataItem.cpp:4003): sqlite3_statement_backend::loadOne: database disk image is malformed
Dec 13, 2022 18:33:49.532 [0x1522a2674b38] ERROR - Exception assimilating media item in : sqlite3_statement_backend::loadOne: database disk image is malformed
Dec 13, 2022 18:33:49.532 [0x1522a2674b38] DEBUG - Native Scanner: Executed Add to Database stage in 0.01 sec.
Because in your logs which I have copied a section of in my reply says they are “malformed”. Malformed means corrupt. i have already told you this
oh… How would it get like that?
We don’t know how your system got like that.
In most (almost every) case it’s from a very short list of possibilities:
-
Abrupt power off of the system (PMS doesn’t have time to shutdown and write out everything back to the database)
-
A crash
But if that were the case, wouldn’t it have worked at some point but then stopped working properly? I read that link to repairing a corrupt database. That looks very techincal, outside my skill set.
Are you saying that Plex has never worked correctly ?
Not with this one thing I’m trying to do, no. I’ve never been able to add a ripped DVD to my Plex library. Thats what I’m tryig to figure out.
Photos works perfectly
Give me a minute to rewind and come back through this thread.
Ripping a DVD, making it into a MP4/MKV file is straight forward.
After that, All that needs be done is name it correctly and place it with the right permissions for Linux to see it.
But, Let me re-read to make certain I’m not missing something.
Thats another thing, permissions. I don’t know how to check that.
Did BigWheels give up on me?
Before we get to permissions, which it kinda looks like you have right,
we do need to reset or fix the DB. There’s no way around it.
The very first log file you shared with us shows:
Dec 13, 2022 18:33:49.526 [0x1522a2674b38] DEBUG - No match for hash.
Dec 13, 2022 18:33:49.531 [0x1522a2674b38] DEBUG - Added new metadata item (The Patriot) with ID 25948
Dec 13, 2022 18:33:49.531 [0x1522a2674b38] ERROR - SQLITE3:0x80000001, 11, database corruption at line 81887 of [1b256d97b5]
Dec 13, 2022 18:33:49.531 [0x1522a2674b38] ERROR - SQLITE3:0x80000001, 11, statement aborts at 11: [SELECT idx, start_block, leaves_end_block, end_block, root FROM 'main'.'fts4_metadata_titles_icu_segdir' WHERE level = ? ORDER BY idx ASC] database disk image is malformed
Dec 13, 2022 18:33:49.531 [0x1522a2674b38] ERROR - SQLITE3:0x80000001, 11, statement aborts at 178: [update metadata_items set updated_at=null,guid=?,hash=? where id=?] database disk image is malformed
What these lines tell us:
- It’s trying to add metadata for “The Patriot” (so it saw and recognized the file)
- When PMS went to put that metadata into the database, it faulted because the database is damaged – right there
Bigwheel is here with us too. I’m more of the “Linux Guy” than he is so “My turn to drive” 
I work on the backend of PMS at the operating system level.
I have a nice database repair utility but, because I can’t get unraid to install for me, I can’t port my software to it.
That’s where things get caught up in the weeds.
