Specific shows will not mark as played

[Stackk]

Server Version#: 1.25.8.5663
Player Version#: 1.25.8.5663

Hi all, hope this is a simple one.

I migrated my library.db from my old Mac based server to my new Unraid server. Everything seems to be fine except for one show which was being watched when I copied the database. That show will no longer accept changes to play status.

It will not mark as played when clicking the “mark as played” either as a show, by episode, or by season.

The specific episode that was being watched is permanently stuck at its last played point. (~50%) Watching that episode or others does not change play status. They always show as new with the exception of the one stuck at 50%.

Restarting episodes also does not set the process back to the beginning. I can resume from start, watch 5 mins of the ep, then return to the season screen and it will still say that episode is 50% watched.

Is there a way to remove and re-add this show from the .db file without losing the rest of the database? Removing and re-adding to the library was unsuccessful.

[tom80H]

Have you checked for database corruption and potentially attempted to repair the database?

[Stackk]

Ah, I have not. I think repairing is a good first step, but I’m not sure how to get the command to run when I’m hosting in docker.

Found this on reddit, I’ll give it a go and see if it works.

you need to copy the plex executable out of the container
docker cp plex:/usr/lib/plexmediaserver/ /path/to/some/folder

then you can use

"/path/to/some/folder/Plex Media Server" --sqlite com.plexapp.plugins.library.db "SQL Statement goes here"

Should look like this for me I think:

docker cp plex:/usr/lib/plexmediaserver/ /mnt/user/‘SHARE’
[return]
/mnt/user/‘SHARE’/Plex\ Media\ Server --sqlite com.plexapp.plugins.library.db “.output recover.out” “.recover”
[return]