2010-04-14, 00:48
my setup > ubuntu karmic minimal ala XBMCbuntu + xbmc svn28256. AMD 2.2GHz x2 + 2GB ram | nvidia 9800 + 512.vRam > HDMI a/v > 40" Sony XBR6 @ 1080p
the goal > i have 2 different sources (anime/TV), both are type=TV & scrap=thetvdb.org. by using 2 smart playlists (genre = anime & genre != anime ) i'd like them to be separate ... then i will add each XSP to confluence home screen (TV/Sub-menu)
the problem > smart playlists with type=tvshows throw SQL errors ...
pastebin://smart.playlists
the 3rd (720P TV) has type=episodes ... it works
the first two are type=tvshow ... they dont
EDIT: all 3 where created through the XBMC UI
pastebin://debub.log
this is what happens when i open the first 2 ... lines 464 || 496
is something wrong
the goal > i have 2 different sources (anime/TV), both are type=TV & scrap=thetvdb.org. by using 2 smart playlists (genre = anime & genre != anime ) i'd like them to be separate ... then i will add each XSP to confluence home screen (TV/Sub-menu)
the problem > smart playlists with type=tvshows throw SQL errors ...
pastebin://smart.playlists
the 3rd (720P TV) has type=episodes ... it works
the first two are type=tvshow ... they dont
EDIT: all 3 where created through the XBMC UI
pastebin://debub.log
this is what happens when i open the first 2 ... lines 464 || 496
Code:
17:53:15 T:3079116672 M:1949437952 ERROR: SQL: SQL error or missing database
Query: SELECT tvshow.*,path.strPath AS strPath,counts.totalcount AS totalCount,counts.watchedcount AS watchedCount,counts.totalcount=counts.watchedcount AS watched FROM tvshow JOIN tvshowlinkpath ON tvshow.idShow=tvshowlinkpath.idShow JOIN path ON path.idpath=tvshowlinkpath.idPath LEFT OUTER join ( SELECT tvshow.idShow AS idShow,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.idShow) counts ON tvshow.idShow=counts.idShow WHERE (idshow in (select idshow from genrelinktvshow join genre on genre.idgenre=genrelinktvshow.idgenre where genre.strGenre LIKE 'Animation'))
is something wrong