{"type_":"Posts","comments":[],"posts":[{"post":{"id":741763,"name":"[Guide] Adding/editing Plex edition tags using simple SQL commands. No PlexPass Required.","url":"https://i.ibb.co/nzRprNb/Screenshot-2023-07-08-at-11-43-51.png","body":"cross-posted from: https://lemmy.fmhy.ml/post/778602\n\n> 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.\n> \n> ### Limitations\n> 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. \n> \n> \n> ## Method\n> \n> ### 1. Identify your plex database location.\n> Generally your database should be located here:\n> `[Plex data directory]/Plug-in Support/Databases`.\n> But depending on your system `[Plex data directory]` will be different.\n> [Here is a list of common directories.](https://support.plex.tv/articles/202915258-where-is-the-plex-media-server-data-directory-located/)\n> \n> ### 2. Identify your plex binary location.\n> 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.\n> In my case the path is `/volume3/@appstore/Plex Media Server/Plex Media Server`, since I installed plex in Volume 3 on my Synology.\n> \n> 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.\n> \n> ### 3. Connecting to the database\n> 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`.\n> \n> > You may have to enable ssh access on your system.\n> \n> 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\"`.\n> \n> Alternatively you could try `sqlite3 \"[Plex Data directory]/Plug-in Support/Databases/com.plexapp.plugins.library.db\"`\n> \n> 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\"`\n> \n> Now a prompt should appear that looks like this:\n> \n> `sqlite>`\n> \n> ### 4. Finding IDs\n> 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 Info` and press `View XML`. In the XML file that opens you'll find the id as a string here: `

Search