SQLite Edit or Curl API syntax help

[Chris_Teasdale]

Server Version#: 1.21.1.3876
Player Version#:NA

Okay I upgraded to the new Movie agent and had many posters changed on me. So I want to change over to using local media assets with artwork stored with my movie files. I did some testing and have the details worked out.

My problem is on my main 4000+ movie collection many of the (meta-items - user_fields - lockedFields) are set to lock the poster and fanart and local assets doesn’t bypass the lock)

So what I need to do is modify the value like (lockedFields=9|10|13|14) to remove the 9|10 but leave the rest of the values intact, in the example value resulting in (lockedFields=13|14)

I am no expert on SQLite but did make a few changes with DB Browser for SQLite but I am not sure it can do the change I want for the entire section of the database.

I also downed loaded sqlite-tools for windows. I assume this can be done from CMD with this tool. But I could really use some help with the CMD line instructions? Any help is appreciated.

[Volts]

Check these out -

New Music Metadata handling

Ahh, gotcha. There unfortunately no way to do that in the GUI. But of course you can edit your database directly and remove those locks on all items in one sweep. If you have access to the curl command or have an equivalent way of sending commands per http to your server, here is a sequence of commands to unlock them all. First you need to determine the library ID of your music library. You can get it from the Plex XML info of one of the music tracks (or by simply hovering the mouse cursor o…

PMS revert back to old rating from stars

Manual changes to rating (critic ratings) are overwritten by Plex when metadata is refreshed This can be prevented by locking the field. The list of locked fields is stored in metadata_items.user_fields. The rating (critic ratings) field is index 5, so metadata_items.user_fields is set to lockedFields=5 when locked. If multiple fields are locked they are separated with a |. lockedFields=2|5|7. The audience_rating field is index 30. To lock critic and audience, use lockedFields=5|30. I was g…

If you want to do it in sqlite, check out the REPLACE() function, but be sure to take a DB backup first, and be careful not to over-match and replace the wrong things.

[Chris_Teasdale]

Now I am trying to use curl on Ubuntu:

curl -X PUT “https://(CUSTOM SERVER URL)/library/sections/1/all?type=9&poster.locked=0&X-Plex-Token=XXXXX”

XXXXX replaced by token

But poster was just a guess … I can’t find the syntax for what would unlock all posters and then for fanart?? My server is running behind a reverse proxy, do I need to include port 443? I am now sort of lost on this method. It does seem safer.

[Chris_Teasdale]

Okay I tracked down the solution:

curl -X PUT “https://(CUSTOM SERVER URL)/library/sections/1/all?type=1&thumb.locked=0&X-Plex-Token=XXXXX”

curl -X PUT “https://(CUSTOM SERVER URL)/library/sections/1/all?type=1&art.locked=0&X-Plex-Token=XXXXX”

I guess “thumb” is for Posters and “art” is for Backgrounds.