Weird 'On Deck' Behaviour

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 :slight_smile:

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.

Any help would be amazing!

Thanks,

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…

OK. Try a full Plex Dance. https://forums.plex.tv/discussion/comment/908454/#Comment_908454

Also, add to that an “optimize database” while the series is not in the Plex library structure.

Wow, I really wished that helped, I thought all bases were covered there, but 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.

Maybe, this show was in the past already on the server?
Or another show was mistakenly identified as this one?

If that is not the case, it might be time to repair your Plex database.

@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.

https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database

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,

Oh, wait… I see where the data folder is, my bad. But it is still in the default location… Man, this is going to keep me up at night!

@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.

read from here: https://forums.plex.tv/discussion/comment/1323952/#Comment_1323952

Do you use Trackt?
That addon caused me “on deck” grief

@spikemixture said:
Do you use Trackt?
That addon caused me “on deck” grief

Hehe, yes that could do some weird things.

Another source for weird things in OnDeck would be a Plex Client in perpetual ‘Pause’ mode.
Check your Rokus…

@OttoKerner said:
Another source for weird things in OnDeck would be a Plex Client in perpetual ‘Pause’ mode.
Check your Rokus…

Thanks for that tidbit.
I have a couple of clients that are roku’s and get paused!
Will monitor that.

Cheers for the help guys! I ended up just watching the show, that sorted it out. Will run sqlite at some point tho, cos it could probably help anyway :slight_smile: