Volts
January 20, 2021, 10:23pm
2
Check these out -
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…
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.
1 Like
