Plex Sort by Date - New libraries file added date is wrong

Server Version#: 1.18.2.2058 - Linux
Player Version#: Samsung

I have had this issue before, and this was the solution:

update metadata_items set added_at=(select media_items.updated_at from media_items where media_items.metadata_item_id=metadata_items.id)

Has the field name changed from “added_at” to “created_at”?
I don’t see the “added_at” field in the media_items table.

Thank you in advanced.
Leon

The added_at field is in the metadata_items table, just like your sql statement is written. Did you get some kind of error when you ran that statement?

Hi helphand

Thank you for the quick response.
No, i did not get any error from sql, but after i re-start PMS with the new database, the files still seemed out of order.
I then did it again, but this time PMS crashed every time i tried to open Plex.

I am busy re-building my database, thanks to 100Mb/s internet, it is not taking that long.
I shall try to do it again after the re-build and let you know, should be within the next 45 min.

Hi helphand

It all worked, it seems that after a clean database, PMS is a lot more happy… :smiley:

Thank you again for your quick response.

Z

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