Latest Update and Agent, Collections Issues

I just updated Plex and switched to the new agent. Did a force Refresh metadata and having a few issues.

  1. Can no longer edit Collection Tags “Your changes could not be saved.” Doesn’t matter if the field is locked or not.
  2. Movies that are part of collections, is not being added to the collection.
  3. Can’t delete existing collections.

I’ve added 2 new movies, Cruel Intentions 3 (collections none) and Honey: Rise Up and Dance (no collection listed either)

As I said I can’t manually add them as I just get the generic error “Your changes could not be saved” and refreshing the metadata multiple times and agents doesn’t solve the issue either.

Any ideas?

Could you provide the server logs? Settings -> Troubleshooting -> Download Logs.

Thanks, I can see what appears to be some database corruption. To get to the bottom of this a copy of your database would be the easiest for me to diagnose. If you don’t mind grabbing that and sending it to me via a DM (click my username and hit Message).

To grab the database just head over to Settings -> Troubleshooting -> Download Database.

I am having this exact same problem. Could you please let me know what the solution is?

Here is what he sent me

AS ALWAYS BACKUP YOUR DATABASE FIRST JUST IN CASE!

Thanks. That helped me figure out the problem.

Somehow some title fields on collections in your database got set to NULL which is a bit strange as that shouldn’t ever happen.

The fix for this should be just setting these back to a readable value but you will need to run a sqlite command on your database.

To do this you can follow these steps:

  1. Shutdown your Plex server (very important)
  2. Navigate to the folder where your database resides, find the data folder for your installation (https://support.plex.tv/articles/202915258-where-is-the-plex-media-server-data-directory-located/) and the database will be located in the “Plug-ins Support” directory.
  3. Once in the directory with the database run the following command:

sqlite3 com.plexapp.plugins.library.db "update metadata_items set title = title_sort where library_section_id = 2 and metadata_type = 18 and title is NULL"

  1. Restart your Plex server and check if you can now make changes to collection.

If you’re not too familiar working with the command line there are also other tools available so please let me know.

folks should be very careful about randomly putting that command, because it is likely that different people will have different section id’s (I assume metadata_type would stay the same, but that could be different too).

1 Like

I’m having the same issue. I tried to repair the database by using the steps from the forum, but it didn’t work. It could be my command line skills or lack of. You mention about other tools that could be used, can you elaborate? I’d like to try to repair myself. I’m concerned that the solution you provided this user was specific for his database so I don’t want to try given the comment by the last user. Please let me know … thanks!

I’m also having the same problem. I’m unable to delete unwanted collections or add/remove collection tags from individual movies. I’ve also noticed that when I try to remove the collection tag from a movie, the option to refresh metadata for that movie is grayed out.

The SQL fix listed above doesn’t apply to me, either. I have no collections with a NULL title. Are there other ways we can check for corruption in the database?

Plex Media Server Logs_2020-07-29_02-50-18.zip (7.0 MB)
This problem has been non-stop since I installed the new update. The first time, I wound up frustratingly downgrading and having to launch from an old database. Then I updated again and the same thing happened. Then I created a brand new Library for movies. I felt like maybe the solution was to create a new library from scratch with the new agent to avoid the problem. Worth a try, right? I scanned in all of my movies. As I went through the library one title at a time changing posters, editing metadata, creating collections; all was well except for the fact that collections that i created wouldn’t save any synopsis information i put in.

Here’s what happened next, and I hope this information can help the devs pinpoint the problem. When I created the library i set the automatic collection minimum to 2. I had a series with two films in it, but one of them failed to match when i initially scanned everything in. So, I went and matched the unmatched title. When the two films didn’t automatically move into a collection, I went to edit them manually into a collection. When I attempted to do this, ‘Your changes could not be saved’. It was after this point that I could no longer edit ANY metadata and still can’t.

I now have two broken movie libraries that I can’t edit any metadata for. Like wi11wright, refresh metadata is grayed out on any title that I attempt to edit. This is the third time this has happened to me since upgrading. There has to be something wrong with the update. Is there a fix for this, or should I just downgrade again? Please advise. Please help. Thanks.

Open any collection. Click edit. Click advanced. Change collection mode. Doesn’t matter to what. Save changes. After you do this you can change it back. I have no clue why or how, but this completely fixed everything instantly. Everything except synopsis in created collections still won’t stick. Automatically vanishes. This is way minor though compared to what I was going through before. Something is wonky for sure, but try this out until they figure it out. Let me know if it works for you too!

1 Like

Thanks so much for the updated commentary. Glad I’m not alone here and that fellow users are trying to help. I did try to change the collection mode, then change it back, but unfortunately it didn’t help. I’m hoping this gets the attention of the Plex team. Thanks again.

To add little more information from my view, I have 12 movie related libraries. Only one of the libraries is not allowing me to add new movies to a collection or delete that collection. All 12 libraries don’t allow me to add summary comments about that collection. And, if there are comments originally from before this started, if I open the collection to view, close and reopen, the comments disappear. I hope this helps.

One other issue I noticed recently which has been annoying. When I refresh the Metadata on any particular movie I can tell Plex is going out and retrieving the new information but when it stops there is no change. However, when I hit reload on my browser (Google Chrome), it puts me back into the user sign in, I enter my pin and it brings me right to the movie I updated with the new metadata. I’m the administrator for my server. Hope that makes sense, anyone else see this issue?

Does anyone from Plex monitor these comments? Or, is there a better way to connect with them to provide solution(s)?

I’m still unable to edit synopsis in my collections. I type it in. I click save changes. It saves. Box closes. Then it looks as though the collection refreshes because the poster does that little spin and POOF! My synopsis is gone. I can edit the already existing synopsis for the collections that were automatically generated, but any collections that I create still no synopsis. Will this be addressed in the next update? Given the traffic to this thread right after the update, I would say this problem is probably not unique to myself or the few in this thread. I’d be happy to send over more logs or anything you need. If anybody on Plex’s staff is reading this, please help us address this. A major feature is broken. Thanks.

Thank you for your comments. I agree, same is happening to me. Just to be clear any existing collections that I created over the years that had summary comments is now completely blank. Any new collections I can add a comment, hit save and it appears. Reopen the collection and the comments are gone.

In addition to the above, the other major issue is the inability to add movies to a collection. Of my 12 libraries this only happens in one. I can see the collection title that I would like to add, but when I select “Save Changes” I get the statement to the left in the box: “Your Changes Could Not Be Saved.” Also, if I try to delete a collection a red box comes down from the top and says, “There Was a Problem Deleting This Item”.

It would be helpful and appreciated if a Plex employee could acknowledge this thread and provide any relevant commentary.

Thannks.

Bueller … Bueller … Bueller?

Anyone listening? A simple response from Plex like we’re looking into the issue and will get back to you might be nice.

Is it practical to downgrade the PMS software to an earlier version? I’m currently on 1.20.0.3133. If the downgrade makes sense, what are the pitfalls?

In my very non-technical view, the problem may have been started with Plex using a new Agent approach. It wiped out all my prior collection comments that I spent many hours curating.

Comments are appreciated.
Thanks.

I don’t immediately see it, but a Plex employee commented - somewhere - that there’s a known issue with summaries/comments on collections, and that an upcoming beta will address the issue.

@deactivated was that you?

Maybe it was @gbooker02, because look what was just released:

Thanks guys for responding … appreciate it!

I see the update is available, fingers crossed that it will fix the issue.

Best regards!