sql:
(SELECT COUNT(DISTINCT(idAlbum)) FROM song AS song2WHERE idPath = song.idPath) = 1

Quote:I've done some checks and in debug log I saw some sql queries where performed yet, not all of them. From what I understand there's a query per album when I try to display artist albums (a bit odd, why not one query? but it's another story)

(2020-06-25, 23:34)DaveBlake Wrote: You uploaded some poory tagged files arranged in folders inconsistently, these are no use to me whatsoever.

Tagging - no track numbers, duplicated year values

(2020-06-25, 23:34)DaveBlake Wrote: For example Album1 will have an album  path of TestMusic/album1/, but "Album Other" and "Album Another"  share the same folder as a single TestMusic/album1/.  Hence "Album Other" and "Album Another"  will not have a album path (the folder conatining all the music files of an album and only that album).

(2020-06-30, 19:29)secondlolek Wrote: Please don't focus on things that are not relevant in this case.

(2020-07-09, 19:19)secondlolek Wrote: ...you prefer to waste my time.
But ok, here it is:
https://paste.kodi.tv/pugikawogo.kodi
the holly kodi.log file which contains nothing as you can see.

Now can you finally do the test I've asked in the beginning?

(2020-07-13, 09:50)DaveBlake Wrote: However you clearly didn't do what I asked - enable component loging and use Chorus to try and show the albums.

(2020-07-13, 09:50)DaveBlake Wrote: How do you really expect me to respond to that attitude?
I take an interest in the issue, offer to help and ask repeatedly for certain info, you don't provide it and then accuse me of wasting your time.
 
Well I simply spent my time helping another user instead.

cpp:
// Check any path found is unique to that album artist, and do *not* return any path

// that is shared with other album artists. That could be because of collaborations

// i.e. albums with more than one album artist, or because there are albums by the

// artist on multiple music sources, or elsewhere in the folder hierarchy.

// Avoid returning some generic music path.

if (!basePath.empty())

{

strSQL = PrepareSQL("SELECT COUNT(album_artist.idArtist) FROM album_artist "

"JOIN song ON album_artist.idAlbum = song.idAlbum "

"JOIN path ON song.idPath = path.idPath "

"WHERE album_artist.idArtist <> %ld "

"AND strPath LIKE '%s%%'",

idArtist, basePath.c_str());

std:tring strValue = GetSingleValue(strSQL, m_pDS2);

if (!strValue.empty())

{

int countartists = static_cast<int>(strtol(strValue.c_str(), NULL, 10));

if (countartists == 0)

return true;

}

}

cpp:


// Get the unique paths of songs on the album, providing there are no songs from

    // other albums with the same path. This returns

    // a) <album> if is contains all the songs and no others, or

    // b) <album>/cd1, <album>/cd2 etc. for disc sets

    // but does *not* return any path when albums are mixed together. That could be because of

    // deliberate file organisation, or (more likely) because of a tagging error in album name

    // or Musicbrainzalbumid. Thus it avoids finding somme generic music path.

    strSQL = PrepareSQL("SELECT DISTINCT strPath, song.idPath FROM song "

      "JOIN path ON song.idPath = path.idPath "

      "WHERE song.idAlbum = %ld "

      "AND (SELECT COUNT(DISTINCT(idAlbum)) FROM song AS song2 "

      "WHERE idPath = song.idPath) = 1", idAlbum);