Ich habe eben von repos.slimdevices.com/yum/squeezecenter/trunk die
aktuellste Version des SqueezeCenters installiert. Anschliessend geht
weder an meinen SB3's, noch an Softsqueeze die Funktion
Musikbibliothek->Stilrichtung->(irgend eine Stilrichtung)->Alle Alben
Vorher ging das, ich weis allerdings nicht mehr was das für eine
Version war. Sollte aus der gleichen Quelle sein, etwa 2 Wochen alt.
Ich habe "Datenbank löschen und alles neu durchsuchen" ausgeführt, aber
keine Besserung.

SqueezeCenter-Version: 7.2 - 21792 @ Wed Jul 16 02:00:10 PDT 2008 -
SUSE - DE - utf8
IP-Adresse des Servers: 192.168.1.2
Perl-Version: 5.10.0 i586-linux-thread-multi
MySQL-Version: 5.0.51a

Plattformarchitektur: i686-linux
Hostname: server
Server-Portnummer: 9000
Anzahl erkannte Player: 4

Alle SB3's haben die Firmware nach dem Einspielen der neuen
Squeezecenter-Version updaten wollen: alle haben jetzt die Firmware 101

Mein Server log sagt:

[08-07-16 19:40:16.0772] main::checkDataSource (887) Warning: Schema
updated or no tracks in the database, initiating scan.
[08-07-16 20:45:29.4443] Slim::Schema::Storage::throw_exception (70)
Error: Error executing 'SELECT COUNT( DISTINCT( contributor.id ) ) FROM
albums me LEFT JOIN tracks tracks ON ( tracks.album = me.id ) LEFT JOIN
genre_track genreTracks ON ( genreTracks.track = tracks.id )  JOIN
albums album ON ( album.id = tracks.album )  JOIN contributors
contributor ON ( contributor.id = album.contributor ) WHERE ( ( (
contributorTracks.role IN ( ?, ?, ? ) ) AND ( genreTracks.genre = ? AND
me.id = ? ) ) )': DBD::mysql::st execute failed: Unknown column
'contributorTracks.role' in 'where clause' at
/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771.
[08-07-16 20:45:29.4454] Slim::Schema::Storage::throw_exception (70)
Backtrace:

frame 0: Slim::Utils::Log::logBacktrace
(/usr/lib/perl5/vendor_perl/Slim/Schema/Storage.pm line 70)
frame 1: Slim::Schema::Storage::throw_exception
(/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 2: DBIx::Class::Storage::DBI::_execute
(/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 3: DBIx::Class::Storage::DBI::_select
(/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line
79)
frame 4: DBIx::Class::Storage::DBI::Cursor::next
(/usr/share/squeezecenter/CPAN/DBIx/Class/ResultSet.pm line 888)
frame 5: DBIx::Class::ResultSet::_count
(/usr/share/squeezecenter/CPAN/DBIx/Class/ResultSet.pm line 849)
frame 6: DBIx::Class::ResultSet::count
(/usr/lib/perl5/vendor_perl/Slim/Web/Pages.pm line 230)
frame 7: (eval) (/usr/lib/perl5/vendor_perl/Slim/Web/Pages.pm line
227)
frame 8: Slim::Web::Pages::addLibraryStats
(/usr/lib/perl5/vendor_perl/Slim/Web/Pages/BrowseDB.pm line 515)
frame 9: Slim::Web::Pages::BrowseDB::browsedb
(/usr/lib/perl5/vendor_perl/Slim/Web/HTTP.pm line 1065)
frame 10: Slim::Web::HTTP::generateHTTPResponse
(/usr/lib/perl5/vendor_perl/Slim/Web/HTTP.pm line 938)
frame 11: Slim::Web::HTTP::processURL
(/usr/lib/perl5/vendor_perl/Slim/Web/HTTP.pm line 749)
frame 12: Slim::Web::HTTP::processHTTP
(/usr/lib/perl5/vendor_perl/Slim/Networking/IO/Select.pm line 248)
frame 13: (eval)
(/usr/lib/perl5/vendor_perl/Slim/Networking/IO/Select.pm line 248)
frame 14: Slim::Networking::IO::Select::select
(/usr/libexec/squeezecenter-server line 514)
frame 15: main::idle (/usr/libexec/squeezecenter-server line 464)
frame 16: main::main (/usr/libexec/squeezecenter-server line 1026)

[08-07-16 20:45:29.4463] Slim::Web::Pages::addLibraryStats (233) Error
building library counts: Carp::Clan::__ANON__(): Error executing
'SELECT COUNT( DISTINCT( contributor.id ) ) FROM albums me LEFT JOIN
tracks tracks ON ( tracks.album = me.id ) LEFT JOIN genre_track
genreTracks ON ( genreTracks.track = tracks.id )  JOIN albums album ON
( album.id = tracks.album )  JOIN contributors contributor ON (
contributor.id = album.contributor ) WHERE ( ( ( contributorTracks.role
IN ( ?, ?, ? ) ) AND ( genreTracks.genre = ? AND me.id = ? ) ) )':
DBD::mysql::st execute failed: Unknown column 'contributorTracks.role'
in 'where clause' at
/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771.

Irgend welche Ideen ?


-- 
cajus
------------------------------------------------------------------------
cajus's Profile: http://forums.slimdevices.com/member.php?userid=16872
View this thread: http://forums.slimdevices.com/showthread.php?t=49914

_______________________________________________
slimserver-de mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/slimserver-de

Antwort per Email an