Bugzilla – Bug 5951
Clicking "Albums" link under "My Music" in web interface continuously loads
Last modified: 2009-01-29 09:47:43 UTC
After a complete clear and rescan of my music library, clicking on "My Music -> Albums" places firefox in a constant "Loading..." state. The following is spit out to the server log: [10:24:04.4378] Slim::Schema::Storage::throw_exception (67) Error: rows attribute must be positive if present [10:24:04.4386] Slim::Schema::Storage::throw_exception (67) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/local/slimserver/Slim/Schema/Storage.pm line 67) frame 1: Slim::Schema::Storage::throw_exception (/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 822) frame 2: DBIx::Class::Storage::DBI::_select (/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 118) frame 3: DBIx::Class::Storage::DBI::Cursor::all (/usr/local/slimserver/CPAN/DBIx/Class/ResultSet.pm line 945) frame 4: DBIx::Class::ResultSet::all (/usr/local/slimserver/CPAN/DBIx/Class/ResultSet.pm line 143) frame 5: DBIx::Class::ResultSet::search (/usr/local/slimserver/CPAN/DBIx/Class/ResultSet.pm line 659) frame 6: DBIx::Class::ResultSet::slice (/usr/local/slimserver/Slim/Web/Pages/BrowseDB.pm line 393) frame 7: Slim::Web::Pages::BrowseDB::browsedb (/usr/local/slimserver/Slim/Web/HTTP.pm line 1036) frame 8: Slim::Web::HTTP::generateHTTPResponse (/usr/local/slimserver/Slim/Web/HTTP.pm line 903) frame 9: Slim::Web::HTTP::processURL (/usr/local/slimserver/Slim/Web/HTTP.pm line 742) frame 10: Slim::Web::HTTP::processHTTP (/usr/local/slimserver/Slim/Networking/Select.pm line 243) frame 11: (eval) (/usr/local/slimserver/Slim/Networking/Select.pm line 243) frame 12: Slim::Networking::Select::select (/usr/local/slimserver/slimserver.pl line 487) frame 13: main::idle (/usr/local/slimserver/slimserver.pl line 437) frame 14: main::main (/usr/local/slimserver/slimserver.pl line 979) [10:24:04.4398] Slim::Networking::Select::select (245) Error: Select task failed: Carp::Clan::__ANON__(): rows attribute must be positive if present at /usr/local/slimserver/Slim/Schema/Storage.pm line 71 I did another clear and rescan and noticed that I could view by Albums up until it started working on the playlist stage. From that point on in the rescan process and once it completes, I encounter the behavior above. I've only tested this in the Default and Fishbone skins so far. Both exhibiting the same behavior. This has been observed in the following builds: SqueezeCenter Version: 7.0 - 13848 - RedHat - EN - utf8 Server IP address: 192.168.7.2 Perl Version: 5.8.8 i386-linux-thread-multi MySQL Version: 5.0.21-standard SqueezeCenter Version: 7.0 - 13997 - RedHat - EN - utf8 Server IP address: 192.168.7.2 Perl Version: 5.8.8 i386-linux-thread-multi MySQL Version: 5.0.21-standard SqueezeCenter Version: 7.0 - 14150 - Red Hat - EN - utf8 Server IP address: 192.168.7.2 Perl Version: 5.8.8 i386-linux-thread-multi MySQL Version: 5.0.21-standard
please do not preset targets. these are for QA review.
oops, I'm very sorry about that. I didn't realize the proper protocol. It won't happen again.
Please remove all the playlists in your music folder. If it's working fine then, add them back, one after the other, while retesting after every addition. Once you've found the playlist in question, please post it here.
Created attachment 2326 [details] Problematic Playlist After activating one playlist at a time, this was shown to be the problematic playlist.
Created attachment 2329 [details] Smaller Problematic Playlist This playlist exhibited the same behavior but is smaller so I thought it may be useful for reference as well.
QA to check to see if this playlist breaks our systems. I (Chris) can help review the file for anomalies.
I just upgraded to the 20071230 version using the yum repository and this appears to be working now. Was something changed in the code that would have fixed this? ;-)
This bug is being closed since it was resolved for a version which is now released! Please download the new version of SqueezeCenter (formerly SlimServer) at http://www.slimdevices.com/su_downloads.html If you are still seeing this bug, please re-open it and we will consider it for a future release.