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

Antwort per Email an