Library not displaying albums or tracks

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Connect with the app to Raspbmc
2. Select "Listen to Music"
3. Click on "Artists" and then select an artist

What is the expected output? What do you see instead?
I expect to see albums or tracks to play.  Instead I see "No albums found"

What version of XBMC Remote are you using?
Latest download from Google Play store (12.0-Alpha5 Git:20120804-f93511e)

Which Android device are you using (and which ROM, if custom)?
Google Nexus 7, stock.

Which XBMC revision are you running and on which platform?
Raspbmc, RC4, on Raspberry Pi

Please provide any additional information below.
Listing of tracks does appear both when viewing the XBMC library directly 
through the TV / monitor, and also appears properly when using current version 
of AndMote.  I am therefore concluding that this is an issue with the Official 
XMBC Remote.  All other features (remote operation etc) appear to work as 
expected.

Original issue reported on code.google.com by matthew....@gmail.com on 15 Aug 2012 at 8:36

[GoogleCodeExporter]

Same issue here. Seems that the SQL query that is send to XBMC is no longer 
valid with recent XBMC builds:

SELECT idAlbum, strAlbum, strArtist, iYear, strThumb FROM albumview WHERE 
albumview.strAlbum <> '' ORDER BY lower(strAlbum) ASC

the column strArtist is renamed to strArtists and the column strThumb does no 
longer exist.

Perhaps the queries should be made XBCM-version aware?

Original comment by basrie...@gmail.com on 18 Aug 2012 at 8:31

[GoogleCodeExporter]

I fixed it in my dataase by modifying the albumview and songview to have a 
strArtist=strArtists and strThumb = "none"

Original comment by basrie...@gmail.com on 18 Aug 2012 at 9:04

[GoogleCodeExporter]

Cool - I'm no dev, so can you give me a quick pointer to how to amend that for 
myself?

Matt

Original comment by matthew....@gmail.com on 18 Aug 2012 at 9:36

[GoogleCodeExporter]

Do you have a MySQL setup or not? If you do not have a MySQL set, then you can 
simple download SQL Lite Export Personal and open your MyMusic27.db (the number 
could be different). BACKUP THE FILE just to make sure.

Select the albumview, then select the Design tab and past the following just 
before the " from albums......"

, album.strArtists AS strArtist
, 'None' AS strThumb

Then click "apply". Then open the songview and add these lines just before the 
" FROM song......"

, song.strArtists as strArtist
, 'None' as strThumb

Click "apply" that should do the trick.

Original comment by basrie...@gmail.com on 18 Aug 2012 at 9:41

[GoogleCodeExporter]

Thanks!

Original comment by matthew....@gmail.com on 18 Aug 2012 at 9:44

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Oh, if you do have a MySQL setup, then you need to edit the same views in the 
MySQL database (using some editor) and don't forget that the table and 
columnnames have `. So they look like:

`album`.`strArtists` as `strArtist`

AND: after each database version update (with new XBMC versions or nightlies), 
you loose these changes and you need to re-apply them. 

Original comment by basrie...@gmail.com on 18 Aug 2012 at 9:44