Right, where to start ?
Leona. Yeah I noticed in the xls file, so I checked the csv file that I exported from MySQL. Turns out the last field in each of those records was '"N' which is what threw the csv import I guess. Digging into the database reveals this for Leona.
PHP Code:
+---------+----------------------+-------------+-------------+------------------------+
| idAlbum | strAlbum | strArtists | strArtist | strMusicBrainzArtistID |
+---------+----------------------+-------------+-------------+------------------------+
| 2081 | Christmas, With Love | Leona Lewis | Leona Lewis | NULL |
| 2082 | Spirit | Leona Lewis | Leona Lewis | NULL |
| 2083 | Spirit | Leona Lewis | Leona Lewis | NULL |
+---------+----------------------+-------------+-------------+------------------------+
3 rows in set (0.00 sec)
No idea how that's happened, although I was already aware she was in 3 times. Didn't know she didn't have an MBID though.
The MySQL stuff is indeed all new to me. I've used phpMyAdmin for looking through stuff, but that's about it. Not done any command line queries before. Even setting the bCompilation flag had me worried in case it did something else !!!
I've re-written my tagdumper to dump the entire m4a tags barring the embedded cover-art and the resulting dump of Capture is
here.
Quote:Can you confirm that scraping (extra info from online or NFO) isn't happening, that those settings are disabled?
Can you confirm that you started scanning a fresh with an empty library?
Which albums have .m4a song files?
Originally, when Adam first appeared I believe that extra info was indeed disabled, but then I turned it on hoping it would correct things.
Yes, I started with a fresh empty library after the upgrade from 15.2 to 16.0 appeared to lose a lot of albums. So I dropped the entire DB and started again.
m4a albums are :-
Capture - Afro Celt Sound System
Seed - A C S S
Pod - A C S S
Volume 1: Sound Magic - A C S S
Volume 2: Release - A C S S
Volume 3: Further in Time - A C S S
Volume 5: Anatomic - A C S S
Finest Selection: The Greatest Hits - The Saturdays
Living For The Weekend - The Saturdays
Salute - Little Mix
Two Lanes Of Freedom - Tim McGraw
A Perfect Contradiction - Paloma Faith
I'm going to do as you suggest and drop the DB again. Actually, this gives me a good chance to clean up the path to the Music Library, as it's currently rather convoluted and the whole thing will benefit from some tidying up on disk. Therefore, I'm going to create a new root path, and just drop Capture in there to start with. I don't normally have any logging at all turned on, but I will get a debug log of the scan. Call me sceptical, but I think it'll scan in fine
I'll get back to you shortly with some news !
---- EDIT ----
OK, so I have got Kodi to reproduce the error again where Adams details are inserted. Have a debug log of it too !!!!
Here is what I did. I scanned in capture to start with, with all the online stuff turned off. Scan went fine and album was correctly displayed. But, this doesn't give you art and biographies/discographies etc, so I turned on 'Fetch additional information'.
When the scanner get to 'Sinead O'Connor' the following happens
PHP Code:
11:15:41 T:139914614007552 DEBUG: UpdateDatabaseArtistInfo downloading info for: Sinéad O'Connor
11:15:41 T:139914614007552 DEBUG: scraper: ResolveIDToUrl returned <url>http://musicbrainz.org/ws/2/artist/c78a77fa-507c-4c07-947a-0355029453bd?inc=url-rels</url>
11:15:43 T:139914614007552 DEBUG: -- nfo-scraper: Universal Artist Scraper
11:15:43 T:139914614007552 DEBUG: -- nfo url: http://musicbrainz.org/ws/2/artist/c78a77fa-507c-4c07-947a-0355029453bd?inc=url-rels
11:15:43 T:139914614007552 DEBUG: Found matching nfo file: artist.nfo
11:15:43 T:139914614007552 DEBUG: DownloadArtistInfo Got details from nfo
11:15:43 T:139914614007552 DEBUG: Mysql execute: UPDATE artist SET strArtist = 'Sinéad O\'Connor', strBorn = 'London (1954)', strFormed = '', strGenres = 'Pop/Rock',
strMoods = 'Cynical/Sarcastic;Rousing;Tense;Anxious;Theatrical;Visceral;Witty;Aggressive;Celebratory;Confident;Freewheeling;Quirky
;Rebellious;Snide;Boisterous;Detached;Eccentric;Fierce;Fun;Humorous;Playful;Raucous;Rollicking;Brassy;
Bravado;Bright;Dramatic;Earnest;Energetic;Gutsy;Intense;Lively;Sexual;Sexy;Street-Smart;Swaggering;Manic;Urgent;Hedonistic;Ironic;Irreverent;Menacing;Nocturnal;Ominous;Sleazy;
Sophisticated;Trashy;Volatile;Campy;Exuberant',
strStyles = 'Alternative/Indie Rock;Contemporary Pop/Rock;New Wave;Post-Punk;Punk/New Wave;Dance-Rock', strInstruments = '',
strBiography = 'Adam Ant is best known as a singer. He led Adam and the Ants in the early 1980s. Soon after he began a solo career with hits like
\"Goody Two Shoes\" His most recent solo album was 1995\'s \"Wonderful\", which spawned the top 40 US single by the same name.
His biggest contribution to music was probably his pioneering use of videos in the early 1980s.',
strDied = '', strDisbanded = '', strYearsActive = '1970s - 2010s',
strImage = '<thumb preview=\"http://assets.fanart.tv/fanart/music/e188a520-9cb7-4f73-a3d7-2f70c6538e92/artistthumb/ant-adam-500052f733720.jpg/preview\">
http://assets.fanart.tv/fanart/music/e188a520-9cb7-4f73-a3d7-2f70c6538e92/artistthumb/ant-adam-500052f733720.jpg</thumb>
<thumb preview=\"http://www.theaudiodb.com/images/media/artist/thumb/ant-adam-500052f733720.jpg/preview\">
http://www.theaudiodb.com/images/media/artist/thumb/ant-adam-500052f733720.jpg</thumb><thumb>http://cps-static.rovicorp.com/3/JPG_1080/MI0003/489/MI0003489224.jpg?partner=allrovi.com</thumb>
<thumb>http://cps-static.rovicorp.com/3/JPG_1080/MI0001/467/MI0001467944.jpg?partner=allrovi.com</thumb>',
strFanart = '<fanart><thumb preview=\"http://assets.fanart.tv/fanart/music/e188a520-9cb7-4f73-a3d7-2f70c6538e92/artistbackground/adam-ant-4ec52aa8dfbff.jpg/preview\">
http://assets.fanart.tv/fanart/music/e188a520-9cb7-4f73-a3d7-2f70c6538e92/artistbackground/adam-ant-4ec52aa8dfbff.jpg</thumb><thumb preview=\"http://assets.fanart.tv/fanart/music/e188a520-9cb7-4f73-a3d7-2f70c6538e92/artistbackground/adam-ant-4ec52ab1e2e3a.jpg/preview\">
http://assets.fanart.tv/fanart/music/e188a520-9cb7-4f73-a3d7-2f70c6538e92/artistbackground/adam-ant-4ec52ab1e2e3a.jpg</thumb></fanart>',
lastScraped = '2016-03-13 11:15:43', strMusicBrainzArtistID = 'c78a77fa-507c-4c07-947a-0355029453bd' WHERE idArtist = 13
If you put the URL into a browser, it returns Sinead O'Connor's details as expected.
I'm doing some more digging with cURL debugging turned on. Hopefully that'll show something more.