2019-02-11, 07:58
Well, that is interesting. I can clearly see the [Missing] Tag as shown in the image, but it is a mystery for me where it is coming from.
I think this one will have to be for @DaveBlake who is currently away, but returning in the next few days. He will be able to access the DB, if not he will ping me and I can pass it onto him.
It exists so that every song has an artist relationship, hence queries can be just joins (not left joins which are much slower) without risk of missing records
As a side note, your tags could benefit from a cleanup. Many Artists are duplicated due to accents, incorrect spelling or incorrect use of separators. Have you thought of running your files through Music Brainz Picard to correct the tags?
I think this one will have to be for @DaveBlake who is currently away, but returning in the next few days. He will be able to access the DB, if not he will ping me and I can pass it onto him.
(2019-02-11, 07:13)mrob Wrote: he first row in the ARTIST table is ([Missing Tag], Artist Tag Missing, [Missing Tag], ...), which I guess is what I'm seeing on the list of artists.That is normal and is there by design. A quote of why it is there...
It exists so that every song has an artist relationship, hence queries can be just joins (not left joins which are much slower) without risk of missing records
As a side note, your tags could benefit from a cleanup. Many Artists are duplicated due to accents, incorrect spelling or incorrect use of separators. Have you thought of running your files through Music Brainz Picard to correct the tags?
