Some Series show all episodes watched, but actually are not

[t0815]

VERSION INFORMATION

Server Version: 4.2.1

Desktop Version: 4.2.1

LOG FILE

n/a

DESCRIPTION

Related to #627 propably.

I noticed that some series show, there are no episodes remaining to watch after update, but all episides are actually unwatched. Did not start playing them with new version either.

STEPS TO REPRODUCE

1. ) Hard to tell, i can accross a series by chance
2. ) so... find a series you havent been watching and check details page

[ElementalCrisis]

Do you actually have files for this series?

I believe you're using the beta Web UI, check on there and let us know what it says.

[t0815]

yes, i have files for the given series. How do i access the beta web ui?

[ElementalCrisis]

Manually download it and replace the contents of the Web UI folder with it.

[revam]

~~Or just change the update channel for the web ui to dev and hit update.~~

~~And if you're coming from a stable version of web ui, then hard refresh the web browser, reset the local storage and/or session storage, and close and re-open the tab. You probably need to do this regardless of how you update to the β web ui.~~

[t0815]

Same in web-ui:

Files are available and unwatched:

[danmarce]

I'm having a similar issue with server 4.2.2 and Desktop 4.2.1, in my case I noticed the problem the other way, series I KNOW are completed (even with the vote) with un-watched episodes. On "Series Info" I get "all episodes have watched" but on the episodes tab I get the un-watched episodes (so I do on the search)

I would not take much issue, but the "mark all as watched" button does not work. While I see this happening mostly with recent series, it also happens with older series. I'm my case with over 3k series, is a bit hard to really find the errors on the desktop client, but I'll check the DB later.

Edit: Ok, on desktop I created a filter with "Has un-watched episodes: include" and "user voted: include". Definitively is mostly with recent added, watched and voted series.

I also tested the other way with "has unwatched episodes: exclude" and "user voted (any): exclude", and I got a few series.

[t0815]

i did some messing around in the db and did notice the entries for crossref_file_episode did not match the videolocal entries. I did update them with correct hash, filename and size, then the problem was fixed. I have no clue tho, under which circumstances old invalid crossref entries remain or are not updated....

[t0815]

And for the particular case above, the issue was in videolocal_user, there the resume position would be present, which seems to break the continue watching tile. EDIT: did some more digging, and this seems to be the root cause, for breaking continue watching. I found several more instances, and every time the resume position was set (> 0). So to conclude, the query to fetch next episode will return null when the resume position is set. This gets set, if you play an episode via internal MP (I believe) / use play controls in UI. This also explains the issue https://github.com/ShokoAnime/ShokoDesktop/issues/627