Some Movies are missing from view when sorted by anything but "By Title"

[bryguy2828_gmail.com]

Server Version#: 1.19.5.3112 (on Windows 10.0.19041 Build 19041)
Player Version#: 4.29.2

My Movies view is almost always sorted by “Date Added” so I see the most recent added movies first, but I noticed recently that a new movie wasn’t being sorted to the top of the page. When I searched for that movie (Ava), I found that it had been mistakenly match with Onward, so I Split it and the ran a “Fix Match” to properly match the movie. I went back to my Sort by Date Added view and it was still not listed. When I search for the movie, Plex finds it correctly. I switched the Sort by from “Date Added” to “Title”, and then I scrolled down to the find the movie listed! I flipped through all the other sort by options and noticed that they only list 659 movies, while Sort by “Title” lists 692 movies.

The movie is also not listed in the “Recently Added Movie” on the “Media Server” page.

I ran an “Optimize Database”, and it completed without any change.

I ran a “Clean Bundles” not that i could imagine it would be related to this issue.

I reviewed my %LOCALAPPDATA%\Plex Media Server\Logs\Plex Media Server.log file and searched for both corrupt or malformed but found neither.

Is my next step to Check for Corruption and Run a Repair?

Thanks in advance,

[Volts]

The issue with Ava (2020) matching Onward (2020) is known and Plex has said they’re investigating. (This does seem to be matching correctly with the latest preview Scanner/Agent.)

There are a couple of workarounds to get it added with a current date.

One is to move the file for Ava out of any Plex-monitored directory, scan, empty trash, and clean bundles. Then name the file something that cannot match any other movies you have, add it back, scan. Then manually fix the match to Ava. Then rename the file to the correct/original name, and scan again to make sure it detected the rename. It should, and should also have a current date.

Or if you’ve already got it split from Onward and the only issue is the added_at date, you can do this if you are comfortable.

Plex find the movie folder but don't show on library

I didn’t have this problem with this movie - my files are named how Plex likes, and the new agent matched it correctly for me - but I have had this issue in the past. I’m not absolutely certain if Plex needs to be stopped before running this update. Can’t hurt. sqlite3 com.plexapp.plugins.library.db "update metadata_items set added_at=datetime('2020-08-20 12:34:56') where title = 'Ava' and metadata_type = 1;" This assumes you don’t have other movies named “Ava” exactly.

—

Sort by Title is a special view because it also includes Collections - so the number of items will be larger.

—

One effective way to look for files that may be incorrectly matching existing movies is the Duplicate view.

[bryguy2828_gmail.com]

Thanks for the suggestions! I’ll give them a try and report back.

@Volts

Sort by Title is a special view because it also includes Collections - so the number of items will be larger.

Great point that I didn’t make the connection on! That accounts for the difference between 692 and 659 for me as I have 33 collections!

@Volts

One effective way to look for files that may be incorrectly matching existing movies is the Duplicate view.

That is exactly how I found out that Ava had matched with Onward, so I lucked into that one!

[bryguy2828_gmail.com]

@Volts

One is to move the file for Ava out of any Plex-monitored directory, scan, empty trash, and clean bundles. Then name the file something that cannot match any other movies you have, add it back, scan. Then manually fix the match to Ava. Then rename the file to the correct/original name, and scan again to make sure it detected the rename. It should, and should also have a current date.

That worked for me! Thank you!!!

[Volts]

Yay! It was silly-complicated, but … glad it worked for you.