[MKay]

It seems Awx doesn't support external database.

No movie & Tv Shows listing when using mysql database, everythings works ok whith sqlite.

More info on this thread:
http://forum.xbmc.org/showthread.php?tid=84647

As you mentioned in your thread there seems to be a problem with the JSON-API, because the float-value for rating is not well formatted.
Nevertheless this is strange because i am using mysql too and have no problems

Not sure what i've done wrong but it seems as though AWX is only grabbing the wide banners for my shows and not the correct smaller banners?

What do you exactly mean? AWX is not grabbing wide banners or poster banners. It is just grabbing banners because the API does not differentiate between wide banners and poster banners.
What's wrong with the "smaller banners" (poster banners?)? Are they not shown or are they shown in a wrong aspect ratio?

[hotlobster]

in fact solved it by changing ratings fields from TXT to INT.


I don't know if that's my fault or the default config.

[UndisclosedP]

Hi Mkay,

It looks like this:


Both in the dark and light skins.

[MKay]

Ok, so you have mixed type of tv-show-thumbs? Both banner and poster-images?
Because on startup of AWX it checks your tvshow-list if you have either poster-thumbs or banner-thumbs.

[ppic]

and if we use landscape images ?

[MKay]

Then it will reboot your pc and automatically format all your hdd's

If other image formats are needed: just make a feature request

[UndisclosedP]

Aha, thanks Mkay, Somehow one show had managed to get itself a vertical thumb instead of a wide thumb, it also happened to be the first show in my library so I guess thats why AWX picked it. Cleaned that up and its now all ok! Love the interface.

[ppic]

well landscape image are massively used but i don't want to overload you

[MKay]

Do you have an example image?

[ppic]

yes find it on http://www.xbmcstuff.com

apart: i've tested with timeout = 60 still can't load movie or tvshow list, still have a "failed to retrieve" error

[MKay]

If you have a linux running try this on a console and check if it returns your tvshow list and check how long it would take:

Code:

curl -u 'username:password -i -X POST -d '{"jsonrpc": "2.0", "method": "VideoLibrary.GetTVShows", "params": { "start": 0, "fields": ["genre", "director", "plot", "title", "originaltitle", "runtime", "year", "rating"] }, "id": 1}' http://your_xbmc_host/jsonrpc

[ppic]

just giving me this:

>

[MKay]

What's this? A prompt waiting for user-input?
Try to redirect the output of the program into file (by adding ">> filename" to the command above) Does the file contain any useful data (tvshow list)?

[ppic]

don't work, i still get a prompt.

Code:

xbmc@media:~$ curl -u 'xbmc:xbmc -i -X POST -d '{"jsonrpc": "2.0", "method": "VideoLibrary.GetTVShows", "params": { "start": 0, "fields": ["genre", "director", "plot", "title", "originaltitle", "runtime", "year", "rating"] }, "id": 1}' http://192.168.0.8/jsonrpc >> test.txt
>

[thazzy]

don't work, i still get a prompt.

Code:

xbmc@media:~$ curl -u 'xbmc:xbmc -i -X POST -d '{"jsonrpc": "2.0", "method": "VideoLibrary.GetTVShows", "params": { "start": 0, "fields": ["genre", "director", "plot", "title", "originaltitle", "runtime", "year", "rating"] }, "id": 1}' http://192.168.0.8/jsonrpc >> test.txt
>

Some characters needs to be escaped. Should be something like

Code:

curl -u "xbmc:xbmc -i -X POST -d \'\{\"jsonrpc\": \"2.0\", \"method\": \"VideoLibrary.GetTVShows\", \"params\": \{ \"start\": 0, \"fields\": \[\"genre\", \"director\", \"plot\", \"title\", \"originaltitle\", \"runtime\", \"year\", \"rating\"\] \}, \"id\": 1\}" http://127.0.0.1:8080/jsonrpc