[SlimDevices: Plugins] Re: Announce: New WeatherTime Screensaver adds graphical forecasts
How about displaying moonphases for the now screen after the sun sets? I have no idea if this is even possible (is this info available from weather.com?) Just a thought :) -- Yannzola Yannzola's Profile: http://forums.slimdevices.com/member.php?userid=874 View this thread: http://forums.slimdevices.com/showthread.php?t=21989 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL
Hello I've been using 6.3.0 with trackstat, sqlplaylist and dynamicplaylists. Yesterday i've upgraded to 6.5.1 (06-10-10). I made a backup of the trackstat data. I uninstalled and deleted the slimserver directory. Then i installed 6.5.1 I then installed the latest version of the plug-ins. Then i restored the trackstat data from file. Now i can see that the trackstat data is included when playing songs (have added TRACKSTATRATINGMNUMBER). However the problem is that none of my sql playlists works, and also i cannot browse e.g. top rated songs in trackstat.. For the playlists, just NOTHING happens when selecting to play the playlist. For the trackstat browsing, when i e.g. select trop rated songs, nothing is displayed below the navigation menu.. No matter what i select. I then tried with 6.5.0 also and had the same problem... Now i'm back to 6.5.1 and hope that it's just some setting that i've missed??? -- wiped Squeezebox 3 - SS 6.3 - Core Duo T2500 - 2Gb ram - 25000 Songs - 1750 Albums (Mp3 and soon also FLAC) wiped's Profile: http://forums.slimdevices.com/member.php?userid=1542 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: AlienBBC - Can't listen to non-default radio stations
bpa;144603 Wrote: Virgin uses MP3 or WMA which would be handled differently than RealAudio so I suspect something to do with SoftSqueeze.In fact, we use RealAudio, if you want it. Full links are at www.virginradio.co.uk/listen and click on the 'online' tab. Those of you using the OPML feeds at http://wiki.slimdevices.com/index.cgi?WikiRadio - I've updated our OMPL feed here, including station descriptions and better audio links which should work more reliably for the vast majority of users. If you'd update your own systems, that would be great. -- virginradio virginradio's Profile: http://forums.slimdevices.com/member.php?userid=7934 View this thread: http://forums.slimdevices.com/showthread.php?t=28479 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Moose not picking up artist tag?
Many thanks to Dr. Lovegrove, for identifying and fixing the problem! Moose is now working perfectly on my system. -- Jon Jon's Profile: http://forums.slimdevices.com/member.php?userid=2848 View this thread: http://forums.slimdevices.com/showthread.php?t=28515 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Custom Browse plugin
Hello,
I took look on the plugin yesterday, in the hope, o work around the
problem that the original brows entries are not presenting compilations
tracks in differnt folders as one album.
I started modifying the shallowgenre template to cater my needs. I
modifyed two sections that select the albums and tracks to present to
the user.
Code:
menudata
SELECT
albums.id,albums.title,substr(albums.titlesort,1,1)
FROM tracks left JOIN albums ON
albums.id=tracks.album LEFT JOIN genre_track ON tracks.id=genre_track.track
WHERE
tracks.audio=1 and
genre_track.genre={genre}
group by albums.title
order by {orderby}
/menudata
and
Code:
menudata
SELECT albums.id, albums.title,
tracks.id, tracks.title
FROM tracks LEFT JOIN albums ON
albums.id=tracks.album LEFT JOIN genre_track ON tracks.id=genre_track.track
WHERE
tracks.audio=1 AND
albums.title = ( SELECT
albums.title
FROM albums
WHERE albums.id
= {album} ) AND
genre_track.genre =
{genre}
order by tracks.tracknum
asc,tracks.titlesort asc
/menudata
The problem I have is, that those selections work as I would expect it
in every query browser (when I put in numbers for the {genre} and
{album} place holders). But if I uses those querries from within the
SlimServer I only get weired results. I guess, I did not catch one o
two important points about how the SlimServer querries work ...
Regards, Lars
--
Lars
Lars's Profile: http://forums.slimdevices.com/member.php?userid=6541
View this thread: http://forums.slimdevices.com/showthread.php?t=27043
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Custom Browse plugin
Lars;145325 Wrote:
The problem I have is, that those selections work as I would expect it
in every query browser (when I put in numbers from the database for the
{genre} and {album} place holders). But if I uses those querries from
within the SlimServer I only get weired results. I guess, I did not
catch one or two important points about how the SlimServer querries
work ...
I believe the second SQL has incorrect result columns for usage with
CustomBrowse plugin, you will need to change the first row from:
SELECT albums.id, albums.title, tracks.id, tracks.title
To:
SELECT tracks.id, tracks.title
The reason is that CustomBrowse will expect the three first columns to
be:
- Identifier
- Name
- Letter (For letter links in web interface) (This column is optional
and only required if a menulinksalpha/menulinks element exist for
the specific menu.)
So in your case you should be fine by returning the
identifier(tracks.id) and the name(tracks.title) as described above.
--
erland
Erland Isaksson
'My homepage' (http://erland.homeip.net) 'My download page'
(http://erland.homeip.net/download)
(Developer of 'TrackStat'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat)
, 'SQLPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist)
, 'DynamicPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist),
'Custom Browse'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse)
and 'RandomPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist)
plugins)
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=27043
___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Custom Browse plugin
Lars;145325 Wrote: But if I uses those querries from within the SlimServer I only get weired results. I guess, I did not catch one or two important points about how the SlimServer querries work ... I forgot to mention in my last post that if the SQL returns the correct result columns it is executed the same way in CustomBrowse as it is in your ordinary query tool. If you want to see the exact SQL executed you can turn on the debugging parameter in the Custom Browse web interface. But as mentioned in my previous post, the result columns are really important. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat) , 'SQLPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist) , 'DynamicPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist), 'Custom Browse' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse) and 'RandomPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist) plugins) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=27043 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Custom Browse plugin
)p(;145232 Wrote: I had selected the popular folder in the above debugging example. I have searched the music folder for .lnk files but the search was empty.Strange. I tried to setup a similar structure on Windows and it works perfectly here. If you selected popular it would'nt show any tracks since you have no tracks in F:\Music\Popular if I understand you correct. But the thing is that it seems to look for tracks in F:\Music\ar which doesn't even exist, I would have expected it to look for music in F:\Music\popular Could you try to choose something other than popular and see where the CustomBrowse: Executing debugging message seems to look for music ? Is F: a local harddrive or is there some networked connect drive ? Where does the music directory parameter in standard slimserver point to ? F:\Music ? -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat) , 'SQLPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist) , 'DynamicPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist), 'Custom Browse' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse) and 'RandomPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist) plugins) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=27043 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL
wiped;145234 Wrote: However the problem is that none of my sql playlists works, and also i cannot browse e.g. top rated songs in trackstat.. For the playlists, just NOTHING happens when selecting to play the playlist. Unless you have been using mysql together with 6.3.0, the SQLPlayList plugin playlists need to be modified. In 6.3.0 the contained something like order by random() in 6.5.0 this has to be changed to order by rand(). For newly created playlist this will be done automatically but for old playlist you will have to change this yourself. wiped;145234 Wrote: For the trackstat browsing, when i e.g. select trop rated songs, nothing is displayed below the navigation menu.. No matter what i select.Could you enable debugging in the TrackStat settings page and see if you see some error message in the log ? wiped;145234 Wrote: not sure if it helps, but if i open a sql playlist and press test i get this output: Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' This looks like some sort of character encoding problem. Are you using Windows or Linux for slimserver and for the computer where you access the web interface ? Is everything else working correctly in slimserver ? -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat) , 'SQLPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist) , 'DynamicPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist), 'Custom Browse' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse) and 'RandomPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist) plugins) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL
I may be missing something... but is it currently possible to use a combination of Random Playlist, Dynamic Playlists, and Trackstat to create a playlist of random songs filtered by rating? In particular, I'd love to be able to have the ability to play a random list of unrated tracks + tracks rated 2/3/4/5 or higher. Or the ability to exclude low rated tracks from randomplay. Make sense? y. -- Yannzola Yannzola's Profile: http://forums.slimdevices.com/member.php?userid=874 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL
Yannzola;145418 Wrote: I may be missing something... but is it currently possible to use a combination of Random Playlist, Dynamic Playlists, and Trackstat to create a playlist of random songs filtered by rating? In particular, I'd love to be able to have the ability to play a random list of unrated tracks + tracks rated 2/3/4/5 or higher. Or the ability to exclude low rated tracks from randomplay. Make sense? You will have to use the SQLPlayList plugin for this, there is wizards available for it to create a playlist with only top rated tracks. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat) , 'SQLPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist) , 'DynamicPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist), 'Custom Browse' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse) and 'RandomPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist) plugins) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL
wiped;145234 Wrote: For the playlists, just NOTHING happens when selecting to play the playlist. I am having the same problem. Upgraded to 6.5 and my playlists do not work anymore. When editing them via the web interface no tracks are displayed. When attempting to play them the web interface shows zero files, even though the files do contain information. I also have the same plugins installed for 6.5. Any ideas anyone? -- socialxray socialxray's Profile: http://forums.slimdevices.com/member.php?userid=2996 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL
erland;145399 Wrote: Unless you have been using mysql together with 6.3.0, the SQLPlayList plugin playlists need to be modified. In 6.3.0 the contained something like order by random() in 6.5.0 this has to be changed to order by rand(). For newly created playlist this will be done automatically but for old playlist you will have to change this yourself. Ok, I'll changed that but it does not help erland;145399 Wrote: Could you enable debugging in the TrackStat settings page and see if you see some error message in the log ? Ok i'll try that, where is the log located? i enabled debugging but i don't find any log. erland;145399 Wrote: This looks like some sort of character encoding problem. Are you using Windows or Linux for slimserver and for the computer where you access the web interface ? Is everything else working correctly in slimserver ? Running on a Windows 2003 server (my only machine so i'm browsing there also), no changes made since 6.3 Everything else seems to be working fine so far. -- wiped Squeezebox 3 - SS 6.5.1 - Core Duo T2500 - 2Gb ram - 25000 Songs - 1912 Albums (FLAC and MP3) - 324Gb Music Folder wiped's Profile: http://forums.slimdevices.com/member.php?userid=1542 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Custom Browse plugin
erland;141578 Wrote: A new version (1.5) of the CustomBrowse plugin is now available, the new functionallity and changes are: ... ... - Added support for playing/adding all tracks on album ... ... Thanks again for all your hard work on this great addition to an already great system. I have a comment/question about the new 'play all songs in album' feature quoted above. It doesn't seem to work the same as the default Browser's. Maybe there's something I didn't understand or configured right. I have the 'PLAY OTHER SONGS IN ALBUM' setting turned on in the server settings. When using the default browser and pressing 'play' on a song, the current playlist is cleared, all the songs in the current album are added to a new playlist and the *selected* song starts playing. In Custom Browse, all songs are added (I don't remember if the playlist is cleared first, I guess it is. I'm at work now...) but playing starts at the *first* song of the album, not the selected one. Does any of this make actual sense? If so, could it be made to behave the same as the default browser? Thanks again. Donald -- dpayeur dpayeur's Profile: http://forums.slimdevices.com/member.php?userid=7394 View this thread: http://forums.slimdevices.com/showthread.php?t=27043 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: AlienBBC - works but starts to stutter
bpa;145124 Wrote: ...I suggest 1. Using Softsqueeze or AlienBBC mplayer test to set up a RealAudio session between PC and BBC (i.e. no WIfi). Check TCP stats at start and end. 2. With no other internet traffic to/from PC. Play an audio file on SB and look at TCP stats at the beginning and end of song - this will give TCP stats mainly for the Wifi link. bpa Here are the results: 1. mplayer/RealAudio - 7 resets; no retransmists (in about 5 mins) 2. Audio file on SB - 8 resets; 3891 retransmits (in about 4 mins) Does this tell you anything usesful? I'm beginning to have doubts about my Linksys WAG54G modem/wireless router. SB reports wireless signal strength 80-85% (in the Information section); but the wireless network has stopped several times since I installed the SB (it did stop occasionally before, but it seems to happen more now). And quite often the SB - which I leave plugged in all the time - does not find the wireless network when the PC powers up in the morning until I switch the SB off and on again (sometimes more than once). I've changed the wireless router to channel 11 (it was on 1), which seemed to help a bit. But searches of linksys forums suggest a number of owners are unenthusiastic about the WAG54G's wireless. Have you - or has anyone else - had any experience of problems with Linksys WAG54G? And are there any recommendations for a modem/wireless router powerful and reliable enought for SB (using Win XP Pro)? -- Diana -- Diana Diana's Profile: http://forums.slimdevices.com/member.php?userid=7463 View this thread: http://forums.slimdevices.com/showthread.php?t=28257 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: iTunesupdate on Tiger(Intel)
Hie Guys. Here's the result for command with debugging argument: 2006-10-11 21:35:35.0040 Requiring Plugins::iTunesUpdate::Plugin plugin. Loaded module: [Plugins::iTunesUpdate::Plugin] ok! 2006-10-11 21:35:35.1015 Initialization of Plugins::iTunesUpdate::Plugin failed: Can't locate Mac/AppleScript/Glue.pm in @INC (@INC contains: /Library/SlimDevices/ /Users/bendabloss/Library/SlimDevices /Users/bendabloss/Library/SlimDevices /Library/SlimDevices /Library/PreferencePanes/SlimServer.prefPane/Contents/server /Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/arch/5.8/darwin-thread-multi-2level /Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/arch/5.8/darwin-thread-multi-2level/auto /Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/arch/5.8.6/darwin-thread-multi-2level /Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/arch/5.8.6/darwin-thread-multi-2level/auto /Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/arch/5.8/darwin-thread-multi-2level /Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/arch/5.8/darwin-thread-multi-2level/auto /Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN/arch/darwin-thread-multi-2level /Library/PreferencePanes/SlimServer.prefPane/Contents/server/lib /Library/PreferencePanes/SlimServer.prefPane/Contents/server/CPAN /Library/PreferencePanes/SlimServer.prefPane/Contents/server /Library/PreferencePanes/SlimServer.prefPane/Contents/server /System/Library/Perl/5.8.6/darwin-thread-multi-2level /System/Library/Perl/5.8.6 /Library/Perl/5.8.6/darwin-thread-multi-2level /Library/Perl/5.8.6 /Library/Perl /Network/Library/Perl/5.8.6/darwin-thread-multi-2level /Network/Library/Perl/5.8.6 /Network/Library/Perl /System/Library/Perl/Extras/5.8.6/darwin-thread-multi-2level /System/Library/Perl/Extras/5.8.6 /Library/Perl/5.8.1/darwin-thread-multi-2level /Library/Perl/5.8.1 .) at /Library/PreferencePanes/SlimServer.prefPane/Contents/server/Plugins/iTunesUpdate/Plugin.pm line 501. Does the @INC stuff speak you? Thanks for your help. Bye. -- dabloss dabloss's Profile: http://forums.slimdevices.com/member.php?userid=7106 View this thread: http://forums.slimdevices.com/showthread.php?t=24648 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Custom Browse plugin
dpayeur;145435 Wrote: In Custom Browse, all songs are added (I don't remember if the playlist is cleared first, I guess it is. I'm at work now...) but playing starts at the *first* song of the album, not the selected one. Does any of this make actual sense? If so, could it be made to behave the same as the default browser? I'll add it to the wish list for a comming release. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat) , 'SQLPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist) , 'DynamicPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist), 'Custom Browse' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse) and 'RandomPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist) plugins) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=27043 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL
socialxray;145428 Wrote: I am having the same problem. Upgraded to 6.5 and my playlists do not work anymore. When editing them via the web interface no tracks are displayed. When attempting to play them the web interface shows zero files, even though the files do contain information. I also have the same plugins installed for 6.5. Any ideas anyone?See my previous message a few minutes before yours regarding changing random() to rand(). Make sure you have the latest versions of the plugins. If that doesn't work turn on the debugging parameter in the settings page for TrackStat/SQLPlayList and look for error messages in the log. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat) , 'SQLPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist) , 'DynamicPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist), 'Custom Browse' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse) and 'RandomPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist) plugins) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL
erland;145467 Wrote: I'm not sure if its stored to a file by default, but you should be able to open a command prompt window and run slim.exe --logfile C:\log.txt manually and then you will get the log in C:\log.txt Ok, here is the log. Started slimserver. Opened the webpage Opened trackstat Selected - top rated - top rated songs Next i switched to dynamic playlist and tried to play one of them 4-5 selected artist next i switched to sqlplaylist and choose to edit 4-5 selected artist and the pressed test (with rand()) Here is the output. 061011 22:51:51 InnoDB: Started; log sequence number 0 331678118 061011 22:51:51 [Note] C:\PROGRA~1\SLIMSE~1\server\Bin\MSWIN3~1\mysqld.exe: ready for connections. Version: '5.0.22-community-nt' socket: '' port: 9092 MySQL Community Edition (GPL) 2006-10-11 22:51:55.8281 TrackStat: initialising 2006-10-11 22:51:55.8285 TrackStat: Hook activated. 2006-10-11 22:51:55.8286 TrackStat::Storage: Checking if track_statistics database table exists 2006-10-11 22:51:55.8306 TrackStat::Storage: Checking if track_history database table exists 2006-10-11 22:51:55.8746 TrackStat::Storage: Checking charsets on tables 2006-10-11 22:51:56.6562 TrackStat::Storage: Got tracks charset = utf8 2006-10-11 22:51:56.6571 TrackStat::Storage: Got track_statistics charset = utf8 2006-10-11 22:51:56.7631 TrackStat::Storage: Got track_history charset = utf8 2006-10-11 22:51:56.7634 TrackStat::Storage: Checking if indexes is needed for track_statistics 2006-10-11 22:51:56.7689 TrackStat::Storage: Checking if indexes is needed for track_history 2006-10-11 22:51:56.7972 TrackStat::Storage: Checking if additional indexes are needed for tracks 2006-10-11 22:51:57.2969 TrackStat::Storage: Starting to analyze indexes 2006-10-11 22:51:57.8281 TrackStat::Storage: Finished analyzing indexes : It took 1.030966 seconds 2006-10-11 22:51:57.8283 TrackStat::Storage: Starting to update urls in statistic data based on musicbrainz ids 2006-10-11 22:51:57.8297 Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' 2006-10-11 22:51:57.8299 TrackStat::Storage: Finished updating urls in statistic data based on musicbrainz ids, updated 0 items : It took 0.001582 seconds 2006-10-11 22:51:57.8300 TrackStat::Storage: Starting to update musicbrainz id's in statistic data based on urls 2006-10-11 22:51:57.8305 Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' 2006-10-11 22:51:57.8306 TrackStat::Storage: Finished updating musicbrainz id's in statistic data based on urls, updated 0 items : It took 0.000583 seconds 2006-10-11 22:51:57.8307 TrackStat::Storage: Starting to update ratings in standard slimserver database based on urls 2006-10-11 22:51:57.8311 Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' 2006-10-11 22:51:57.8313 TrackStat::Storage: Finished updating ratings in standard slimserver database based on urls, updated 0 items : It took 0.000529 seconds 2006-10-11 22:51:57.8314 TrackStat::Storage: Starting to update added times in statistic data based on urls 2006-10-11 22:51:57.8318 Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' 2006-10-11 22:51:57.8319 TrackStat::Storage: Finished updating added times in statistic data based on urls, updated 0 items : It took 0.000529 seconds 2006-10-11 22:51:57.8320 TrackStat::Storage: Starting to add tracks without added times in statistic data based on urls 2006-10-11 22:51:57.8329 Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' 2006-10-11 22:51:57.8331 TrackStat::Storage: Finished adding tracks without added times in statistic data based on urls, added 0 items : It took 0.00104 seconds 2006-10-11 22:51:57.8332 TrackStat::Storage: Starting to update ratings in statistic data based on urls 2006-10-11 22:51:57.8336 Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' 2006-10-11 22:51:57.8337 TrackStat::Storage: Finished updating ratings in statistic data based on urls, updated 0 items : It took 0.000551 seconds 2006-10-11 22:51:57.8338 TrackStat::Storage: Starting to update urls in track_history based on musicbrainz ids 2006-10-11 22:51:57.8346 Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' 2006-10-11 22:51:57.8348 TrackStat::Storage: Finished updating urls in track_history based on musicbrainz ids, updated 0 items : It took 0.000906 seconds 2006-10-11 22:51:57.8350 TrackStat::Storage: Starting to update musicbrainz id's in track_history based on urls 2006-10-11 22:51:57.8354 Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' 2006-10-11
[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL
FYI, not sure if it matters but..: Searching for utf8_unicode_ci returns these txt files under slimserver: schema_1_up.sql schema_2_up.sql Searching for utf8_general_ci returns these txt files under slimserver: system.sql --- Also searched the web for the error message and found a similar one, it's swedish originally. It's not 100% the same but perhaps it can mean someting to someone who knows SQL... llegal mix of collations (swe7_swedish_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' Det betyder att databasen/tabellen/fälten har collation swe7_swe... och din anslutning till mysql har latin1, kolla om du kan ändra ngn av dem.. Translation It means that the database/table/field has collation swe7_swe ... and the connection to mysql has latin1, check if you can change one of them -- wiped Squeezebox 3 - SS 6.5.1 - Core Duo T2500 - 2Gb ram - 25000 Songs - 1912 Albums (FLAC and MP3) - 324Gb Music Folder wiped's Profile: http://forums.slimdevices.com/member.php?userid=1542 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: AlienBBC - works but starts to stutter
The Reset statistic is hard to judge but the retransmit number is a sure sign of data being lost. These tests say that data is lost on your Wifi link and not your ISP link. For internet streams this is significant because data will have to be retransmitted from the source and so you get choppy audio and stream breakdown because of your Wifi. There are a number of possible reason for lost data 1. Poor signal strength - but this does not seem to be case according to SB but it's possible signal strength value is misleading. 2. Interference - other Wifi, microwave, cordless digital phone are usual suspects but treat any wireless equipment with suspicion. 3. Access point - I can't offer any opinion on WAG54G but ensure the firmware is up to date. 4. SB - in other threads the SB handling of internet streams has been noted and firmware has been modified to rebuffer when internal buffer runs out due to errors/lack of data. This firmware is available in 6.5.1. This will help but it won't solve the basic wifi problem. What to do: 1. Run SB's net test - if it corroborates the retransmit problem with lowish 100% bitrate then use Net test for testing the following suggestions. 2. Try SB wired to router to verify that there is no failing hardware issues. 3. Move SB closer to router using wireless and run net test to see if any improvement. If no real improvement then there may be some compatibility issues or interference issues affect wireless. 4. Borrow a wireless router to see if it improves situation. 5. If wireless is unreliable in your location - you could use Homeplug (Devolo or similar) to either wire SB to router or move WAG54G router to a better locations. The process has been a bit tedious but at least you are very close to identifying the problem and hence fixing it so that you'll be able to listen to the Beeb in peace. -- bpa bpa's Profile: http://forums.slimdevices.com/member.php?userid=1806 View this thread: http://forums.slimdevices.com/showthread.php?t=28257 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Alien BBC 'Problem Can't open file for:
Hi folks - wonder if you can help - thought I would catch-up on that Etta James Radio 2 feature that I missed last week, and installed Alien BBC - carefully installed via Windows installer and tried all hints regarding firewall setting and patched version of socketwrapper.exe - but all I get is the error message 'Problem Can't open file for: and then the name of the station I am trying to play. Never used this plugin before, presume you just go to Internet Radio/Alien BBC and then press play on say Radio 1? Couldn't find it anywhere else - incidentally same error message on using softsqueeze and the test mplayer.bat works just fine...must be doing something wrong? . -- Timbo Timbo's Profile: http://forums.slimdevices.com/member.php?userid=933 View this thread: http://forums.slimdevices.com/showthread.php?t=28595 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Alien BBC 'Problem Can't open file for:
PS. notice that I get a new process of socketwrapper.exe every time I try to play a station - might be a clue :-) -- Timbo Timbo's Profile: http://forums.slimdevices.com/member.php?userid=933 View this thread: http://forums.slimdevices.com/showthread.php?t=28595 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: AlienBBC - works but starts to stutter
I was afraid it would come up with a good figure but it confirms the signal strength. I'm not sure how the SB's net test works and how it handles retransmits but I don't think the result contradicts the retransmit statistics finding as I can get 5000kb @ 100% on my SB with signal strength 81%. I think retransmissions may have reduced your throughput so your aim is to increase your 3000 figure. -- bpa bpa's Profile: http://forums.slimdevices.com/member.php?userid=1806 View this thread: http://forums.slimdevices.com/showthread.php?t=28257 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: AlienBBC - works but starts to stutter
Assuming wireless, 3000kpbs at 100% seems reasonable to me. Key issue is whether it drops below this occasionally? -- Triode Triode's Profile: http://forums.slimdevices.com/member.php?userid=17 View this thread: http://forums.slimdevices.com/showthread.php?t=28257 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] MuiscIP + SlimServer != 'Browse folders'
I just recently installed MusicIP and use it together with SlimServer. One very nifty browsing feature that exists in SlimServer is the ability to browse folders (i.e. browse where the music files exists in pure physical form, e.g. directories/folders). Howevere, it seems that this option isn't present when using MusicIP? It would be most unfortunate to 'loose' this browsing option :) Please let me know if I'm wrong. -- arcticblue arcticblue's Profile: http://forums.slimdevices.com/member.php?userid=7711 View this thread: http://forums.slimdevices.com/showthread.php?t=28598 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] MuiscIP + SlimServer != 'Browse folders'
On 11-Oct-06, at 10:32 PM, arcticblue wrote: It would be most unfortunate to 'loose' this browsing option :) they are not exclusive. Enter a folder in the server settings and you will be able to browse that music folder. if you do not have a directory in that setting, then you cannot browse the music folder. Having musicIP set to use or not use is completely separate. -kdf ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL
wiped;145234 Wrote: Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='This is caused by a change between slimserver 6.5.0 and slimserver 6.5.1. I'll have to change the same thing in TrackStat, I have it working in my own setup, but I will need to test it a bit more before releasing since it involves changing settings in the database tables. A new version of TrackStat and DynamicPlayList should be available within the next 24 hours if nothing goes wrong. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat) , 'SQLPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist) , 'DynamicPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist), 'Custom Browse' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse) and 'RandomPlayList' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist) plugins) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=20533 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
