# Fixing Future-dated metadata

**URL:** <https://forums.plex.tv/t/fixing-future-dated-metadata/932298>\
**Category:** Metadata & Adding Files\
**Tags:** metadata\
**Created:** [October 9, 2025, 8:20pm UTC](https://forums.plex.tv/t/fixing-future-dated-metadata/932298 "2025-10-09T20:20:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![akraut](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/akraut/32/103245_2.png) [@akraut](https://forums.plex.tv/u/akraut)\
**Post date:** [October 9, 2025, 8:20pm UTC](https://forums.plex.tv/t/fixing-future-dated-metadata/932298/1 "2025-10-09T20:20:11Z")

</div>

After finding this excellently informative post by @omegadev: [Fix for movies and tv shows stuck at the front of recently added](https://forums.plex.tv/t/fix-for-movies-and-tv-shows-stuck-at-the-front-of-recently-added/902262)

I think I may have streamlined this approach. In my case, the `updated_at` dates were fine, but the `added_at` dates were out of whack. You could easily replace `updated_at` with `unixepoch()` to make them added “right now”.

I did this on the DB live while Plex was running because I like to live dangerously. Don’t try this at home. Consult a medical professional before beginning treatment. etc…

Also note, those trigger definitions might change between versions. I fyou’re not using the Server version I listed at the bottom, use `.schema metadata_items` to copy their create statements somewhere safe and use those to put them back in place after your UPDATE statement.

```SQL
DROP TRIGGER fts4_metadata_titles_before_update_icu;
DROP TRIGGER fts4_metadata_titles_after_update_icu;
UPDATE metadata_items SET added_at = updated_at WHERE added_at > unixepoch();
CREATE TRIGGER fts4_metadata_titles_after_update_icu AFTER UPDATE ON metadata_items BEGIN INSERT INTO fts4_metadata_titles_icu(docid, title, title_sort, original_title) VALUES(new.rowid, new.title, new.title_sort, new.original_title); END;
CREATE TRIGGER fts4_metadata_titles_before_update_icu BEFORE UPDATE ON metadata_items BEGIN DELETE FROM fts4_metadata_titles_icu WHERE docid=old.rowid; END;

```

* * *

Server Version#: 1.43.0.10162 (TrueNAS Docker Container)

---

<div class="post-metadata">

**Author:** ![omegadev](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/omegadev/32/341814_2.png) [@omegadev](https://forums.plex.tv/u/omegadev)\
**Post date:** [October 9, 2025, 9:41pm UTC](https://forums.plex.tv/t/fixing-future-dated-metadata/932298/2 "2025-10-09T21:41:34Z")

</div>

Thanks for the shoutout @akraut . I still think its rather damming that this issue still exists and the plex team seems to be thumbing their nose all this time. at us. The only reason i didn’t use unixepoch() is it would be detrimental to my hypersensitive OCD. LMAO. Still good call.

---

<div class="post-metadata">

**Author:** ![akraut](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/akraut/32/103245_2.png) [@akraut](https://forums.plex.tv/u/akraut)\
**Post date:** [October 9, 2025, 11:08pm UTC](https://forums.plex.tv/t/fixing-future-dated-metadata/932298/3 "2025-10-09T23:08:25Z")

</div>

Aside from doing deep digging on the disk for the ~800 entries that needed fixing to find “last modified file times” I decided that `updated_at` was a suitable proxy. But yeah, I hear ya. I wish it was more accurate to the time it landed on disk for the first time. Some of these are years old…

---

<div class="post-metadata">

**Author:** ![omegadev](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/omegadev/32/341814_2.png) [@omegadev](https://forums.plex.tv/u/omegadev)\
**Post date:** [October 10, 2025, 1:18am UTC](https://forums.plex.tv/t/fixing-future-dated-metadata/932298/4 "2025-10-10T01:18:01Z")

</div>

Definitely, i’ve got some files with created dates as far back as 2004 so i’m right there with ya. Anywhoo. Happy my post was able to help someone else sort through their stuck items. It took me a while to get to a bulletproof solution, at least for my needs, figured i’d share it with the community.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [January 8, 2026, 1:18am UTC](https://forums.plex.tv/t/fixing-future-dated-metadata/932298/5 "2026-01-08T01:18:38Z")

</div>

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