search

manniru / android-xbmcremote

Automatically exported from code.google.com/p/android-xbmcremote
0 stars 0 forks source link

TV shows aren't showing up #407

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Hit "watch tv shows", and get "no tv shows found."
2.
3.

What is the expected output? What do you see instead?
Expected to see the various TV shows I have.

What version of XBMC Remote are you using?
Tried with 0.7.1, 0.8.3b1, and 0.8.4b1.

Which Android device are you using (and which ROM, if custom)?
Motorola Droid, android 2.2

Which XBMC revision are you running and on which platform?
r9.11

Please provide any additional information below.
I have content on my xbmc box setup as tv shows, and properly showing up in the 
library, so something should be there. I also have movies and music, both of 
which show up properly. Oddly enough, the "actor" and "genre" view do list the 
various actors/genres I have, but when viewing them, get me back to "no tv 
shows." Anything I can look at or debug to help?

Original issue reported on code.google.com by davef....@gmail.com on 8 Oct 2010 at 10:48

GoogleCodeExporter commented 9 years ago 
I've been doing some digging - got eclipse to build the latest svn version, and 
got the debugger fired up. Surprisingly easy, so that was neat. When trying 
with the latest svn, the command being called by xbmc-remote is:

10-08 23:37:56.995: INFO/Connection(303): 
http://192.168.1.200:8081/xbmcCmds/xbmcHttp?command=QueryVideoDatabase(SELECT 
tvshow.idShow, tvshow.c00, "" AS c01, ROUND(tvshow.c04, 2), tvshow.c05, 
tvshow.c08, tvshow.c13, tvshow.c14,        paths.strPath,        
counts.totalcount AS totalCount,        counts.watchedcount AS watchedCount,    
    counts.totalcount = counts.watchedcount AS watched    FROM (        select 
min(tvshow.idShow) as idShow, tvshow.c00 from tvshow        group by tvshow.c00 
   ) showNames    LEFT OUTER join tvshow on showNames.idShow = tvshow.idShow    
LEFT OUTER join (        SELECT min(tvshow.idShow) as idShow, tvshow.c00, 
count(1) AS totalcount, count(files.playCount) AS watchedcount     FROM tvshow  
      JOIN tvshowlinkepisode ON tvshow.idShow = tvshowlinkepisode.idShow        
JOIN episode ON episode.idEpisode = tvshowlinkepisode.idEpisode        JOIN 
files ON files.idFile = episode.idFile        GROUP BY tvshow.c00    ) counts 
ON tvshow.idShow = counts.idShow    LEFT OUTER join (        SELECT 
tvshow.idShow, strPath         FROM tvshow        JOIN tvshowlinkpath ON 
tvshow.idShow = tvshowlinkpath.idShow        JOIN path ON path.idpath = 
tvshowlinkpath.idPath        WHERE path.idPath in (SELECT max(idPath) FROM 
tvshowlinkpath GROUP BY idShow)    )  paths on tvshow.idShow = paths.idShow  
ORDER BY lower(tvshow.c00) ASC)

When I try this in a browser, I get:

Error:SQL error or missing database

When looking at the xbmc database description in the wiki, there seems to be 
two problems - first, there's no "paths" table, just "path", and second, this - 
"paths on tvshow.idShow = paths.idShow" doesn't work, because the path table 
doesn't have a "idShow", you need to use the "tvshowlinkpath" table. Since I'm 
not clear yet what the point of the SQL is, I haven't gotten to a working sql 
query yet, but I'm going to try and figure that out next - then patch xbmc as 
appropriate and try it out.

Original comment by davef....@gmail.com on 9 Oct 2010 at 12:38

GoogleCodeExporter commented 9 years ago 
ah, I misunderstood the syntax, it was already trying to use tvshowlinkpath to 
connect the two. I've now got working sql:

http://192.168.1.200:8081/xbmcCmds/xbmcHttp?command=QueryVideoDatabase( SELECT 
tvshow.idShow, tvshow.c00, "" AS c01, ROUND(tvshow.c04, 2), tvshow.c05, 
tvshow.c08, tvshow.c13, tvshow.c14, path.strPath, counts.totalcount AS 
totalCount, counts.watchedcount AS watchedCount, counts.totalcount = 
counts.watchedcount AS watched FROM (select min(tvshow.idShow) as idShow, 
tvshow.c00 from tvshow group by tvshow.c00) showNames LEFT OUTER join tvshow on 
showNames.idShow = tvshow.idShow LEFT OUTER join (SELECT min(tvshow.idShow) as 
idShow, tvshow.c00, count(1) AS totalcount, count(files.playCount) AS 
watchedcount FROM tvshow JOIN tvshowlinkepisode ON tvshow.idShow = 
tvshowlinkepisode.idShow JOIN episode ON episode.idEpisode = 
tvshowlinkepisode.idEpisode JOIN files ON files.idFile = episode.idFile GROUP 
BY tvshow.c00) counts ON tvshow.idShow = counts.idShow LEFT OUTER join (SELECT 
tvshow.idShow as idShow, strPath FROM tvshow JOIN tvshowlinkpath ON 
tvshow.idShow = tvshowlinkpath.idShow JOIN path ON path.idpath = 
tvshowlinkpath.idPath WHERE path.idPath in (SELECT max(idPath) FROM 
tvshowlinkpath GROUP BY idShow)) path on tvshow.idShow = path.idShow ORDER BY 
lower(tvshow.c00) ASC)

that took two changes - change all cases of "paths" to "path", and add "as 
idShow" to "...SELECT tvshow.idShow as idShow, strPath FROM tvshow JOIN..." 
because otherwise the outer join's "on" clause wasn't working. Now to figure 
out where to change the xbmc-remote code...

Original comment by davef....@gmail.com on 9 Oct 2010 at 12:47

GoogleCodeExporter commented 9 years ago 
hmm, no, wasn't quite right still. the paths -> path is not needed since it's a 
temp table?, and I'd imagine is intentional. so it's just adding the "as 
idShow" bit. Found where in the java, and now I'm trying it out.

Original comment by davef....@gmail.com on 9 Oct 2010 at 12:58

GoogleCodeExporter commented 9 years ago 
Do you have anything special as setup? I mean it is working for everyone else. 
I use the TV Shows features nearly every day.

Original comment by till.ess...@googlemail.com on 9 Oct 2010 at 1:06

GoogleCodeExporter commented 9 years ago 
The sql change worked, and now everything shows up in the tv menu.

Not as far as I know. I'm using xbmc on Ubuntu 9.4. I guess something's 
different about my backend database, perhaps? I'll look into it to see what 
xbmc is using. FWIW, I'm not a sql expert, but the changes I made to get it to 
work should be harmless for anyone where it's already working, as they're just 
further clarifying the syntax, and for some reason my setup is more strict than 
everyone elses.

Original comment by davef....@gmail.com on 9 Oct 2010 at 3:58

GoogleCodeExporter commented 9 years ago 
Found another one like this - when  listing all the shows in a given genre, the 
sql snippit:

    ... ( SELECT min(tvshow.idShow) as idShow, genrelinktvshow.idGenre FROM tvshow LEFT OUTER JOIN genrelinktvshow ...

needs to be:

    ... ( SELECT min(tvshow.idShow) as idShow, genrelinktvshow.idGenre as idGenre FROM tvshow LEFT OUTER JOIN genrelinktvshow ...

if it's easier to have a patch, of course, let me know and I'll provide one.

Original comment by davef....@gmail.com on 9 Oct 2010 at 4:13

GoogleCodeExporter commented 9 years ago 
Are you using MySQL as database?

Original comment by Gabor.Fo...@gmail.com on 9 Oct 2010 at 7:34

GoogleCodeExporter commented 9 years ago 
Nope, I seem to be using SQLite3, the one that comes w/ xbmc 9.11. Not clear 
exactly what version, but I can dig further if it will help. As soon as xbmc 
10.0 comes out, I'll try that as well.

Original comment by davef....@gmail.com on 9 Oct 2010 at 3:26

GoogleCodeExporter commented 9 years ago 
I have the same issue. Tv shows are not showing up anymore. Altho, in my case 
it started at the last market update 0.8.4 beta1. 0.8.3 was working fine. 

Im runinng xbmc 9.04 stable on xbox and my phone is a nexus one running 
cyanogenmod 6.0.

Original comment by steve.garon on 11 Oct 2010 at 7:38

GoogleCodeExporter commented 9 years ago 
Okay, I think I've figured out all the places where this is an issue, and they 
all boil down to "needed to do an "select foo.bar as bar..." when referencing a 
value from a subselect. Attached is a patch that fixes up all the various tv 
show options where I've found this an issue. :) No idea why it's busted for me 
and not most anyone else, but here we are.

steve.garon - if you want, I can put together a build that has my patch 
applied, attach it here, and you can try it out and see if we have the same 
problem. let me know.

Original comment by davef....@gmail.com on 11 Oct 2010 at 11:49

Attachments:

GoogleCodeExporter commented 9 years ago 
I've updated my xbmc version to xbmc4xbox 3.0 beta r30688 and I still have the 
same issue with tv shows not showing up. 

davef.box - If you do have a build I can test to see if this works...

Original comment by steve.garon on 12 Oct 2010 at 7:25

GoogleCodeExporter commented 9 years ago 
steve - try the attached apk. it also has a patch for a different issue that 
adds a "clear playlist" menu entry, but that should be independent of the 
various tv issues.

Original comment by davef....@gmail.com on 13 Oct 2010 at 3:48

Attachments:

GoogleCodeExporter commented 9 years ago 
I cant get your apk to install even if I turn on unknown source install and 
remove xbmc remote from the market. I'll just checkout the source and apply 
your patch to see if it works...

Original comment by steve.garon on 15 Oct 2010 at 7:54

GoogleCodeExporter commented 9 years ago 
Confirmed! your patch works! Devs please apply patch and get us a new version 
on market :)

Original comment by steve.garon on 15 Oct 2010 at 8:17

GoogleCodeExporter commented 9 years ago 
ah, well, sorry about the apk not working. :) I'm pretty new to android, so I'm 
sure I screwed something up. Glad the patch works, hopefully it'll make it into 
a release at some point.

Original comment by davef....@gmail.com on 16 Oct 2010 at 1:13

GoogleCodeExporter commented 9 years ago 
Will have a look at this soon, promised. Thanks for the detailed reports, 
davef.box!

Original comment by phree...@gmail.com on 22 Oct 2010 at 1:11

GoogleCodeExporter commented 9 years ago 
any feedback on the patch? Or (since this one is pretty much trivial) the one 
for issue #356? I wanted to learn more about android coding/development, and 
figured hacking on the xbmcremote's a good way to go, but I don't want to 
submit garbage patches to you guys, and waste your time...

Original comment by davef....@gmail.com on 8 Nov 2010 at 1:38

GoogleCodeExporter commented 9 years ago 
Alright.... Same issue... Remote 0.8.4-beta1
I've been using 3.0 (30691) for a while, and tv shows always tell me the 
library is empty. Movies and music libraries work perfectly though :-/
In the unofficial  xbmc remote 2.0 loads the tv library just fine, but I don't 
like its interface as much.
Movies, files, browse to the tv folder, and they will play, but it isn't as 
pretty as the screen shots in the market, and it can be a pain browsing to the 
right folder. I made my directory structure prettier now, but still think it 
would be nice if this just worked.
I don't have a computer, just an evo and an xbox.
Can I apply this patch without a computer, and if do, how? Thanks!

Original comment by Mikepohl...@gmail.com on 30 Nov 2010 at 8:01

GoogleCodeExporter commented 9 years ago 
Just to say i'm looking forward to see this patch applied.

For the record, I have the same issue with :
android 2.2 on HTC Desire (original ROM)
all versions of XBMCRemote since 0.8.3 (the only version that worked)
XBMC 9.11 and now 10.0 on Debian Lenny

Original comment by marc.c...@gmail.com on 26 Jan 2011 at 8:46

GoogleCodeExporter commented 9 years ago 
Since the issue persists with the latest Beta, here's what I noticed:
It applies to all kinds of databases (Music, Video, etc,). Everything that is 
stored locally on the Xbox shows up. Things stored on a NAS don't.

Original comment by elto...@gmx.de on 21 Mar 2011 at 4:47

GoogleCodeExporter commented 9 years ago 
I just updated to version 3.0-BETA2-r30756.  TV shows on my NAS that work 
perfectly in XBMC still aren't showing up in xbmcremote.

Original comment by foresto@gmail.com on 25 Apr 2011 at 7:17

GoogleCodeExporter commented 9 years ago 
I can also confirm that the patch works well.
attached is an apk including the patch ( r779, android2.3.3), so that we can 
wait till the patch is finally committed.
It's my first apk, so there's no warranty, but it works for me (tm) :) (galaxy 
s2)

Original comment by marc.c...@gmail.com on 12 Jul 2011 at 9:06

Attachments:

GoogleCodeExporter commented 9 years ago 
I'm now using android-xbmcremote version 0.8.7-beta1 and xbmc 3.0-r30850 (xbox 
hardware).  This bug persists.

Original comment by foresto@gmail.com on 2 Sep 2011 at 3:06

GoogleCodeExporter commented 9 years ago 
can some clarify if this has been resolved? using SE Xperia mini pro droid 2.1. 
off the top of my head just the current xbmc4xbox from the svn. Or is it just 
down to changing the folder name to "TV Shows"?

Original comment by jphe...@gmail.com on 20 Sep 2011 at 5:04

GoogleCodeExporter commented 9 years ago 
this bug started showing up for me today after i upgraded from xbmc 11 to a 
nightly build (1495cbeb771bb5dde20a83a50d23c89a50e6f5c1). everything worked 
fine before.

Original comment by tsu...@lagat.org on 31 May 2012 at 10:13

GoogleCodeExporter commented 9 years ago 
same bug for me!

Original comment by thiagoha...@gmail.com on 4 Jun 2012 at 7:06

GoogleCodeExporter commented 9 years ago 
Same bug here also.

Original comment by fryingfi...@gmail.com on 7 Jun 2012 at 4:52

GoogleCodeExporter commented 9 years ago 
Facing this bug also.
Android 4.0.4, xbmc 12-Alpha3 (compiled june 8, 2012)

Original comment by andrey.i...@gmail.com on 10 Jun 2012 at 11:42

GoogleCodeExporter commented 9 years ago 
I am also having this problem on all the nightlies that are currently listed 
from May 28th to Jun 12th. First noticed it when I installed the Alpha 2 
Monthly.

Original comment by JSimpso...@gmail.com on 13 Jun 2012 at 12:31

GoogleCodeExporter commented 9 years ago 
This bug came back after i upgraded from xbmc 10 to 12 alpha 2 :(
It still works for films and music though.
The previous patch doesn't work anymore ...

Original comment by marc.c...@gmail.com on 16 Jun 2012 at 3:48

GoogleCodeExporter commented 9 years ago 
Same issue with Alpha 2

Original comment by judgejul...@gmail.com on 10 Jul 2012 at 1:30

GoogleCodeExporter commented 9 years ago 
The issue is there with version 12.0 Alpha 5 as well.

Original comment by a...@haxalot.com on 8 Aug 2012 at 8:09

GoogleCodeExporter commented 9 years ago 
Same here too..

Original comment by rehat...@gmail.com on 20 Aug 2012 at 2:57

GoogleCodeExporter commented 9 years ago 
The same for me, please update :-(

Original comment by sebastien.andreatta on 1 Oct 2012 at 7:53

GoogleCodeExporter commented 9 years ago 
it may solve your problem (it did for me !) :
https://github.com/freezy/android-xbmcremote/pull/37

Original comment by marc.c...@gmail.com on 27 Oct 2012 at 5:15

GoogleCodeExporter commented 9 years ago 
For those still using xbmc on an original xbox, you might have better luck with 
this remote app:

https://play.google.com/store/apps/details?id=com.dandar3.xbmc4xbox.remote&hl=en

Also, there updates for your xbox are still released from time to time:

http://www.xbmc4xbox.org.uk/

Original comment by tadafor...@gmail.com on 17 Jun 2013 at 2:46