Re: [SlimDevices: Plugins] Dynamic Playlist bug
>I think it's harmless if everything works as it should. > Okay. The error may not have related to some minor issues I was seeing this morning. I'll have another play on SB3 when I go upstairs and see if I can remember what those issues were (and jot them down this time!). Phil ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Dynamic Playlist bug
I think it's harmless if everything works as it should. If I remember correctly, this is the situation. Dynamic Playlist doesn't know if you have used a query with 2 or 3 result parameters, so it first try to use 3 and if it gets an error it will use 2. Unfortunately, the error is logged deep down in Slim or DBI code, so you will get the confusing error in the log even if nothing is wrong. The result columns supported are: - id - name - sortname (optional) If the above is the case, you will get the error when Dynamic Playlist need a playlist parameter. This happens either when you launch a Dynamic Playlist mixer or when you start to play a Dynamic Playlist playlist. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=70454 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
[SlimDevices: Plugins] Dynamic Playlist bug
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::addParameterValues (D:\Squeezebox Server\trunk\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm line 3433) frame 6: Plugins::DynamicPlayList::Plugin::cliJivePlaylistParametersHandler (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? ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Dynamic Playlist Bug?
>I've discovered that I lose my dynamic playlist settings after a rescan >of my music. I'm using Music Magic for my music library source. After >either a full rescan or a changed music scan, when I return to the >dynamic playlist option on the web interface all of the playlists are >listed instead of the ones that I have previously selected in the >dynamic playlist settings dialog. Did you mean dynamic playlist, as in the Dynamic Playlists plugin written by Erland? I suspect all of your problems are because you haven't configured Music library/Playlist Folder settings in SqueezeCenter, and instead it only reads information that is in MusicIP. ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] Dynamic Playlist Bug?
I've discovered that I lose my dynamic playlist settings after a rescan of my music. I'm using Music Magic for my music library source. After either a full rescan or a changed music scan, when I return to the dynamic playlist option on the web interface all of the playlists are listed instead of the ones that I have previously selected in the dynamic playlist settings dialog. -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=54907 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] Dynamic Playlist Bug?
yes, the checkboxes are restored after a restart. I haven't checked the log yet. will do and get back to you. I'm using Dynamic Playlist 2.4 and squeezecenter 7.2.1 -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=54907 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] Dynamic Playlist Bug?
exile;358503 Wrote: > I'm finding that my enabled playlists that I set in the settings of the > plugin refresh back to the full list after I do a restart of > squeezecenter. Shouldn't the selected enabled playlists remain the same > until I change those settings? > Are you saying that the checkboxes in the settings page are restored after a SqueezeCenter restart ? Do you get any errors in the SqueezeCenter log found in SqueezeCenter Settings/Logging ? Are you using the latest version of Dynamic Playlist ? Which version of SqueezeCenter are you using ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=54907 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Dynamic Playlist Bug?
I'm finding that my enabled playlists that I set in the settings of the plugin refresh back to the full list after I do a restart of squeezecenter. Shouldn't the selected enabled playlists remain the same until I change those settings? -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=54907 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
