[1395] - Expanding AlbumArtist in a collection fails [#7985]

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: [1395] - Expanding AlbumArtist in a collection fails [#7985]

Re: [1395] - Expanding AlbumArtist within a collection fails

by jiri » Thu Jun 23, 2011 9:53 am

Thanks, it will be fixed in the next build.

Jiri

Re: [1395] - Expanding AlbumArtist within a collection fails

by Stigg » Thu Jun 23, 2011 2:49 am

Yeah. I am having the same problem with v4.0.0.1395.

First Error
Image

Second Error
Image

[1395] - Expanding AlbumArtist in a collection fails [#7985]

by toof4st » Thu Jun 23, 2011 2:19 am

I have a created Collection, and within that, I have a AlbumArtist (other nodes may also be affected). Expanding this node, fails with an error.
It fails even if there is no filter on the collection.
However it works on the main Music tree.

Error is:
---------------------------
MediaMonkey
---------------------------
Error executing SQL "SELECT Artists.ID, Artists.Artist,Artists.Albums AS cnt FROM Artists
WHERE Artists.ID IN (SELECT ArtistsSongs.IDArtist FROM ArtistsSongs WHERE ArtistsSongs.PersonType=1 AND ArtistsSongs.idSong IN (SELECT ID FROM Songs WHERE((1))))
OR Artists.ID IN (SELECT ArtistsAlbums.IDArtist FROM ArtistsAlb" : cannot use index: idxSongsTrackTypeAlbumID (1, 1)
---------------------------
OK
---------------------------


Thanks

Top