What steps will reproduce the problem?
1. Connect to XBMC
2. Select TV-Shows
What is the expected output? What do you see instead?
No TV Shows are shown
What version of XBMC Remote are you using?
v0.8.8.beta1
Which XBMC revision are you running and on which platform?
XBMC 12.0-ALPHA Git:ba2c709
XBMC logs show this
23:56:14 T:1256887392 DEBUG: webserver: request received for
/xbmcCmds/xbmcHttp?command=QueryVideoDatabase(SELECT+tvshow.idShow%2C+tvshow.c00
%2C+%22%22+AS+c01%2C+ROUND%28tvshow.c04%2C+2%29%2C+tvshow.c05%2C+tvshow.c08%2C+t
vshow.c13%2C+tvshow.c14%2C%09%09paths.strPath%2C%09%09counts.totalcount+AS+total
Count%2C%09%09counts.watchedcount+AS+watchedCount%2C%09%09counts.totalcount+%3D+
counts.watchedcount+AS+watched%09FROM+%28%09%09select+min%28tvshow.idShow%29+as+
idShow%2C+tvshow.c00+from+tvshow%09%09group+by+tvshow.c00%09%29+showNames%09LEFT
+OUTER+join+tvshow+on+showNames.idShow+%3D+tvshow.idShow%09LEFT+OUTER+join+%28%0
9%09SELECT+min%28tvshow.idShow%29+as+idShow%2C+tvshow.c00%2C+count%281%29+AS+tot
alcount%2C+count%28files.playCount%29+AS+watchedcount+%09FROM+tvshow%09%09JOIN+t
vshowlinkepisode+ON+tvshow.idShow+%3D+tvshowlinkepisode.idShow%09%09JOIN+episode
+ON+episode.idEpisode+%3D+tvshowlinkepisode.idEpisode%09%09JOIN+files+ON+files.i
dFile+%3D+episode.idFile%09%09GROUP+BY+tvshow.c00%09%29+counts+ON+tvshow.idShow+
%3D+counts.idShow%09LEFT+OUTER+join+%28%09%09SELECT+tvshow.idShow%2C+strPath+%09
%09FROM+tvshow%09%09JOIN+tvshowlinkpath+ON+tvshow.idShow+%3D+tvshowlinkpath.idSh
ow%09%09JOIN+path+ON+path.idpath+%3D+tvshowlinkpath.idPath%09%09WHERE+path.idPat
h+in+%28SELECT+max%28idPath%29+FROM+tvshowlinkpath+GROUP+BY+idShow%29%09%29++pat
hs+on+tvshow.idShow+%3D+paths.idShow++ORDER+BY+CASE+WHEN+tvshow.c15+IS+NULL+OR+t
vshow.c15+%3D+%27%27+THEN+replace%28lower%28tvshow.c00%29%2C%27the+%27%2C%27%27%
29+ELSE+replace%28lower%28tvshow.c15%29%2C%27the+%27%2C%27%27%29+END+ASC)
23:56:14 T:1100369920 DEBUG: HttpApi Start command: QueryVideoDatabase
paras: [not recorded]
23:56:14 T:1100369920 ERROR: SQL: The table does not exist
Query: 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 CASE WHEN tvshow.c15 IS NULL OR tvshow.c15 = '' THEN replace(lower(tvshow.c00),'the ','') ELSE replace(lower(tvshow.c15),'the ','') END ASC
Original issue reported on code.google.com by wdl1...@gmail.com on 19 Sep 2012 at 10:05
Original issue reported on code.google.com by
wdl1...@gmail.comon 19 Sep 2012 at 10:05