I have a perplexing issue. I have a corrupt Plex entry which I cannot figure out how to get rid of. I discovered it through some weird behavior ocurring whenever I scrolled near the movie. Whenever I got to the movies beginning in “My___” every app (web, mobile, desktop) would bug out and spit out an error in the middle of scrolling through, no matter if I scrolled from above or below it. As soon as I got close to it, it would basically crash Plex (unexpected error or something) and I’d have to quit and restart. I wasn’t sure which movie it was exactly, but I followed steps to repair the database, which fixed the scrolling issue, so I can now see it was “Mystery Date,” but now it’s a corrupt entry I cannot get rid of.
Deleting the file does nothing. It’s empty, doesn’t appear in search, I can’t even edit it, open it, refresh metadata, match, unmatch, etc (It always returns an error). Viewing the XML returns a 500 Internal Server Error, too. I have tried manually deleting the original file, rescanning, etc, but it still remains in Plex.
tl;dr I have a corrupt Plex entry that can’t be deleted, edited, or viewed. I’m thinking the only way to remove it is via SQL in the database. Is that correct, and how would I do this? Within the Mac terminal, and what are the exact commands?
I have a similar issue with music. I was editing some tags and accidentally used the artist name for the album too. I tried fixing this, but it seemed to have a stop and was spinning while trying to update the tags for the song. Eventually it threw an error about unable to update the file. Looking for it later, the tags I was trying to edit (Track and album titles) are blank. Any attempt to update them “appears” to save, but going back to the details shows the fields are blank again.
I already removed the file, moved file around, done scans/cleanup trash/plex dance. Even tried restarts of the server itself. The file seems to be “stuck” in plex limbo, and anytime I re-add the same file it seems to associate so it doesn’t give me a new song loaded, but I still can’t manipulate the “bugged” song.
The odd part is when moving the file to a different folder, it will pick up on the new location of the file when checking the details but still won’t let me manipulate any of the tags/details to adjust the title or similar again.
I’m thinking of editing the tags for the song locally, putting into a different directory again, and seeing if it will at least find the song again. I would still have this “bugged” version of the song lingering around though.
Just as a follow up, my “workaround” did work for me. I edited tags locally, put into a new directory, it found the new song separate from the previous “bugged” song. As I figured though, I still have the “bugged” song lingering around in the library.
As a note my server is on Linux, as I noted the original post noted mac for the server.
