A movie I've deleted from my hard drive keeps reappearing in my Plex Movie Libarary

General Discussions
21

LOL! I changed it to that so that it’d be a little humorous!

22

That would be fantastic. I had Plex create a DB report, but I don’t know how to PM you? I’ll keep trying to find it.

23

Okay, I read how to send a PM, and I can send it to some people, just not you.

Untitled-1
Untitled-1820×610 162 KB

24

he might have messaging turned off because he gets too many unrequested ones. You can message it to me and I will get it to him.

25

It was too large to send the file, so I uploaded it to my Google Drive & sent you the link. He should be able to D/L the zip file from there. Thank you very much!

26

@Steve-Pippin

Somehow you have a phantom metadata_items record for something without an associated media item.

You can remove this by doing the following;

  1. Stop PMS
  2. Make a backup of your database
  3. Downloads sqlite3 (more info here https://support.plex.tv/articles/201100678-repair-a-corrupt-database/)
  4. Then run the following commands from windows command prompt (ensuring you have the full path to your database and sqlite3 executable)
  5. sqlite3 com.plexapp.plugins.library.db "DROP index 'index_title_sort_naturalsort'"
  6. sqlite3 com.plexapp.plugins.library.db "DELETE from metadata_items where id = 39614"
  7. Start Plex Media Server and check that the bad record has been removed.
27

Thanks. It didn’t work. I sent you a private message with more information and a link to a fresh media database. I think I might have messed you up by changing the DB before I did the fix.

28

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