Bugzilla – Bug 3559
Library Statistics broken
Last modified: 2008-09-15 14:39:24 UTC
I can navigate to Settings -> Information -> Library Statistics. However, it only allows the display of items "Total Albums", "Total Tracks", "Total Genres" (items 2, 3 and 5 of 5). Items 1 and 4 cannot be displayed. Additional keypresses are required to skip over those items.
For Total Track Time item: ERROR: Request: Error when trying to run function coderef: [DBIx::Class::UTF8Columns::get_column(): No such column 'sum' at D:\slim\server/Slim/Schema.pm line 721 For Artist Count: DBD::mysql::st execute failed: Unknown column 'album.compilation' in 'where clause' at D:\slim\server\CPAN/DBIx/Class/Storage/DBI.pm line 525. ERROR: Request: Error when trying to run function coderef: [DBIx::Class::ResultSet::count(): Error executing 'SELECT COUNT( DISTINCT( me.id ) ) FROM contri butors me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.contributor = me.id ) WHERE ( ( ( ( ( album.compilation IS NULL ) OR ( album.compilation = ? ) ) ) AN D ( contributorTracks.role IN ( ?, ? ) ) ) )' (`0', `1', `5'): DBD::mysql::st execute failed: Unknown column 'album.compilation' in 'where clause' at D:\slim\server\CPAN/DBIx/Class /Storage/DBI.pm line 525. ] This only applies when variousArtistAutoIdentification = 1. When it is 0, then total artist count shows up fine.
Fixed in change 8007