![]() ![]() dump | grep '/home/steve/media/libraries/cartoons/The Rocky and Bullwinkle Show (1959)/Season 01/The Rocky and Bullwinkle Show - s01e04.mkv' So, here’s the first thing I ran, was to dump the database contents and grep to see which one it stores filenames in: But first I wanted to see what table the file was actually in. I had to browse through the schema a bit (which from what I can tell, is efficiently developed as well) so I could figure out the relations between everything. Any writes to the database will be blocked if there’s an active lock on it from another process (Plex), so you’d just have to rerun it. If you want to play things safe (you probably do) you could stop the Plex daemon if you wanted to before making any changes to the database. ![]() $ sqlite3 '/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases/.db'. I should add that it’s really important that you back up your database before doing anything. On my Linux box, the Plex database is at ‘/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases/.db’. I can only imagine the horror of running a database with a daemon in the background, it would just introduce a new litany of issues that would have to be debugged. Plex very wisely uses SQLite for its backend database. I just need to poke at the Plex database directly. When the metadata is changed and saved manually, there will be an orange background color behind the lock for the specific item. I could do it manually, but I keep track of everything in my own application in separate database (PostgreSQL if you’re curious) along with all the information about my DVD library, and so I can automate everything. Plex will let you set a custom title for a show, along with any other metadata you’d like to change. No problem, that’s why we hack on things. However, I want to replace what Plex is displaying as the title names with what I’ve actually ripped. Anomalies like this are difficult to work with, which is not completely unusual when it comes to source material that is split up like this, and TVDB shouldn’t be criticized in any way, there are a lot of complex situations and the contributors do a masterful job of dealing with it. There are other series where the same thing crops up – more than one “series” is in a show - Huckleberry Hound and Snagglepuss are split into two series, even though are on the same DVD set. “Peabody’s Improbable History” shows up later in Rocky and Bullwinkle’s. For example, “ Fractured Fairy Tales,” has its own series. They decided to split the show a couple of different ways. The actual show itself, in its half-hour program, was five segments, but the sequence “ Jet Fuel Formula” actually ran for 40 episodes across multiple programs and DVDs! The TVDB handles situations like this differently, but not always in the same method. Sources like these are tricky to deal with. ![]()
0 Comments
Leave a Reply. |