Remove poster lock in database

[paolovador]

Hi everyone,

So after another gentle push from Plex popups I finally decided to upgrade my libraries to the new Plex agents (both TV and Movies). So far so good looks like the vast majority of the earlier posters bugs are fixed ! Love your work, my libraries are incredibly beautiful now.

But I have another problem: over the years, with the previous agents problems, I used to regularly manually change default posters, and in doing so locking them. I’ve made duplicate libraries (both new agent) to compare the default posters between locked and unlocked and looks like I’m missing a lot of good and beautiful posters because of my manual posters actions.

I already tried last year, after understanding that there’s no “unlock poster” button, to look in the database to find “poster lock” metadata to reset but couldn’t find anything.
Could anyone guide me towards finding this information in the database (which table/column) ? I’ll try scripting this and share it back.

PS: I don’t want to Plex Dance as I want to keep stats, custom tags, labels & titles

Thanks

[OttoKerner]

Sorry, I cannot tell you how to edit the database directly.
Instead, I can show you an alternate method of using Plex API, which might be safer to use.

You need access to the curl command or have an equivalent way of sending commands per http to your server. (There is also a Windows version of curl available.)

First you need to determine the library ID number of your Plex library.
You can get it from the Plex XML info of one of this library’s items (or by simply hovering the mouse cursor over the library name of this library in the web app)

Then you need your X-Plex-Token as well.
https://support.plex.tv/articles/204059436-finding-an-authentication-token-x-plex-token/

Then you build yourself some queries:
(Unlocking the thumbnails for movies, tv shows, tv show seasons, tv shows episodes need to be done separately. At least to my knowledge.
This is the type parameter.)

Each line will unlock the thumbnail selections of all items in a library of a certain type at once.

curl -X PUT "me.local:32400/library/sections/NN/all?type=1&thumb.locked=0&X-Plex-Token=XXXXX"
curl -X PUT "me.local:32400/library/sections/NN/all?type=2&thumb.locked=0&X-Plex-Token=XXXXX"
curl -X PUT "me.local:32400/library/sections/NN/all?type=3&thumb.locked=0&X-Plex-Token=XXXXX"
curl -X PUT "me.local:32400/library/sections/NN/all?type=4&thumb.locked=0&X-Plex-Token=XXXXX"

• replace me.local by the IP address or the domain name of your Plex server
• replace NN by the library ID of your music library
• replace XXXXX with your X-Plex-Token

If you’re interested, there are very similar calls for music libraries here New Music Metadata handling - #10 by OttoKerner

---

The following is just for documentation purposes.
Not all of these types are actually used!

‘Movie’ : 1, ‘Show’ : 2, ‘Season’ : 3, ‘Episode’ : 4, ‘Trailer’ : 5, ‘Comic’ : 6, ‘Person’ : 7, ‘Artist’ : 8, ‘Album’ : 9, ‘Track’ : 10, ‘Clip’ : 12, ‘Photo’ : 13, ‘Photo_Album’ : 14, ‘Playlist’ : 15, ‘Playlist_Folder’ : 16, ‘Podcast’ : 17
(shamelessly copied from the old WebTools source code)

[paolovador]

Thanks for this exhaustive answer ! I’ll try this

[paolovador]

Thanks a lot it worked great !