PDA

View Full Version : Dynamic Playlist bug



Philip Meyer
2009-10-27, 00:57
I've noticed a few things not quite working, although this was last night in bed, and this morning I can't remember what I was going to report ;-) I'll report them when I remember/rediscover them ;-)

In the mean time, I checked the logs this morning, and saw the following:

[07:37:21.3286] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st bind_columns failed: bind_columns called with 3 values but 2 are needed [for Statement "select year,year from tracks where year is not null group by year order by year desc"]
[07:37:21.3526] Slim::Schema::Storage::throw_exception (82) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm line 82)
frame 1: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 957)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (D:\Squeezebox Server\trunk\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm line 1146)
frame 3: (eval) (D:\Squeezebox Server\trunk\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm line 1145)
frame 4: (eval) (D:\Squeezebox Server\trunk\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm line 1134)
frame 5: Plugins::DynamicPlayList::Plugin::addParameterValu es (D:\Squeezebox Server\trunk\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm line 3433)
frame 6: Plugins::DynamicPlayList::Plugin::cliJivePlaylistP arametersHandler (P:/Music/SlimServer/trunk/server/Slim/Control/Request.pm line 1914)
frame 7: (eval) (P:/Music/SlimServer/trunk/server/Slim/Control/Request.pm line 1914)
frame 8: Slim::Control::Request::execute (P:/Music/SlimServer/trunk/server/Slim/Web/Cometd.pm line 806)
frame 9: Slim::Web::Cometd::handleRequest (P:/Music/SlimServer/trunk/server/Slim/Web/Cometd.pm line 548)
frame 10: Slim::Web::Cometd::handler (P:/Music/SlimServer/trunk/server/Slim/Web/Cometd.pm line 108)
frame 11: Slim::Web::Cometd::webHandler (P:/Music/SlimServer/trunk/server/Slim/Web/HTTP.pm line 488)
frame 12: Slim::Web::HTTP::processHTTP (P:/Music/SlimServer/trunk/server/Slim/Networking/IO/Select.pm line 139)
frame 13: (eval) (P:/Music/SlimServer/trunk/server/Slim/Networking/IO/Select.pm line 123)
frame 14: Slim::Networking::IO::Select::__ANON__ (P:/Music/SlimServer/trunk/server/Slim/Networking/IO/Select.pm line 183)
frame 15: (eval) (P:/Music/SlimServer/trunk/server/Slim/Networking/IO/Select.pm line 183)
frame 16: Slim::Networking::IO::Select::loop (P:\Music\SlimServer\trunk\server\slimserver.pl line 620)
frame 17: main::idle (P:\Music\SlimServer\trunk\server\slimserver.pl line 574)
frame 18: main::main (P:\Music\SlimServer\trunk\server\slimserver.pl line 1065)


I think this looks like it's one of my manually created SQL playlists, trying to display a list of years to choose from. Does Dynamic Playlist now expect 3 columns to be returned?

Phil

Philip Meyer
2009-10-27, 01:02
Whoops. Sorry - wrong forum.

Ignore this post - I'll repost in plugins.