Strange. I’m assuming so just based on the database location and I don’t have another I could mix it up with.
make a copy of the database file and then open that in DB Browser (or other suitable app) and inspect the tables to see what fields are there.
That’s exactly what I did haha. I think I got confused along the way – added_at is inside metadata_items, but I was looking in media_items.
well yeah, that’s the table my post had
Good thing I noticed. I updated added_at , which I can see took effect, but the movie is still showing up in recently added. Not sure what to try anymore.
"/Applications/Plex Media Server.app/Contents/MacOS/Plex SQLite" "$HOME/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db" "UPDATE metadata_items SET added_at='2018-04-20 11:40:33' WHERE id = 148715"
I’m assuming it’s the right ID because its library_section_id is 2 and the title matches.
did you stop and start the plex server? and then re-analyse the item?
if it’s the correct ID then it should disappear from the recently added items if there are newer items.
1 Like
That did the trick. Thank you
Friends, i need your help. Yesterday in com.plexapp.plugins.library.db the date format was normal lile added_at=‘2018-04-20 11:40:33’ but today after large move of files between 2 folders, the dates in metadata_items db are strange lile “1650580306”.
In plex app info is normal.
What is this format and how to revert back?
Thanks
Doing so will break Plex!
Time is now Unix Epoc
See: https://www.epochconverter.com/ for easy convert, as already said by @Volts here: Can no longer update library database with sqlite3 - #135 by Volts
1 Like
And since this post has been resolved, I’m now closing it
