Announce: Spicefly SugarCube Version 2.03 – (Automatic MusicIP DJ) for 7.x

[bakker_be]

I already posted this on the Spicefly forum too, but I'd like to ask you guys to shed a light too
I have quite a lot of compilations with Album Artist set to "Various", but different Track Artists. Block Artist repeating is set to 20 tracks, but somehow this doesn't quite work out. I'll get for instance a Whitesnake track from a "Rock ballads" compilation, followed immediately by a Whitesnake track from "Live, in the heart of the city".
Is it somehow possible to ignore the Album Artist for mix creation?

[Blisteringblue]

After recently discovering MusicIP which is working fine I'm intreagued by the Sugarcube for the thought of 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:BI::__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?

[Wirrunna]

After recently discovering MusicIP which is working fine I'm intreagued by the Sugarcube for the thought of 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.

Any ideas?

You should have been given a user name and password to access the Spicefly site, use these and login, then you can get SugarCube 3.50 which works fine with 7.6.1

[Blisteringblue]

You should have been given a user name and password to access the Spicefly site, use these and login, then you can get SugarCube 3.50 which works fine with 7.6.1

Thanks, I now have that and am trying 3.50 now

AND it works perfectly !! Top Job

[Wirrunna]

Thanks, I now have that and am trying 3.50 now

AND it works perfectly !! Top Job

Good stuff ! Now you can start tweeking the parameters to get the mixing to your taste. I find the live view in the GUI very helpful, the number of tracks shown is set in the MIP mix parameters. There are some discussions in the Spicefly forum that may be of interest.

[Blisteringblue]

Good stuff ! Now you can start tweeking the parameters to get the mixing to your taste. I find the live view in the GUI very helpful, the number of tracks shown is set in the MIP mix parameters. There are some discussions in the Spicefly forum that may be of interest.

Was very impressed actually, first track I picked was REM obscure acoustic track and it instantly followed it with an obscure acoustic Beck track from Sea Changes! Going to have some fun with this one!

[Blisteringblue]

3 days in and absolutely love this plugin!! Why have I not been using it before. It works an absolute treat and I cannot fault it. I work from home a few days and it's so cool just to click your seed track and see where it goes. Gone from Genesis to Elvis Costello in 6 moves this morning ... LOL

I know I should get out more ;-)

[mnrbig]

How do I stop sugarcube from adding songs when I am in the mood to listen to particular tracks?

[cparker]

How do I stop sugarcube from adding songs when I am in the mood to listen to particular tracks?

Two options;
1) Disabled it via the player menu or sbs web gui, this is per player so you can still have Sugarcube adding songs on playerA but be disabled on playerB

2) Use the Dynamic Queuing option, then Sugarcube will only pick a track if your playlist is going to end. e.g listening to track 7 of 7. If you are listening to track 5 of 7 it wont queue up a track

[MeSue]

How do I stop sugarcube from adding songs when I am in the mood to listen to particular tracks?

You could do what I do - just queue what you want to "play next" and leave the SugarCube track at the end. Sugarcube will take over again when your manually added tracks are finished playing. (I guess that is with the Dynamic Queueing Cparker referred to.) It's great because you can still hand-pick stuff, but the music keeps going so you don't have to think about "what next?" until you are ready to.