Incomplete In-Progress TV using Kodi DB

[feardamhan]

Any suggestions on what I can do to get to the bottom of this?

[amet]

Unfortunately no, if you can dump the database and send it to us to ‘support at mrmc dot tv’ , we can try to reproduce the issue on our end.

[feardamhan]

Zipped DB dump sent as suggested. Thanks.

[feardamhan]

Any luck triaging?

[amet]

In a middle of other things, it’s on my to-do list

[feardamhan]

No problem. Happy to help troubleshoot. Could you tell me where in the DB (table/view etc) the in-progress TV shows are stored. I poked around but couldnt see anything obvious. If I knew the table or query used I might be able to help narrow down the cause.

[amet]

its a specific call for it... depends where you are in the app.

Code: Select all

SELECT * FROM tvshow_view  WHERE watchedCount != 0 AND totalCount != watchedCount ORDER BY c00

I dont see any missing episodes in "in-progress" ... can you be specific on what is missing? I am running your database on Kodi and MrMC next to each other and I see no issues

note that we display in-progress differently, Kodi has it on home screen as the show with watched/total episodes and we show the next in progress item.

if you deselect flatten hierarchy in Settings -> video -> Library, clicking on a TV Show icon on home will present you with a "new" list where you can go into in-progress tv shows

[feardamhan]

So some examples that my Kodi app shows that I have been watching but MrMC doesn’t show in in-Progress TV shows at all.

Vikings
The Sinner
Endeavour
Titan Games
Black Sails

[feardamhan]

Currently, running this query

Code: Select all

SELECT * FROM tvshow_view  WHERE watchedCount != 0 AND totalCount != watchedCount ORDER BY lastPlayed desc

Produces the correct data in terms of most recently watched. Currently at 95 rows (which will be slightly different that you have, as I've watched shows since then)

However, this is not the list that MrMC displays for me. Before I took the db dump, MrMC was only showing three in-progress shows

[feardamhan]

So I deselected flatten hierarchy, and accessing in-progress TV that way looks correct. Its only the in-progress TV from the home screen thats inaccurate