Recently Added doesn't list movies by date added

Plex Media Server Metadata & Adding Files
1

Server Version#: 1.50.1
Player Version#: 1.28.1.6018

I tried a full library scan and still not showing up in proper order of addition to the library. I peeked into the SQL Database located here:

/Users/john/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db

executed this SQL command
‘select * from metadata_items’

and noticed many of the “originally_available_at” dates are listed as “NULL” and that the “added_at” date strings are in a form I can’t recognize as a date. Looks like it’s in Epoch format?

I would like to recalculate the “added_at” date string based off the files “Modified” Date. How can I do this?

EDIT
On macOS
cd into the movie files directory and run this command on the file to compare it to the data in the SQL database:
stat -f %B file

2

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