Hallo,
hab seit ein paar Tagen meine Squeezebox3 und bin suuuuuper zufrieden.
Geiles Teil. WAF=100%. Auf der Squeezebox klappt auch alles soweit, nur
im WebInteface des Slimservers suchen bringt den slimserver zum
Absturz.
Ein Auszug aus dem Log findet ihr unten. Ich hab die 6.5.1 am laufen.
Any hints?
Code:
--------------------
2006-12-04 23:56:20.7243 ERROR: Error executing 'SELECT
LEFT(album.titlesort, 1), COUNT( DISTINCT(album.id) ) FROM
contributors me LEFT JOIN contributor_album contributorAlbums ON
( contributorAlbums.contributor = me.id ) JOIN albums album ON
( album.id = contributorAlbums.album ) WHERE ( ) GROUP BY LEFT
(album.titlesort, 1) ORDER BY concat('0', me.namesort),concat
('0', album.titlesort)': DBD::mysql::st execute failed: You have
an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near ')
GROUP BY LEFT (album.titlesort, 1) ORDER BY concat('0', me.name
at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 743.
2006-12-04 23:56:20.7446 ERROR: Backtrace follows:
2006-12-04 23:56:20.7456 Backtrace:
frame 0: Slim::Schema::Storage::throw_exception
(/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 745)
frame 1: DBIx::Class::Storage::DBI::_execute
(/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 798)
frame 2: DBIx::Class::Storage::DBI::_select
(/usr/share/perl5/DBIx/Class/Storage/DBI/Cursor.pm line 79)
frame 3: DBIx::Class::Storage::DBI::Cursor::next
(/usr/share/perl5/DBIx/Class/ResultSet.pm line 677)
frame 4: DBIx::Class::ResultSet::next
(/usr/share/perl5/DBIx/Class/ResultSet.pm line 966)
frame 5: DBIx::Class::ResultSet::first (/usr/share/perl5/Slim/Web/Pages.pm
line 388)
frame 6: Slim::Web::Pages::pageInfo
(/usr/share/perl5/Slim/Web/Pages/BrowseDB.pm line 274)
frame 7: Slim::Web::Pages::BrowseDB::browsedb
(/usr/share/perl5/Slim/Web/HTTP.pm line 824)
frame 8: Slim::Web::HTTP::generateHTTPResponse
(/usr/share/perl5/Slim/Web/HTTP.pm line 690)
frame 9: Slim::Web::HTTP::processURL (/usr/share/perl5/Slim/Web/HTTP.pm line
536)
frame 10: Slim::Web::HTTP::processHTTP
(/usr/share/perl5/Slim/Networking/Select.pm line 238)
frame 11: Slim::Networking::Select::select (/usr/sbin/slimserver line 492)
frame 12: main::idle (/usr/sbin/slimserver line 445)
frame 13: main::main (/usr/sbin/slimserver line 1071)
Carp::Clan::__ANON__(): Error executing 'SELECT LEFT
(album.titlesort, 1), COUNT( DISTINCT(album.id) ) FROM
contributors me LEFT JOIN contributor_album contributorAlbums ON
( contributorAlbums.contributor = me.id ) JOIN albums album ON
( album.id = contributorAlbums.album ) WHERE ( ) GROUP BY LEFT
(album.titlesort, 1) ORDER BY concat('0', me.namesort),concat
('0', album.titlesort)': DBD::mysql::st execute failed: You have
an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near ')
GROUP BY LEFT(album.titlesort, 1) ORDER BY concat('0', me.name
at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 743.
--------------------
--
RaK
------------------------------------------------------------------------
RaK's Profile: http://forums.slimdevices.com/member.php?userid=7855
View this thread: http://forums.slimdevices.com/showthread.php?t=30301
_______________________________________________
slimserver-de mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/slimserver-de