[Bug] TV show seasons are partly wrong - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33) +--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116) +---- Forum: Kodi Remote for Android Official Forum (https://forum.kodi.tv/forumdisplay.php?fid=129) +---- Thread: [Bug] TV show seasons are partly wrong (/showthread.php?tid=78456) Pages:
1
2
|
[Bug] TV show seasons are partly wrong - charleynaseweis - 2010-08-05 Hi, I like XBMC and especially the Android remote. Unfortunately there is an error with the TV shows. I have one TV show with 5 seasons, and all except of the last one are shown as season -1. When I tap on it, there are no episodes in it (which is wrong). The last season, which is shown correctly, has one episode in it and there everything is alright. I use XBMC r32453 and the newest Remote app from the market. Do you know about this error? - kris2k - 2010-08-05 me too..i have same problem..only in tv shows - gfoldv - 2010-08-05 Would you do me a favor? Please run this in the web browser on the machine where the xbmc is running. Code: http://localhost:8080/xbmcCmds/xbmcHttp?command=QueryVideoDatabase(SELECT%20tvshow.idShow,%20tvshow.c00%20FROM%20tvshow) It should look something like: <html> <field>1</field><field>Fringe</field></html> - Flomaster - 2010-08-06 I too have the same problem I installed last night right before bed. I am running xbmc-live so I have no browser on my machine -=Jason=- - wankdanker - 2010-08-06 I have this same or similar problem. I believe it is due to either multiple records of the same show or multiple paths to episodes within the same show. I believe issue 302 is on the right track. (http://code.google.com/p/android-xbmcremote/issues/detail?id=302) I ran the query gfoldv suggested, here are my results. Code: <html> HTH - gfoldv - 2010-08-06 wankdanker, thank you for the html result. From this list for which show do you get the faulty -1 for the seasons? - wankdanker - 2010-08-06 Here is what I see where there are issues. When I refer to 'Banner' I am talking about the graphic that is displayed for the show. Entourage - Banner Entourage - No Banner, 55 Episodes Entourage - No Banner, -1 Episodes Family Guy - Banner Family Guy - No Banner, -1 Episodes Family Guy - No Banner, 11 Episodes Family Guy - No Banner, -1 Episodes South Park - Banner South Park - No Banner, 5 Episodes South Park - No Banner, -1 Episodes Thanks gfoldv! - gfoldv - 2010-08-06 So you get -1 only for that shows which have multiple record, don't you? - wankdanker - 2010-08-06 Yes, and I can see how this is happening too. Here is the query that is executed to get the list of shows: Code: SELECT tvshow.idShow, tvshow.c00, "" AS c01, ROUND(tvshow.c04, 2), tvshow.c05, tvshow.c08, tvshow.c13, tvshow.c14, I ran this query using sqlite3 cli directly on MyVideos database. Since the first table in the query is tvshow and it contains multiple records for the same show it will have a record for each instance in the result set. If there happens to be any files linking to that specific record, then the counts will be included from the LEFT OUTER JOIN. The cases where I see a -1 in the remote control interface are when there are no actual files for that show in which case totalCount and watchedCount would end up being null. I tried the following query and it returns everything as expected: Code: SELECT tvshow.idShow, tvshow.c00, "" AS c01, ROUND(tvshow.c04, 2), tvshow.c05, tvshow.c08, tvshow.c13, tvshow.c14, - wankdanker - 2010-08-06 After reviewing the OP's message, I think that the issue I am having is different from what they described. However I think the issue that I am describing would lead to the solution for all of these issues. I am going to work on getting the source and attempt to provide a patch for these queries. Good thing my boss isn't working today. - charleynaseweis - 2010-08-08 Quote: Would you do me a favor? Please run this in the web browser on the machine where the xbmc is running. Sorry for answering so late, I did not expect to get so many replies in such a short time Here is the code I get: Code: <html> I also just noticed that this problem only appears if there are more than one seasons belonging to a tv show. It would be really great if you can fix this. - freezy - 2010-08-09 Will check out your patch in a minute wankdanker. Sorry it took so long, I'm more outside that behind the screen in my freetime these days. - wankdanker - 2010-08-09 Thanks freezy. No problem. Gotta enjoy the summer while it's around. If you need anything more from the patch like comments or whatever, just let me know. I'm more than happy to do whatever I can for the project. - freezy - 2010-08-09 Test it! Here is an intermediate build. Cheers! - rewen - 2010-08-11 Hi guys, I had an issue where my TV Shows would show up on the remote multiple times, in addition to the bug mentioned in this thread. My 'TV Shows' source is linked to multiple folders, and sometimes certain shows are spanned among those folders. Example: Source setup: TV Shows { C:\Video\TV Shows, D:\Video (overflow)\TV Shows, E:\Video (overflow 2)\TV Shows, F:\Video (overflow 3)\TV Shows } Spanned TV Show: Futurama Season 1-4 may be in the C: "TV Shows" folder Futurama Season 5 in the D: "TV Shows" folder Futurama Season 6 in the F: "TV Shows" folder In XBMC this spanning is completely transparent. In the version of the remote that is on the market (as of this post) there was the problem I mentioned. ANYWAY... the intermediate build solved the issue for me BUT the back button on my phone has to be held now in order to flip back a screen. I'm sure you're already aware, but if not, then now you are I just wanted to let you know. Keep up the good work! |