2011-09-28, 00:11
Well its not blank can see xbmc logo and movies and music menu but not anything else. Clicking does nothing. Anything obvious? I have changes the port to 85.
DEBUG: CVideoDatabase::GetSetsNav query: SELECT sets.idSet,sets.strSet,COUNT(1) AS c,count(files.playCount) FROM sets JOIN setlinkmovie ON sets.idSet=setlinkmovie.idSet JOIN movie ON setlinkmovie.idMovie=movie.idMovie JOIN files ON files.idFile=movie.idFile GROUP BY sets.idSet HAVING c>1
DEBUG: CVideoDatabase::GetMoviesByWhere query: select * from movieview WHERE movieview.idMovie NOT IN (SELECT idMovie FROM setlinkmovie s1 JOIN(SELECT idSet, COUNT(1) AS c FROM setlinkmovie GROUP BY idSet HAVING c>1) s2 ON s2.idSet=s1.idSet)
DEBUG: Time for actual SQL query = 2
DEBUG: Time to retrieve movies from dataset = 7
DEBUG: CMusicDatabase::GetAlbumsByWhere query: select * from albumview where albumview.strAlbum <> ''
jhsrennie Wrote:How does this compare with your system?
JR
18:11:51 T:2496 M:1163300864 DEBUG: CVideoDatabase::GetSetsNav query: SELECT sets.idSet,sets.strSet,path.strPath,files.playCount FROM sets JOIN setlinkmovie ON sets.idSet=setlinkmovie.idSet JOIN (SELECT idSet, COUNT(1) AS c FROM setlinkmovie GROUP BY idSet HAVING c>1) s2 ON s2.idSet=sets.idSet JOIN movie ON setlinkmovie.idMovie=movie.idMovie JOIN files ON files.idFile=movie.idFile JOIN path ON path.idPath=files.idPath
18:11:51 T:2496 M:1163280384 DEBUG: CVideoDatabase::GetMoviesByWhere query: select * from movieview WHERE movieview.idMovie NOT IN (SELECT idMovie FROM setlinkmovie s1 JOIN(SELECT idSet, COUNT(1) AS c FROM setlinkmovie GROUP BY idSet HAVING c>1) s2 ON s2.idSet=s1.idSet)
18:11:51 T:2496 M:1163030528 DEBUG: Time for actual SQL query = 5
18:11:51 T:2496 M:1163128832 DEBUG: Time to retrieve movies from dataset = 82
bilbonvidia Wrote:DB deleted and re-created, interface does work now but I only get a movies and music menu is that right?