I'm trying to figure out why I'm getting so many "No Genre" and "No
Album" entries in my library when scanned by SC 7.1.
I'm not sure if this is related, but, after a scan, the "tracks" table
has a row with null tracknum and null album fields for each album in
the library. These rows also don't have related rows in the
"genre_track" table or in the "contributor_track" table. The "Title"
field in these rows corresponds to the parent album name, not any track
name and the "url" field points to the audio file.
This is the query I'm using to see these rows:
Code:
--------------------
SELECT tracks.id, tracks.title, tracks.url, tracks.tracknum,
tracks.content_type, tracks.album, genre_track.genre, contributor_track.role
FROM (tracks LEFT JOIN genre_track ON tracks.id = genre_track.track) LEFT
JOIN contributor_track ON tracks.id = contributor_track.track
WHERE (((tracks.tracknum) Is Null) AND ((tracks.content_type)="fec"));
--------------------
For my library, that query returns 2638 rows.
Are these orphaned rows in "tracks" used anywhere, or are these garbage
rows which ought to be cleaned out? Are these rows a side-effect of the
audio file format in my library: whole-album flacs with embedded cues?
--
gharris999
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=46208
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/beta
