Hey, i’m hoping someone can help me with a bizarre issue I have not encountered before. I’ve searched the forums and can’t find anything, so if this has been asked before, please point me in the right direction
I have just added a new show to Plex with 10 episodes. Strangely, it automatically appeared in ‘On Deck’ even though I haven’t watched a single episode. Stranger still, the episode that appeared in ‘On Deck’ is the 10th episode! All episodes are marked as ‘Unwatched’, so firstly, how do I stop it from appearing in ‘On Deck’, and secondly, if it really has to, how can I make sure it is only the first episode that appears, and not the 10th?
I’ve marked the 10th episode as watched, and the 1st then appears on ‘On Deck’, but I like my Plex to be cleaner than that.
I have also stripped all the files of any tags, and retagged with MetaX, and used FileBot to name and move the files to the correct location.
Using the web interface mark the entire series as watched then mark it us unwatched. Unless there is something really weird happening that should clear all the flags.
Must be something really weird, that didn’t help either (but thanks for the suggestion!).
I have even gone so far as to remove the files, restart the server and re-add them. Marked them as watched, restarted the server, and marked them as unwatched etc. Still no joy…
@geokie said:
Must be something really weird, that didn’t help either (but thanks for the suggestion!).
I have even gone so far as to remove the files, restart the server and re-add them. Marked them as watched, restarted the server, and marked them as unwatched etc. Still no joy…
I know it probably has nothing to do with it but exactly how is that series named and what is the structure of the file system? I do not know how that could matter but it “could” be detecting it as another series that has been partially watched or some such thing.
We are kind of getting close to my limits of reasonable ideas. There are others here with much more expertise that might be able to help more.
@OttoKerner said:
Maybe, this show was in the past already on the server?
Or another show was mistakenly identified as this one?
Not to doubt but would not either of those issues be cleared by marking the series as watched and then marking it unwatched?
In the past whenever I have performed those actions on a series that was on deck it disappeared from on deck. That is it was returned to a totally virgin state.
Hey guys, I’ve tried the watched/unwatched process. Its also the first time I’ve added it to the server. The files are structured & named:
G:\TV Shows\Santa Clarita Diet\Season 1\Santa Clarita Diet - S01E01 - So Then a Bat or a Monkey.mkv (etc.)
I’ve even gone so far as to download the show from another source, and swap out the files, using the Plex Dance process, including optimization, but still no luck sad face
@Elijah_Baley said:
Not to doubt but would not either of those issues be cleared by marking the series as watched and then marking it unwatched?
In the past whenever I have performed those actions on a series that was on deck it disappeared from on deck. That is it was returned to a totally virgin state.
These procedures should work, yes.
So I guess it is database repair time.
@geokie I hope you did not move your plex data folder over to a network folder or something? Because this is a recipe for database corruption. And I think this is what we have here.
The above linked help article contains 4 commands to be issued on a command line.
These need to be replaced by the 4 commands below, otherwise you may get garbled special characters.
Windows
-------
sqlite3 "%LocalAppData%\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" "PRAGMA integrity_check"
sqlite3 "%LocalAppData%\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" .dump > dump.sql
rename "%LocalAppData%\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" com.plexapp.plugins.library.db.original
sqlite3 "%LocalAppData%\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db" < dump.sql
If you previously moved the Plex data folder to a different location than the default, replace %LocalAppData% with the actual parent directory path.
Hey thanks @OttoKerner , but I really have no idea what i’m doing there, and i’m really scared i’m gonna f**k it all up…
I haven’t moved the data folder, its still located in C:\Program Files (x86)\Plex where I installed it.
I followed your link to the Repair a Corrupt Database page, and followed that through to the SQLite Download page, but I have no idea what one I need to download.
My windows is a 64bit version, but the only option I could find that seemed even remotely correct was sqlite-tools-win32-x86-3170000.zip which contained sqlite3.exe.
I ran it, and entered the first command you gave me above, however it seemed to do nothing, and just returned this “…>”
I even tried to put in the full address so it read ““C:\Program Files (x86)\Plex\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db” “PRAGMA integrity_check”” but no joy.
I know i’m doing something wrong, but this is way above anything I have had to do before and I have no clue…
Are you able to dumb it down for me please? Sorry to take up so much of your time, and I fully appreciate all you guys have done so far…
Cheers,
@geokie said:
I followed your link to the Repair a Corrupt Database page, and followed that through to the SQLite Download page, but I have no idea what one I need to download.