# Update added\_at field in metadata\_items table

**URL:** <https://forums.plex.tv/t/update-added-at-field-in-metadata-items-table/888672>\
**Category:** Metadata & Adding Files\
**Tags:** metadata\
**Created:** [September 18, 2024, 3:47pm UTC](https://forums.plex.tv/t/update-added-at-field-in-metadata-items-table/888672 "2024-09-18T15:47:54Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![pablo17](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/pablo17/32/9178_2.png) [@pablo17](https://forums.plex.tv/u/pablo17)\
**Post date:** [September 18, 2024, 3:47pm UTC](https://forums.plex.tv/t/update-added-at-field-in-metadata-items-table/888672/1 "2024-09-18T15:47:54Z")

</div>

Server Version#: 1.41.0.8992  
Player Version#: N/A

I am trying to update the added\_at field in the metadata\_items table for a single movie. I am using DB Visualizer to run the SQL command on a saved copy of my PlexMedia database.

Here is my command and error. The database is not missing as I can run many select queries on it.

![image](https://global.discourse-cdn.com/plex/original/4X/f/7/8/f789614e8b97664d3a5f84d17256eb24edfbc6f0.png)

I was wondering what I am doing wrong.

---

<div class="post-metadata">

**Author:** ![anon5074910](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@anon5074910](https://forums.plex.tv/u/anon5074910)\
**Post date:** [September 18, 2024, 4:00pm UTC](https://forums.plex.tv/t/update-added-at-field-in-metadata-items-table/888672/2 "2024-09-18T16:00:24Z")

</div>

You need to use sqlite which comes with plex itself.

---

<div class="post-metadata">

**Author:** ![pablo17](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/pablo17/32/9178_2.png) [@pablo17](https://forums.plex.tv/u/pablo17)\
**Post date:** [September 18, 2024, 4:16pm UTC](https://forums.plex.tv/t/update-added-at-field-in-metadata-items-table/888672/3 "2024-09-18T16:16:14Z")

</div>

Thanks for your quick response. So the fact that DB Visualizer provides a SQLite driver is not adequate then?

---

<div class="post-metadata">

**Author:** ![anon5074910](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@anon5074910](https://forums.plex.tv/u/anon5074910)\
**Post date:** [September 18, 2024, 4:45pm UTC](https://forums.plex.tv/t/update-added-at-field-in-metadata-items-table/888672/4 "2024-09-18T16:45:30Z")

</div>

From what I remember plex uses a custom schema and the version of sqlite that is bundled with plex is required to save that specific data.

---

<div class="post-metadata">

**Author:** ![pablo17](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/pablo17/32/9178_2.png) [@pablo17](https://forums.plex.tv/u/pablo17)\
**Post date:** [September 18, 2024, 5:08pm UTC](https://forums.plex.tv/t/update-added-at-field-in-metadata-items-table/888672/5 "2024-09-18T17:08:48Z")

</div>

Good to know and thanks again.

---

<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:** [December 17, 2024, 5:09pm UTC](https://forums.plex.tv/t/update-added-at-field-in-metadata-items-table/888672/6 "2024-12-17T17:09:14Z")

</div>

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