1202: reference libFLAC added to wrong fields BUG#5034

[Teknojnky]

I found some tracks where "reference libFLAC" <version number> was added several fields such as grouping, composer, conductor, lyricist, involved people, original artist, original album title, original lyricist, irsc, and publisher.

I don't know when or how they got messed up, but they all appear to tracks which I had updated or added to the library since I started with 3.1 betas.

I am going through and trying to clean them all up now.

Other beta users may want to check if any of those fields have the wrong data assigned some how.

added to mantis @ http://www.ventismedia.com/mantis/view.php?id=5034

[Lowlander]

I saw the same on FLAC tracks I added with 3.0.1.1201, as the files didn't originate with me I didn't think much of it.

[Owyn]

Tried to reproduce this in 1202.

Copied a flac album folder to a "- Copy" folder via WE.
Re-Scanned parent folder to add "new" folder to library.
Checked folder in Location. Looked good.
Used FTS to search for "libflac". None found.

[Owyn]

Just double checked search.
I (temporarily) added Encoder to Search fields and it found all my flac files.

[Peke]

Regarding Encoder: In case that field is Empty when you rescan FLAC files in MM. MM will read encoder Information from FLAC file and then fill Encoder Field. But this only happened in case Encoder is Empty.

[Owyn]

Regarding Encoder: In case that field is Empty when you rescan FLAC files in MM. MM will read encoder Information from FLAC file and then fill Encoder Field. But this only happened in case Encoder is Empty.

That was not a comment about a bug with Encoder. Just added it because I knew it contained the search string.

However, are there other blank on scan fields that could be possibly populated in error with the "libflac" strings?

[Peke]

1. I didn't understand it as bug report, just wanted to clarify things.

2. No, it should not be populated.

[Teknojnky]

I believe that reference libFLAC 1.1.2 20050205 is being added to the mm library fields:

grouping
composer
conductor
lyricist
involved people
original artist
original album
original lyricist

(and encoder, as it normally should be)

when flac tracks are picked up by monitored folder.

here is debug log and screenshot

Code: Select all

[4900] Thread has started 4276
[4900] Thread registered, going to initialize 4276
[4900] Thread initialized 4276
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND ( ( exists (SELECT idTrack FROM PodcastEpisodes WHERE PodcastEpisodes.idTrack = Songs.id)  OR  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%podcast%'))) ) 
[4900] 1716 DB lock finished, took 1461501.
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND (  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%book%')) ) 
[4900] 1716 DB lock finished, took 428544.
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND ( ( exists (SELECT idTrack FROM PodcastEpisodes WHERE PodcastEpisodes.idTrack = Songs.id)  OR  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%podcast%'))) ) 
[4900] 1716 DB lock finished, took 852291.
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND (  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%book%')) ) 
[4900] 1716 DB lock finished, took 249552.
[4900] Going to make final callback 4276
[4900] Thread has finished 4276
[4900] Forms: Received WM_ACTIVATEAPP
[4900] Forms: Accepted WM_ACTIVATEAPP +
[4900] Forms: RestoreTopMost: Level: 1
[4900] Forms: RestoreTopMost: Starting
[4900] 1716 DB prepare SQL: SELECT NULL FROM Songs WHERE IDMedia=? LIMIT 1
[4900] 1716 DB query prepare finished, took 168705.
[4900] 1716 DB open SQL: SELECT * FROM Medias ORDER BY DriveType, isAudioCD, ShowLabel 
[4900] 1716 DB lock finished, took 804717.
[4900] 1716 DB open SQL: SELECT NULL FROM Songs WHERE IDMedia=? LIMIT 1 
[4900] 1716 DB lock finished, took 293130.
[4900] 1716 DB open SQL: SELECT NULL FROM Songs WHERE IDMedia=? LIMIT 1 
[4900] 1716 DB lock finished, took 119061.
[4900] 1716 DB open SQL: SELECT NULL FROM Songs WHERE IDMedia=? LIMIT 1 
[4900] 1716 DB lock finished, took 117684.
[4900] 1716 DB open SQL: SELECT NULL FROM Songs WHERE IDMedia=? LIMIT 1 
[4900] 1716 DB lock finished, took 115677.
[4900] 1716 DB open SQL: SELECT NULL FROM Songs WHERE IDMedia=? LIMIT 1 
[4900] 1716 DB lock finished, took 116100.
[4900] 1716 DB open SQL: SELECT NULL FROM Songs WHERE IDMedia=? LIMIT 1 
[4900] 1716 DB lock finished, took 122094.
[4900] 1716 DB open SQL: SELECT NULL FROM Songs WHERE IDMedia=? LIMIT 1 
[4900] 1716 DB lock finished, took 114903.
[4900] 1716 DB open SQL: SELECT NULL FROM Songs WHERE IDMedia=? LIMIT 1 
[4900] 1716 DB lock finished, took 115659.
[4900] WMDM: Device change message
[4900] WMDM: Queueing action id:0
[4900] Media: Returned value: 1
[4900] WMDM: Starting action id: 0
[4900] WMDM: Looking for device changes...
[4900] WMDM: Finished action id: 0
[4900] WMDM: Device change message
[4900] WMDM: Queueing action id:0
[4900] Media: Returned value: 1
[4900] WMDM: Starting action id: 0
[4900] WMDM: Looking for device changes...
[4900] WMDM: Finished action id: 0
[4900] WMDM: Device change message
[4900] WMDM: Queueing action id:0
[4900] Media: Returned value: 1
[4900] WMDM: Starting action id: 0
[4900] WMDM: Looking for device changes...
[4900] WMDM: Finished action id: 0
[4900] Node Location starting.
[4900] Node Location going to clear SongList.
[4900] 1716 DB prepare SQL: SELECT Count(*) FROM PathProcessing
[4900] 1716 DB query prepare finished, took 284112.
[4900] 1716 DB open SQL: SELECT Count(*) FROM PathProcessing 
[4900] 1716 DB lock finished, took 489456.
[4900] 1716 DB prepare SQL: SELECT ID,TrackCount FROM Folders WHERE IDMedia=? AND IDParentFolder=? AND Folder=?
[4900] 1716 DB query prepare finished, took 170802.
[4900] 1716 DB open SQL: SELECT ID,TrackCount FROM Folders WHERE IDMedia=? AND IDParentFolder=? AND Folder=? 
[4900] 1716 DB lock finished, took 330885.
[4900] 1716 DB open SQL: SELECT Flds1.Folder, Flds1.ID,  COUNT(Flds2.TrackCount) FROM Folders Flds1 LEFT OUTER JOIN Folders Flds2 ON Flds2.IDParentFolder=Flds1.ID AND Flds2.IDMedia=82 WHERE Flds1.IDMedia=82 AND Flds1.IDParentFolder=43812 AND Flds1.TrackCount>0 GROUP BY Flds1.Folder 
[4900] 1716 DB lock finished, took 1070208.
[4900] 1716 DB open SQL: SELECT Count(*) FROM PathProcessing 
[4900] 1716 DB lock finished, took 403326.
[4900] 1716 DB open SQL: SELECT ID,TrackCount FROM Folders WHERE IDMedia=? AND IDParentFolder=? AND Folder=? 
[4900] 1716 DB lock finished, took 293922.
[4900] 1716 DB open SQL: SELECT ID,TrackCount FROM Folders WHERE IDMedia=? AND IDParentFolder=? AND Folder=? 
[4900] 1716 DB lock finished, took 387945.
[4900] 1716 DB open SQL: SELECT Flds1.Folder, Flds1.ID,  COUNT(Flds2.TrackCount) FROM Folders Flds1 LEFT OUTER JOIN Folders Flds2 ON Flds2.IDParentFolder=Flds1.ID AND Flds2.IDMedia=82 WHERE Flds1.IDMedia=82 AND Flds1.IDParentFolder=43813 AND Flds1.TrackCount>0 GROUP BY Flds1.Folder 
[4900] 1716 DB lock finished, took 116286228.
[4900] Node Incoming starting.
[4900] Node Incoming going to clear SongList.
[4900] Thread has started 5084
[4900] Thread registered, going to initialize 5084
[4900] Thread initialized 5084
[4900] 5084 DB prepare SQL: SELECT Count(*) FROM PathProcessing
[4900] 5084 DB query prepare finished, took 152820.
[4900] 5084 DB open SQL: SELECT Count(*) FROM PathProcessing 
[4900] 5084 DB lock finished, took 321624.
[4900] 5084 DB prepare SQL: SELECT ID,TrackCount FROM Folders WHERE IDMedia=? AND IDParentFolder=? AND Folder=?
[4900] 5084 DB query prepare finished, took 180063.
[4900] 5084 DB open SQL: SELECT ID,TrackCount FROM Folders WHERE IDMedia=? AND IDParentFolder=? AND Folder=? 
[4900] 5084 DB lock finished, took 233775.
[4900] 5084 DB open SQL: SELECT ID,TrackCount FROM Folders WHERE IDMedia=? AND IDParentFolder=? AND Folder=? 
[4900] 5084 DB lock finished, took 189648.
[4900] 5084 DB open SQL: SELECT ID,TrackCount FROM Folders WHERE IDMedia=? AND IDParentFolder=? AND Folder=? 
[4900] 5084 DB lock finished, took 383580.
[4900] 5084 DB open SQL: SELECT Songs.* 
[4900] FROM Songs 
[4900] WHERE Songs.IDFolder=64323 
[4900]  
[4900] 5084 DB lock finished, took 1305981.
[4900] Going to make final callback 5084
[4900] DB: Deleting prepared query: SELECT Count(*) FROM PathProcessing 
[4900] DB: Deleting prepared query: SELECT ID,TrackCount FROM Folders WHERE IDMedia=? AND IDParentFolder=? AND Folder=? 
[4900] Thread has finished 5084
[4900] 1716 DB open SQL: SELECT Lyrics, Comment, WebCommercial, WebCopyright, WebFilepage, WebArtist, WebSource, WebRadio, WebPayment, WebPublisher, WebUser, PreviewStartTime, PreviewLength, CacheName, PreviewName, PlaybackPos, Copyright, Publisher, Encoder, ISRC, InitialKey, Language, OrigLyricist,PreGap, PostGap, TotalSamples, GaplessBytes, SignType, SignPart1, SignPart2, SignPart3, SignPart4 FROM Songs WHERE ID = 230164 
[4900] 1716 DB lock finished, took 680247.
[4900] 1716 DB open SQL: SELECT Count(*) FROM PathProcessing 
[4900] 1716 DB lock finished, took 416718.
[4900] 1716 DB open SQL: SELECT ID,TrackCount FROM Folders WHERE IDMedia=? AND IDParentFolder=? AND Folder=? 
[4900] 1716 DB lock finished, took 214974.
[4900] 1716 DB open SQL: SELECT ID,TrackCount FROM Folders WHERE IDMedia=? AND IDParentFolder=? AND Folder=? 
[4900] 1716 DB lock finished, took 191124.
[4900] 1716 DB open SQL: SELECT ID,TrackCount FROM Folders WHERE IDMedia=? AND IDParentFolder=? AND Folder=? 
[4900] 1716 DB lock finished, took 401112.
[4900] 1716 DB open SQL: SELECT Flds1.Folder, Flds1.ID,  COUNT(Flds2.TrackCount) FROM Folders Flds1 LEFT OUTER JOIN Folders Flds2 ON Flds2.IDParentFolder=Flds1.ID AND Flds2.IDMedia=82 WHERE Flds1.IDMedia=82 AND Flds1.IDParentFolder=64323 AND Flds1.TrackCount>0 GROUP BY Flds1.Folder 
[4900] 1716 DB lock finished, took 827469.
[4900] Thread has started 872
[4900] Thread registered, going to initialize 872
[4900] Thread initialized 872
[4900] 872 DB open SQL: SELECT Artist, Tracks, Albums, Authors, Conducts, Lyrics FROM Artists 
[4900] 872 DB lock finished, took 714897.
[4900] 1716 DB open SQL: SELECT IDGenre, GenreName FROM Genres 
[4900] 1716 DB lock finished, took 264627.
[4900] Thread has started 488
[4900] Thread registered, going to initialize 488
[4900] Thread initialized 488
[4900] 488 DB open SQL: SELECT Album FROM Albums 
[4900] 488 DB lock finished, took 277542.
[4900] 1716 DB open SQL: SELECT DISTINCT Artist FROM Songs WHERE IdAlbum=65726 and not Artist=(SELECT Artist FROM Albums Where ID=65726) 
[4900] 1716 DB lock finished, took 542745.
[4900] Forms: NormalizeTopMosts: Level: 0
[4900] Forms: NormalizeTopMost: Starting
[4900] Going to make final callback 488
[4900] Thread has finished 488
[4900] Going to make final callback 872
[4900] Thread has finished 872
[4900] Thread has started 2364
[4900] Thread registered, going to initialize 2364
[4900] Thread initialized 2364
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND ( ( exists (SELECT idTrack FROM PodcastEpisodes WHERE PodcastEpisodes.idTrack = Songs.id)  OR  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%podcast%'))) ) 
[4900] 1716 DB lock finished, took 3267828.
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND (  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%book%')) ) 
[4900] 1716 DB lock finished, took 534447.
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND ( ( exists (SELECT idTrack FROM PodcastEpisodes WHERE PodcastEpisodes.idTrack = Songs.id)  OR  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%podcast%'))) ) 
[4900] 1716 DB lock finished, took 1098945.
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND (  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%book%')) ) 
[4900] 1716 DB lock finished, took 440361.
[4900] Going to make final callback 2364
[4900] Thread has finished 2364
[4900] Forms: RestoreTopMost: Level: 1
[4900] Forms: RestoreTopMost: Starting
[4900] Node Now Playing starting.
[4900] Node Now Playing going to clear SongList.
[4900] Thread has started 3700
[4900] Thread registered, going to initialize 3700
[4900] Thread initialized 3700
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND ( ( exists (SELECT idTrack FROM PodcastEpisodes WHERE PodcastEpisodes.idTrack = Songs.id)  OR  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%podcast%'))) ) 
[4900] 1716 DB lock finished, took 1164735.
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND (  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%book%')) ) 
[4900] 1716 DB lock finished, took 228006.
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND ( ( exists (SELECT idTrack FROM PodcastEpisodes WHERE PodcastEpisodes.idTrack = Songs.id)  OR  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%podcast%'))) ) 
[4900] 1716 DB lock finished, took 952218.
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND (  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%book%')) ) 
[4900] 1716 DB lock finished, took 230148.
[4900] Going to make final callback 3700
[4900] Thread has finished 3700
[4900] Forms: Received WM_ACTIVATEAPP
[4900] Forms: Accepted WM_ACTIVATEAPP -
[4900] Forms: NormalizeTopMosts: Level: 0
[4900] Forms: NormalizeTopMost: Starting
[4900] Thread has started 4864
[4900] Thread registered, going to initialize 4864
[4900] Thread initialized 4864
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND ( ( exists (SELECT idTrack FROM PodcastEpisodes WHERE PodcastEpisodes.idTrack = Songs.id)  OR  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%podcast%'))) ) 
[4900] 1716 DB lock finished, took 1122696.
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND (  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%book%')) ) 
[4900] 1716 DB lock finished, took 532818.
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND ( ( exists (SELECT idTrack FROM PodcastEpisodes WHERE PodcastEpisodes.idTrack = Songs.id)  OR  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%podcast%'))) ) 
[4900] 1716 DB lock finished, took 1611198.
[4900] 1716 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND (  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%book%')) ) 
[4900] 1716 DB lock finished, took 323136.
[4900] Going to make final callback 4864
[4900] Thread has finished 4864

It should be noted, that this appears to only be in MM and not in the tags... until MM writes any updates to the tags, which then writes them.

I'll create a bug entry later unless someone gets to it first.

[nohitter151]

I can reproduce this by sending any FLAC file to a monitored folder as well

[Peke]

Will be fixed in 1203.

[Teknojnky]

[Dirhael]

Just wanted to add that this is not only a problem with flac files, because today I had this exact thing happen with some MP4's (they just ended up with "mp4creator" in those fields instead).

[Al_G]

Not sure how I missed this thread

In addition to the Encoder field being copied into the tags mentioned above, the Comment tag (if present) is copied into ISRC, Publisher and Copyright.

[Teknojnky]

Any idea when 1203+ will be posted? Working around/fixing this issue is becoming quite a chore.

[Owyn]

Any idea when 1203+ will be posted? Working around/fixing this issue is becoming quite a chore.

Hopefully soon. There is another nasty regression (5037) which has just been fixed.