vagskal;565305 Wrote:
> I am afraid that the "Query returned more than one row" errors are back
> again and appears when playing music. After the nightly automatic
> rescan for changed files this night, they surfaced this morning. In the
> scanner.log there are also some similar error messages. I have not done
> anything but playing some music last afternoon.
>
Could you try to install the "Database Query" plugin and then goto
"Extras/Database Query" and select the "Create new data query" link at
the bottom and select the "Free form query" type and enter the
following "SQL statement":
Code:
--------------------
select count(*),url from track_statistics group by url having count(*)>1
limit 10
--------------------
Then save the query and click on it and see if it displays an empty
result or if it returns 10 rows.
Note!
The Database Query plugin currently doesn't show the "Create new data
query" link in the Default skin, so you can temporary open SBS with the
classic skin by going to this address when performing the above
sequence:
http://localhost:9000/Classic (Where you can replace localhost with
the ip address if you are running SBS on a remote computer)
If the above query returns 10 rows, it means there are duplicates in
the TrackStat data. The next step is to try to find out why, to do
this, I'd like you to repeat the above steps with the following query.
You of course only need to do this if the above query returns any rows.
This query will return multiple tracks that have the same musicbrainz_id
tracks.
Code:
--------------------
select count(*),musicbrainz_id from tracks where musicbrainz_id is not null
group by musicbrainz_id having count(*)>1 limit 10;
--------------------
If none of the above queries returns anything, it means that the
problem probably is in the Custom Scan data. You can then try to run
this query but I suspect it's going to be too slow in your library
because it takes several seconds to execute in my 3000 track library.
Code:
--------------------
select count(*),module,attr,value,url from customscan_track_attributes group
by module,attr,value,url having count(*)>1 limit 10;
--------------------
If there aren't any duplicates in the Custom Scan data, this query
should return an empty result.
--
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=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
