Remove poster lock in database

General Discussions
2

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)

5 Likes