TV Shows "Last Episode Date Added" sorting incorrectly

Server Version#: 1.20.1.3252

The sorting is incorrect on all clients. It seems to use the date of the “first episode date added”.

seems to be working here with 1.20.2. in the menu is the arrow pointing down indicating it is descending . ( click the item in menu to reverse direction)

Plex

Perhaps it is just an issue with DVR recordings. I have descending “Last Episode Date Added” sort order as shown in your picture. The result is in the picture below. The latest episode dates are Oct. 3 for Austin City Limits, Oct. 1 for This Old House, and Oct. 5 for Dancing With the Stars so the display sort order makes no sense.

sort

Additionally, using this sorting on Android TV shows captions like “27 days ago” under the show thumbnail for shows with recordings that have taken place within the last week.

In the Recommended tab for that library is Recently Added hub correct? it should basically be the same as Last episode date added

Yes the “Recently Aired” hub has the correct order (different from what Last Episode Date Added is presenting).

not the Recently Aired, if you scroll down on the Recommended Tab there should be a Recently Added hub. Wondering if that has the same issue

I only have the Recently Aired hub for my Recordings Library, no Recently Added.

I do have Recently Added TV on the home screen which has the same order as Recently Aired for the Library.

Will this be addressed sometime soon?

Been asking folks and it seems like there may be something wrong with your database as I have not seen this elsewhere. I am thinking the added at date is not being saved for some reason or not properly. A recently added hubs should be there and the last episode date added sort would be using the same value to sort by

if you look at the XML for one of the newly added episodes in it should be an addedAt value in epoch time.

for this episode of Brooklyn 99 the added at date is addedAt=“1587692869” which is GMT Friday, April 24, 2020 1:47:49 AM ( epoch time converter https://www.epochconverter.com/ )

Screen Shot 2020-10-14 at 12.59.57 PM

Can you check a few of your recently recorded stuff and see if that addedAt value is there or very incorrect. Info on viewing XML here https://support.plex.tv/articles/201998867-investigate-media-information-and-formats/#toc-1

My first thought if incorrect is to check the clocks on your computer running PMS and/or device files are saved if a NAS for example. If it is correct or not there then I am thinking something wrong with database

A Windows 10 PC set to the correct time is running the server and doing the TV recording. The addedAt values seem to be correct in the XML. For example, for Dancing With the Stars it has addedAt=“1601950200” which corresponds to October 5. Maybe it is looking at a different date for DVR recordings?

it should not be afaik. if you look at multiple the newest episodes for shows listed when sorted by last episode date added are they all correct?

It sure seems to me that it is sorting by the date when the “show” was first recorded/added rather than individual episodes. See below. It lists Next before This Old House even though the latest episode of TOH was recorded after the first episode of Next. This would also explain why the show thumbnail caption in Android TV is so far in the past.


then I would check the date for first episode those shows were added then to confirm.

if you view by episode rather than shows and sort by date added. is that wrong also?

Screen Shot 2020-10-14 at 3.31.58 PM

That sorting is correct.

thx.

is it possible to get a copy if your database file and message it to me? You can get it from trouble shooting section of server settings. (click on my username or avatar and click message)

So there is another table UpdatedAt in the database for the entire show that does not appear to be updating for you but not sure why. I cannot reproduce and other folks who have DVR only libraries are not having the issue.

I was wondering if you could do a couple things.

  1. update your server to the latest public which is 1.20.2
  2. run a database optimization ( from troubleshooting section of server settings)
  3. check if it updates for the next show episode you add via DVR

I did all these steps but it did not make a difference. A new episode of This Old House was recorded this morning but the show is still displayed in the same sorting position. Oh well, I guess this is not going to work. Thanks for trying.

I am trying the DVR again so want to revisit this and try to get it working. Would setting up the DVR recordings through a Managed user instead of the Admin have any effect on this?