What steps will reproduce the problem?
1.Go to 'Tv Shows'tab
2.No tv shows displayed
What is the expected output? What do you see instead?
..nothing but the "No media TV Shows found" message
What version of XBMC Remote are you using?
v0.8.8-beta1, build revision 8
Which Android device are you using (and which ROM, if custom)?
Galaxy Note with ICS 4.0.4 stock (3.0.15 kernel)
Which XBMC revision are you running and on which platform?
XBMC 12.0-ALPHA6 (Git:20120909-d576ade) nightly build of xbmc on ubuntu 11.10
Please provide any additional information below.
The problem occurs when the following HTTP request is sent to xbmc :
http://XXX.XXX.XXX.XXX:9999/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.idEpi
sode = tvshowlinkepisode.idEpisode JOIN files ON files.idFile =
episode.idFile GROUP BY tvshow.c00 ) counts ON tvshow.idShow =
counts.idShow LEFT OUTER join ( SELEC
T tvshow.idShow, strPath FROM tvshow JOIN tvshowlinkpath ON tvshow.idShow =
tvshowlinkpath.idShow JOIN path ON path.idpath = tvshowlinkpath.idPath WHERE
path.id
Path in (SELECT max(idPath) FROM tvshowlinkpath GROUP BY idShow) ) paths on
tvshow.idShow = paths.idShow ORDER BY CASE WHEN tvshow.c15 IS NULL OR
tvshow.c15 = '' THEN replace(lower(tvshow.c00),'the ','')
ELSE replace(lower(tvshow.c15),'the ','') END ASC)
It seems that the 'paths' table is now named 'path', so the request cannot
succeed... I faced the same problem with 'Music' tab, the alias "strArtists" is
now named "strArtist" in the albumview view (check this link who solved this
problem). But for the tvshowview, it needs to rename a table, not an alias, it
won't be so easy...
Do you plan to fix the internal SQL queries to match with xbmc 12 database
changes. Thankz 4 ur work !
Original issue reported on code.google.com by the.mou...@gmail.com on 1 Oct 2012 at 6:37
Original issue reported on code.google.com by
the.mou...@gmail.comon 1 Oct 2012 at 6:37