Movies are not showing up in On Deck

General Discussions
1

TV Shows are currently showing up in ON deck but Movies are not. I double checked in the library preferences/Advanced and Include in dashboard is checked. I do have one library that this is disabled, but not my primary movie library.

Any ideas? I have a bunch of unfinished movies and am having trouble finding them sometimes.

Movies not showing in On Deck
2

Only the most recent 3 movies are shown in OnDeck.

And only for a limited time.
(Settings - Server - Library - ‘Show Advanced’ - “Weeks to consider for On Deck”)

And only if the movie library has this check box active in its
library properties - ‘Advanced’ tab - “Include in dashboard”

3

Then perhaps mine is broken.

Weeks to consider for on Desk - Currently 10, have tried up to 52 (no movies)

Include in Dashboard = Checked

No movies in list (i have watched quite a few in the last month that are currently unfinished.

Is there any other way to search for unfinished movies?

4

You can try the ‘list’ view.
Switch your library into list view
then make sure the column ‘Progress’ is visible
then click on the column header ‘Progress’ twice.

But your original issue might be an indication of a damaged database.
You better investigate it now before the damage is beyond repair:

  1. activate debug logging (not ‘verbose’!)
  2. quit Plex Server
  3. wait 1 minute
  4. start Plex Server
  5. wait 3 minutes
  6. fetch log files and attach them here

or Inspect them yourself. Open the Plex Media Server.log and search for occurences of the work corrupt
If you find any, you need to repair your Plex database.

5

Thanks OttoKerner. I had no idea that progress was an option in list view. Very handy. I have about 50 unfinished movies!

On the logs. I followed directions and found about 50ish listings of:

Apr 30, 2017 14:30:35.547 [0x30bdf400] ERROR - SQLITE3:(nil), 11, database corruption at line 62365 of [fc49f556e4]
Apr 30, 2017 14:30:35.550 [0x30bdf400] ERROR - Gracenote: Music locale error -1870658241 (CorruptDB: A database disk image is malformed)

All seem to be referring to the music database…

So, yeah there is some database corruption. For once I’me not terribly worried about it this time as I’m in the process of backing everything up and rebuilding my server. I have about 12 TB to backup then restore, so I’m in this for 10-14days if my estimates are correct.

I wonder if this error was preventing me from doing Plex updates a while back on my Drobo? Hmm.

6

@jsfarmer said:
Apr 30, 2017 14:30:35.547 [0x30bdf400] ERROR - SQLITE3:(nil), 11, database corruption at line 62365 of [fc49f556e4]
Apr 30, 2017 14:30:35.550 [0x30bdf400] ERROR - Gracenote: Music locale error -1870658241 (CorruptDB: A database disk image is malformed)

Luckily, this is only referring to a supplementary database, which gets recreated over time when deleted.
Your main database seems to be unaffected.

Or do you also get references to the main DB file com.plexapp.plugins.library.db being corrupt?

7

Hmm. I don’t see a file called com.plexapp.plugins.library.db or reference to one in the main log file.

Here are my logs. What am I doing wrong?

8

You are doing nothing wrong.
It is like I assumed, the main database is intact - that’s good.

Shut down Plex server
go to your Plex data folder/Cache
in there are 4 files with names

gn_cachc.gdb
gn_cachq.gdb
gn_colls.gdb
gn_lists.gdb

erase them.

Then restart Plex Server.
This should get rid of the corruption messages in the log.
(Gracenote functions will be temporarily out of order. Make sure you leave the device powered on during the maintenance hours, so the Butler has a chance to restore the data.)

Delete the ._ExpatTV.bundle from your plugins folder.
It throws errors as well.

9

Wow. Thanks! I’ll do that as soon as I get home.