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… 
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.
