dtaweb / android-xbmcremote

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

Wrong SQL send to XBMC when viewing TV-Show (XBMC git version) #662

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
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