Erland,
Since the recent Dynamic Playlist update some of my SQL Playlists no
longer work in Squeeze Commander.
They are all in this style:
Code:
--------------------
-- PlaylistName:All by Years...
-- PlaylistParameter1:year:Select 1st year:
-- PlaylistParameter2:custom:Select 2nd year:select tracks.year,tracks.year
from tracks where tracks.year>='PlaylistParameter1' and tracks.audio=1 group by
tracks.year order by tracks.year
select tracks.url from tracks
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
tracks.audio=1
and dynamicplaylist_history.id is null
and tracks.year>='PlaylistParameter1'
and tracks.year<='PlaylistParameter2'
group by tracks.id
order by random()
limit 20;
--------------------
and result in this in the log file:
Code:
--------------------
[12-12-31 10:46:27.2800] Slim::Schema::Storage::throw_exception (122)
Error: DBI Exception: DBD::SQLite::st bind_columns failed: bind_columns called
with 3 values but 2 are needed [for Statement "select tracks.year,tracks.year
from tracks where tracks.year>=2005 and tracks.audio=1 group by tracks.year
order by tracks.year"]
[12-12-31 10:46:27.2802] Slim::Schema::Storage::throw_exception (122)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/usr/share/perl5/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 1164)
frame 3: (eval)
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 1163)
frame 4: (eval)
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 1152)
frame 5: Plugins::DynamicPlayList::Plugin::addParameterValues
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm
line 3555)
frame 6: Plugins::DynamicPlayList::Plugin::cliJivePlaylistParametersHandler
(/usr/share/perl5/Slim/Control/Request.pm line 1884)
frame 7: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 1884)
frame 8: Slim::Control::Request::execute (/usr/share/perl5/Slim/Web/Cometd.pm
line 880)
frame 9: Slim::Web::Cometd::handleRequest
(/usr/share/perl5/Slim/Web/Cometd.pm line 553)
frame 10: Slim::Web::Cometd::handler (/usr/share/perl5/Slim/Web/Cometd.pm
line 112)
frame 11: Slim::Web::Cometd::webHandler (/usr/share/perl5/Slim/Web/HTTP.pm
line 486)
frame 12: Slim::Web::HTTP::processHTTP
(/usr/share/perl5/Slim/Networking/IO/Select.pm line 139)
frame 13: (eval) (/usr/share/perl5/Slim/Networking/IO/Select.pm line 123)
frame 14: Slim::Networking::IO::Select::__ANON__
(/usr/share/perl5/Slim/Networking/IO/Select.pm line 184)
frame 15: (eval) (/usr/share/perl5/Slim/Networking/IO/Select.pm line 184)
frame 16: Slim::Networking::IO::Select::loop (/usr/sbin/squeezeboxserver line
695)
frame 17: main::idle (/usr/sbin/squeezeboxserver line 645)
frame 18: main::main (/usr/sbin/squeezeboxserver line 1158)
--------------------
They still work through the web interface but in Squeeze Commander it
just hangs after picking the second year.
This is something which you have previously addressed and fixed. Has the
new version broken this again?
Could I manually re-install the older version of the plugin (using
Ubunutu) to verify that this is the cause?
------------------------------------------------------------------------
MillmoorRon's Profile: http://forums.slimdevices.com/member.php?userid=6413
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
