# On deck is broken from new server move **URL:** \ **Category:** General Discussions\ **Created:** [January 23, 2018, 11:06pm UTC](https://forums.plex.tv/t/on-deck-is-broken-from-new-server-move/222691 "2018-01-23T23:06:02Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![antonclr](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@antonclr](https://forums.plex.tv/u/antonclr)\ **Post date:** [January 23, 2018, 11:06pm UTC](https://forums.plex.tv/t/on-deck-is-broken-from-new-server-move/222691/1 "2018-01-23T23:06:02Z")
Also posted in General discussions (Plex Pass) - If this is bad, someone tell me Pleassseee someone help! I have just moved from Windows to Freenas and decided to make a fresh new database (which I see now is a slight mistake, but I was advised that moving the whole folder structure over would be difficult due to the Windows registry storing settings, where linux/freebsd will use an XML…anyway). I have followed the link below to move over the viewstates; [support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/](https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/ "https://support.plex.tv/articles/201154527-move-viewstate-ratings-from-one-install-to-another/") But this has **only** pulled across whether I have viewed the item or not. When I check On Deck, this is empty. If I go to a show, even though a lot are watched, the On Deck in the TV show doesn’t show either; But will do for any unwatched; If I then go and check the database, I can see that everything is matched up and for my account ID still. In that the generated guid is correct; ![](https://sea1.discourse-cdn.com/plex/uploads/default/original/3X/8/6/8619e10f18bac8631fb2947ea31efff4facbcffb.png) ![](https://sea1.discourse-cdn.com/plex/uploads/default/original/3X/5/1/51cfe8666dec19d85e34675585bf35d7eb6a0135.png) One weird thing, if I then watch the next item, everything sorts itself out, but with a shared server of around 10 people I need a blanket fix for this. I have ran `sqldiff.exe` to see what happens to the data when I watch something, but this has told me nothing, only that a `metadata_item_settings` record is created and also a `metadata_item_views` record, but the latter table can be dropped and on deck still shows; which tells me `metadata_item_settings` is the key! I have probably hunted every post imaginable here and really need some help from someone who knows that slightly little bit more than me. Someone suggested that this is based on originally available, but all my TV Shows have a originally\_available\_at datetime as I use this for correcting my Recently added all the time (as to me it should be recently aired); `UPDATE metadata_items SET refreshed_at = NULL, added_at = originally_available_at, created_at = originally_available_at, updated_at = NULL WHERE library_section_id IN (3)` To finalise, things I have tried; - Import from SQL file made in the “Move Viewstate/Ratings support page” - Update any mismatched TV Shows (basically, my previous server have TheMovieDB for some of the Shows, so simply updated these to the TheTVDB guids - Corrected any `view_counts` \> 1, whilst making sure the season/show `view_count` is updated also, just a thought I had - Re-run the SQL from “Move Viewstate/Ratings support page” about 10 times total now - Optimised the database - Cleaned bundles - Emptied trash - Restarted PMS - Cleared cache in Web Browser - Checked that the new Server’s On Deck “look back X weeks” is set to \>= 156 (previously) - Updated random datetime fields in the `metadata_item_settings` table to see if that does anything, i.e. you can’t watch a season before the last episode is watched (yeah I know this would of been done correctly when being watched in old PMS Please anyone help or find your nearest Plex Ninja/Employee! 😃 ---
**Author:** ![antonclr](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@antonclr](https://forums.plex.tv/u/antonclr)\ **Post date:** [January 25, 2018, 12:58pm UTC](https://forums.plex.tv/t/on-deck-is-broken-from-new-server-move/222691/2 "2018-01-25T12:58:39Z")
Bump bump? I really am lost here. Seems like a bug ---
**Author:** ![antonclr](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@antonclr](https://forums.plex.tv/u/antonclr)\ **Post date:** [January 28, 2018, 12:28pm UTC](https://forums.plex.tv/t/on-deck-is-broken-from-new-server-move/222691/3 "2018-01-28T12:28:00Z")
Bump. Anyone have any ideas? (Nothing on my Plex Pass forum post, but it looks like that is closed now. Not sure why. ---
**Author:** ![antonclr](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@antonclr](https://forums.plex.tv/u/antonclr)\ **Post date:** [February 3, 2018, 10:57am UTC](https://forums.plex.tv/t/on-deck-is-broken-from-new-server-move/222691/4 "2018-02-03T10:57:02Z")
Bump. Anyone from the Plex workforce? 😄 ---
**Author:** ![anon18523487](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@anon18523487](https://forums.plex.tv/u/anon18523487)\ **Post date:** [February 7, 2018, 7:41pm UTC](https://forums.plex.tv/t/on-deck-is-broken-from-new-server-move/222691/5 "2018-02-07T19:41:21Z")
Hi there. Another staffer pointed me to this thread. Can you post a screenshot of your OnDeck screens? I’m a bit confused on what screens you are looking at. ---
**Author:** ![anon18523487](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@anon18523487](https://forums.plex.tv/u/anon18523487)\ **Post date:** [February 7, 2018, 8:00pm UTC](https://forums.plex.tv/t/on-deck-is-broken-from-new-server-move/222691/6 "2018-02-07T20:00:43Z")
Ignore my earlier post. > @antonclr said: > But this has **only** pulled across whether I have viewed the item or not. When I check On Deck, this is empty. If I go to a show, even though a lot are watched, the On Deck in the TV show doesn’t show either; Correct, that process is only for copying the watched status. The OnDeck info is based on this info, so if this was done properly, the OnDeck should also carry over. OnDeck is based on the last watched date so maybe something isn’t quite right. > One weird thing, if I then watch the next item, everything sorts itself out, but with a shared server of around 10 people I need a blanket fix for this. I get it now. Can you PM me your current database with the ratings already imported so I can check whats going on? ---
**Author:** ![antonclr](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@antonclr](https://forums.plex.tv/u/antonclr)\ **Post date:** [February 11, 2018, 12:01am UTC](https://forums.plex.tv/t/on-deck-is-broken-from-new-server-move/222691/7 "2018-02-11T00:01:07Z")
Good evening, I sure can. Just waiting for it to not be in use if you see this message in the next 15 minutes or so ---
**Author:** ![Thr3d](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/thr3d/32/102369_2.png) [@Thr3d](https://forums.plex.tv/u/Thr3d)\ **Post date:** [October 23, 2018, 5:46pm UTC](https://forums.plex.tv/t/on-deck-is-broken-from-new-server-move/222691/8 "2018-10-23T17:46:21Z")
@antonclr What ended up happening with this? ---
**Author:** ![antonclr](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@antonclr](https://forums.plex.tv/u/antonclr)\ **Post date:** [October 25, 2018, 6:52pm UTC](https://forums.plex.tv/t/on-deck-is-broken-from-new-server-move/222691/9 "2018-10-25T18:52:27Z")
I didn’t end up getting any response from replying to the previous guy. I just left it, manually marked stuff as On Deck again on my own account and reported what shows my shared user base had as well and emailed them all. I think this was an in-depth database issue with al the fields, I could not see what had happened after hours of research and comparing database changes between before and after watching a video to attempt to mark it all via sql as on deck again. ---
**Author:** ![kenkieffer](https://avatars.discourse-cdn.com/v4/letter/k/a698b9/32.png) [@kenkieffer](https://forums.plex.tv/u/kenkieffer)\ **Post date:** [June 5, 2019, 8:55pm UTC](https://forums.plex.tv/t/on-deck-is-broken-from-new-server-move/222691/10 "2019-06-05T20:55:06Z")
Would love to get some further detail on how Plex determines the On Deck stuff - I have 3 servers (identical content) and have figured out a good solution for syncing watch states across the servers, but not a good solution for the “On Deck”. Any info on how this is determined or could be manipulated would be greatly appreciated! ---
**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\ **Post date:** [January 8, 2020, 12:30am UTC](https://forums.plex.tv/t/on-deck-is-broken-from-new-server-move/222691/11 "2020-01-08T00:30:03Z")