Date added incorrect, contradicts own information

[vippin]

Server Version#: Version 1.15.6.1079
Player Version#: Version 3.95.2

Hi team, I added another HDD and moved the folder my movie collection is stored in to the new HDD. I then changed the folder location in the web server library to point it at the new HDD.

The web server didn’t like it much and now it shows all files as added at the time the location was moved. It has however kept what movies have been watched.

It contradicts itself as it will show a movie as added several hours ago, but if you check the play history, it has plays from years ago. I’m not sure how to resolve this problem.

I have refreshed metadata, had it scan the library multiple times, closed and reopened the server multiple times.

Any assistance appreciated.

[OttoKerner]

• Restore a database file from before the move.
  https://support.plex.tv/articles/202485658-restore-a-database-backed-up-via-scheduled-tasks/
• Shut down Plex server
• Make sure the movies are stored under the same folder names as they were on the old hard drive.
• Change the drive letter of the new drive to the drive letter of the old drive.
  https://www.lifewire.com/how-to-change-a-drive-letter-2626069
• give the old drive a different drive letter

When you start plex server, it won’t notice anything has changed, since it still can find the movies under the old drive letter.

If you want to move content to other locations, without chaning anything about its metadata, edit the Plex database directly: [HowTo] Plex database modification - Moving media the right/wrong way

[vippin]

Unfortuntately that did not work. On further attempt to Google the issue, I found this link:

Recently Added changed to File Create/Modified date

astrofisher; While I thank you for that info, the problem exists with the link I posted due to the image used in that discussion is no longer available and that contained the lines of code I needed.

Following the instructions set out by MI95SHO I was able to resolve the issue.

Steps are as follows:

1. Download SQLITE3.exe (http://www.sqlite.org/download.html )
2. Place the .exe in your Plex Server database location; Typically: “C:\Users\NAME\AppData\Local\Plex Media Server\Plug-in Support\Databases”
3. Run SQLITE3 as Admin
4. type: “.open com.plexapp.plugins.library.db”
5. type: “update metadata_items set added_at=(select media_items.updated_at from media_items where media_items.metadata_item_id=metadata_items.id);”
6. type: “.quit”
7. Close out of Plex Media Server (tray icon and all)
8. Relaunch Plex Media Server
9. Enjoy re-sorted titles

[paulvian1965_gmail_com]

Thanks vippin - that did the trick!