Server Recently Added Not Updating - addedat not being correctly set

Plex Media Server Desktops & Laptops
1

Server Version#: 1.18.2.2029 \ windows
Player Version#: 4.12.2

The server recently added items list isn’t updating. I looked at the xml for one of the items at the beginning and it shows “originallyAvailableAt=“2009-04-12” addedAt=“4039401600” updatedAt=“1574070852”>”

The updatedat epoch is correct, however the addedat shows a date of 1\1\2098 at 8am (12am local).

I couldn’t figure out how it got this date, so I looked at the video file. The date timestamps on the video file are:
Created: ‎Friday, ‎September ‎23, ‎2016, ‏‎6:34:02 PM
Modified: ‎Wednesday, ‎January ‎1, ‎2098, ‏‎12:00:00 AM
Accessed: ‎Friday, ‎September ‎23, ‎2016, ‏‎6:34:02 PM

I have no idea why the modified date is incorrect\garbage, however that appears to be where the addedat epoch is coming from.

From this I have two questions:

  • Why is the addedat date coming from the file and not when the server indexes the file (my assumption of what addedat is since it uses this field for recentlyadded)?
  • Should there be some kind of filter or bounds checking to prevent an addedat in the future - realistically it couldn’t be addedat anything further in the future than the current date\time?
2

This only happens when you create a new library in Plex and let it index a folder immediately during the course of the library creation. These nonsensical ‘modified’ date/timestamps are often caused by file servers or workstations without battery-buffered RTC chips.
Maybe a NAS which wasn’t configured to use a NTP server or couldn’t acquire proper time because it had no (internet)connection while it was booted up.

Maybe. But it is rather a rare occurence.

3

Do you know if there is a batch way to fix (ideally) or detect which files in plex have bad times? As an example it shows a tv series with this issue, but I’d have to check each episode of the series to see which file has the bad date.

Also, since you said above that it only uses these dates during library creation, if I delete the whole library and create it with no folders (or a temp empty folder) and then add all of my folder paths after the library exists, would it then use the current date instead of the file date? If so then this might work as well.

4

I assume so.

Somewhere on these forums is also a SQL command which you could cast in a SQL editor. Unfortunately I can’t find it right now.

5

Creating each library empty and adding the folders after appears to have worked. Thanks for the help.

6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.