johnieutah;601994 Wrote:
> Ok, let me just get this straight... I do a restore from file (using
> the older 6.2MB file) that fills in any bits which aren't in the
> current trackstat DB. So effectively trackstat only holds data for
> songs that are rated/played?
>
No they contain all songs because TrackStat also store the time a track
was added to the SBS library and that attribute exists for all tracks.
johnieutah;601994 Wrote:
>
> I've got the DB query working now and there are some 'problems' -
> whether that means anything though?!?
>
"Missing entries" just refers to entries which has been added to SBS
but aren't available in TrackStat yet. Probably because TrackStat
haven't synchronized with the SBS database. It should do this
synchronization after a rescan and at SBS startup.
"Not refreshed entries" indicates similar things, it's about tracks
that don't have a matching URL with the SBS library but do have a
Musicbrains identity that matches a track in SBS library.
"Unused entries" indicates that you have entries in the TrackStat
tables that no longer exist in SBS library, typically this is cased by
removed files or removed/moved files if you don't have Musicbrainz
identities in their tags. There is a button in "Backup" section of
TrackStat settings page that can remove these unused entries.
It's probably more interesting to run the "TrackStat Statistics" query
to see if the number of records of each type matches what you think it
should be.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=84705
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
