# Problems adding new media

**URL:** <https://forums.plex.tv/t/problems-adding-new-media/577854>\
**Category:** Metadata & Adding Files\
**Tags:** server-drobo, library-management\
**Created:** [April 20, 2020, 2:54pm UTC](https://forums.plex.tv/t/problems-adding-new-media/577854 "2020-04-20T14:54:38Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![mackfamily](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/mackfamily/32/84224_2.png) [@mackfamily](https://forums.plex.tv/u/mackfamily)\
**Post date:** [April 20, 2020, 2:54pm UTC](https://forums.plex.tv/t/problems-adding-new-media/577854/1 "2020-04-20T14:54:38Z")

</div>

Upon updating my Drobo PMS to this version I had experienced the same problem of no new media showing up and all searches broken.

Upon installing sqlite3 onto my drobo and trying to read the database I got these errors from the sqlite3 program.

```auto
sudo sqlite3 com.plexapp.plugins.library.db "DROP index 'index_title_sort_naturalsort'"
Last login: Mon Apr 20 07:37:29 PDT 2020
Error: file is encrypted or is not a database

```

So I decided the file must be corrupt. I backed it up and deleted the original and restarted the server from scratch… sad to loose all context within the library, but it could be worse.

Hope this helps others experiencing the same problem.

---

<div class="post-metadata">

**Author:** ![tom80H](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tom80h/32/19753_2.png) [@tom80H](https://forums.plex.tv/u/tom80H)\
**Post date:** [April 20, 2020, 4:31pm UTC](https://forums.plex.tv/t/problems-adding-new-media/577854/2 "2020-04-20T16:31:52Z")

</div>

The error message actually say it correct – it’s encrypted (so people or apps don’t start messing around in the productive/running server).

That being said… before jumping to fix the database, let’s rule out some more basic issues.  
What exact issue do you have with your Plex? What troubleshooting steps have you already done?  
Mind sharing some details about your setup / what type of files isn’t showing?!  
Any related error messages?

---

<div class="post-metadata">

**Author:** ![tom80H](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tom80h/32/19753_2.png) [@tom80H](https://forums.plex.tv/u/tom80H)\
**Post date:** [April 20, 2020, 4:50pm UTC](https://forums.plex.tv/t/problems-adding-new-media/577854/3 "2020-04-20T16:50:24Z")

</div>

> [@tom80H](#):
>
> The error message actually say it correct – it’s encrypted (so people or apps don’t start messing around in the productive/running server).

Sorry… I should not answer posts while still chasing stuff from work 😉  
I only read up to the part that you installed sqlite3 on your drobo…

Have you quit the PMS before running those commands?

---

<div class="post-metadata">

**Author:** ![mackfamily](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/mackfamily/32/84224_2.png) [@mackfamily](https://forums.plex.tv/u/mackfamily)\
**Post date:** [April 20, 2020, 5:23pm UTC](https://forums.plex.tv/t/problems-adding-new-media/577854/4 "2020-04-20T17:23:34Z")

</div>

Yes I did quit/stop Plex before attempting to “repair” the database.

Ah yes if it is encrypted then it may not have been corrupted. Should there be text/commands added on how to unencrypt it in order to execute the commands linked on the documentation page about fixing a corrupt db?

Though after deleting and reindexing everything search and recently added (really library sync) works again… Something definitely was off just don’t know what was wrong.

---

<div class="post-metadata">

**Author:** ![mackfamily](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/mackfamily/32/84224_2.png) [@mackfamily](https://forums.plex.tv/u/mackfamily)\
**Post date:** [April 20, 2020, 6:54pm UTC](https://forums.plex.tv/t/problems-adding-new-media/577854/5 "2020-04-20T18:54:55Z")

</div>

@tom80H I first noticed that server search wasn’t working after the upgrade to this version as called out in this other thread, [Library Search Not Working](https://forums.plex.tv/t/library-search-not-working/570838/16)

Though even after confirming that I had included via config the libraries into global search it still didn’t work. After a while I noticed that some titles I were looking for were recent additions (~3-5 days old all added after the upgrade), but weren’t showing up in the Dashboard nor in the Library View itself.

I’m not really sure why, but even manually triggering a “scan library files” didn’t resolve my issues so that led me to believe something wasn’t right about the database.

---

<div class="post-metadata">

**Author:** ![tom80H](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tom80h/32/19753_2.png) [@tom80H](https://forums.plex.tv/u/tom80H)\
**Post date:** [April 20, 2020, 8:17pm UTC](https://forums.plex.tv/t/problems-adding-new-media/577854/6 "2020-04-20T20:17:33Z")

</div>

> [@mackfamily](#):
>
> Though even after confirming that I had included via config the libraries into global search…

Meaning you have checked the `On Deck` option for all libraries you want to be in the global search scope?

# 

> [@mackfamily](#):
>
> … recent additions (~3-5 days old all added after the upgrade … weren’t showing up in the Dashboard nor in the Library View itself.

What media are we talking about – e.g. movies or tv shows?  
Have you verified the files are not simply ignored?  
[https://support.plex.tv/articles/201543057-why-is-some-of-my-content-not-found/](https://support.plex.tv/articles/201543057-why-is-some-of-my-content-not-found/)

If that’s not it… can do a [Plex Dance](https://forums.plex.tv/t/the-plex-dance/197064) and pull some logs after returning the files and running the final scan? ([Plex Dance](https://forums.plex.tv/t/the-plex-dance/197064): remove the files in question from the folder supervised by Plex, scan the library files, empty trash, clear bundles, return the files, scan the library files again)

---

<div class="post-metadata">

**Author:** ![mackfamily](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/mackfamily/32/84224_2.png) [@mackfamily](https://forums.plex.tv/u/mackfamily)\
**Post date:** [April 21, 2020, 12:55am UTC](https://forums.plex.tv/t/problems-adding-new-media/577854/7 "2020-04-21T00:55:57Z")

</div>

After the removal of the old database all the media was added and read successfully by the Plex scanners. I have always used the same naming pattern: `<Movie Title> (<YYYY>)` and have never had a problem.

All titles missing from index/database metadata were movies and not TV Shows.

---

<div class="post-metadata">

**Author:** ![mackfamily](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/mackfamily/32/84224_2.png) [@mackfamily](https://forums.plex.tv/u/mackfamily)\
**Post date:** [April 27, 2020, 6:19pm UTC](https://forums.plex.tv/t/problems-adding-new-media/577854/8 "2020-04-27T18:19:57Z")

</div>

Just started having the same issues again. In the server logs I’m seeing a few logs about database corruption (before and after updating to 1.19.2.2711-bab6de29f which was just released).

```auto
Thread: Uncaught exception running async task which was spawned by thread 0x2f743450: sqlite3_statement_backend::loadOne: database disk image is malformed

SQLITE3:0x3787, 11, database corruption at line 64757 of [bf8c1b2b7a]

SQLITE3:0x3787, 11, database corruption at line 64798 of [bf8c1b2b7a]

SQLITE3:0x3787, 11, statement aborts at 13: [select statistics_bandwidth.id as 'statistics_bandwidth_id', statistics_bandwidth.account_id as 'statistics_bandwidth_account_id', statistics_bandwidth.device_id as 'statistics_bandwid

```

---

<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:** [July 26, 2020, 6:20pm UTC](https://forums.plex.tv/t/problems-adding-new-media/577854/9 "2020-07-26T18:20:02Z")

</div>

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