Posts: 6
Joined: Jun 2016
Reputation:
0
Hello Everyone!
I have a strange problem with my music albums in kodi, and I haven't found anything similar neither on google nor here in the forums. I have about 700 albums, and only about 400 of them get recognized in kodi as seperate album, but all the songs from the remaining albums appear under one single album. All metadata is correct for those tracks, but they get that one special album and cover. In this case this one special album can be found under almost every artist, and now its useless this way.
All the id3 tracks are filled in correctly, my music folder is processed by musicbrainz pickard, and all my other music applications (like w10 groove, syno audio station, plex) recognize each and every album.
I'm stuck here, and I can't find any solution... I've already tried rebuilding my complete music library, removing that "special album" (in this case another album gets this special role, most of the time the last processed album), but nothing... Maybe any of you had similar issues, and found a solution?
Thanks in advance!
Posts: 4,545
Joined: Jun 2015
Reputation:
269
Tomscie, firstly which version of Kodi are you using?
I would like to persue your specific issue here before you get whisked off into the bigger discussion Troy and I are having in the other thread. Your experiences sound sufficiently different to those of Troy to me. That the problem moves from one album to another is very odd.
What are your "Prefer online information", and "Fetch additional information during updates" settings?
Also could you let me have a copy of your MyMusicXX.db file (XX being version dependent) via the cloud (Dropbox or equivalent).
Posts: 6
Joined: Jun 2016
Reputation:
0
Thanks for the replies!
I'm using version 16., "Prefer online information", and "Fetch additional information during updates" are turned on, but as I remember,if i turn them off, I have the same issue, it seem independent, but I'll check once again.
Once I got home this evening I'll share the db file.
I forgot to mention, but im using Openelec on a RasPi3, and all my databases and media are on a Synology NAS. In this case the MyMusic db is on the Pi or in the MySQL db?
Posts: 4,545
Joined: Jun 2015
Reputation:
269
If you could try a clean scan (remove source, clean then add source, scan) with those two options disabled then that would be interesting. The music db in either case could be interesting too.
If you are setup using MySQL, rather than the default SQLite that would put the db as a file on the SD card of the Pi, then getting me the db will be a bit different. I haven't got the tools in front of me to check, but you will need to use a MySQL utility to export the MyMusic56 database.
Posts: 6
Joined: Jun 2016
Reputation:
0
Thanks, I will try the clean scan with those disabled settings overnight, and if I'll have no luck I'll play with the sql db. It seems complicated at first. I'll get back to you.
Posts: 4,545
Joined: Jun 2015
Reputation:
269
The other thing to try would be using SQLite, that is modify your advancesettings.xml commenting out the MySQL options. Kodi will create MyMusic56.db on the SD card, that can be pulled off across your network. It would show if the issue is MySQL specific, I don't think it will be but maybe work a go.
Posts: 6
Joined: Jun 2016
Reputation:
0
I can export a backup of my MyMusic56 database. What would be the preferred format you can analyze? I can see in phpMyAdmin, that a lot of songs has a wrong idAlbum, that belongs to that specific album...
Posts: 4,545
Joined: Jun 2015
Reputation:
269
Weird, an album mbid of "Musicbrainz Album Id".... that will be in the tags. Check how all those misplaced songs are tagged, they have probably got tag Musicbrainz Album Id = "Musicbrainz Album Id" rather than a valid mbid. At least one file will have or this album record wold not have been created,
Very odd that Picard would tag that way though? Sure these files were tagged using that tool? Other players don't use mbids, Kodi does, and if there is a problem with those tags it will lead to odd behaviour.
Yes, albums will be created in artist, album title order with A-Z, others chars, then numbers.
Export format - csv I guess. I work mostly using SQLite, but should be able to convert most things.
Posts: 4,545
Joined: Jun 2015
Reputation:
269
That is a mess! I have not seen Picard do that before, even this second go it has only corrected 1 mbid (artist), the rest are junk. Almost like the look-up of the Musicbrainz DB didn't work for you - I just looked up that recording and got all the tags in Picard (v1.3.2) no problem.
Certainly worth raising on their forum, give version etc. and let us know what they say could have happened.
