[Raspberry Pi] table does not exist error when viewing TV Shows on "XBMC Official Remote (Android)"

[wdl1908]

RPi.arm-devel-20120820224706-r11818
XBMC commit: efef226

Error in the xbmc.log file

17:08:14 T:1103556608 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
17:08:14 T:1103556608 ERROR: GetArbitraryQuery failed

After looking in the DB the table "tvshowlinkepisode" does not exist.

[bitgangsta]

I also can confirm this problem. The iOS remote doesn't suffer from the same issue as it seems to query via a different interface (JSONRPC), but while it didn't throw any error, it crashed the iOS remote software.

[bitgangsta]

This appears to be an upstream bug in xbmc and/or the remote. See: http://code.google.com/p/android-xbmcremote/issues/detail?id=637

[bitgangsta]

After more investigation it appears that the latest version of XBMC in git has removed that db table. The following (simple) pull request to xbmc-remote stops joining it and fixes the issue: freezy/android-xbmcremote#37

I plan on compiling a build with this pull request and can share it if you'd like.

[bitgangsta]

I have created a fork which includes the fix for this problem. If you'd like to install my fork, you can compile it yourself from: https://github.com/bitgangsta/android-xbmcremote

Or you can just install my pre-compiled binary: https://dl.dropbox.com/u/1408139/android/android-xbmcremote-drj.apk