Hi I wrote a small python script to pull some additional genres and write them onto my tv shows. However, I don’t see a way to “lock” the genre field via the options in sqlite and it seems that whenever a new episode is added, Plex will refresh the whole series, wiping out my changes. Is there any…

Locking the fields will prevent the data changing during a refresh. Locking the fields is not an on/off thing. It’s in the “metadata_items” table, “user_fields” field. A locked entry looks like this: lockedFields=2|6 Where the 2 and 6 are the specific fields. Lock the fields you want manually …

Because lockedFields is pipe-delimited, I dislike editing it directly with SQLite. So another option is to use the Plex HTTP API. There’s a nice example of how to do so, including locking genre, here: [image] New Music Metadata handling General Discussions Ahh, gotcha. T…

For tv shows, you will need the right type number. I think it is 2 for shows, 3 for seasons and 4 for episodes. I could be wrong though.

thank you! that’s exactly what I need!!

thanks! I liked someone else’s suggestion of lock the fields via the gui then check the table to see which number is dropped. “application is where the theory rubber meets the road” etc etc :slight_smile:

Some of the metadata_item field IDs are listed here. [image] Updating the PLEX database outside Plex - how? General Discussions Thanks. Just to finish off, my further investigation has revealed the following, documented here for use by others who may be in similar situati…

Set "lock" fields via sqlite?

Dev Community Dev/API Corner

Volts August 5, 2021, 8:21pm 7

Some of the metadata_item field IDs are listed here.

Topic		Replies	Views
Mannually lock metadata fields via SQLite Dev/API Corner other-dev	1	194	March 4, 2014
SQLite Edit or Curl API syntax help Plex Media Server server-windows	3	231	January 21, 2021
Is it possible to bulk lock a tag field? Metadata & Adding Files server-synology	4	83	January 27, 2025
How does locked data get overwritten after save? General Discussions	4	505	March 24, 2019
Plex wiping metadata in locked fields Metadata & Adding Files server-windows	1	184	September 5, 2020

Set "lock" fields via sqlite?

Related topics