# Weird 'On Deck' Behaviour **URL:** \ **Category:** General Discussions\ **Created:** [February 17, 2017, 11:27pm UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480 "2017-02-17T23:27:06Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![geokie](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@geokie](https://forums.plex.tv/u/geokie)\ **Post date:** [February 17, 2017, 11:27pm UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/1 "2017-02-17T23:27:06Z")
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. Any help would be amazing! Thanks, ---
**Author:** ![Elijah\_Baley](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elijah_baley/32/10336_2.png) [@Elijah\_Baley](https://forums.plex.tv/u/Elijah_Baley)\ **Post date:** [February 17, 2017, 11:34pm UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/2 "2017-02-17T23:34:08Z")
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. ---
**Author:** ![geokie](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@geokie](https://forums.plex.tv/u/geokie)\ **Post date:** [February 18, 2017, 12:04am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/3 "2017-02-18T00:04:20Z")
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… ---
**Author:** ![Elijah\_Baley](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elijah_baley/32/10336_2.png) [@Elijah\_Baley](https://forums.plex.tv/u/Elijah_Baley)\ **Post date:** [February 18, 2017, 12:07am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/4 "2017-02-18T00:07:32Z")
> @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/t/the-plex-dance/197064). [https://forums.plex.tv/discussion/comment/908454/#Comment\_908454](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. ---
**Author:** ![geokie](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@geokie](https://forums.plex.tv/u/geokie)\ **Post date:** [February 18, 2017, 12:49am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/5 "2017-02-18T00:49:00Z")
Wow, I really wished that helped, I thought all bases were covered there, but no joy! ---
**Author:** ![Elijah\_Baley](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elijah_baley/32/10336_2.png) [@Elijah\_Baley](https://forums.plex.tv/u/Elijah_Baley)\ **Post date:** [February 18, 2017, 1:00am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/6 "2017-02-18T01:00:44Z")
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. ---
**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\ **Post date:** [February 18, 2017, 1:06am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/7 "2017-02-18T01:06:06Z")
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. ---
**Author:** ![Elijah\_Baley](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/elijah_baley/32/10336_2.png) [@Elijah\_Baley](https://forums.plex.tv/u/Elijah_Baley)\ **Post date:** [February 18, 2017, 1:11am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/8 "2017-02-18T01:11:07Z")
> @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. ---
**Author:** ![geokie](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@geokie](https://forums.plex.tv/u/geokie)\ **Post date:** [February 18, 2017, 1:18am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/9 "2017-02-18T01:18:53Z")
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.) ---
**Author:** ![geokie](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@geokie](https://forums.plex.tv/u/geokie)\ **Post date:** [February 18, 2017, 1:22am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/10 "2017-02-18T01:22:40Z")
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_ ---
**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\ **Post date:** [February 18, 2017, 1:46am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/11 "2017-02-18T01:46:17Z")
> @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](https://support.plex.tv/articles/202915258-where-is-the-plex-media-server-data-directory-located/) 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](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. ```auto 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](https://support.plex.tv/hc/en-us/articles/202915258-Where-is-the-Plex-Media-Server-data-directory-located- "Plex data folder") to a different location than the default, replace %LocalAppData% with the actual parent directory path. ---
**Author:** ![geokie](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@geokie](https://forums.plex.tv/u/geokie)\ **Post date:** [February 18, 2017, 2:15am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/12 "2017-02-18T02:15:27Z")
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, ---
**Author:** ![geokie](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@geokie](https://forums.plex.tv/u/geokie)\ **Post date:** [February 18, 2017, 3:56am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/13 "2017-02-18T03:56:18Z")
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! ---
**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\ **Post date:** [February 18, 2017, 2:01pm UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/14 "2017-02-18T14:01:53Z")
> @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](https://forums.plex.tv/discussion/comment/1323952/#Comment_1323952) ---
**Author:** ![spikemixture](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/spikemixture/32/7233_2.png) [@spikemixture](https://forums.plex.tv/u/spikemixture)\ **Post date:** [February 19, 2017, 8:37am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/15 "2017-02-19T08:37:43Z")
Do you use Trackt? That addon caused me “on deck” grief ---
**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\ **Post date:** [February 19, 2017, 5:14pm UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/16 "2017-02-19T17:14:31Z")
> @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… ---
**Author:** ![spikemixture](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/spikemixture/32/7233_2.png) [@spikemixture](https://forums.plex.tv/u/spikemixture)\ **Post date:** [February 20, 2017, 5:16am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/17 "2017-02-20T05:16:20Z")
> @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. ---
**Author:** ![geokie](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@geokie](https://forums.plex.tv/u/geokie)\ **Post date:** [March 13, 2017, 6:57am UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/18 "2017-03-13T06:57:52Z")
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 🙂 ---
**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\ **Post date:** [January 7, 2020, 10:46pm UTC](https://forums.plex.tv/t/weird-on-deck-behaviour/180480/19 "2020-01-07T22:46:30Z")