erland wrote:
> Could you create a new free form query in Database Query plugin with the
> following SQL:
> >
Code:
--------------------
> >
> select * from track_statistics where url like '%1963/18%Back%Door%Man.flac'
>
--------------------
> >
> And post the result.
> Please use the CSV link in the Database Query plugin so you get a text
> file with the result instead of pasting the screen shoot.
>
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.
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
