Hi
Quote:They shouldn't be causing it. (Thanks for listing them. Zarquon cleaned them up today so it shouldn't warn about them anymore)
Does the music section I added yesterday work for you? I am interested in hearing other people's experience with the media library widget. Is it working for people?
Yes the music section works perfectly here.
Only clicking on movie section have problem ( and showing movie info in latest added movie ).
Some new test I've made:
Code:
http://myhost/mediafrontpage/widgets/wXBMCLibrary.php?w=re&style=w&a=d&bc=re&showid=&season=1&videoid=459
Works.
xbmc log:
Code:
GetEpisodesByWhere query: select * from episodeview order by idEpisode desc limit 25
Time for actual SQL query = 1
Time to retrieve episodes from dataset = 6
Code:
http://myhost/mediafrontpage/widgets/wXBMCLibrary.php?w=rm&style=w&a=d&bc=rm&videoid=389
Doesn't Works.
I've checked in the xbmc mysql database and videoid 389 exist.
Xbmc log:
Code:
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
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)
Time for actual SQL query = 6
Time to retrieve movies from dataset = 78
The only difference i have in between my Tv Shows and Movies databases is the scrapper. I use TVDB in english for TV, and Cinepassion in french for movie.
Perhaps a character encoding problem when receiving special characters in json data ?
edit:
Other thing, why does it calls getMovies for having one movie details ?
Because when i call this
Quote:wXBMCLibrary.php?w=rm&style=w&a=d&bc=rm&videoid=389
, it seems to give this request acording to the logs:
Quote:{"jsonrpc": "2.0", "method": "VideoLibrary.GetMovies", "params": { "sortorder" : "ascending", "fields" : [ "genre", "director", "trailer", "tagline", "plot", "plotoutline", "title", "originaltitle", "lastplayed", "showtitle", "firstaired", "duration", "season", "episode", "runtime", "year", "playcount", "rating", "writer", "studio", "mpaa", "premiered", "album" ] }, "id": 1}
This not seems to be the json call we want , isn't it ?