Re: [SlimDevices: Plugins] CustomBrowse customized menus issues
I know, and there ARE artistnames starting with _. In the custom browse menu I have ALSO enabled the standard menu called Artists. If I click this one in 'Manage menus' I don't get the XML editor but a settings page which means that it is not customized but predefined. This Artists menu item works perfectly fine and proves (by browsing to e.g. _Agnar Mykle) that I DO HAVE artists names in the database that starts with an underscore. Just like I had before when the menu item above worked perfectly fine. But on the custom browse 'Settings' page I find something strange... Under 'Properties to use in queries and menus' I find the property libraryDir with the value C:\Users\Ronny\Music. This is NOT THE PATH to my music library. But changing this doesn't help. You mention possible differences in scanner settings. Do you have any specific scanner settings in mind? -- RonHatl RonHatl's Profile: http://forums.slimdevices.com/member.php?userid=15371 View this thread: http://forums.slimdevices.com/showthread.php?t=80634 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Beta version of SvrPowerControl
Look through the thread to find the answer. There are a couple of free programs, Caffeine and Jiggler, that stop a Mac from sleeping when activated. You can write a shell script to run either of these, and set up SvrPowerControl to run the script when the SB is not idle. It's your choice which of the two you prefer to use. For more details search either on the words Caffeine or Jiggler or for posts by me. -- danco danco's Profile: http://forums.slimdevices.com/member.php?userid=210 View this thread: http://forums.slimdevices.com/showthread.php?t=48521 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: New versions of erlands plugins
erland;563757 Wrote: > Ok, this new log explains it a bit better, reading and parsing the tag > data seems to take about 2/100 of a second but writing the tag data > takes about 0.4 to 0.7 seconds. So this means that it scans just above > 1 track per second which instead result in a scanning time around 28 > hours or something similar. This is only for one scanning module, so > for both Custom Tag and Rating Tag that time might even be duplicated > in your library. There is also a risk these times varies a bit, I > suspect they are a lot faster in the beginning when there are little > data in the database and gets slower in the end when there are more > data. I just wanted to let you know that the CustomTag scan actually took some 36 hrs on the new PC (while only 2 hrs on the old PC): Code: [10-07-22 12:29:59.7918] Plugins::CustomScan::Scanner::moduleRescan (741) Performing module rescan [10-07-24 00:38:26.8665] Plugins::CustomScan::Scanner::exitScan (1009) Rescan finished of Plugins::CustomScan::Modules::CustomTag Let me know if you have an interest in the complete log. -- vagskal 2 x SB3 (wired), Receiver (wireless), Boom (wireless), Controller, iPeng on iPod Touch, muso on remote computer running Win 7 | 7.5.2 on Win XP vagskal's Profile: http://forums.slimdevices.com/member.php?userid=20778 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
Re: [SlimDevices: Plugins] Announce: New versions of erlands plugins
vagskal;563961 Wrote: > I just wanted to let you know that the CustomTag scan actually took some > 36 hrs on the new PC (while only 2 hrs on the old PC): > > > Code: > > [10-07-22 12:29:59.7918] Plugins::CustomScan::Scanner::moduleRescan (741) Performing module rescan > > [10-07-24 00:38:26.8665] Plugins::CustomScan::Scanner::exitScan (1009) Rescan finished of Plugins::CustomScan::Modules::CustomTag > > > > Let me know if you have an interest in the complete log. PS. I use Microsoft Security on the new PC and Avast on the old PC. Just to exclude any AV software problem on the new PC I excluded the processes SqueezeSvr.exe and Mysqld.exe in Microsoft Security, but as far as I can tell that did not speed things up. -- vagskal 2 x SB3 (wired), Receiver (wireless), Boom (wireless), Controller, iPeng on iPod Touch, muso on remote computer running Win 7 | 7.5.2 on Win XP vagskal's Profile: http://forums.slimdevices.com/member.php?userid=20778 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
Re: [SlimDevices: Plugins] CustomBrowse customized menus issues
PS. Some interesting findings: When i edit libraryDir from C:\Users\Ronny\Music to C:\000_Musikk and libraryAudioDirUrl from file:///C:/Users/Ronny/Music to file:///C:/000_Musikk the setting is actually stored (it's still there if I reopen the settings page) but if I stop and start SbS then the properties are back to the first values. Does this tell you anything? -- RonHatl RonHatl's Profile: http://forums.slimdevices.com/member.php?userid=15371 View this thread: http://forums.slimdevices.com/showthread.php?t=80634 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Spotify Premium Plugin (Beta)
Hi, I just wanted to say thanks to Triode for this. Finally set this up today and it's simply amazing. Running perfectly on my OSX 10.6 server to duet, classic and boom players. Now off to download SqueezeCommander for my phone... -- mlpinto mlpinto's Profile: http://forums.slimdevices.com/member.php?userid=39416 View this thread: http://forums.slimdevices.com/showthread.php?t=79706 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Beta version of SvrPowerControl
Yes, the beta version of SrvrPowerCtrl will do what you want it to. Make sure it's the latest beta version (from last January, I think) that you have installed. But getting this to work is going to require some extra effort on your part. SrvrPowerCtrl is really all about putting the server to sleep, not keeping it awake. So, exactly as Danco suggests above, do this: Search this thread for 'caffeine' and read up on that Mac utility. Download caffeine and install it (google search for 'caffeine OSX'). Then you'll need to write a script to invoke caffeine. There should be an example script of Danco's in the thread here somewhere. Then, you may need to modify your /etc/sudoers file so that caffeine can be run by the user account that Squeezebox Server is running under. Finally, configure SrvrPowerCtrl so that the 'not-idle' action calls your caffeine invocation script. I think that's it, in a nutshell. I've been intending, for the past 9 months or so, to redo my 'ReallyPreventStandby' plugin so that it supports OSX and linux for exactly this sort of stuff and then rip out the 'not-idle' support in SrvrPowerCtrl. That probably won't happen until December, though. -- gharris999 gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115 View this thread: http://forums.slimdevices.com/showthread.php?t=48521 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CustomBrowse customized menus issues
RonHatl;563959 Wrote:
> I know, and there ARE artistnames starting with _. In the custom browse
> menu I have ALSO enabled the standard menu called Artists. If I click
> this one in 'Manage menus' I don't get the XML editor but a settings
> page which means that it is not customized but predefined. This Artists
> menu item works perfectly fine and proves (by browsing to e.g. _Agnar
> Mykle) that I DO HAVE artists names in the database that starts with an
> underscore. Just like I had before when the menu item above worked
> perfectly fine.
>
The menu you posted earlier was restricted so it only listed artists
with the role "BAND", basically those in the "BAND" tag of the music
files.
Maybe the information is scanned differently into the database so these
artists appear with the role ARTIST or ALBUMARTIST instead of BAND ?
If you are using MP3 I think there is an option in SBS Settings/My
Music called "Treat TPE2 MP3 tag as Album Artist" that might have this
effect.
Could that be the problem ?
RonHatl;563959 Wrote:
>
> But on the custom browse 'Settings' page I find something strange...
> Under 'Properties to use in queries and menus' I find the property
> libraryDir with the value C:\Users\Ronny\Music. This is NOT THE PATH to
> my music library. But changing this doesn't help.
>
The libraryDir is only used in the "Library" menu template which I
don't think people use anymore, so you can probably ignore this. It's
definitely not related to the bands menu you now have problem with.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=80634
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: New versions of erlands plugins
vagskal;563964 Wrote:
> PS. I use Microsoft Security on the new PC and Avast on the old PC. Just
> to exclude any AV software problem on the new PC I excluded the
> processes SqueezeSvr.exe and Mysqld.exe in Microsoft Security, but as
> far as I can tell that did not speed things up.
>
Is the standard SBS scanner also slower or is it just the Custom Scan
scanning ?
If other things are slower the problem is probably not related to
Custom Scan.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
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
Re: [SlimDevices: Plugins] Announce: New versions of erlands plugins
erland;563977 Wrote: > Is the standard SBS scanner also slower or is it just the Custom Scan > scanning ? > If other things are slower the problem is probably not related to > Custom Scan. It is just CustomScan scanning. The standard scanner is considerably faster on the new PC. The scan for new files the night before last night took 24 minutes on the old PC and only 11 minutes on the new PC. -- vagskal 2 x SB3 (wired), Receiver (wireless), Boom (wireless), Controller, iPeng on iPod Touch, muso on remote computer running Win 7 | 7.5.2 on Win XP vagskal's Profile: http://forums.slimdevices.com/member.php?userid=20778 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
Re: [SlimDevices: Plugins] Announce: New versions of erlands plugins
erland;563945 Wrote: > > If it's stored as one of the contributor tags SBS scanner do scan, it > should be enough if your SQL is changed from: > > Code: > > > contributor_track.track=contributors.id > > > > To: > > Code: > > > contributor_track.contributor=contributors.id > > > > It needs to a tag in the music files to be scanned in the SBS > database. PERFORMER tags aren't scanned by the standard scanner, so > if this is a tag and it is called PERFORMER, you will need the Custom > Scan plugin .. > Erland thank you very much for quick response. foobar offers PERFORMER as standard tag. code-modification didn't help unfortunately. then I have to go for Custom scan plugin..ok I'll try. thanks a lot. -- prinzenrolle prinzenrolle's Profile: http://forums.slimdevices.com/member.php?userid=39407 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
Re: [SlimDevices: Plugins] Announce: Spotify Premium Plugin (Beta)
hi. this looks great but I can't get it to work. I followed the instructions step by step, but can't get the application running (Helper App: Not Running). I am sure that I probably do something wrong, the problem is that I do not know what it is. I am using a Synology NAS (latest firmware) in combination with squeezebox 7.5 (latest available release). And I do have a spotify premium account. if i try to use it via the controller it says: (Connect timed out: Transport endpoint is not connected). I guess this is a result of not having the plug in running. CAN SOMEBODY HELP ME PLEASE? -- mdegroot mdegroot's Profile: http://forums.slimdevices.com/member.php?userid=39417 View this thread: http://forums.slimdevices.com/showthread.php?t=79706 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Spotify Premium Plugin (Beta)
mdegroot;563989 Wrote: > hi. this looks great but I can't get it to work. > > I followed the instructions step by step, but can't get the application > running (Helper App: Not Running). I am sure that I probably do > something wrong, the problem is that I do not know what it is. > > I am using a Synology NAS (latest firmware) in combination with > squeezebox 7.5 (latest available release). And I do have a spotify > premium account. > > if i try to use it via the controller it says: (Connect timed out: > Transport endpoint is not connected). I guess this is a result of not > having the plug in running. > > CAN SOMEBODY HELP ME PLEASE? Which Synology NAS - it only works on NASs using intel processors due to the limitations of the libraries available from Spotify. -- Triode Triode's Profile: http://forums.slimdevices.com/member.php?userid=17 View this thread: http://forums.slimdevices.com/showthread.php?t=79706 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Spotify Premium Plugin (Beta)
Originally Posted by PeterT View Post Just waiting to get my Qnap TS210 any day now. Will the solution you have found work on that and with a SB Duo? contour;563552 Wrote: > Without knowing for sure, my best guess is that it will not work since > the TS210 has a Marwell CPU instead of an Intel CPU according to the > QNAP website. > > /Martin I read that as well... Why is that a problem? Is there any way to move around that? Any other suggestions for a nice, silent, affordable NAS witch can support the Spotify plug in? -- PeterT PeterT's Profile: http://forums.slimdevices.com/member.php?userid=33516 View this thread: http://forums.slimdevices.com/showthread.php?t=79706 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Spotify Premium Plugin (Beta)
Thanks for your quick reply. It is a Synology 209+. -- mdegroot mdegroot's Profile: http://forums.slimdevices.com/member.php?userid=39417 View this thread: http://forums.slimdevices.com/showthread.php?t=79706 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: New versions of erlands plugins
erland;563943 Wrote: > Is the issue only related to album cover size ? > Or are there other issues too ? > Is your skin available somewhere ? Can I run it on a standard laptop ? If I were a better coder there I would've commented the changes I will attach the LUA of my skin (it's just a modified version of the WQVGA for 1024x600 resolution) and the modifed files for Album flow and the custom clock. My memory says that it was more the cover size and fooling the program to use the touch layout instead of the controller layout for each of them. I didn't have the custom clock applet all done. I was thinking there was something in there where I had to set the reolution too because the Album flow was still showing in the 480x272 space... I really should have done a better job with commenting. I was doing a lot of "try this" and I didn't go back and comment when I found somethign that worked. It should run on a standard laptop. It seems to go full screen no matter what your resolution is but if it's not native monitor resolution it's not as clear +---+ |Filename: albumflow and custom clock.zip | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=10364| +---+ -- jemmicat jemmicat's Profile: http://forums.slimdevices.com/member.php?userid=36060 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
Re: [SlimDevices: Plugins] Announce: Spotify Premium Plugin (Beta)
I tested this on a Windows based Squeezebox Server and it really works perfect on my Squeezebox Duet. I waited for this a long time an and i also think it is worth money!. Also i own a Netgear Duo and tried to install it there. The installation went well and is pretty much the same (go to the settings page by the URL : " (LAN adress):9000/settings/index.html)") However it does not actually RUN after installation the helper app says. The icon shows up on my remote (Internet Radio) but i cannot search etc. The login seems not to be active?? Is there anybody having soved this issue??? Lex -- lsjoerds lsjoerds's Profile: http://forums.slimdevices.com/member.php?userid=39421 View this thread: http://forums.slimdevices.com/showthread.php?t=79706 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Spotify Premium Plugin (Beta)
lsjoerds;564011 Wrote: > I tested this on a Windows based Squeezebox Server and it really works > perfect on my Squeezebox Duet. I waited for this a long time an and i > also think it is worth money!. > Also i own a Netgear Duo and tried to install it there. The > installation went well and is pretty much the same (go to the settings > page by the URL : > " (LAN adress):9000/settings/index.html)") > However it does not actually RUN after installation the helper app > says. > The icon shows up on my remote (Internet Radio) but i cannot search > etc. The login seems not to be active?? > Is there anybody having soved this issue??? > > Lex So for Linux based NASs there is no way to detect the architecture in advance and disable the plugin. Hence several people have installed but then found it does not work. I may look to putting an error message on the settings page saying it only works on intel based architectures. -- Triode Triode's Profile: http://forums.slimdevices.com/member.php?userid=17 View this thread: http://forums.slimdevices.com/showthread.php?t=79706 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SqueezeControl for Android announcement and support thread
Hi, I love this app and use it daily to control my squeezebox. However, since my droid has been updated with Froyo, the text in SqueezeControl is all on top of each other (see attached). You can see that the artist/album information is in small text underneath the track title, however this applies in all menus. Does anyone know how I can fix this? Simon +---+ |Filename: CAP201007241712.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=10365| +---+ -- mrsimes mrsimes's Profile: http://forums.slimdevices.com/member.php?userid=12091 View this thread: http://forums.slimdevices.com/showthread.php?t=62581 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
[SlimDevices: Plugins] SQL Playlist problem with Unicode Custom Tag
Hi there, I've noticed a little problem when using a "Random for custom tag" based sql playlist : accents in PlaylistParameter won't work, therefore the customscan_track_attributes.value in the JOIN clause is not correct e.g. é becomes é So the given playlist won't work with such values (it works with 'pure ascii' values) (I've checked a 'debug' log) For further information : - All Plugins are up to date - CustomBrowse works well with all values - I modified playlist.sql.xml and "hardcoded" the value (containing é) in JOIN instead of asking for it, and of course it works well. It's really the retrieving the value of PlaylistParameter that fails. Is there something I could/shall do, or is it a bug ? PS : I don't think it's related in any way, but when I checked the log, I noticed this, so I thought I'd report : Code: 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 customscan_track_attributes.value,customscan_track_attributes.value from customscan_track_attributes where customscan_track_attributes.module='customtag' and customscan_track_attributes.attr='MOOD' group by customscan_track_attributes.value order by customscan_track_attributes.value"] -- Stan Pulsar Stan Pulsar's Profile: http://forums.slimdevices.com/member.php?userid=6669 View this thread: http://forums.slimdevices.com/showthread.php?t=80657 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Spotify Premium Plugin (Beta)
On many Linux system "uname -m" gives the processor architecture - could the plugin not test for a response which matches "i*86" and give an error message if it fails ? -- bpa bpa's Profile: http://forums.slimdevices.com/member.php?userid=1806 View this thread: http://forums.slimdevices.com/showthread.php?t=79706 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CustomBrowse customized menus issues
Erland, I tried your suggestion, but no difference.. Then I tried to remove the entire statement about role. And now the query works! Except perhaps I get too many rows returned.. Do you know which role number is Artist? And which role numer is Albumartist? Should two roles, e.g. 1 and 2, be written like 'role in (1,2)' in the query? And yes, I'm using MP3 and only Artist and Albumartist is tagged on most of my files. -- RonHatl RonHatl's Profile: http://forums.slimdevices.com/member.php?userid=15371 View this thread: http://forums.slimdevices.com/showthread.php?t=80634 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Spotify Premium Plugin (Beta)
Triode;563914 Wrote: > New version 0.2beta10 available > - add "Starred" playlist (experimental - does not always seem to work > :() > Works great for me. In Spotify I have both local files and "spotify-files" stared, and when using your incredible great plugin only the "spotify-files" (which is exptected since your plugin can't know of my local files) get listed and plays. I love it since I use "Starred" a lot so my vote is definitely on keeping it :-) FYI; I am using Windows Home Server for running SC and your plugin. -- mariowing SqueezeCenter on Windows Home Server. Duet in living room, Boom in bathroom, second bathroom and home office, Classic v3 in home theater, Radio in bedroom and kitchen. All together; seven SB in my home. mariowing's Profile: http://forums.slimdevices.com/member.php?userid=22779 View this thread: http://forums.slimdevices.com/showthread.php?t=79706 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CustomBrowse customized menus issues
RonHatl;564037 Wrote:
>
> Do you know which role number is Artist? And which role numer is
> Albumartist?
>
Artist=1
composer=2
conductor=3
band=4
albumartist=5
trackartist=6
RonHatl;564037 Wrote:
>
> Should two roles, e.g. 1 and 2, be written like 'role in (1,2)' in the
> query?
>
Yes
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=80634
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CustomBrowse customized menus issues
Thank you so much, Erland!!! Works like a charm now! :-) One last question: In SbS 7.5.1 Settings/Interface there's an option to have Year displayed in parenthesises behind Album when browsing... Is such a way of displaying year behind album name in any way possible using customized CustomBrowse menus like e.g. the one I pasted in above? -- RonHatl RonHatl's Profile: http://forums.slimdevices.com/member.php?userid=15371 View this thread: http://forums.slimdevices.com/showthread.php?t=80634 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CustomBrowse customized menus issues
RonHatl;564047 Wrote:
>
> One last question: In SbS 7.5.1 Settings/Interface there's an option to
> have Year displayed in parenthesises behind Album when browsing...
>
> Is such a way of displaying year behind album name in any way possible
> using customized CustomBrowse menus like e.g. the one I pasted in
> above?
>
Yes, try changing:
Code:
select albums.id,albums.title
To:
Code:
select albums.id,if(albums.year=0,' ',concat('(',albums.year,')'))
And also changing:
Code:
album
To:
Code:
albumconcat
The first change will make the SQL only return " " or "(1992)" the
second change will make it append the album title in front of the value
returned by the SQL.
You might possibly also want to change the "order by" directive to
primarily order the albums by year and secondary by title and disc
number.
Code:
order by albums.year desc,albums.titlesort asc,albums.disc asc
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=80634
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Spotify Premium Plugin (Beta)
This really is great. I installed it this afternoon and am all up and running straight away. One thing - is it possible to add the radio stream functionality? Thanks a lot! -- jimdm jimdm's Profile: http://forums.slimdevices.com/member.php?userid=18080 View this thread: http://forums.slimdevices.com/showthread.php?t=79706 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] iPeng support thread
I think this might be an Ipeng issue. When I listening to a Slacker custom radio station and I save it to a "favorite" status list the selection is saved but an existing station in the "favorite" list is bumped off. So,I have a limited number of stations that can be saved as a favorite . I have contacted Slacker and they say that they cannot duplicate this. It does not happen when I am using my pc as a controller. That is why I think it might be an ipeng issue. Any answers to this? Thank you. -- Ikabob Ikabob's Profile: http://forums.slimdevices.com/member.php?userid=32088 View this thread: http://forums.slimdevices.com/showthread.php?t=51929 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] CustomBrowse customized menus issues
Just excellent!! That worked perfectly! And I agree with you; that sort order is the best! Thanks a lot, Erland! I really do appreciate it! -- RonHatl RonHatl's Profile: http://forums.slimdevices.com/member.php?userid=15371 View this thread: http://forums.slimdevices.com/showthread.php?t=80634 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] iPeng support thread
Ikabob;564067 Wrote: > I think this might be an Ipeng issue. > When I listening to a Slacker custom radio station and I save it to a > "favorite" status list the selection is saved but an existing station > in the "favorite" list is bumped off. So,I have a limited number of > stations that can be saved as a favorite . I have contacted Slacker and > they say that they cannot duplicate this. It does not happen when I am > using my pc as a controller. That is why I think it might be an ipeng > issue. Any answers to this? Thank you. What you describe is probably not an iPeng issue since I see the exact same thing when using my Controller so you should probably file a bug at bugs.slimdevices.com However, I also can't reproduce this in iPeng since in iPeng I somehow seem to be unable to save a favorite AT ALL? iPeng as well as the controller SAY that the favorite was saved but it doesn't happen. I will look into this. -- pippin --- see iPeng, the Squeezebox iPhone remote, at penguinlovesmusic.com pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777 View this thread: http://forums.slimdevices.com/showthread.php?t=51929 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
[SlimDevices: Plugins] SQL Playlist issue with v2.5.3224
Since I had the problem reported in 'this post'
(http://forums.slimdevices.com/showthread.php?t=80657), I upgraded to
the latest versions of all Erland's plugins (the ones I'm using)
Now I have a problem : if I fiddle a bit with custom SQL code in
playlists, I can't validate ("save") anymore lists, even non-modified
ones !
The error shown in red below the code box is : Not unique table/alias:
'tracks'
(that is, if I choose a simple template, like "Random for rating", and
select "custom SQL", then save immediately in the next window, I get
the error)
Same if I open ("edit") a custom one created earlier and try to save it
again without any modifications.
The playlist is still working, though.
My SBS version is 7.4.0
I'll try an upgrade, but is it the solution ?
Shall I downgrade the plugins ?
Is it a known issue ?
Thanks a lot !
--
Stan Pulsar
Stan Pulsar's Profile: http://forums.slimdevices.com/member.php?userid=6669
View this thread: http://forums.slimdevices.com/showthread.php?t=80666
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Spotify Premium Plugin (Beta)
Triode;563914 Wrote: > New version 0.2beta10 available > - windows browsing long playlists should be more reliable > - always send artwork via server > - avoid using Track by Artist as the title for playlists and search > tracks > - add "Starred" playlist (experimental - does not always seem to work > :() > > Note that I am not sure I will keep the "starred" playlist as the > spotify api calls often return an empty playlist which leads to an > inconsitent user interface - would be interested in feedback as to > whether this works at all for people... I can confirm that beta 10 fixes my playlist problems. Great work Triode. -- rectorydp 1xSB, 1xSB2, 1xSB3, 2xDuet, 1xBoom, 1xRadio iPeng (on Touch), SB Server 7.5.1 on WHS rectorydp's Profile: http://forums.slimdevices.com/member.php?userid=2131 View this thread: http://forums.slimdevices.com/showthread.php?t=79706 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist issue with v2.5.3224
I upgraded SBS, same problem.
Actually, after a fresh start of SBS, everything goes fine until I try
to launch this playlist :
Code:
-- PlaylistName:test carac multiple
-- PlaylistGroups:_Perso
-- PlaylistParameter1:list:Select rating:20:* (10-29),40:** (30-49),60:***
(50-69),80: (70-89),100:* (90-100)
-- PlaylistStartAction1:cli:customskip setsecondaryfilter
advancedrandom.cs.xml
-- PlaylistStopAction1:cli:customskip clearsecondaryfilter
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
join customscan_track_attributes
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='SPEED'
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
where
audio=1
and dynamicplaylist_history.id is null
and track_statistics.rating>=('PlaylistParameter1'-10)
and customscan_track_attributes.value in ('lent')
group by tracks.id
order by rand()
limit 50;
I get this error in the log :
Code:
[10-07-24 23:28:47.8683] Plugins::SQLPlayList::Plugin::getPlayList (143)
Get playlist: randomforrating
[10-07-24 23:28:47.8689] Plugins::SQLPlayList::Plugin::replaceParametersInSQL
(888) Replacing 'PlaylistParameter1' with 20
[10-07-24 23:28:47.8694] Plugins::SQLPlayList::Plugin::replaceParametersInSQL
(888) Replacing 'PlaylistOffset' with 0
[10-07-24 23:28:47.8697] Plugins::SQLPlayList::Plugin::replaceParametersInSQL
(888) Replacing 'PlaylistActiveLibrary' with 0
[10-07-24 23:28:47.8700] Plugins::SQLPlayList::Plugin::replaceParametersInSQL
(888) Replacing 'PlaylistPlayer' with '00:04:20:06:92:87'
[10-07-24 23:28:47.8703] Plugins::SQLPlayList::Plugin::replaceParametersInSQL
(888) Replacing 'PlaylistLimit' with 15
[10-07-24 23:28:47.8710] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist
(1004) Executing: select tracks.url from tracks join track_statistics on
tracks.url=track_statistics.url join customscan_track_attributes
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='SPEED' left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='00:04:20:06:92:87' where audio=1 and
dynamicplaylist_history.id is null and track_statistics.rating>=(20-10) and
customscan_track_attributes.value in ('lent') group by tracks.id order by
rand() limit 50;
[10-07-24 23:28:47.8716] Slim::Schema::Storage::throw_exception (82) Error:
DBI Exception: DBD::mysql::st execute failed: Not unique table/alias: 'tracks'
[for Statement "select tracks.url from tracks join track_statistics on
tracks.url=track_statistics.url join customscan_track_attributes
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='SPEED' left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='00:04:20:06:92:87' where audio=1 and
dynamicplaylist_history.id is null and track_statistics.rating>=(20-10) and
customscan_track_attributes.value in ('lent') group by tracks.id order by
rand() limit 50;"]
[10-07-24 23:28:47.8854] Slim::Schema::Storage::throw_exception (82)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/Slim/Schema/Storage.pm line 82)
frame 1: Slim::Schema::Storage::throw_exception
(/DBIx/Class/Storage/DBI.pm line 957)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (C:\Documents and Settings\All
Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm line 1005)
frame 3: (eval) (C:\Documents and Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm line 1002)
frame 4: Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (C:\Documents
and Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm line 910)
frame 5: Plugins::SQLPlayList::Plugin::getTracksForPlaylist (C:\Documents and
Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm line 1203)
frame 6: Plugins::SQLPlayList::Plugin::getNextDynamicPlayListTracks
(C:\Documents and Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm line
3213)
frame 7: (eval) (C:\Documents and Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm line
3213)
frame 8: Plugins::DynamicPlayList::Plugin::getTracksForPlaylist (C:\Documents
and Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plug
Re: [SlimDevices: Plugins] Announce: Spotify Premium Plugin (Beta)
mdegroot;563989 Wrote: > hi. this looks great but I can't get it to work. > > I followed the instructions step by step, but can't get the application > running (Helper App: Not Running). I am sure that I probably do > something wrong, the problem is that I do not know what it is. > > I am using a Synology NAS (latest firmware) in combination with > squeezebox 7.5 (latest available release). And I do have a spotify > premium account. > > if i try to use it via the controller it says: (Connect timed out: > Transport endpoint is not connected). I guess this is a result of not > having the plug in running. > > CAN SOMEBODY HELP ME PLEASE? The only time I have seen such a message myself (on a self made NAS with a regular linux distro) was when I forgot to install the flac/ogg libraries. I assume spotifyd could not be started then (unmet library dependency) and the regular squeezecenter log would print such a message. A simple test would be to log in and do a "ldd spotifyd" (in /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/Spotify/Bin/) to verify that all required libraries are available. -- Espen Espen's Profile: http://forums.slimdevices.com/member.php?userid=15057 View this thread: http://forums.slimdevices.com/showthread.php?t=79706 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist issue with v2.5.3224
The SQL is invalid, instead of:
Code:
join customscan_track_attributes
You should have:
Code:
join customscan_track_attributes on
Was this SQL generated from one of the templates so the template also
might be incorrect ? Or did you modify this part yourself ?
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=80666
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist problem with Unicode Custom Tag
Stan Pulsar;564034 Wrote:
>
> accents in PlaylistParameter won't work, therefore the
> customscan_track_attributes.value in the JOIN clause is not correct
>
> e.g. é becomes é (I've checked a 'debug' log)
>
> Is there something I could/shall do, or is it a bug ?
>
It's a bug in SQL Playlist or Dynamic Playlist, it seems like they
don't handle non ascii characters in custom tags correctly when
specified as parameters.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=80657
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
