erland wrote:
> See the "Track ID" column in this table:
> http://wiki.slimdevices.com/index.php/SlimServerSupportedTags
> I know the Musicbrainz Picard tagger does it right, but it's probably
> done by the other Musicbrainz tools also:
> http://musicbrainz.org/doc/MusicBrainz_Picard
> The Picard tagger is a bit dangerous because it also replace other tags
> like ALBUM and ARTIST with the values stored in the central Musicbrainz
> database.
OK, thanks, that clarifies things.
erland wrote:
> If you install the free Database Query plugin you can look at the
> report called "Squeezebox Server Statistics", if the row "Number of
> songs without musicbrainz tags" on that report exists after a full
> rescan and is a non zero value it means that you still have files
> without musicbrainz tags.
I have been trying this now for several hours, and I cannot get that
plugin to give me a result for the ""Squeezebox Server Statistics". What
happens if I click on it is that CPU usage of my NAS goes up like crazy
and the fan starts to blow but I'm not getting anything in the browser.
I can't even open the SqueezeCenter settings page anymore. I will leave
it be for the night and see what it gives me tomorrow. But it's really
weird.
erland wrote:
> If using Database Query plugin, it's also worth to check the "Duplicate
> musicbrainz song tags" row in the "Squeezebox Server
> Inconsistency/Problems" report because if that is a non zero value the
> TrackStat musicbrainz handling won't work good in your library. The
> "Duplicate musicbrainz song tags" row typically indicate that you have
> compilation albums which contains the same songs as some of your normal
> albums, the result of this is that musicbrainz identities aren't unique.
> The easiest solution is to just remove the musicbrainz tags from the
> compilation albums which have the duplicates, which means that it works
> for most of your library just not for some of the compilation albums. If
> you don't want to do this, there is an option to disable musicbrainz
> logic in TrackStat settings page, but then you can't move/rename files
> without loosing TrackStat data.
If I try to get the "Squeezebox Server Inconsistency/Problems" I get the
following (printed in red):
Code:
--------------------
Error: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare
failed: no such function: if [for Statement " select distinct 'Missing rows in
contributor_album table' as 'Problem type',if(count(*)>0,'Yes','No') as
'Possible problem', count(*) as 'Number of' from contributor_track,tracks where
tracks.id=contributor_track.track and not exists(select * from
contributor_album where contributor=contributor_track.contributor and
role=contributor_track.role and album=tracks.album) "] at
/usr/share/perl5/Slim/Schema/Storage.pm line 126 , no such function: if
Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such
function: if [for Statement " select distinct 'Invalid musicbrainz song tags'
as 'Problem type',if(count(*)>0,'Yes','No') as 'Possible problem', count(*) as
'Number of' from tracks where musicbrainz_id is not null and musicbrainz_id not
like '%-%-%-%-%' "] at /usr/share/perl5/Slim/Schema/Storage.pm line 126 , no
such function: if Carp::Clan:
:__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such function:
if [for Statement " select distinct 'Invalid musicbrainz album tags' as
'Problem type',if(count(*)>0,'Yes','No') as 'Possible problem', count(*) as
'Number of' from albums where musicbrainz_id is not null and musicbrainz_id not
like '%-%-%-%-%' "] at /usr/share/perl5/Slim/Schema/Storage.pm line 126 , no
such function: if Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db
prepare failed: no such function: if [for Statement " select distinct 'Invalid
musicbrainz artist tags' as 'Problem type',if(count(*)>0,'Yes','No') as
'Possible problem', count(*) as 'Number of' from contributors where
musicbrainz_id is not null and musicbrainz_id not like '%-%-%-%-%' "] at
/usr/share/perl5/Slim/Schema/Storage.pm line 126 , no such function: if
Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such
function: if [for Statement " select distinct 'Duplicate musicbrainz song tags'
as 'Proble
m type',if(sum(cnt)>0,'Yes','No') as 'Possible problem', ifn!
ull(sum(cnt),0) as 'Number of' from (select count(*) as cnt from tracks where
musicbrainz_id is not null group by musicbrainz_id having count(*)>1) result "]
at /usr/share/perl5/Slim/Schema/Storage.pm line 126 , no such function: if
Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such
function: if [for Statement " select distinct 'Duplicate musicbrainz album
tags' as 'Problem type',if(sum(cnt)>0,'Yes','No') as 'Possible problem',
ifnull(sum(cnt),0) as 'Number of' from (select count(*) as cnt from albums
where musicbrainz_id is not null group by musicbrainz_id having count(*)>1)
result "] at /usr/share/perl5/Slim/Schema/Storage.pm line 126 , no such
function: if Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare
failed: no such function: if [for Statement " select distinct 'Duplicate
musicbrainz artist tags' as 'Problem type',if(sum(cnt)>0,'Yes','No') as
'Possible problem', ifnull(sum(cnt),0) as 'Number of' from (select count(*) as
cnt fr
om contributors where musicbrainz_id is not null group by musicbrainz_id
having count(*)>1) result "] at /usr/share/perl5/Slim/Schema/Storage.pm line
126 , no such function: if Carp::Clan::__ANON__(): DBI Exception:
DBD::SQLite::db prepare failed: no such function: if [for Statement " select
distinct 'Artists without any songs' as 'Problem
type',if(sum(cnt)>1,'Yes','No') as 'Possible problem', sum(cnt) as 'Number of'
from (select count(distinct contributors.id) as cnt from contributors left join
contributor_track on contributor_track.contributor=contributors.id left join
tracks on contributor_track.track=tracks.id where tracks.id is null) result "]
at /usr/share/perl5/Slim/Schema/Storage.pm line 126 , no such function: if
Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such
function: if [for Statement " select distinct 'Albums without any songs' as
'Problem type',if(sum(cnt)>0,'Yes','No') as 'Possible problem', sum(cnt) as
'Number of' from (select c
ount(distinct albums.id) as cnt from albums left join tracks!
on album!
s.id=tracks.album where tracks.id is null) result "] at
/usr/share/perl5/Slim/Schema/Storage.pm line 126 , no such function: if
Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such
function: if [for Statement " select distinct 'Genres without any songs' as
'Problem type',if(sum(cnt)>0,'Yes','No') as 'Possible problem', sum(cnt) as
'Number of' from (select count(distinct genres.id) as cnt from genres left join
genre_track on genre_track.genre=genres.id left join tracks on
genre_track.track=tracks.id where tracks.id is null) result "] at
/usr/share/perl5/Slim/Schema/Storage.pm line 126 , no such function: if
Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such
function: if [for Statement " select distinct 'Years without any songs' as
'Problem type',if(sum(cnt)>0,'Yes','No') as 'Possible problem', sum(cnt) as
'Number of' from (select count(distinct years.id) as cnt from years left join
tracks on years.id=tracks.year where trac
ks.id is null) result "] at /usr/share/perl5/Slim/Schema/Storage.pm line 126 ,
no such function: if
--------------------
However, I managed to check my files with "MusicBrainz Picard" and found
that all but very few of my files actually have the Track ID :-(
Finally, I was wondering about the "TrackStat Statistics" query: I
restored yesterdays TrackStat backup in order to see what statistics it
would give me and it seems to be getting slightly different results,
depending on when I call the query. It's as if the database is still
being updated in the background while the query is running. If this is
the case, how do I know when the results are final? The last time I
checked, it gave me not only the usual query results but also a long
error message in read, similar to the one above, but not quite as long:
Code:
--------------------
Error: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare
failed: no such function: concat [for Statement " select concat('Number of
',round(track_statistics.rating/20),' star rated songs') as parameter,count(*)
from track_statistics,tracks where tracks.url=track_statistics.url and audio=1
and track_statistics.rating>0 group by round(track_statistics.rating/20) order
by track_statistics.rating "] at /usr/share/perl5/Slim/Schema/Storage.pm line
126 , no such function: concat Carp::Clan::__ANON__(): DBI Exception:
DBD::SQLite::db prepare failed: no such function: concat [for Statement "select
concat('Number of played unique songs in ',multilibrary_libraries.name, '
library') as parameter,count(*) from
multilibrary_libraries,multilibrary_track,track_statistics,tracks where
multilibrary_libraries.id=multilibrary_track.library and
multilibrary_track.track=tracks.id and tracks.url=track_statistics.url and
audio=1 and track_statistics.playcount>0 group by multilibrar
y_libraries.id order by multilibrary_libraries.name"] at
/usr/share/perl5/Slim/Schema/Storage.pm line 126 , no such function: concat
Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such
function: concat [for Statement "select concat('Number of totally played songs
in ',multilibrary_libraries.name, ' library') as
parameter,sum(track_statistics.playcount) from
multilibrary_libraries,multilibrary_track,track_statistics,tracks where
multilibrary_libraries.id=multilibrary_track.library and
multilibrary_track.track=tracks.id and tracks.url=track_statistics.url and
audio=1 and track_statistics.playcount>0 group by multilibrary_libraries.id
order by multilibrary_libraries.name"] at
/usr/share/perl5/Slim/Schema/Storage.pm line 126 , no such function: concat
--------------------
------------------------------------------------------------------------
chaug's Profile: http://forums.slimdevices.com/member.php?userid=47641
View this thread: http://forums.slimdevices.com/showthread.php?t=35962
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
