[confirm] Albumartist not showing (1 Viewer)

[jgbc]

After a clean import of all my music files some artists don't show in the "Album Artists" view.

I have looked in the music db using a SqlLite browser and can see that the flac files in question are included correctly in tracks table (including a strAlbumArtist), but the strAlbumArtist is not in the albumartist table. The artist is included in the artists table.

Thus modifying the "Album Artists" view and using artist instead of albumartist remedies the problem.

I have included a log from a clean import.

MediaPortal Version: 1.2 Beta
MediaPortal Skin: Default wide
Windows Version: Win 7 Home Premium x64
CPU Type: AMD
HDD: SSD
Memory: 4 Gb
Video Card: ATI
Sound Card: M2Tech HiFace

 

[jameson_uk]

Is there anything odd about these album artists? Everything seems ok to me on all my albums so need to understand what is odd here.

Do you have the treat folder as album option ticked? Are there multiple album artists in some folders?

 

[jgbc]

The treat folder as album option is checked.

One of the problematic albums is The Social Network Soundtrack by Trent Reznor and Atticus Ross.

All files for the album are in the same folder. No other files are in the folder except folder.jpg and Thumbs.db.

I have attached a screenshot from SqlLite, showing the tracks table and the album.

 

[jameson_uk]

The treat folder as album option is checked.

One of the problematic albums is The Social Network Soundtrack by Trent Reznor and Atticus Ross.

All files for the album are in the same folder. No other files are in the folder except folder.jpg and Thumbs.db.

I have attached a screenshot from SqlLite, showing the tracks table and the album.

could you expand the strArtist field in that screenshot too?

 

[jgbc]

New screenshot...

 

[jameson_uk]

Sorry can't figure out what is wrong their. I am on holiday now for a week or so. Could you please upload that album somewhere and pm me a link? I will have another look when back home

 

[jgbc]

The following SQL seems to identify the problematic tracks:

select distinct trim(substr(substr(strAlbumArtist, 2), 0, length(strAlbumArtist) - 2)) as a from tracks where a not in (select distinct strAlbumArtist from AlbumArtist)

 

[jameson_uk]

The following SQL seems to identify the problematic tracks:

select distinct trim(substr(substr(strAlbumArtist, 2), 0, length(strAlbumArtist) - 2)) as a from tracks where a not in (select distinct strAlbumArtist from AlbumArtist)

Yes in tracks multi value fields are enclosed with |
So it is only this single album artist that comes back?

 

[jgbc]

I have now tried to just import one of the problematic records from a new test music folder.

When doing so, the record is imported correctly - i.e. with a strAlbumArtist in the albumArtist table

Maybe the problem occurs because of the large number of music files I have (about 10.000 files)???

Could it help if I post the music db???