Kodi Community Forum
XBMC Remote for Android - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116)
+---- Forum: Kodi Remote for Android Official Forum (https://forum.kodi.tv/forumdisplay.php?fid=129)
+---- Thread: XBMC Remote for Android (/showthread.php?tid=55346)



- freezy - 2009-10-21

@mikkle: Thanks. Sure, always open for new ideas Smile

@Starchild: The view in video mode will be gone soon and the other view will be used, which has fast scrolling out of the box. Rarfiles see here. Xbox is indeed another issue, but #32 is the one I converted for your problem.


- seaweeduk - 2009-10-21

Since the 5.7 I have had 0 problems at all using the remote with my xbox, increasing the timeout to 30 seconds seems to have done the trick although it does take a while or the lists to load there's no more problems or crashes Big Grin

I have noticed some small bugs recently relating to podcasts, I'll update the google code page later.

Great work everyone Smile


- freezy - 2009-10-21

Added: "Hide artists who appear only on compilations" (Setting read from XBMC)
Fixed: Album and song listing should now be faster
Fixed: Weird remote-moving-down-bug

Download v0.5.8

@seaweeduk: Can you test with this version if you see any speedup with your Xbox?


- StarChild - 2009-10-21

@freezy: Got a similar problem with folders. see updated ticket#43.


- seaweeduk - 2009-10-21

freezy Wrote:Added: "Hide artists who appear only on compilations" (Setting read from XBMC)
Fixed: Album and song listing should now be faster
Fixed: Weird remote-moving-down-bug

Download v0.5.8

@seaweeduk: Can you test with this version if you see any speedup with your Xbox?

I'll post an update once I get home using a stop watch to see the difference between the two if there is one Smile

Thought this wasn't worth opening an issue for since the old music and video views will be gone soon but I wanted to let you know that video plugins don't work properly currently, rss feeds also display on the remote incorrectly and crash now playing.


- StarChild - 2009-10-21

Good news is that my XBMC doesn't freeze anymore with v0.5.8 when I access Music Library, and "Albums..." goes to "Albums (0)" much faster.

EDIT: Actual, I can use "Artists (6467)", "Genres (75)" and "/", which I couldn't use before. Just "Albums" that doesn't work for me now.

Is it possible to get a rolling text for the selected items?

//Cheers StarChild


- mikkle - 2009-10-21

StarChild Wrote:Good news is that my XBMC doesn't freeze anymore with v0.5.8 when I access Music Library, and "Albums..." goes to "Albums (0)" much faster.

Are you still testing on the ~3000 albums db?
Did freezy's latests optimizations solve the out-of-mem-crash?

:O) mikkle


- StarChild - 2009-10-21

mikkle Wrote:Are you still testing on the ~3000 albums db?
Did freezy's latests optimizations solve the out-of-mem-crash?

:O) mikkle
Yes ~3000 albums. I can't see in the changelog that it should been fixed? But it's overall better.
It does crash, but I cant really reproduce it because it seems that it's a little here and there in Music, at least I can use the other alternatives to access my music.


- freezy - 2009-10-21

There are albums missing I just noticed.


- seaweeduk - 2009-10-22

freezy Wrote:Added: "Hide artists who appear only on compilations" (Setting read from XBMC)
Fixed: Album and song listing should now be faster
Fixed: Weird remote-moving-down-bug

Download v0.5.8

@seaweeduk: Can you test with this version if you see any speedup with your Xbox?

maybe a slight speedup for the artist and genre views however albums view doesn't work at all just shows albums(0) and doesn't time out, selecting an artist also then causes the same behaviour.

xbmc log here incase it helps

http://pastebin.ca/1636247

edit: also here's a log of the previous version with the working album view looks like it takes about 28 seconds

http://pastebin.ca/1636270


- freezy - 2009-10-22

That's pretty weird. It seems that VA albums are not listed in album view, but zero albums is pretty strange. Basically it means that
Code:
SELECT idAlbum, strAlbum, strArtist, iYear, strThumb FROM albumview WHERE albumview.strAlbum <> ''
doesn't return anything at all.

Can you either verify that using a SQLite client, or can you do the following:
- Start XBMC
- Go to music library mode -> Albums
- Open up XBMC Remote, list albums (where you get 0 albums)
- Send me the XBMC log.

The idea is to see what query XBMC runs where you see your albums compared to what XBMC Remote runs. Should both be in XBMC's log.


- StarChild - 2009-10-22

freezy Wrote:That's pretty weird. It seems that VA albums are not listed in album view, but zero albums is pretty strange. Basically it means that
Code:
SELECT idAlbum, strAlbum, strArtist, iYear, strThumb FROM albumview WHERE albumview.strAlbum <> ''
doesn't return anything at all.

Can you either verify that using a SQLite client, or can you do the following:
- Start XBMC
- Go to music library mode -> Albums
- Open up XBMC Remote, list albums (where you get 0 albums)
- Send me the XBMC log.

The idea is to see what query XBMC runs where you see your albums compared to what XBMC Remote runs. Should both be in XBMC's log.
doesn't return anything at all.... so thats why its so fast Smile
So any suggestion to a SQLite client that can sen query commands? Tried SQLiteSpy, but don't understand how to query.


- freezy - 2009-10-22

For Windows you can get a 30-day trial of SQLite Maestro. Drag and drop your musicdb.db3 into the prog, open a query window and copy+paste the query mentioned above. Hit F9 to run it.


- StarChild - 2009-10-22

SELECT idAlbum, strAlbum, strArtist, iYear, strThumb FROM albumview WHERE albumview.strAlbum <> '' :
13281 rows fetched (0,31 sec) XBMC Debug Log

SELECT a.idAlbum, a.strAlbum, i.strArtist, a.iYear, ( SELECT p.strPath FROM song AS s, path AS p WHERE s.idPath = p.idPath AND s.idAlbum = a.idAlbum LIMIT 1 ) FROM album AS a, artist AS i WHERE a.idArtist = i.idArtist ORDER BY i.strArtist ASC :
13698 rows fetched (280,51 sec)


- freezy - 2009-10-22

So that's 13k albums instead of 3k suddenly? Now I understand you're having memory problems Wink

What does
Code:
http://xbox/xbmcCmds/xbmcHttp?command=QueryMusicDatabase(SELECT%20idAlbum,%20strAlbum,%20strArtist,%20iYear,%20strThumb%20FROM%20albumview%20WHERE%20albumview.strAlbum%20<>%20'')
return? A list with something, or nothing? Need to view source in browser, since it's in XML.