Context / Logs
Since my previous post on this topic was closed due to inactivity (On Deck “Weeks to consider” not being respected), I have been able to update my Synology DSM version and therefore my PMS version. Unfortunately, the problem persists, so I’m starting a new thread.
CC @TeknoJunky
Server Version#: 1.19.2.2702 (776106bc6)
Player Version#: not applicable; shows up in all clients, including Android, Roku, web
Plex Media Server Logs_2020-04-24_11-00-19.zip (4.9 MB)
Summary
- I have “Weeks to consider for On Deck and Continue Watching” set to 104 weeks.
- A show I haven’t watched since 2016-07-14 has the next episode manifesting in “On Deck” across all player platforms.
Detail
To see what’s going on under the hood of the watched history, to validate when Plex thinks I last watched the show, I made a copy of /volume1/Plex/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db and ran some SQL commands on it (using sqlite3), dumping the output to a text file (Plex.View.Log.2020-04-24.txt):
SELECT c.name,
b.title,
a.rating,
a.view_count,
CASE
WHEN a.view_offset IS NULL THEN '100.0%'
ELSE printf('%.1f', 100.0 * cast(a.view_offset AS REAL) / cast(b.duration AS REAL)) || '%'
END percent,
a.last_viewed_at
FROM metadata_item_settings a
LEFT JOIN accounts c ON a.account_id = c.id
LEFT JOIN
(SELECT a.guid,
CASE a.library_section_id
WHEN 1 THEN a.title
WHEN 2 THEN d.title || ' - S' || substr('00' || c.`index`, -2, 2) || 'E' || substr('00' || a.`index`, -2, 2) || ' - ' || a.title
WHEN 6 THEN a.studio || ' - ' || a.title
END title,
b.duration
FROM metadata_items a
LEFT JOIN media_items b ON a.id = b.metadata_item_id
LEFT JOIN metadata_items c ON c.id = a.parent_id
LEFT JOIN metadata_items d ON d.id = c.parent_id
WHERE a.metadata_type = 1
OR a.metadata_type = 4) b ON a.guid = b.guid
WHERE b.title IS NOT NULL
AND a.last_viewed_at IS NOT NULL
ORDER BY a.last_viewed_at ASC;
Now, here is the relevant line of output from running cat Plex.View.Log.2020-04-24.txt | grep Silicon:
ArthurZey Silicon Valley - S03E10 - The Uptick 1 100.0% 2016-07-14 22:31:12
You can see that the last_viewed_at value is 2016-07-14 22:31:12, which should disqualify the show from coming up in “On Deck”, since that’s well over 104 weeks in the past.
