A community for discussing Plex Media Server. Plex Media Server is a smart software that makes playing movies, tv shows, and other media on your computer simple.
Ask questions, get support, and be part of the community here on Lemmy!
Join the c/Plex community on Matrix!
Rule 1 - Don't be a dick
Don't be a dick. This includes any kind of trolling, baiting, etc. Bigotry may result in an instant permaban.
Rule 2 - No misleading or non-descriptive titles
No misleading or non-descriptive titles. Try to be brief but detailed.
Rule 3 - Keep post and comments relevant
Posts must be related to Plex and Plex-related products, apps. etc. Try to keep comments relevant to the parent comment and to the post.
Rule 4 - Keep discussions of "media aqcuistion" limited to means and methods only.
Discussions regarding media acquisition should be limited to the "how" not the "what", as this is not the place to discuss piracy of specific media. There are other communities for that, and we don't want to get this community defederated from instances where it's a forbidden topic. Posts/comments discussing specific acts of piracy ("How do I find X show?" or "Where can I download Y film?")will be removed. For further clarification see this post
Rule 5 - No asking / offering Plex shares.
No asking / offering Plex shares. There are other communities for that.
Rule 6 - No low-effort / spam / meme posts
No low-effort / meme posts. These are considered spam, and will be removed. Repeat offenses may result in a ban.
Rule 7 - No referral / self-promotion / affiliate links, personal voting / campaigning / funding, or selling posts
No referral / self-promotion / affiliate links, personal voting / campaigning / funding, or selling posts. These are considered spam, and will be removed. Repeat offenses may result in a ban.
^This^ ^is^ ^a^ ^community^ ^page^ ^and^ ^is^ ^not^ ^affiliated^ ^with^ ^Plex,^ ^Inc.^ ^in^ ^any^ ^way.^
Platforms : LG webOS 3.0+
Platforms : Hisense models (in United States and Europe) running the U4 system software
Platforms : Samsung 2016 to 2022 Televisions (Tizen 2.4, 3.0, 4.0, 5.0, 5.5, 6.0, 6.5)
This is part of a weekly series of Share-Your-Build Post threads for everyone to share their builds, discuss different server solutions, and share knowledge and resources! Please be polite and helpful to beginners just getting started out, and we want to be as welcoming as we can to newcomers to this community.
Common info to share can include:
Anyone who posts good starter guides, FAQs, and/or wikis may get their links added to the sidebar so the rest of the community can benefit!
Cheers!
We’ve released an update to the Plex preview channel - 7.6.0
NEW:
FIXES:
We're restarting the Friday Advice / No Stupid Questions (NSQ) Post after a break.
This is part of a weekly series of Plex Advice threads for novices and pros alike to ask questions, give advice, troubleshoot, and share knowledge and resources! Please be polite and helpful to beginners just getting started out, and we want to be as welcoming as we can to newcomers to this community.
Common subjects can include:
Anyone who posts good starter guides, FAQs, and/or wikis may get their links added to the sidebar so the rest of the community can benefit!
Cheers!
cross-posted from: https://lemmy.fmhy.ml/post/778602
In this guide I will explain how to add edition tags to movies or alter already existing ones. This guide assumes you have access to the plex database.
Limitations
While this solution enables anyone to add/remove edition tags that will show up in any app/website that supports them. Some features are still be restricted to PlexPass subscribers such as displaying other editions on the movie details page.
Method
1. Identify your plex database location.
Generally your database should be located here:
[Plex data directory]/Plug-in Support/Databases. But depending on your system[Plex data directory]will be different. Here is a list of common directories.2. Identify your plex binary location.
This might be a little more difficult as there is no nice pre-made list as there is with the data-directory. Try googling a little. In my case the path is
/volume3/@appstore/Plex Media Server/Plex Media Server, since I installed plex in Volume 3 on my Synology.If you are unable to locate your plex binary you may still be able to continue if you have sqlite3 installed on your system. Though I have not tested this solution.
3. Connecting to the database
Open your terminal and make sure you can access the plex binary. If your plex binary is on a server or in a docker container you may have to access it using ssh. In my case I have to use ssh:
ssh Quark95@123.69.10.420.You may have to enable ssh access on your system.
Now we can connect to the database using SQLite. The command will look like this:
"[Plex binary path]" --sqlite "[Plex Data directory]/Plug-in Support/Databases/com.plexapp.plugins.library.db".Alternatively you could try
sqlite3 "[Plex Data directory]/Plug-in Support/Databases/com.plexapp.plugins.library.db"And for reference my command looks like this:
"/volume3/@appstore/Plex Media Server/Plex Media Server" --sqlite "/volume3/Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db"Now a prompt should appear that looks like this:
sqlite>4. Finding IDs
Now you'll need to find the ID of the movie(s) you want to edit. To do this, find the movie in your plex library on desktop, in the ... menu select
Get Infoand pressView XML. In the XML file that opens you'll find the id as a string here:<Video ratingKey="108014". Where in this case108014is the id.5. Editing the database
Before you continue I must warn you that editing the database in this way is not supported and if done incorrectly, can in a worst case scenario corrupt the plex database. However, as we are doing only minor changes, I feel it is relatively safe.
Here are some examples of common commands I've found useful: Remember to change
<your movie id>,<old tag>and<new tag>or you may get an error.
- Add/edit edition tag for a single item:
UPDATE metadata_items SET edition_title = "<new tag>" WHERE id = <your movie id>;- Add/edit tag for a list of items:
UPDATE metadata_items SET edition_title = "<new tag>" WHERE id in (<your movie id>, <your movie id>, <your movie id>);- Edit all instances of a tag from
<old tag>to<new tag>:UPDATE metadata_items SET edition_title = "<New tag>" WHERE edition_title = "<old tag>";That's it!
-- Quark95 🖖🏻
