TV shows do not show up with latest nightly

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Start XBMC with webserver
2. Connect to webserver with xbmcremote
3. Open TV shows menu

What is the expected output? What do you see instead?
I expect to see a list of TV shows, but I see nothing. If I look at artists or 
genre page, everything works as expected, it's just the show list that is 
missing.

What version of XBMC Remote are you using?
v0.8.8-beta1 Revision 808

Which Android device are you using (and which ROM, if custom)?
Samsung Galaxy S2 with CM9.

Which XBMC revision are you running and on which platform?
Latest XBMC nightly build (fresh install)

Please provide any additional information below.

XBMC debug log when trying to see TV show list:

10:48:52 T:140709043975936   DEBUG: webserver: request received for 
/xbmcCmds/xbmcHttp?command=GetSystemInfo(120)
10:48:52 T:140709716850464   DEBUG: HttpApi Start command: GetSystemInfo  
paras: GetSystemInfo; 120
10:48:53 T:140709043975936   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)
10:48:53 T:140709716850464   DEBUG: HttpApi Start command: QueryVideoDatabase  
paras: [not recorded]
10:48:53 T:140709716850464   ERROR: SQL: SQL error or missing database
                                            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
10:48:53 T:140709716850464   ERROR: GetArbitraryQuery failed

Original issue reported on code.google.com by tsu...@lagat.org on 5 Jun 2012 at 8:52

[GoogleCodeExporter]

I can confirm this issue. Also noted on OpenELEC issue: 
https://github.com/OpenELEC/OpenELEC.tv/issues/1127

Original comment by djabbour on 21 Sep 2012 at 9:57

[GoogleCodeExporter]

Looks like it's fixed in github pull req: 
https://github.com/freezy/android-xbmcremote/pull/37

Original comment by djabbour on 21 Sep 2012 at 10:16