Bugzilla – Bug 17342
A lot of deprecated warnings in log when saving playlist
Last modified: 2011-08-04 21:35:53 UTC
When you hit the save link in current playlist window in web interface to save a playlist, it produces a lot of warnings like below in the server log. Not sure if it cause any issues but it's confusing to end users to get all these irrelevant messages in the server.log. There seems to be at least one message per track in the playlist. This was tested and found in 7.6 r32861 [11-07-26 07:26:29.6798] Slim::Utils::Misc::msg (1236) Warning: [07:26:29.6795] DBIx::Class::ResultSet::single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /media/disk2/squeezecenter/7.6/server_noplugins/Slim/Schema/Track.pm line 256
I don't see any. Can you try to figure out where that call comes from?
The problem occurs for tracks with multiple genres. There is a back trace from my 7.6.1 setup: frame 0: Slim::Schema::Track::genre (/usr/src/squeezecenter/7.6/server/Slim/Control/Queries.pm line 4307) frame 1: Slim::Control::Queries::_songData (/usr/src/squeezecenter/7.6/server/Slim/Control/Queries.pm line 3810) frame 2: Slim::Control::Queries::_addSong (/usr/src/squeezecenter/7.6/server/Slim/Control/Queries.pm line 2004) frame 3: Slim::Control::Queries::playlistsTracksQuery (/usr/src/squeezecenter/7.6/server/Slim/Control/Request.pm line 1878) frame 4: (eval) (/usr/src/squeezecenter/7.6/server/Slim/Control/Request.pm line 1878) frame 5: Slim::Control::Request::execute (/usr/src/squeezecenter/7.6/server/Slim/Menu/BrowseLibrary.pm line 787) frame 6: Slim::Menu::BrowseLibrary::_generic (/usr/src/squeezecenter/7.6/server/Slim/Menu/BrowseLibrary.pm line 1800) frame 7: Slim::Menu::BrowseLibrary::_playlistTracks (/usr/src/squeezecenter/7.6/server/Slim/Menu/BrowseLibrary.pm line 725) frame 8: Slim::Menu::BrowseLibrary::_topLevel (/usr/src/squeezecenter/7.6/server/Slim/Control/XMLBrowser.pm line 194) frame 9: Slim::Control::XMLBrowser::cliQuery (/usr/src/squeezecenter/7.6/server/Slim/Menu/BrowseLibrary.pm line 328) frame 10: Slim::Menu::BrowseLibrary::cliQuery (/usr/src/squeezecenter/7.6/server/Slim/Control/Request.pm line 1878) frame 11: (eval) (/usr/src/squeezecenter/7.6/server/Slim/Control/Request.pm line 1878) frame 12: Slim::Control::Request::execute (/usr/src/squeezecenter/7.6/server/Slim/Control/Request.pm line 875) frame 13: Slim::Control::Request::executeRequest (/usr/src/squeezecenter/7.6/server/Slim/Web/Pages/EditPlaylist.pm line 265) frame 14: Slim::Web::Pages::EditPlaylist::browsePlaylist (/usr/src/squeezecenter/7.6/server/Slim/Web/Pages/EditPlaylist.pm line 122) frame 15: Slim::Web::Pages::EditPlaylist::saveCurrentPlaylist (/usr/src/squeezecenter/7.6/server/Slim/Web/Pages/EditPlaylist.pm line 33) frame 16: Slim::Web::Pages::EditPlaylist::editplaylist (/usr/src/squeezecenter/7.6/server/Slim/Web/HTTP.pm line 1103) frame 17: Slim::Web::HTTP::generateHTTPResponse (/usr/src/squeezecenter/7.6/server/Slim/Web/HTTP.pm line 926) frame 18: Slim::Web::HTTP::processURL (/usr/src/squeezecenter/7.6/server/Slim/Web/HTTP.pm line 736) frame 19: Slim::Web::HTTP::processHTTP (/usr/src/squeezecenter/7.6/server/Slim/Networking/IO/Select.pm line 139) frame 20: (eval) (/usr/src/squeezecenter/7.6/server/Slim/Networking/IO/Select.pm line 123) frame 21: Slim::Networking::IO::Select::__ANON__ (/usr/src/squeezecenter/7.6/server/Slim/Networking/IO/Select.pm line 184) frame 22: (eval) (/usr/src/squeezecenter/7.6/server/Slim/Networking/IO/Select.pm line 184) frame 23: Slim::Networking::IO::Select::loop (/opt/squeezecenter76/slimserver.pl line 693) frame 24: main::idle (/opt/squeezecenter76/slimserver.pl line 643) frame 25: main::main (/opt/squeezecenter76/slimserver.pl line 1138)
== Auto-comment from SVN commit #32989 to the slim repo by mherger == == http://svn.slimdevices.com/slim?view=revision&revision=32989 == Fixed Bug: 17342 Description: ->single is deprecated for multiple results. Use ->first instead