Fix incorrect recently added items in Plex

fix-incorrect-recently-added-items-in-plex.md

Fix incorrect recently added items in Plex

Sometimes Plex saves a addedAt date in the future, in which case the item will always be stuck in the first position.

With this method you don't have to edit the database directly or shut down the server. You can fix it directly in the browser.

Fix the wrong date value

1. Open your browser's developer tools
2. Navigate to the console tab
3. Adjust the following command and paste it into the console

var plexHost = "https://plex.domain.com"
var plexToken = "XXXXXXXXXXX"

var sectionId = "1"
var itemId = "12345"
// 1 for movie, 4 for episode
var typeId = "4"
// unix timestamp
var addedAtValue = "1672527600"

fetch(
  `${plexHost}/library/sections/${sectionId}/all?type=${typeId}&id=${itemId}&addedAt.value=${addedAtValue}&X-Plex-Token=${plexToken}`,
  {"method": "PUT"}
)

Get Plex token / Get item metadata

Unix timestamp conversion

Found this, and it helped a bunch!

Ill just leave this here for people using docker and is having this issue.

This will change all items that have a date never than next year (1767272400 - You can change this to whatever)

I also found a bunch of errors going back in time, added a code to update all items that are older than year 2000 (946731600)

docker exec -it plex bash

cd "/config/Library/Application Support/Plex Media Server/Plug-in Support/Databases"

/usr/lib/plexmediaserver/Plex\ SQLite "com.plexapp.plugins.library.db" "UPDATE metadata_items SET added_at = created_at WHERE added_at > 1767272400;"

/usr/lib/plexmediaserver/Plex\ SQLite "com.plexapp.plugins.library.db" "UPDATE metadata_items SET added_at = created_at WHERE added_at < 946731600;"

exit