# Database browser help!
**URL:** https://forums.plex.tv/t/database-browser-help/768884
**Category:** Plex Media Server
**Tags:** server-windows, server-linux
**Created:** [January 6, 2022, 11:46am UTC](https://forums.plex.tv/t/database-browser-help/768884 "2022-01-06T11:46:27Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@SUPERBIF](https://forums.plex.tv/u/SUPERBIF)
#### Post date: [January 6, 2022, 11:46am UTC](https://forums.plex.tv/t/database-browser-help/768884/1 "2022-01-06T11:46:27Z")
Hi I want to add some old movies, but doesn’t want the to show up in recently added.
Earlier I could either change timestamp on file or use SQL database browser to correct that, but neither solution work anymore.
How can I get it to work?
I have Plex on Unraid docker but can also install and export db file to Windows.
The built in SQL doesn’t have a browser, so really hope someone can help, so I don’t have old movies to recently added.
---
### Author:  [@anon18523487](https://forums.plex.tv/u/anon18523487)
#### Post date: [January 6, 2022, 6:22pm UTC](https://forums.plex.tv/t/database-browser-help/768884/2 "2022-01-06T18:22:34Z")
See [Can no longer update library database with sqlite3](https://forums.plex.tv/t/can-no-longer-update-library-database-with-sqlite3/701405/) for a similar situation and solution near the bottom.
Changing the file’s timestamp won’t work. The added date is based on your system clock. You would need to change the date on your computer, scan the file, change the date back.
---
### Author:  [@VBB](https://forums.plex.tv/u/VBB)
#### Post date: [January 6, 2022, 6:57pm UTC](https://forums.plex.tv/t/database-browser-help/768884/3 "2022-01-06T18:57:43Z")
It would really be great to have a “Remove from recently added” option. I tend to add a lot of old (read: really OLD) movies that nobody ever watches or even remotely cares about. So, with an option like that, I could easily keep the queue much cleaner.
Along those lines, and sorry for hijacking the thread, what I’d also love to see is an option to “Split apart” at the library level. This would be highly useful, if your Plex count doesn’t match your file/folder count, but you have no idea what’s missing. Splitting apart at the library level would then put those movies/shows into the “Unmatched” category instead, and they would be easy to filter out and fix.
Thanks for reading! 😛
---
### Author:  [@anon18523487](https://forums.plex.tv/u/anon18523487)
#### Post date: [January 6, 2022, 7:16pm UTC](https://forums.plex.tv/t/database-browser-help/768884/4 "2022-01-06T19:16:05Z")
> [@VBB](#):
>
> It would really be great to have a “Remove from recently added” option.
That’s been requested. [Remove show from "Recently added..." list](https://forums.plex.tv/t/remove-show-from-recently-added-list/278075)
---
### Author:  [@anon18523487](https://forums.plex.tv/u/anon18523487)
#### Post date: [January 6, 2022, 7:27pm UTC](https://forums.plex.tv/t/database-browser-help/768884/5 "2022-01-06T19:27:47Z")
> [@VBB](#):
>
> Along those lines, and sorry for hijacking the thread, what I’d also love to see is an option to “Split apart” at the library level.
There’s a filter for duplicates that will show you anything that can be “split”. Not sure how useful splitting an entire library in 1 time would be. I have things that are merged on purpose.
---
### Author:  [@VBB](https://forums.plex.tv/u/VBB)
#### Post date: [January 6, 2022, 7:32pm UTC](https://forums.plex.tv/t/database-browser-help/768884/6 "2022-01-06T19:32:45Z")
It would be helpful for cases where something is merged, but not a duplicate. This can happen with TV shows, for example when you have two seasons of show 1, and Plex merged another show and added it as a third season, or when it merges shows at the season level, but with non-overlapping episodes. I admit, this would be rare, but it can happen. Ever since I switched to the new scanner, my show count is off by just one, and it’s been driving me nuts 😉 When you have a huge amount of shows, it’s near impossible to figure out what’s going on.
---
### Author:  [@anon18523487](https://forums.plex.tv/u/anon18523487)
#### Post date: [January 6, 2022, 7:42pm UTC](https://forums.plex.tv/t/database-browser-help/768884/7 "2022-01-06T19:42:33Z")
> [@VBB](#):
>
> It would be helpful for cases where something is merged, but not a duplicate.
Ah, only for TV shows.
> when it merges shows at the season level,
I see what you mean. I don’t know if a library level split apart would be the solution, but yeah there does need to be a way to identify these easier.
---
### Author:  [@VBB](https://forums.plex.tv/u/VBB)
#### Post date: [January 6, 2022, 7:46pm UTC](https://forums.plex.tv/t/database-browser-help/768884/8 "2022-01-06T19:46:36Z")
> [@anon18523487](#):
>
> there does need to be a way to identify these easier.
I don’t really see another way, if something gets identified, but mismatched and therefore merged. Maybe add a filter for only splittable items, so we can at least get an idea of what’s been merged already.
---
### Author:  [@SUPERBIF](https://forums.plex.tv/u/SUPERBIF)
#### Post date: [January 7, 2022, 10:31am UTC](https://forums.plex.tv/t/database-browser-help/768884/9 "2022-01-07T10:31:49Z")
Hi thanks for all the answers.
The first solution with changing the system clock is not easy. Using Unraid with Plex in a Docker.
I however found a solution. The solution is this:
Copy db to a Windows 10 machine.
Launch PowerShell:
$PlexDB = “c:\Users\username\AppData\Local\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db”
$PlexEXE = “C:\Program Files (x86)\Plex\Plex Media Server\Plex Media Server.exe”
$SQL = “UPDATE metadata\_items SET added\_at = ‘2005-12-03 00:00:00’ where library\_section\_id = ‘1’ and added\_at \>= ‘2022-01-05 00:00:00’”
& “$PlexEXE” “-sqlite” $PlexDB $SQL
With this command I change all movies from January 05 2022 and forward to December 03 2005.
Can’t take credit for it, saw @bpalloni wrote a post about it and a Reddit post with commands.
The little thing I stumbed upon is the following.
When I copy it back to directory afterwards the attributes is 666, before it was 644. When I change it back, it gives the following error and can’t launch Plex, but if I leave it at 666, I get no errors and can launch Plex.
Error: Unable to set up server: sqlite3\_statement\_backend::loadOne: attempt to write a readonly database (N4soci10soci\_errorE)
---
### Author:  [@SUPERBIF](https://forums.plex.tv/u/SUPERBIF)
#### Post date: [January 10, 2022, 11:36am UTC](https://forums.plex.tv/t/database-browser-help/768884/10 "2022-01-10T11:36:16Z")
Anyone that can validate if it’s okay to have the db as 666?
---
### Author:  [@pl\_5309](https://forums.plex.tv/u/pl_5309)
#### Post date: [January 10, 2022, 2:35pm UTC](https://forums.plex.tv/t/database-browser-help/768884/11 "2022-01-10T14:35:10Z")
Did you change the user:group back to plex?
---
### Author:  [@SUPERBIF](https://forums.plex.tv/u/SUPERBIF)
#### Post date: [January 11, 2022, 11:53am UTC](https://forums.plex.tv/t/database-browser-help/768884/12 "2022-01-11T11:53:11Z")
owner is root
group is users
It’s the same as the original file before changing.
Am using it in Unraid docker.
---
### Author:  [@pl\_5309](https://forums.plex.tv/u/pl_5309)
#### Post date: [January 11, 2022, 12:53pm UTC](https://forums.plex.tv/t/database-browser-help/768884/13 "2022-01-11T12:53:56Z")
When you created your docker container via the template a userid and groupid where set, most likely 99/100 unless you changed them to root/user.
You can use 666 but I don’t know if that will cause plex to fail when it does backup and optimize.
---
### Author:  [@SUPERBIF](https://forums.plex.tv/u/SUPERBIF)
#### Post date: [January 12, 2022, 11:44am UTC](https://forums.plex.tv/t/database-browser-help/768884/14 "2022-01-12T11:44:47Z")
I haven’t changed anything, but how can I see the default userid/groupid? Using Guacamole but can use commandline as well.
---
### Author:  [@SUPERBIF](https://forums.plex.tv/u/SUPERBIF)
#### Post date: [January 12, 2022, 11:52am UTC](https://forums.plex.tv/t/database-browser-help/768884/15 "2022-01-12T11:52:21Z")
Got it working now. Did a ls -l and saw the other files had nobody as owner. Did a chown nobody of db file and changed to 644 and it’s working like original:)
---
### Author:  [@system](https://forums.plex.tv/u/system)
#### Post date: [April 12, 2022, 11:52am UTC](https://forums.plex.tv/t/database-browser-help/768884/16 "2022-04-12T11:52:51Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.