Re: Incomplete In-Progress TV using Kodi DB
Posted: 07 Jul 2020, 12:53
Any suggestions on what I can do to get to the bottom of this?
Page 2 of 3
Re: Incomplete In-Progress TV using Kodi DB
Posted: 07 Jul 2020, 12:57
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.
Re: Incomplete In-Progress TV using Kodi DB
Posted: 07 Jul 2020, 17:55
Zipped DB dump sent as suggested. Thanks.
Re: Incomplete In-Progress TV using Kodi DB
Posted: 13 Jul 2020, 15:43
Any luck triaging?
Re: Incomplete In-Progress TV using Kodi DB
Posted: 13 Jul 2020, 15:57
In a middle of other things, it’s on my to-do list
Re: Incomplete In-Progress TV using Kodi DB
Posted: 13 Jul 2020, 16:05
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.
Re: Incomplete In-Progress TV using Kodi DB
Posted: 13 Jul 2020, 17:50
its a specific call for it... depends where you are in the app.
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
Code: Select all
SELECT * FROM tvshow_view WHERE watchedCount != 0 AND totalCount != watchedCount ORDER BY c00note 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
Re: Incomplete In-Progress TV using Kodi DB
Posted: 13 Jul 2020, 21:08
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
Vikings
The Sinner
Endeavour
Titan Games
Black Sails
Re: Incomplete In-Progress TV using Kodi DB
Posted: 13 Jul 2020, 21:37
Currently, running this query
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
Code: Select all
SELECT * FROM tvshow_view WHERE watchedCount != 0 AND totalCount != watchedCount ORDER BY lastPlayed descHowever, this is not the list that MrMC displays for me. Before I took the db dump, MrMC was only showing three in-progress shows
Re: Incomplete In-Progress TV using Kodi DB
Posted: 13 Jul 2020, 21:50
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