After recently discovering MusicIP which is working fine I'm intreagued by the Sugarcube for the thought a pick a track and away you go mixes.
I've donated and have the install parameters which installs v3.02 which as I understand it is fine for my 7.6.1 squeezecentre and SQLite. Well it looks like it has installed correctly. I have the new realtime spicefly sugarcube icon and I have enabled it under the player settings for Squeezeplay as a test for now. It just will not work, you start a track playing and all you get are constant "playing next - the same track name" and it just stops after the single track. I get the following in my server log, so it would appear to be a miss somewhere. [11-09-03 20:09:31.8115] Slim::Utils::Scanner::scanDirectory (318) Found 1 files in D:\Scott\FLAC\Simply Red\Stars (1991)\10 - Simply Red - Wonderland.flac [11-09-03 20:09:45.5640] Slim::Schema::Storage::throw_exception (119) Error: DBI Exception: DBD::SQLite::db prepare failed: no such function: rand [for Statement "SELECT tracks.url, genres.name FROM contributor_track INNER JOIN tracks ON (contributor_track.track = tracks.id) INNER JOIN contributors ON (contributor_track.contributor = contributors.id) INNER JOIN genre_track ON (genre_track.track = tracks.id) INNER JOIN genres ON (genre_track.genre = genres.id) WHERE genres.name = "General Pop" order by rand() limit 1"] [11-09-03 20:09:45.5652] Slim::Schema::Storage::throw_exception (119) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line 119) frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~3.EXE>DBIx/Class/Storage/DBI.pm line 1006) frame 2: DBIx::Class::Storage::DBI::__ANON__ (C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/SugarCube/breakout.pm line 34) frame 3: Plugins::SugarCube::breakout::getRandom (C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/SugarCube/Plugin.pm line 904) frame 4: Plugins::SugarCube::Plugin::kickoff (C:\ProgramData\Squeezebox\Cache\InstalledPlugins/Plugins/SugarCube/Plugin.pm line 841) frame 5: Plugins::SugarCube::Plugin::commandCallback (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Control/Request.pm line 2076) frame 6: (eval) (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Control/Request.pm line 2076) frame 7: Slim::Control::Request::notify (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Control/Request.pm line 854) frame 8: Slim::Control::Request::checkNotifications (slimserver.pl line 672) frame 9: main::idle (slimserver.pl line 641) frame 10: main::main (slimserver.pl line 99) frame 11: PerlSvc::Interactive (/<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~3.EXE>PerlSvc.pm line 99) frame 12: PerlSvc::_interactive (slimserver.pl line 0) frame 13: (eval) (slimserver.pl line 0) [11-09-03 20:09:45.5661] Slim::Control::Request::notify (2079) Error: Failed notify: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such function: rand [for Statement "SELECT tracks.url, genres.name FROM contributor_track INNER JOIN tracks ON (contributor_track.track = tracks.id) INNER JOIN contributors ON (contributor_track.contributor = contributors.id) INNER JOIN genre_track ON (genre_track.track = tracks.id) INNER JOIN genres ON (genre_track.genre = genres.id) WHERE genres.name = "General Pop" order by rand() limit 1"] at /<C:\PROGRA~1\SQUEEZ~1\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line 123 Any ideas? -- Blisteringblue 'What am I listening to?' (http://www.last.fm/user/blisteringblue) 1 x Boom, 1 x Receiver, 1 x iPhone iPeng ------------------------------------------------------------------------ Blisteringblue's Profile: http://forums.slimdevices.com/member.php?userid=22946 View this thread: http://forums.slimdevices.com/showthread.php?t=73988 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
