# Remove poster lock in database **URL:** \ **Category:** General Discussions\ **Tags:** server-windows\ **Created:** [August 27, 2021, 9:22am UTC](https://forums.plex.tv/t/remove-poster-lock-in-database/739195 "2021-08-27T09:22:34Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![paolovador](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/paolovador/32/23423_2.png) [@paolovador](https://forums.plex.tv/u/paolovador)\ **Post date:** [August 27, 2021, 9:22am UTC](https://forums.plex.tv/t/remove-poster-lock-in-database/739195/1 "2021-08-27T09:22:34Z")
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](https://forums.plex.tv/t/unlocking-movie-posters/655588), 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](https://forums.plex.tv/t/the-plex-dance/197064) as I want to keep stats, custom tags, labels & titles Thanks ---
**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\ **Post date:** [August 27, 2021, 10:05am UTC](https://forums.plex.tv/t/remove-poster-lock-in-database/739195/2 "2021-08-27T10:05:00Z")
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`](https://curl.se/windows/) available.) First you need to determine the library ID number of your Plex library. You can get it from the [Plex XML info](https://support.plex.tv/hc/en-us/articles/201998867-Investigate-Media-Information-and-Formats) 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/](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. ```auto 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](https://forums.plex.tv/t/new-music-metadata-handling/469988/10) * * * 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](https://forums.plex.tv/t/rel-webtools-unsupported-appstore/206843/1 "WebTools") source code) ---
**Author:** ![paolovador](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/paolovador/32/23423_2.png) [@paolovador](https://forums.plex.tv/u/paolovador)\ **Post date:** [August 27, 2021, 12:12pm UTC](https://forums.plex.tv/t/remove-poster-lock-in-database/739195/5 "2021-08-27T12:12:04Z")
Thanks for this exhaustive answer ! I’ll try this ---
**Author:** ![paolovador](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/paolovador/32/23423_2.png) [@paolovador](https://forums.plex.tv/u/paolovador)\ **Post date:** [September 1, 2021, 10:03pm UTC](https://forums.plex.tv/t/remove-poster-lock-in-database/739195/6 "2021-09-01T22:03:23Z")
Thanks a lot it worked great ! ---
**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\ **Post date:** [November 30, 2021, 10:03pm UTC](https://forums.plex.tv/t/remove-poster-lock-in-database/739195/7 "2021-11-30T22:03:38Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.