[zosky]

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

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

[jmarshall]

Looks like the tvshowview -> sql query change screwed things up. Post a bug report on trac and linky to it from here.

Cheers,
Jonathan

[zosky]

( note to self > do more research next time )

looks like this was already adressed in t9045
and fixed in r29034, meanwhile im in the stoneAge w/ r28256
i'll resist asking when new builds will resume
i know yall are workin hard

thanks JM
& thanks to myyra too

[jmarshall]

That patch is not in SVN as of yet. I'll see if I have time to test it for correctness later this evening.

[zosky]

i do this kind of thing (bug reporting/tracking/testing) at work, but trac is a new ball game
thanks for the clarification & picking it up

i guess ill put this little hack on hold until this gets fixed
& new PPAs start getting pushed out again.

cheers
~z

[zosky]

Jonathan, i see you committed it to r29286 a few hours ago
thanks mate. you're a pro-star and a scholar