Before I attempt to restore my TrackStat ratings, I am making sure I have everything in place. To do that, I
1. Got the musicbrainz IDs back into my files. I used Jaikoz on a Mac to do it. According to Jaikoz 19,246 of my 20,910 songs have musicbrainz IDs. 2. Deleted my LMS cache and preferences. 3. Rescanned my files. 4. Reinstalled TrackStat and Database Query plugins. 5. Have NOT yet tried to restore my ratings. Database Query question... After doing the above, when I look at Song Info and then click View Tags, I see the musicbrainz IDs are there. Below is the details for the Dominion/Mother Russia track we've been looking at. (It's hard to read, but you can see there are values for the musicbrainz are there. This is the track ID: b8bb131f-5428-4067-bb96-31412c9a48d0.) 13324 This is what Database Query returns for my LMS stats (notice how Database Query thinks only 6496 tracks have a musicbrainz ID): Squeezebox Server Statistics wrote: > > Number of contributors: 1555 > Number of artists: 1298 > Number of track artists: 433 > Number of album artists: 424 > Number of bands: 0 > Number of conductors: 24 > Number of composers: 49 > Number of compilation albums: 273 > Number of artist albums: 224 > Number of genres: 227 > Number of songs: 20910 > Number of played unique songs: 0 > Number of totally played songs: > Number of unplayed songs: 20806 > Number of unplayed albums: 2036 > Number of unplayed artists: 1554 > Number of rated songs: 0 > Number of unrated songs: 20806 > Number of songs with musicbrainz tags: 6496 > Number of songs without musicbrainz tags: 14414 > Number of artists with musicbrainz tags: 157 > Number of artists without musicbrainz tags: 1398 > Number of albums with musicbrainz tags: 691 > Number of albums without musicbrainz tags: 1346 > Number of lossless compressed or uncompressed songs: 13363 > Number of lossy compressed songs: 7547 > Number of lossless compressed or uncompressed albums: 1161 > Number of lossy compressed albums: 876 > Number of alc songs: 13363 > Number of mp3 songs: 7522 > Number of mp4 songs: 25 > Number of songs with comment tags: 97 > Number of songs without comment tags: 20813 > Number of albums with album art: 1998 > Number of albums without album art: 39 > Number of albums with album gain tags: 873 > Number of albums without album gain tags: 1164 > Number of songs with replay gain tags: 7538 > Number of songs without replay gain tags: 13372 > Number of MusicIP mixable songs: 0 > Number of not MusicIP mixable songs: 20910 > Number of songs with lyrics: 14836 > Number of songs without lyrics: 6074 > Number of local songs: 20910 > Number of remote songs: 0 > Number of songs tagged with ID3v2.3.0: 7440 > Number of songs tagged with ID3v2.3.0, ID3v1.1: 82 > Number of songs with sample rate 22050 Hz: 110 > Number of songs with sample rate 32000 Hz: 2 > Number of songs with sample rate 44100 Hz: 20782 > Number of songs with sample rate 48000 Hz: 16 > Total file size of local songs: 443 GB > Total length of local songs: 67.4 days > This is what Database Query returns when I query specifically for the Dominion/Mother Russia track (no musicbrainz ID). select * from track_statistics where url like '%Sisters%Floodland%Dominion%mother%' wrote: > > url: > file:///Volumes/MediaFiles/alac_mp3/alac/lief/The%20Sisters%20Of%20Mercy/Floodland/1987%20%C2%AC%2001-01%20%C2%AC%20Dominion%EF%BC%8Fmother%20Russia.m4a > musicbrainz_id: > playCount: > added: 1335883820 > lastPlayed: > rating: > urlmd5: 1c7c0779158ebd4d1b99e1635b58d639 > Why the discrepancy between Jaikoz and Database Query for the number of tracks with a musicbrainz ID? Why does Jaikoz tell me that my Dominion/Mother Russia file has a musicbrainz ID? Why does viewing track info show me the musicbrainz ID for this same file? But when I run a database query, it says the file does not have a musicbrainz ID? It seems like I should figure this out before attempting to restore TrackStat data. +-------------------------------------------------------------------+ |Filename: song_info_details.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=13324| +-------------------------------------------------------------------+ ------------------------------------------------------------------------ prabbit's Profile: http://forums.slimdevices.com/member.php?userid=11142 View this thread: http://forums.slimdevices.com/showthread.php?t=94909 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
