erland wrote: > Thanks for the quick answer (via mail), it looks like the musicbrainz > identities are still in the TrackStat tables so that should be what's > causing your issues. If the number of extra rows in TrackStat tables > aren't increased when you perform a rescan, I suspect the issue is that > you got these extra rows while still having the musicbrainz support > enabled in TrackStat settings page. > > I don't think they will cause any issues, except for being a worry > nagging in the back of your head. > > Still, I'm fairly shore you should be able to get rid of the duplicates > by: > 1. Taking a TrackStat backup > 2. Deleting all TrackStat data from the TrackStat settings page > 3. Restore the backup from point 1 > > However, doing that will take a bit of time, so an alternative solution > follows below. > First take a backup of TrackStat data so you can go back if something > goes wrong. > > Create a free form query like: > > Code: -------------------- > > > select * from track_statistics where url = 'xxx' > -------------------- > > > (And change xxx to the url value listed in the report with the three > tracks you posted previously) > > Run this query and verify that you get exactly 14 matches (as the > previous report you run indicated that there were 14 duplicates of > each track) > > Then change the query to instead say: > > Code: -------------------- > > > delete from track_statistics where url = 'xxx' > -------------------- > > > (And change xxx to the url value listed in the report with the three > tracks you posted previously) > > Run this query (it won't show any result, it will just delete the > duplicate rows) and then repeat the procedure for the other two > tracks. > > After this, goto TrackStat settings page in the backup section and > select the "Refresh statistics after rescan" button, this should > recreate the deleted data and only produce a single row per track in > the TrackStat tables.
As always, you are the man erland. It worked flawlessly and all the numbers match perfectly once again. My anal-retentive self can now rest easy. ;) Thank you very much. :) ------------------------------------------------------------------------ Morbeas's Profile: http://forums.slimdevices.com/member.php?userid=53547 View this thread: http://forums.slimdevices.com/showthread.php?t=49483 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
