[SlimDevices: Plugins] Re: Announce: Plugins for rating and "smart" playlists using SQL
A new version (1.16) of the SQLPlayList plugin is now available, the new functionallity and changes are: - Added support to start SQL with ( making it possible to use unions in the SQL - Added compatibility check when downloading playlists NOTE This version has only been tested towards slimserver 6.5, it will probably not work towards 6.2 and 6.3 but this has not been tested. The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming SQLPlayList releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-sqlplaylist If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan),'Custom Skip' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customskip) 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
inhico;167928 Wrote: > I wonder if it would be possible to use a 10-star rating system. It > would allow me more differentiation and flexibility. Perhaps 10 stars > is a little overdone, but 5 seems a to me little too rough. I feel it > urges me to think more careful about how much stars to give a song.There is > an option in the TrackStat settings section in the web interface server settings that switch between 10 and 5 star ratings, 5 is the default setting. So you just have to change this option and restart slimserver to get 10-star ratings instead. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan),'Custom Skip' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customskip) 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
Hi Erland, Thanks for your great plug-in! I wonder if it would be possible to use a 10-star rating system. It would allow me more differentiation and flexibility. Perhaps 10 stars is a little overdone, but 5 seems a to me little too rough. I feel it urges me to think more careful about how much stars to give a song. Thanks again, Peter -- inhico inhico's Profile: http://forums.slimdevices.com/member.php?userid=5197 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
A new version (1.35) of the TrackStat plugin is now available, there new functionality and changes are: - Added support for skip filters for use with the new Custom Skip plugin. NOTE This version requires slimserver 6.5.x (It won't even start with 6.3 and 6.2) The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming TrackStat releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-trackstat If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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
Okay. Reinstalled all of the latest 12/25 plugins, changed the number of results up to 100, deleted and rebuilt my old .sql files ... still no joy. Attached is a sample log report: +---+ |Filename: errors.txt | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=2205| +---+ -- 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
erland;166075 Wrote: > > > Are you using the mysql bundled with slimserver ? > > Which operating system are you running slimserver/mysql on ? > > If you are running Windows, have you tried restarting the slimserver > computer ? > (Sometimes solves strange problems on Windows) > > Have you changed anything else in your setup besides upgrading the > plugins that could affect the behaviour in mysql ? > > Could you turn on debug logging in SQLPlayList and see if you see some > errors in the slimserver log ? I'm using the standard mysql bundled with SS. I'm running windows and have already tried restarting the computer to no effect. I can't think of any other changes other than: Upgrading to the latest nightly and upgrading to the 12/25 builds of the plugins. I'll turn on debugging + try increasing the number of results and report. Thanks Erland! -- 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
Also, could you try to raise the limit in the SQL statement from 10 to something higher just to make sure it doesn't randomly select unrated tracks because you have more of them. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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
Yannzola;166066 Wrote: > What I noticed from testing the code you provided was this: All of them > worked as expected =except= for the ones using the line"or > track_statistics.rating is null" which =only= returned unrated tracks. > The result I was expecting was a mix of 3+ star rated tracks and > unrated tracks. > Note: I am using the latest nightly of 6.5.1This is really strange, it works > perfectly at my end. I have tried it both on Windows and Linux (not with the latest 6.5.1 though, my installation is a few weeks old) Are you using the mysql bundled with slimserver ? Which operating system are you running slimserver/mysql on ? If you are running Windows, have you tried restarting the slimserver computer ? (Sometimes solves strange problems on Windows) Have you changed anything else in your setup besides upgrading the plugins that could affect the behaviour in mysql ? Could you turn on debug logging in SQLPlayList and see if you see some errors in the slimserver 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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
What I noticed from testing the code you provided was this: All of them worked as expected =except= for the ones using the line"or track_statistics.rating is null" which =only= returned unrated tracks. The result I was expecting was a mix of 3+ star rated tracks and unrated tracks. Note: I am using the latest nightly of 6.5.1 -- 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;166054 Wrote:
> Nope. No joy. Any other suggestions or data I can provide?
1.
Just to make sure, you have restarted slimserver after you upgraded to
the new plugin versions ?
2.
Have you checked if there are any errors in the slimserver log:
http://localhost:9000/log.txt
3.
Could you try to create a number of new playlists like:
Playlist 1: Simple playlist, check that it only return tracks with
rating>=3. If this playlist doesn't return anything, you don't have to
check the next playlists because then it means that your ratings
doesn't seem to exist. We then need to start investigate why.
Code:
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
where
audio=1
and track_statistics.rating>=50
group by tracks.id
order by rand()
limit 10;
Playlist 2: Doesn't exclude already played tracks, check if it returns
both unrated tracks and track rated>=3
Code:
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
where
audio=1
and tracks.secs>60
and track_statistics.rating>=50
or track_statistics.rating is null
and not exists (select * from tracks t2,genre_track,genres
where
t2.id=tracks.id and
tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in ('Christmas','Musical','Spoken Word'))
group by tracks.id
order by rand()
limit 10;
Playlist 3: Doesn't return unrated tracks, check that it only return
tracks rated>=3
Code:
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
audio=1
and dynamicplaylist_history.id is null
and tracks.secs>60
and track_statistics.rating>=50
and not exists (select * from tracks t2,genre_track,genres
where
t2.id=tracks.id and
tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in ('Christmas','Musical','Spoken Word'))
group by tracks.id
order by rand()
limit 10;
Playlist 4: Doesn't exclude the genres, check if it returns both
unrated tracks and tracks rated>=3
Code:
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
audio=1
and dynamicplaylist_history.id is null
and tracks.secs>60
and track_statistics.rating>=50
or track_statistics.rating is null
group by tracks.id
order by rand()
limit 10;
Playlist 5: Doesn't exclude short tracks, check if it returns tracks
with both unrated tracks and tracks rated>=3
Code:
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
audio=1
and dynamicplaylist_history.id is null
and track_statistics.rating>=50
or track_statistics.rating is null
and not exists (select * from tracks t2,genre_track,genres
where
t2.id=tracks.id and
tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in ('Christmas','Musical','Spoken Word'))
group by tracks.id
order by rand()
limit 10;
--
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),'Custom
Scan'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan)
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;166041 Wrote: > Maybe you already have played most of the tracks rated above 3 that > matches these criterias, then you just have to stop and start to play > the playlist again to start over again. I doubt this very much... unless dynamicplaylist_history.id data is cumulative across sessions. I have approx 12,000 songs (4000 of which are rated) in my collection. Most playlists only end up being 40-80 tracks long on average. erland;166041 Wrote: > > You might also try to put "track_statistics.rating>=50or > track_statistics.rating is null" in between parenteses like > "(track_statistics.rating>=50 or track_statistics.rating is null)". > This isn't required in my own setup, but it might work different in > your setup for some reason. Nope. No joy. Any other suggestions or data I can provide? Thanks! 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;166038 Wrote:
> Like So:
>
> select tracks.url from tracks
> join track_statistics on
> tracks.url=track_statistics.url
> left join dynamicplaylist_history on
> tracks.id=dynamicplaylist_history.id
> where
> audio=1
> and dynamicplaylist_history.id is null
> and tracks.secs>60
> and track_statistics.rating>=50
> or track_statistics.rating is null
> and not exists (select * from tracks t2,genre_track,genres
> where
> t2.id=tracks.id and
>
> tracks.id=genre_track.track and
>
> genre_track.genre=genres.id and
> genres.name in
> ('Christmas','Musical','Spoken Word'))
> group by tracks.id
> order by rand()
> limit 10;
It still works in my setup, are you sure you have rated tracks that
matches the search critera ?
To match the critera they have to fullfill the following:
- They haven't already been played in this playlist since you started
to play it the last time.
- They don't belong to genres Christmas, Musical or Spoken Word
- The track length it as least 60 seconds
- They are unrated or have a rating of 3 or above
Maybe you already have played most of the tracks rated above 3 that
matches these criterias, then you just have to stop and start to play
the playlist again to start over again.
You might also try to put "track_statistics.rating>=50or
track_statistics.rating is null" in between parenteses like
"(track_statistics.rating>=50 or track_statistics.rating is null)".
This isn't required in my own setup, but it might work different in
your setup for some reason.
--
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),'Custom
Scan'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan)
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
Yannzola;166012 Wrote: > Erland, as of the latest version of SQLPlaylist, my old dynamic > playlists no longer work as expected. In particular the problem seems > to be at the following lines: > > where > and track_statistics.rating>=50 > or track_statistics.rating is null > > Previously, This would return only tracks listed with a rating of 3 > stars or more =and= unrated tracks. Now it only returns unrated tracks. > Bug or feature? > It works in my setup, how does the complete SQL look like ? -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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;166036 Wrote:
> It works in my setup, how does the complete SQL look like ?
Like So:
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
audio=1
and dynamicplaylist_history.id is null
and tracks.secs>60
and track_statistics.rating>=50
or track_statistics.rating is null
and not exists (select * from tracks t2,genre_track,genres
where
t2.id=tracks.id and
tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in
('Christmas','Musical','Spoken Word'))
group by tracks.id
order by rand()
limit 10;
--
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
Erland, as of the latest version of SQLPlaylist, my old dynamic playlists no longer work as expected. In particular the problem seems to be at the following lines: where and track_statistics.rating>=50 or track_statistics.rating is null Previously, This would return only tracks listed with a rating of 3 stars or more and unrated tracks. Now it only returns unrated tracks. Bug or feature? Thanks! 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
Erland, I wanted to thank you for your efforts in creating these excellent plugins. I hadn't even noticed that TrackStat now includes the feature I requested (1-10 rating scale) and has for some time! The feature set is massive compared to the last time I used TrackStat, and it's all very impressive. I really like how I can apply ratings right from the web interface. The automatic backups are a great feature, too. Keep up the great work! -- Pale Blue Ego Pale Blue Ego's Profile: http://forums.slimdevices.com/member.php?userid=110 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
A new version (1.15) of the SQLPlayList plugin is now available, the new functionallity and changes are: - Added support for downloading playlists from other users - Added support for publishing playlists for other users to use NOTE This version has only been tested towards slimserver 6.5, it will probably not work towards 6.2 and 6.3 but this has not been tested. The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming SQLPlayList releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-sqlplaylist If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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
A new version (1.33) of the TrackStat plugin is now available, the new functionallity and changes are: - Added support for putting statistics in a Favorites folder to make it easier to access mostly used statistics. NOTE This version requires slimserver 6.5.x (It won't even start with 6.3 and 6.2) The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming TrackStat releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-trackstat If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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
A new version (1.13) of the SQLPlayList plugin is now available, the new functionallity and changes are: - Added possibility to implement playlist templates in separate plugins (Used by TrackStat 1.32) - Added new playlist options --- ContentType: Makes it possible to create playlists that instead of tracks returns albums, artists, genres, playlists or years --- NoOfTracks: When ContentType is used, this makes it possible to limit number of tracks per album/artist/genre/playlist/year --- DontRepeatTracks: When ContentType is used, this makes it possible to make sure already played tracks in playlist isn't played again NOTE 1 This version has only been tested towards slimserver 6.5, it will probably not work towards 6.2 and 6.3 but this has not been tested. NOTE 2 The new template based approach in this version for creating new playlists makes quite easy for me to create new builtin playlist types. It is also possible to have playlist type specific user interfaces for each type of playlist with just the parameters interested for that playlist. The included playlist types is basically the same as before with some additions. If you have suggestions on new playlist types either with more options or with less options than the existing I'm very interested to get information about this so templates for the most used playlist types can be included by default. The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming SQLPlayList releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-sqlplaylist If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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
A new version (1.32) of the TrackStat plugin is now available, the new functionallity and changes are: - Corrected so rating works with several synchronized players - Removed composers and conductors from artist statistics - Updated so TrackStat web interface doesnt lose context when page is refreshed - Changed so "All songs" statistics is order by disc and then track number - Corrected error regarding unrated tracks which sometimes caused album/artist statistics to be decreased to much - Updated so the currently selected song is rated in "Now Playing" SqueezeBox menu instead of currently playing song - Added support for removing ratings for a album/track in web interface - Corrected some overlapping track titles in default skin in web interface - Corrected errors in iTunes import when iTunes path contains () - Added support for about 10 TrackStat playlists for SQLPlayList 1.13 NOTE This version requires slimserver 6.5.x (It won't even start with 6.3 and 6.2) The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming TrackStat releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-trackstat If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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
A new version (1.31) of the TrackStat plugin is now available, the new functionallity and changes are: - Added support for Custom Browse to connect a menu directly to a top level statistic group NOTE This version requires slimserver 6.5.x (It won't even start with 6.3 and 6.2) The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming TrackStat releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-trackstat If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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
gsalton;155415 Wrote: > First part looks okay. Obviously it is just dropping the > file://localhost/ and retaining the Share (E) part; don't know why. I > double-checked the path name in iTunes import. > It should drop the localhost part so thats ok. I have a small suspicion that it might be the () thats causing the problem, I will check and verify this in my own setup. gsalton;155417 Wrote: > The manual import seemed to work.Great gsalton;155417 Wrote: > Unrelated, or probably not related, it now does not want to play AAC > songs with entirely Cyrillic album/artist/song info; MP3s are okay, as > are ones that have Cyrillic artists, but song titles definitely are a > problem. It adds them to a playlist, but the player pauses on them, > chokes and goes on to the next one. It seems more likely to me it's an > issue with LAME (which I have to use due to a limited wireless > connection for AAC files), but I don't have an idea how to track this.Sorry, > I have no idea. You might want to look at registrered bugs at http://bugs.slimdevices.com or post in the General forum to see if anyone else have seen the same problem. If they are added to the playlist it shouldn't be a problem with TrackStat. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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
The manual import seemed to work. This is fabulous! Thanks again for your help. Hopefully I'll eventually get it set up to do back-and-forth, but for the moment this is nice. Unrelated, or probably not related, it now does not want to play AAC songs with entirely Cyrillic album/artist/song info; MP3s are okay, as are ones that have Cyrillic artists, but song titles definitely are a problem. It adds them to a playlist, but the player pauses on them, chokes and goes on to the next one. It seems more likely to me it's an issue with LAME (which I have to use due to a limited wireless connection for AAC files), but I don't have an idea how to track this. Anyway, not likely an issue with TrackStat, but if you have any ideas. And once again, your help and responsive is much appreciated. Greg -- gsalton gsalton's Profile: http://forums.slimdevices.com/member.php?userid=7598 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;155397 Wrote: > There should be a message in the debug log in the beginning of the > import that starts with: > > (time) found the music folder: computer> > > Could you look at which folder it shows in this message. This is the > problem if it shows something else than: > (time) found the music folder: > file://localhost/Volumes/SHARE%20(E)/Music/Greg%20iTunes > > TrackStat will read this path from the "Music Folder" element at the > top of the iTunes xml file and replaces this path with the one you have > entered in the "MUSIC DIRECTORY (ITUNES IMPORT)" parameter. As you have > noted this replacement doesn't seem to happen in your case for some > reason. > > Thanks. Ran this with the following result: 09:55:19.2655 TrackStat::iTunes: found the music folder: file://localhost/Volumes/SHARE%20(E)/Music/Greg%20iTunes 2006-11-17 09:55:19.2657 TrackStat::iTunes: starting track parsing 2006-11-17 09:55:19.2858 TrackStat::iTunes: normalized file://localhost/Volumes/SHARE%20(E)/Music/Greg%20iTunes/Ella%20Fitzgerald%20%26%20Louis%20Armstrong/Ella%20%26%20Louis/01%20Can't%20We%20Be%20Friends.mp3 to file:///Volumes/SHARE%20(E)/Music/Greg%20iTunes/Ella%20Fitzgerald%20%26%20Louis%20Armstrong/Ella%20%26%20Louis/01%20Can't%20We%20Be%20Friends.mp3 2006-11-17 09:55:19.2871 TrackStat::iTunes: file not found: \Volumes\SHARE (E)\Music\Greg iTunes\Ella Fitzgerald & Louis Armstrong\Ella & Louis\01 Can't We Be Friends.mp3 2006-11-17 First part looks okay. Obviously it is just dropping the file://localhost/ and retaining the Share (E) part; don't know why. I double-checked the path name in iTunes import. I will try the search and replace as suggested. Greg -- gsalton gsalton's Profile: http://forums.slimdevices.com/member.php?userid=7598 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
gsalton;155343 Wrote: > It does not seem to be "normalizing" to the local drive, although the > path to iTunes music appears to be correct (this is where the music is, > and Slimserver has access to it. There should be a message in the debug log in the beginning of the import that starts with: (time) found the music folder: Could you look at which folder it shows in this message. This is the problem if it shows something else than: (time) found the music folder: file://localhost/Volumes/SHARE%20(E)/Music/Greg%20iTunes TrackStat will read this path from the "Music Folder" element at the top of the iTunes xml file and replaces this path with the one you have entered in the "MUSIC DIRECTORY (ITUNES IMPORT)" parameter. As you have noted this replacement doesn't seem to happen in your case for some reason. If this is a one-time import and you can't get it to work you can always do a manual replacement in a copy of the iTunes xml file with the text editor of your choice and point TrackStat to the changed copy. You should then replace the path in all files in the xml file from: file://localhost/Volumes/SHARE%20(E)/Music/Greg%20iTunes To: file://localhost/E:/Music/Greg%20iTunes Also if you perform the import manually like this you should clear the "MUSIC DIRECTORY (ITUNES IMPORT)" settings before performing the import. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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 think I now have the file correct for iTunes Music Library.xml (sorry, I misread the path instruction there); when I run this it runs for quite a while, seemingly looking for music, then quits. Errors for virtually every file (that I can see) are of the type: (time) TrackStat::iTunes: file not found:\Volumes\SHARE%20(E)/Music/Greg%20iTunes/artist/album/song.mp3 (time)TrackStat::iTunes: normalized file://localhost/Volumes/SHARE%20(E)/Music/Greg%20iTunes/artist/album/song.mp3 to file://Volumes/Share%20(E)/Music/Greg%20iTunes/artist/album/song.mp3 Then it quits saying: (time) Perl interpreter failed at /PerlApp/Slim/Utils/Misc.pm line 531, chunk 4550 It does not seem to be "normalizing" to the local drive, although the path to iTunes music appears to be correct (this is where the music is, and Slimserver has access to it. Any ideas greatly appreciated. -- gsalton gsalton's Profile: http://forums.slimdevices.com/member.php?userid=7598 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
gsalton;155187 Wrote: > So, in the box for location of iTunes library file, I have: E:\Music > (and the file is there named Itunes Music Library.xml, a recent copy). This is probably your problem, it should point to the actual file, so you should set it to: E:\Music\iTunes Music Library.xml gsalton;155187 Wrote: > > Music directory (iTunes export) is as below, copied directly from the > iTunes xml file. > file://localhost/Volumes/SHARE%20(E)/Music/Greg%20iTunes/ > This looks different than in my own setup and I suspect it might be incorrect but I am not sure, anyway, it isn't used in step 1 so this shouldn't be your problem when performing the import. I have in the iTunes xml file: file://localhost/D:/Egna/My%20Music/iTunes/iTunes%20Music/ And the iTunes export setting is set to: D:\Egna\My Music\iTunes\iTunes Music gsalton;155187 Wrote: > Path to iTunes music (import) is: > E:\Music\Greg iTunes > This should point to the directory on the slimserver machine where you can access your music. So if it is accessible in E:\Music\Greg iTunes from the slimserver machine this should be correct gsalton;155187 Wrote: > When I do the Import from iTunes however, nothing seems to happen. Is > there a log file somewhere? I haven't had any luck looking for this.I suspect > your problem is the iTunes Library Path mentioned above, but if it isn't you can turn on the debugging flag in the TrackStat settings and then startup Slim.exe from a command prompt and perform an import and see if you get any errors in the command prompt window. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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;154717 Wrote: > There is some information in the included README.txt, if you have any > specific questions just ask. What I do is this: > 1. I did a one time import of all iTunes rating using the TrackStat > plugin once a long time ago. This made all my iTunes ratings available > in my Linux based slimserver through TrackStat. > 2. SlimServer continously logs all changed ratings and plays(play > counts) in a text file through the TrackStat plugin. > 3. Occasionally I run the TrackStatiTunesUpdateWin.pl script with the > log file from step 2 as inparameter on the iTunes client computer. This > will transfer all changed play counts and ratings to iTunes. > > Step 2 and 3 can also be done through the iTunes Update plugin in case > you can access the music file at the same path both on iTunes client > and slimserver server. This should be possible using a UNC path like > \\computer1\myshare\mymusic if you are running a Windows server. If you > are running a Linux server you will have to use TrackStat and set the > "MUSIC DIRECTORY (ITUNES EXPORT)" setting in TrackStat to the directory > on the iTunes client computer where the music is. > > Step 1 can be done using standard slimserver iTunes plugin if you are > running the slimserver server on a Windows computer and use UNC paths, > if you are running slimserver on Linux you need to use TrackStat and > set the "MUSIC DIRECTORY (ITUNES IMPORT)" setting in TrackStat to the > directory on the slimserver server where the music is. > > If you perform rating on both slimserver and iTunes the playcounts and > ratings will not be merged completely correct. If I remember correctly > it uses highest play count and last changed rating if iTunes/slimserver > data doesn't match each other for a specific track. Thanks for the offer of assistance. I realised my library needed a little cleaning before I attempted to do anything too complex. I primarily want to accomplish step 1; I can try to figure out steps 2&3 later. I haven't yet set up UNC paths (not tremendously familiar with Windows, even though that's what the server is). So, in the box for location of iTunes library file, I have: E:\Music (and the file is there named Itunes Music Library.xml, a recent copy). iTunes history file location is the same, although not needed yet. Music directory (iTunes export) is as below, copied directly from the iTunes xml file. file://localhost/Volumes/SHARE%20(E)/Music/Greg%20iTunes/ Path to iTunes music (import) is: E:\Music\Greg iTunes When I do the Import from iTunes however, nothing seems to happen. Is there a log file somewhere? I haven't had any luck looking for this. Thanks again. -- gsalton gsalton's Profile: http://forums.slimdevices.com/member.php?userid=7598 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
gsalton;154641 Wrote: > This seems to be exactly what I need - running itunes on one computer, > squeezebox on a server (where the itunes music files are held). The > holy grail would be having the play count / ratings tracked in > slimserver for occasional sync with itunes. Which it seems this does. > > Are there more detailed instructions anywhere? > There is some information in the included README.txt, if you have any specific questions just ask. What I do is this: 1. I did a one time import of all iTunes rating using the TrackStat plugin once a long time ago. This made all my iTunes ratings available in my Linux based slimserver through TrackStat. 2. SlimServer continously logs all changed ratings and plays(play counts) in a text file through the TrackStat plugin. 3. Occasionally I run the TrackStatiTunesUpdateWin.pl script with the log file from step 2 as inparameter on the iTunes client computer. This will transfer all changed play counts and ratings to iTunes. Step 2 and 3 can also be done through the iTunes Update plugin in case you can access the music file at the same path both on iTunes client and slimserver server. This should be possible using a UNC path like \\computer1\myshare\mymusic if you are running a Windows server. If you are running a Linux server you will have to use TrackStat and set the "MUSIC DIRECTORY (ITUNES EXPORT)" setting in TrackStat to the directory on the iTunes client computer where the music is. Step 1 can be done using standard slimserver iTunes plugin if you are running the slimserver server on a Windows computer and use UNC paths, if you are running slimserver on Linux you need to use TrackStat and set the "MUSIC DIRECTORY (ITUNES IMPORT)" setting in TrackStat to the directory on the slimserver server where the music is. If you perform rating on both slimserver and iTunes the playcounts and ratings will not be merged completely correct. If I remember correctly it uses highest play count and last changed rating if iTunes/slimserver data doesn't match each other for a specific track. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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
This seems to be exactly what I need - running itunes on one computer, squeezebox on a server (where the itunes music files are held). The holy grail would be having the play count / ratings tracked in slimserver for occasional sync with itunes. Which it seems this does. Are there more detailed instructions anywhere? Greg -- gsalton gsalton's Profile: http://forums.slimdevices.com/member.php?userid=7598 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
A new version (1.12) of the SQLPlayList plugin is now available, the new functionallity and changes are: - Totally redesign of playlist creating web interface: --- Playlist settings can be changed after the playlist has been created without editing the SQL manually. --- The user no longer need to see the SQL if he only uses predefined playlist types. - Some random playlists included by default - Support for playlist option "Unlimited" making it possible to make playlists that returns more tracks than specifed by DynamicPlayList settings, for example returning all tracks on an album. - Support for builtin playlist parameters PlaylistLimit and PlaylistOffset - Added support for creating playlists based on custom tags scanned with Custom Scan plugin. NOTE 1 This version has only been tested towards slimserver 6.5, it will probably not work towards 6.2 and 6.3 but this has not been tested. NOTE 2 The new template based approach in this version for creating new playlists makes quite easy for me to create new builtin playlist types. It is also possible to have playlist type specific user interfaces for each type of playlist with just the parameters interested for that playlist. The included playlist types is basically the same as before with some additions. If you have suggestions on new playlist types either with more options or with less options than the existing I'm very interested to get information about this so templates for the most used playlist types can be included by default. The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming SQLPlayList releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-sqlplaylist If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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),'Custom Scan' (http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan) 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;152020 Wrote: > I think the problem is that mysql re-executes the inner SQL for every > row in the main SQL, so this results in that you need to get very lucky > to get any hit at all. That makes perfect sense - thanks for your help (and a great plugin!). -- dSw dSw's Profile: http://forums.slimdevices.com/member.php?userid=362 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
dSw;151675 Wrote:
> Can anyone see anything obviously wrong with this query or suggest an
> alternative way of doing it?I think the problem is that mysql re-executes the
> inner SQL for every
row in the main SQL, so this results in that you need to get very lucky
to get any hit at all.
Something like this seems to work for me:
>
> select tracks.url
> from tracks, (select distinct albums.id
> from tracks, albums, genre_track, genres
> where genres.name = 'Mix'
> and genre_track.genre=genres.id
> and tracks.id = genre_track.track
> and tracks.album = albums.id
> and albums.titlesort not in ('NO TITLE','N/A','UNKNOWN
> ALBUM','NO
> ALBUM')
> order by rand() limit 1) as albums
> where tracks.album = albums.id
> order by tracks.disc, tracks.tracknum;
>
--
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),'Custom
Scan'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-customscan)
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'm having problems with SS 6.5 using the a SQL Playlist that I used
successfully with 6.3.x.
The following query used to return all tracks from a single album that
had tracks tagged with the 'Mix' genre. It now usually doesn't return
anything, but occasionally returns just one track. I've played about
with the query using SQLyog (which is pretty useful) but can't see what
the problem is. The nested query works fine (it returns 95 rows when not
limited by 'limit 1') and the main query works fine given an album ID,
so where's the problem?
Code:
select tracks.url
from tracks, albums
where tracks.album = albums.id
and albums.id =
(select distinct albums.id
from tracks, albums, genre_track, genres
where genres.name = 'Mix'
and genre_track.genre=genres.id
and tracks.id = genre_track.track
and tracks.album = albums.id
and albums.titlesort not in ('NO TITLE','N/A','UNKNOWN ALBUM','NO ALBUM')
order by rand() limit 1)
order by tracks.disc, tracks.tracknum
Can anyone see anything obviously wrong with this query or suggest an
alternative way of doing it?
--
dSw
dSw's Profile: http://forums.slimdevices.com/member.php?userid=362
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
So far so good. Thanks for this! -- 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
A new version (1.30.2) of the TrackStat plugin is now available, there is no new functionallity just an error correction: - Corrected problem where automatic rating caused a crash on files with an url longer than 255 characters. NOTE This version requires slimserver 6.5.x (It won't even start with 6.3 and 6.2) The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming TrackStat releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-trackstat If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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;150116 Wrote: > This exact problem is caused by TrackStat. It's caused by an url which > is longer than 255 characters and some bad error handling inside > TrackStat, I will try to post an updated version in the next hours > unless something goes wrong. Thanks Erland! -- 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
kdf;150113 Wrote: > If you truly don't believe trackstat is the cause of the crashes (I have > lost track of all the crossposting) then please delete the plugin > completely from your system and report any crashes that you find in the > log.This exact problem is caused by TrackStat. It's caused by an url which is longer than 255 characters and some bad error handling inside TrackStat, I will try to post an updated version in the next hours unless something 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
[SlimDevices: Plugins] Re: Announce: Plugins for rating and "smart" playlists using SQL
i tried to post twice now, but it's been bouncing. I guess the mail gateway is hosed. there is a debug pref in the server settings->plugins, trackstat section. This will help track down the problem you have with the trackstat crash (hopefully). If you truly don't believe trackstat is the cause of the crashes (I have lost track of all the crossposting) then please delete the plugin completely from your system and report any crashes that you find in the log. (the --noupnp option is another thing to try if you find anything crashing related to upnp servers/clients on your network) good luck. -kdf -- kdf kdf's Profile: http://forums.slimdevices.com/member.php?userid=7 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;150098 Wrote: > > KDF, can you remind me how to output a log.txt file that survives a > crash? > > Thanks! > y. Nevermind found it. For other Windows users who are curious: Stop the slim and slimtray processes via task manager, and enter the following via run or the command line: "C:\\SlimServer\server\slim.exe" --logfile c:\slimlog.txt . Go directly to http://localhost:9000/ in your browser and select your favorite debug opions. -- 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
Thanks KDF. BTW: I'm running the latest version of Trackstat 1.30.1 An interesting point is that the crash is happening repeatedly with one track in particular. KDF, can you remind me how to output a log.txt file that survives a crash? Thanks! 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
Re: [SlimDevices: Plugins] Re: Announce: Plugins for rating and "smart" playlists using SQL
On 26-Oct-06, at 5:14 PM, Yannzola wrote: I've been having Slimserver crash while listening to Random Song with Trackstat set to auto rate. I'm on Windows XP SP2. The crash appears semi-consisitently at the end of a certain unrated track as it loads the next track (about when the auto-rating is assigned?). I'm only guessing that Trackstst is involved, and you'd be right (at least in this case). If you are having crashes without trackstat running, best make sure you can find a note that doesn't clearly show fault in trackstat. There is an updated version that is supposed to be working fine with 6.5.0 (I think it's up to 1.30.1 now) -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
I've been having Slimserver crash while listening to Random Song with Trackstat set to auto rate. I'm on Windows XP SP2. The crash appears semi-consisitently at the end of a certain unrated track as it loads the next track (about when the auto-rating is assigned?). I'm only guessing that Trackstst is involved, as others have been running into similiar intermittent crash issues lately without running Trackstat at all. SlimServer Version: 6.5.1 - 10464 - Windows XP - EN - cp1252 Here is an excerpt from my Event viwer log: This occurs immediately before the crash: Event Type: Error Event Source: Application Event Category: None Event ID: 0 Date: 10/26/2006 Time: 4:58:34 PM User: N/A Computer: MEDIACENTER Description: The description for Event ID ( 0 ) in Source ( Application ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Can't call method "rating" on an undefined value at C:\Program Files\SlimServer\server/Plugins/TrackStat/Plugin.pm line 3047. . -- 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
A new version (1.30.1) of the TrackStat plugin is now available, there is no new functionallity just an error correction: - Corrected problem in "delete unused statistics" function. NOTE This version requires slimserver 6.5.x (It won't even start with 6.3 and 6.2) The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming TrackStat releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-trackstat If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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
A new version (1.30) of the TrackStat plugin is now available, the new functionallity and changes are: - Added support for automatic increase/decrease of rating dependent on if track is skiped early or completely played Ratings internally is stored as a value 0-100, if a track is skipped during the first half the internal rating is decreased with 1 if it is played at least 80 percent the internal ratings is instead increased with 1. By default the automatic rating logic is turned off, so you will need to turn on the "AUTOMATIC RATING" option in the settings page to enable it. - Corrected so it works with 7.0 NOTE This version requires slimserver 6.5.x (It won't even start with 6.3 and 6.2) The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming TrackStat releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-trackstat If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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
Thanks!! Everything is working fine now. -- wiped Squeezebox 3 - SS 6.5.1 - CD T2500 - 2Gb ram - 1945 albums with 26686 songs by 4470 artists (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: Plugins for rating and "smart" playlists using SQL
A new version (1.29.1) of the TrackStat plugin is now available, there is no new functionallity just an error correction: - Corrected so it works with 6.5.1 (llegal mix of collations problem, no correction was needed in DynamicPlayList) - Please note that this version will do a conversion of TrackStat database tables if you are running slimserver 6.5.1 so it might take a bit longer to startup slimserver the first time. A backup of TrackStat data before the upgrade is also a good idea. NOTE This version has only been tested towards slimserver 6.5.x (It still might work with 6.3 and 6.2 but this has not been tested) The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming TrackStat releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-trackstat If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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: > 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
[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: 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-
[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
wiped;145433 Wrote: > Ok i'll try that, where is the log located? > i enabled debugging but i don't find any log.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 -- 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;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: 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
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
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
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
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
Re: [SlimDevices: Plugins] Re: Announce: Plugins for rating and "smart" playlists using SQL
On 09/10/06, erland <[EMAIL PROTECTED]> wrote: A new version (1.29) of the TrackStat plugin is now available NOTE 1 This version does not seem to work correctly with Moose 0.44 due to the CLI interface changes. So if you are using the rating functionallity in Moose you may want to wait for a new Moose version before installing this version of TrackStat. Moose 0.45's now up with some extra stuff for supporting the percentage based ratings.. Enjoy.. -- - Dr Lovegrove Free Moose for all at: http://www.rusticrhino.com/drlovegrove ___ 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
A new version (1.11) of the SQLPlayList plugin is now available, the new functionallity and changes are: - Added support for creating playlists that based on COMMENT tags - Corrected some other small problems NOTE! This version has only been tested towards slimserver 6.5, it might also work towards 6.2 and 6.3 but this has not been tested. The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming SQLPlayList releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-sqlplaylist If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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
A new version (1.29) of the TrackStat plugin is now available, the new functionallity and changes are: - Corrected a lot of 6.5 compatibility problems in dynamic playlists. - Corrected some statistics which didn't show correct result. - Corrected so it does not crash when mixerlinks on year is added to slimserver 6.5 or 7.0 - Added some caching to improve performance when used with MusicInfoSCR 2.99 and later with whitelisted tags - Removed support for the optional simple queries since they didn't seem to work any faster - Imporoved performance when changing tracks in dynamic playlists. - Added new parameters to CLI interface to support percentage ratings. - Added support to not repeat already played tracks in dynamic playlists. - Added "All xxx" statistics and changed the TS button to use this instead of most played to avoid resorting when rating. - Added support for 10 scale ratings (disabled by default) (Some text layout errors may exist in the 10 scale rating mode) NOTE 1 This version does not seem to work correctly with Moose 0.44 due to the CLI interface changes. So if you are using the rating functionallity in Moose you may want to wait for a new Moose version before installing this version of TrackStat. NOTE 2 This version has only been tested towards slimserver 6.5 (It still might work with 6.3 and 6.2 but this has not been tested) The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming TrackStat releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-trackstat If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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;143506 Wrote: > Great this shows the problem exactly, the problem seems to be that if > the MusicMagic call takes longer than 5 seconds it will fail. > > This timeout can be changed by go into the Network settings page in the > slimserver web interface and then change "Radio Station Timeout" value. > I would appreciate if you could try to raise it and report back how > high you need it to be to make it work. That's it! It worked after I set the radio station timeout to 10 seconds. TrackStat:MusicMagic: Import completed in 303 seconds. Thank you thank you thank you! :-) 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;143479 Wrote: > Turning the MusicMagic plugin on and off did not seem to have any > effect. > > Here are a few more snippets from my log (attached) > Great this shows the problem exactly, the problem seems to be that if the MusicMagic call takes longer than 5 seconds it will fail. This timeout can be changed by go into the Network settings page in the slimserver web interface and then change "Radio Station Timeout" value. I would appreciate if you could try to raise it and report back how high you need it to be to make it work. If this solves the problem, I will try to make this configurable in the TrackStat settings instead in the next TrackStat release. This way it's only TrackStat that uses a longer timeout while the rest of slimserver can use the shorter timeout. -- 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;143342 Wrote: > I just installed MusicIP 1.7 and it works perfectly with my slimserver > 6.5.0. I had some problem first where the API servies inside MusicIP > seems to hang, but I then restarted MusicIP and now everything seems to > work perfect. > > Do you get any timestamps in your log ? > I'm specifically interested to know the time between the: > TrackStat::MusicMagic: Calling: > http://localhost:10002/api/songs?extended > > and the: > Failure answer from Music Magic songs > > In my setup these lines are directly after each other with no > intermediate messages, but in your log there seem to be other messages > inbetween. This makes me suspect that there might be some timeout > problem or some conflict with the standard MusicMagic plugin. > > I would also appreciate if you could try to temporary disable the > standard MusicMagic plugin and try to import ratings with TrackStat, > just to make sure there is no conflict between the standard MusicMagic > plugin and TrackStat. Turning the MusicMagic plugin on and off did not seem to have any effect. Here are a few more snippets from my log (attached) (Plugins::WeatherTime seems very active... this normal?) In Server Settings/Debugging, I have the following selected: d_cli d_http_async d_info d_musicmagic d_time Hope this helps. +---+ |Filename: log_musicmagic_off.txt | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=1805| +---+ -- 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;143144 Wrote: > I'm not certain if the problem started with 1.7... I haven't had to > re-import ratings since the first time I installed trackstat way back > when. I first noticed the problem when I lost all of my ratings after > installing the final release of 6.5 (grrr...). AFAIK Everything else > works perfectly... ratings update dynamically (from Trackstat to > MIP)and mixes are made in SS without a hitch. Just can't seem to import > ratings info. > I just installed MusicIP 1.7 and it works perfectly with my slimserver 6.5.0. I had some problem first where the API servies inside MusicIP seems to hang, but I then restarted MusicIP and now everything seems to work perfect. Do you get any timestamps in your log ? I'm specifically interested to know the time between the: TrackStat::MusicMagic: Calling: http://localhost:10002/api/songs?extended and the: Failure answer from Music Magic songs In my setup these lines are directly after each other with no intermediate messages, but in your log there seem to be other messages inbetween. This makes me suspect that there might be some timeout problem or some conflict with the standard MusicMagic plugin. I would also appreciate if you could try to temporary disable the standard MusicMagic plugin and try to import ratings with TrackStat, just to make sure there is no conflict between the standard MusicMagic plugin and TrackStat. -- 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;143140 Wrote: > I think I'll have to install MusicIP 1.7 myself to debug the problem. > Was it MusicIP Mixer 1.7 that caused the problem or did you > change/upgrade something else also when the problem started ? > > Do you know if the standard MusicMagic plugin work in your setup > towards MusicIP 1.7 ? I'm not certain if the problem started with 1.7... I haven't had to re-import ratings since the first time I installed trackstat way back when. I first noticed the problem when I lost all of my ratings after installing the final release of 6.5 (grrr...). AFAIK Everything else works perfectly... ratings update dynamically (from Trackstat to MIP)and mixes are made in SS without a hitch. Just can't seem to import ratings info. Should I try debugging with any other variables? Again thanks for this amazing series of plugins you've totally changed the way I use SS for the better! 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;143100 Wrote: > Erland any progress on this? > Is there anything else I can do to help troubleshoot? > I've upgraded to SlimServer Version: 6.5.1 - 10169 - Windows XP - EN - > cp1252 and to MusicIP Mixer 1.7.1 (beta) but the problem remains. Any > help appreciated. > I think I'll have to install MusicIP 1.7 myself to debug the problem. Was it MusicIP Mixer 1.7 that caused the problem or did you change/upgrade something else also when the problem started ? Do you know if the standard MusicMagic plugin work in your setup towards MusicIP 1.7 ? -- 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 any progress on this? Is there anything else I can do to help troubleshoot? I've upgraded to SlimServer Version: 6.5.1 - 10169 - Windows XP - EN - cp1252 and to MusicIP Mixer 1.7.1 (beta) but the problem remains. Any help appreciated. Thanks! 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
erland;141248 Wrote: > How long time is it between the "TrackStat::MusicMagic: Calling: > http://localhost:10002/api/songs?extended"; entry and the "Failure > answer from Music Magic songs" entry ? > > How long time does "http://localhost:10002/api/songs?extended"; take > when you run it in the web browser ? > > Have you tried several times ? Aha! Just noticed something very odd /songs?extended looks like it's actually returning album info instead of song info! e.g. name Macquarie Ridge (Bonus Track for Japan) artist Boards of Canada album The Campfire Headphase (Japan) album-id 11864864 file D:\Music\MP3\Boards of Canada\00-Macquarie Ridge (Bonus Track).mp3 genre Electronica; Leftfield/IDM; Glitch active yes seconds 297 bytes 7238844 bitrate 192 modified 1158705508 added 1144761377 lastplayed 1144815194 playcount 1 name Astronomy Domine artist Pink Floyd album The Piper at the Gates of Dawn album-id 11921936 file D:\Music\FLAC\Pink Floyd\The Piper at the Gates of Dawn\01 Astronomy Domine.flac genre Prog Rock; Rock/Pop; Classic Rock; Psychedelic; track 1 active yes seconds 252 bytes 25585316 year 1967 bitrate 812 rating 4 modified 1158692909 added 1144761282 etc. -- 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
erland;141248 Wrote: > How long time is it between the "TrackStat::MusicMagic: Calling: > http://localhost:10002/api/songs?extended"; entry and the "Failure > answer from Music Magic songs" entry ? Almost instantaneously... 1 to 2 seconds at the most. erland;141248 Wrote: > How long time does "http://localhost:10002/api/songs?extended"; take when > you run it in the web browser ? 1 second to display at the most very fast. erland;141248 Wrote: > Have you tried several times ? Oh yes. Many many many times :-) -- 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;141168 Wrote: > I'm unable to import my ratings and playcount data from MusicIP Mixer 7 > (final release) to Trackstat 1.28.2 > > I'm running MIP in standard application mode, and SlimServer Version: > 6.5.1 - 10078 - Windows XP - EN - cp1252 > Here are my debug log results: > > TrackStat::MusicMagic: Calling: > http://localhost:10002/api/songs?extended > MusicMagic: get filters list > MusicMagic: found filters: > MusicMagic: Rating >3 > TrackStat: Checking if its time to do a scheduled backup > TrackStat: Its 46260 seconds left until next scheduled backup > Failure answer from Music Magic songs > MusicMagic: read cacheid of 1159507843MusicMagic: got status - idle > > Entering http://localhost:10002/api/songs?extended manually appears to > generate normal results. Any ideas? > Thanks! How long time is it between the "TrackStat::MusicMagic: Calling: http://localhost:10002/api/songs?extended"; entry and the "Failure answer from Music Magic songs" entry ? How long time does "http://localhost:10002/api/songs?extended"; take when you run it in the web browser ? Have you tried several times ? -- 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'm unable to import my ratings and playcount data from MusicIP Mixer 7 (final release) to Trackstat 1.28.2 I'm running MIP in standard application mode, and SlimServer Version: 6.5.1 - 10078 - Windows XP - EN - cp1252 Here are my debug log results: TrackStat::MusicMagic: Calling: http://localhost:10002/api/songs?extended MusicMagic: get filters list MusicMagic: found filters: MusicMagic: Rating >3 TrackStat: Checking if its time to do a scheduled backup TrackStat: Its 46260 seconds left until next scheduled backup Failure answer from Music Magic songs MusicMagic: read cacheid of 1159507843MusicMagic: got status - idle Thanks! -- 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
A new version (1.28.2) of the TrackStat plugin is now available, there is no new functionallity just an error correction: - Corrected so it works towars latest 6.5 release, earlier 6.5 beta releases are no longer supported in this version. The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming TrackStat releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-trackstat If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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
Hi Erland,
I am having some problems with your plugins on the very latest version
of 6.5. Seems this is because the revision number has crept over 10,000
and statements like this no longer do the right thing as you're using
REVISION as a string...
if ($::VERSION ge '6.5' && $::REVISION ge '7505') {
generating warnings like this:
2006-09-25 21:36:53.9378 Warning:
Slim::Music::Info::getCurrentDataStore() is deprecated. Please use
Slim::Schema direct
ly.
2006-09-25 21:36:53.9387 Initialization of
Plugins::DynamicPlayList::Plugin failed: Can't locate object method
"dbh" via
package "Slim::Schema" at C:\Program
Files\SlimServer6.5_MySQL\server/Plugins/DynamicPlayList/Plugin.pm line
2512.
James
--
James
James's Profile: http://forums.slimdevices.com/member.php?userid=189
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
A new version (1.28.1) of the TrackStat plugin is now available, there is no new functionallity just an error correction: - Corrected a problem which caused a slimserver crash when TrackStat was used toghether with Custom Browse 1.4 The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming TrackStat releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-trackstat If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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
Re: [SlimDevices: Plugins] Re: Announce: Plugins for rating and "smart" playlists using SQL
>Corrected problem with incorrect order of rating stars in slimserver 6.5 That was quick! Thankyou! Phil ___ 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
smc2911;132966 Wrote: > It can be done using the remote, but it's not a single button click. > Press the right arrow from Now Playing (i.e. you'll need to press Now > Playing if you're not already there) to get to the song info. Press > down twice to get to the album and then press play. Hey presto, the > album will play! Similarly, if you only press down once to get to the > artist, you can then press right to get to a list of *all* of your > albums by that artists, scroll to one you want and press play. Wow! Thank you very much! I really had no idea that this was possible. I guess you learn something new every day. ;-) -- kyleki kyleki's Profile: http://forums.slimdevices.com/member.php?userid=2510 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
It can be done using the remote, but it's not a single button click. Press the right arrow from Now Playing (i.e. you'll need to press Now Playing if you're not already there) to get to the song info. Press down twice to get to the album and then press play. Hey presto, the album will play! Similarly, if you only press down once to get to the artist, you can then press right to get to a list of *all* of your albums by that artists, scroll to one you want and press play. -- smc2911 smc2911's Profile: http://forums.slimdevices.com/member.php?userid=4388 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
As I was listening to music this morning through the RandomPlayList plugin, a song came on that I really liked and I wanted to listen to the whole album. It would be cool if there were some way to change the current playlist to the album of the currently playing song by pushing a button on the remote. I really don't know the best way to implement something like this, but the idea of it seemed intuitive enough for me. I wonder if anyone else feels this functionality would be useful. I'd be happy to help out where I can if anyone is willing to work through any sticking points with me. The only problem is that I'd have no idea where to start... :( -- kyleki kyleki's Profile: http://forums.slimdevices.com/member.php?userid=2510 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
jleuzinger;132632 Wrote: > > > erland;132001 Wrote: > > By "search" do you mean that you want to be able to enter a whole or > > part of artist name/song title and got a list of matching entries with > > at least rating xxx ? > > > > > yes exactly. Thats the way I can quickly arrange a playlist with the > best of "Pink Floyd" for example. I'll add it to the wish list, but since no search functionallity exist in TrackStat today and its quite different from todays listings and the functionallity already exists in SQLPlayList, I am not sure its going to be implemented. Available already today are: 1. With the SQLPlayList plugin you can quite easy create a dynamic playlist that contains all tracks rated xxx or higher by Pink Floyd 2. You can browse to Pink Floyd in the standard slimserver browse by artist page and hit the TS button beside Pink Floyd. Then hit the "Pink Floyd" link in one of the tracks shown in the TrackStat statistics and you will get "Most played songs by Pink Floyd. Finally just choose the "Top rated songs statistics" and you will get to se "Top rated songs by: Pink Floyd" which is almost what you want. I would also suggest that you enter a feature request on bugs.slimdevices.com that it shall be possible to enter a minimum rating in the standard slimserver search page. -- 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) 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;132001 Wrote: > By "search" do you mean that you want to be able to enter a whole or > part of artist name/song title and got a list of matching entries with > at least rating xxx ? > yes exactly. Thats the way I can quickly arrange a playlist with the best of "Pink Floyd" for example. -- jleuzinger jleuzinger's Profile: http://forums.slimdevices.com/member.php?userid=7135 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
A new version (1.27.4) of the TrackStat plugin is now available, there is no new functionallity just an error correction: - Corrected so hold+play mixer function works correctly in latest 6.5 release The new version is available at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming TrackStat releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-trackstat If anyone have more feature requests or if I have missed some feature you already have requested which hasn't been implemented, please let me know. Also please note that it is a wish list and not a release plan, so some features on this list may never be implemented. -- 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) 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
jleuzinger;131400 Wrote: > A very helpful feature would be a combined search of song/artist AND a > minimum Rating. This is my most often used search method in Winamp. > By "search" do you mean that you want to be able to enter a whole or part of artist name/song title and got a list of matching entries with at least rating xxx ? Or do you just mean that the "Top rated artists" and "Top rated songs" statistics should list artists/songs that at least have rating xxx ? -- 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) 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
Thanks a lot Erland for your help, now I achieved to import my Winamp ratings. The Problem seemed to be a missing key "Music Folder". For me it is a big improvement to be able to use a song rating system ! Good work, thanks ! A very helpful feature would be a combined search of song/artist AND a minimum Rating. This is my most often used search method in Winamp. Joerg -- jleuzinger jleuzinger's Profile: http://forums.slimdevices.com/member.php?userid=7135 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
jleuzinger;130818 Wrote: > Which XML-tags are required by Trackstat ?I just tried to look in the > TrackStat code and haven't tried to actually import this, but I think the tags shown in the example below are the onces that are interested. The "Play Count", "Play Date UTC", "Rating" tags should be optional and should not cause a crash if they are missing (I think). The "Date Added" isn't actually used in the import but its read and I think it might cause a crash if it doesn't exist. The "Track ID" and "Location" tags are a requirement, if they doesn't exist the import would probably crash. Code: http://www.apple.com/DTDs/PropertyList-1.0.dtd";> Music Folderfile://localhost/D:/Egna/My%20Music/iTunes/iTunes%20Music/ Tracks 1 Track ID1 Date Added2006-01-05T16:44:58Z Play Count1 Play Date UTC2006-03-18T11:57:20Z Rating60 Locationfile://localhost/D:/Egna/My%20Music/iTunes/iTunes%20Music/Artist1/1%20Track1.mp3 2 Track ID2 Date Added2006-01-06T11:41:32Z Play Count3 Play Date UTC2006-04-15T10:52:43Z Rating80 Locationfile://localhost/D:/Egna/My%20Music/iTunes/iTunes%20Music/Artist1/1%20Track2.mp3 -- 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) 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
TimM;125612 Wrote: > Hi > > Does anybody else find that SS 6.3 crashes after doing an import from > itunes? > Tim I tried to transfer my song ratings from Winamp to Slimserver / Trackstat. I used a Winamp plugin to export the Winamp Database to an iTunes XML-File. Importing this file in Trackstat crashes Slimserver immediately. No entry in log.txt. I'm not sure if the XML-File has the correct format. Has anybody achieved to transfer Winamp Ratings to Trackstat ? Which XML-tags are required by Trackstat ? Regards, Joerg Using SS 6.3.1, Trackstat 1.27.3. on WinXP -- jleuzinger jleuzinger's Profile: http://forums.slimdevices.com/member.php?userid=7135 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 Wrote: > Would it be acceptable to have a setting in TrackStat where the user > could specify if "all" or "none" of the players are synchronized ? Would work for me, but I always have my players synched. I can see how that solution might not be great for everyone though. -- LoZ LoZ's Profile: http://forums.slimdevices.com/member.php?userid=6792 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
LoZ Wrote: > Okay, sorry to be a pain but I've got to go back to what snarlydwarf was > saying originally. When I recreated the synch between the two devices, > initially both worked fine for rating. Now the slave doesn't want to do > it anymore. > > All very odd, but I can live with it! > I tried to setup the SoftSqueeze player synchronized with my SqueezeBox and the events TrackStat gets from slimserver is not what it expects. So if you are using the slave remote to control the music or do rating it's just luck that it's working at all. Would it be acceptable to have a setting in TrackStat where the user could specify if "all" or "none" of the players are synchronized ? The disadvantage of this solution would be if you have 3 SqueezeBox'es and 2 of them are configured as synchronized players and 1 is not part of the synchronization group. LoZ Wrote: > Have you got a donation link so I can help you along the way to buying > another SB for testing purposes erland? ;)You will find it on 'my download > page' (http://erland.homeip.net/download). -- 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) 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
Okay, sorry to be a pain but I've got to go back to what snarlydwarf was saying originally. When I recreated the synch between the two devices, initially both worked fine for rating. Now the slave doesn't want to do it anymore. All very odd, but I can live with it! Have you got a donation link so I can help you along the way to buying another SB for testing purposes erland? ;) -- LoZ LoZ's Profile: http://forums.slimdevices.com/member.php?userid=6792 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
Well now, up until about 5 minutes ago I would have said it was consistent. I thought I'd break the synchronisation and recreate it the other way round (ie. slave becomes master and vice versa). Lo and behold, the new master is able to rate from the remote. The annoying thing (from a troubleshooting perspective) is that the slave can *also* rate from the remote now. Don't get me wrong, I'm over the moon that I can do it with both players now. I guess I was a bit to quick to agree with snarlydwarf's perspective as it seemed to fit in with my experience. So, it's all good now! Anyone having the same problem should break and recreate the sync between players after installing TrackStat. Thanks for your help erland. -- LoZ LoZ's Profile: http://forums.slimdevices.com/member.php?userid=6792 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
LoZ Wrote: > Here's a section between two songs - is this the sort of thing you > mean? > I think I need to setup a master/slave configuration myself so I easier can see what happens in different situations. Is the behaviour always that its never possible to change ratings on the slave SqueezeBox or is it possible sometimes and sometimes not ? -- 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) 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
Here's a section between two songs - is this the sort of thing you mean? 2006-08-08 20:15:21.8218 TrackStat: "Ohio" was played long enough to count as played. 2006-08-08 20:15:21.8219 TrackStat: Played past percentage threshold of 90.5273469387755 seconds. 2006-08-08 20:15:21.8220 TrackStat: Entering markedAsPlayed 2006-08-08 20:15:21.8258 TrackStat::Storage: findTrack(): URL: file:///E:/mp3server/Neil%20Young/Greatest%20Hits/08-Ohio.Mp3 2006-08-08 20:15:21.8678 TrackStat::Storage: findTrack(): URL: file:///E:/mp3server/Neil%20Young/Greatest%20Hits/08-Ohio.Mp3 2006-08-08 20:15:21.8836 TrackStat::Storage: Marking as played in storage 2006-08-08 20:15:21.8923 TrackStat::Storage: Entering addToHistory 2006-08-08 20:15:21.8930 TrackStat: Calling TrackStat::Plugin 2006-08-08 20:15:21.8935 TrackStat: Entering setTrackStatStatistic 2006-08-08 20:15:21.8938 TrackStat: Exiting setTrackStatStatistic 2006-08-08 20:15:21.8941 Executing command 00:04:20:06:0d:23: trackstat (changedstatistic) (file:///E:/mp3server/Neil%20Young/Greatest%20Hits/08-Ohio.Mp3) (5678) (1) (1155064521) () () 2006-08-08 20:15:21.8958 Returning array: trackstat (changedstatistic) (file:///E:/mp3server/Neil%20Young/Greatest%20Hits/08-Ohio.Mp3) (5678) (1) (1155064521) () () 2006-08-08 20:15:21.8962 TrackStat: Exiting markedAsPlayed 2006-08-08 20:15:21.8966 TrackStat: Starting a new song 2006-08-08 20:15:21.9042 TrackStat: Starting to time file:///E:/mp3server/America/America/05-A%20Horse%20With%20No%20Name.mp3 2006-08-08 20:16:22.0758 Executing command 00:04:20:06:0d:23: ir (7689d02f) (3305134.436) () () () () () 2006-08-08 20:16:22.0767 Executing command 00:04:20:06:0d:23: button (done) (3305134.436) (1) () () () () 2006-08-08 20:16:22.0802 Returning array: button (done) (3305134.436) (1) () () () () 2006-08-08 20:16:22.0807 Returning array: ir (7689d02f) (3305134.436) () () () () () -- LoZ LoZ's Profile: http://forums.slimdevices.com/member.php?userid=6792 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
LoZ Wrote: > Here ya go, started track. Tried setting a rating of four twice. Hope > this is useful to you. > Thats great, do you have the log entries directly before this ? I would like to see how the "Executing command" entries look like that hopefully exists before the "TrackStat: Starting a new song" and "TrackStat: Starting to time" entries. -- 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) 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
Here ya go, started track. Tried setting a rating of four twice. Hope this is useful to you. 2006-08-08 18:51:25.5849 TrackStat: Starting a new song 2006-08-08 18:51:25.5898 TrackStat: Starting to time file:///E:/mp3server/Woody%20Guthrie/[2002]%20The%20Legendary%20Woody%20Guthrie%2022%20Songs%20from%20the%20Original%20American%20Troubadour/04-We%20Shall%20Be%20Free%20(With%20Leadbelly,%20Sonny%20Terry%20&%20Cisco%20Houston).mp3 2006-08-08 18:51:25.5969 Returning array: playlist (playtracks) (listref) (ARRAY(0x59d02a0)) () () () () 2006-08-08 18:51:25.5975 Returning array: button (passback) (3299950.629) (1) () () () () 2006-08-08 18:51:45.0726 Executing command 00:04:20:05:b5:18: ir (76897887) (3299970.168) () () () () () 2006-08-08 18:51:45.0734 Executing command 00:04:20:05:b5:18: button (playdisp_toggle) (3299970.168) (1) () () () () 2006-08-08 18:51:45.0758 Returning array: button (playdisp_toggle) (3299970.168) (1) () () () () 2006-08-08 18:51:45.0763 Returning array: ir (76897887) (3299970.168) () () () () () 2006-08-08 18:51:45.1808 Executing command 00:04:20:05:b5:18: ir (76897887) (3299970.276) () () () () () 2006-08-08 18:51:45.1815 Returning array: ir (76897887) (3299970.276) () () () () () 2006-08-08 18:51:46.9528 TrackStat: Entering getRatingNumberCustomItem 2006-08-08 18:51:46.9535 TrackStat::Storage: findTrack(): URL: file:///E:/mp3server/Woody%20Guthrie/[2002]%20The%20Legendary%20Woody%20Guthrie%2022%20Songs%20from%20the%20Original%20American%20Troubadour/04-We%20Shall%20Be%20Free%20(With%20Leadbelly,%20Sonny%20Terry%20&%20Cisco%20Houston).mp3 2006-08-08 18:51:46.9720 TrackStat: Exiting getRatingNumberCustomItem 2006-08-08 18:51:47.5618 Executing command 00:04:20:05:b5:18: ir (768948b7) (3299972.552) () () () () () 2006-08-08 18:51:47.5626 Executing command 00:04:20:05:b5:18: button (dead) (3299972.552) (1) () () () () 2006-08-08 18:51:47.5633 Returning array: button (dead) (3299972.552) (1) () () () () 2006-08-08 18:51:47.5638 Returning array: ir (768948b7) (3299972.552) () () () () () 2006-08-08 18:51:47.5820 Executing command 00:04:20:05:b5:18: ir (768948b7) (3299972.66) () () () () () 2006-08-08 18:51:47.5827 Returning array: ir (768948b7) (3299972.66) () () () () () 2006-08-08 18:51:47.6878 Executing command 00:04:20:05:b5:18: ir (768948b7) (3299972.767) () () () () () 2006-08-08 18:51:47.6885 Returning array: ir (768948b7) (3299972.767) () () () () () 2006-08-08 18:51:47.7951 Executing command 00:04:20:05:b5:18: ir (768948b7) (3299972.875) () () () () () 2006-08-08 18:51:47.7960 Returning array: ir (768948b7) (3299972.875) () () () () () 2006-08-08 18:51:47.9092 Executing command 00:04:20:05:b5:18: ir (768948b7) (3299972.983) () () () () () 2006-08-08 18:51:47.9099 Returning array: ir (768948b7) (3299972.983) () () () () () 2006-08-08 18:51:48.0170 Executing command 00:04:20:05:b5:18: ir (768948b7) (3299973.091) () () () () () 2006-08-08 18:51:48.0176 Executing command 00:04:20:05:b5:18: button (saveRating_4) (3299973.091) (1) () () () () 2006-08-08 18:51:48.0201 Returning array: button (saveRating_4) (3299973.091) (1) () () () () 2006-08-08 18:51:48.0207 Returning array: ir (768948b7) (3299973.091) () () () () () 2006-08-08 18:51:48.1254 Executing command 00:04:20:05:b5:18: ir (768948b7) (3299973.199) () () () () () 2006-08-08 18:51:48.1262 Returning array: ir (768948b7) (3299973.199) () () () () () 2006-08-08 18:51:48.2391 Executing command 00:04:20:05:b5:18: ir (768948b7) (3299973.307) () () () () () 2006-08-08 18:51:48.2398 Returning array: ir (768948b7) (3299973.307) () () () () () 2006-08-08 18:51:48.3410 Executing command 00:04:20:05:b5:18: ir (768948b7) (3299973.415) () () () () () 2006-08-08 18:51:48.3417 Returning array: ir (768948b7) (3299973.415) () () () () () 2006-08-08 18:51:48.4392 Executing command 00:04:20:05:b5:18: ir (768948b7) (3299973.523) () () () () () 2006-08-08 18:51:48.4399 Returning array: ir (768948b7) (3299973.523) () () () () () 2006-08-08 18:52:30.1402 Executing command 00:04:20:05:b5:18: ir (768948b7) (3300015.02) () () () () () 2006-08-08 18:52:30.1410 Executing command 00:04:20:05:b5:18: button (done) (3300015.02) (1) () () () () 2006-08-08 18:52:30.1466 Returning array: button (done) (3300015.02) (1) () () () () 2006-08-08 18:52:30.1470 Returning array: ir (768948b7) (3300015.02) () () () () () 2006-08-08 18:52:30.2485 Executing command 00:04:20:05:b5:18: ir (768948b7) (3300015.128) () () () () () 2006-08-08 18:52:30.2492 Returning array: ir (768948b7) (3300015.128) () () () () () 2006-08-08 18:52:30.3598 Executing command 00:04:20:05:b5:18: ir (768948b7) (3300015.235) () () () () () 2006-08-08 18:52:30.3605 Returning array: ir (768948b7) (3300015.235) () () () () () 2006-08-08 18:52:30.4635 Executing command 00:04:20:05:b5:18: ir (768948b7) (3300015.343) () () () () () 2006-08-08 18:52:30.4642 Returning array: ir (768948b7) (3300015.343) () () () () () 2006-08-08 18:52:30.5723 Executing command 00:04:20
[SlimDevices: Plugins] Re: Announce: Plugins for rating and "smart" playlists using SQL
LoZ Wrote: > Let me know if you still want me to post the logs, although nothing > relevant seems to appear in them. I think the problem might be that all events/notifications are not sent to both the master and slave unit. Since I haven't setup a master/slave configuration myself it would help if you could enable TrackStat debugging and also enable the d_command debug flag in slimserver. I would like to see the logs when you start playing a song and try to rate it on the slave unit where rating doesn't work. I am not expecting any errors in these logs, I just want to see which events that are sent to each SqueezeBox in this senario. -- 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) 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 Wrote: > Are you playing a song when rating is not possible or are you trying to > rate a song which is stopped or paused ? > > If the problem is for a playing song, can you give me the debug log > output even though it doesn't look as an error. Enable debugging in the > TrackStat section of the the Server Settings. It is for a playing song - on the correct screen, but I think snarlydwarf has hit the nail on the head: snarlydwarf Wrote: > The Synced part is the key: I see this all the time: the slave can't > rate stuff. The device I *can* rate from is the master of the two synched devices, when I attempt to rate a song from the slave (from the 'Now Playing' screen), I get the 'No song playing' error. Let me know if you still want me to post the logs, although nothing relevant seems to appear in them. -- LoZ LoZ's Profile: http://forums.slimdevices.com/member.php?userid=6792 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
LoZ Wrote: > > To add to the mystery, I can rate from one player (Squeezebox 3) but > not the other (Squeezebox 2). They are both synchronised but it doesn't > matter which one I selected the tracks from. The Synced part is the key: I see this all the time: the slave can't rate stuff. (My LivingRoom player right now is the 'master' and Softsqueeze at work is the slave, so I can't use the fake remote to rate.) -- snarlydwarf snarlydwarf's Profile: http://forums.slimdevices.com/member.php?userid=1179 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
LoZ Wrote: > When I attempt to rate a song using the remote control, I get the > message "TrackStat: No song playing" displayed. I am on the "Now > Playing" screen. > The current implementation is limited to: 1. Rate currently playing songs from "Now Playing" menu 2. Rate songs from the "Plugins/TrackStat" menu Are you playing a song when rating is not possible or are you trying to rate a song which is stopped or paused ? If the problem is for a playing song, can you give me the debug log output even though it doesn't look as an error. Enable debugging in the TrackStat section of the the Server Settings. -- 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) 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
Hey erland, Apologies if this has been discussed already but this thread is massive and the search tools didn't show anything up. I am using the latest (as of yesterday, 5th August 2006) versions of the following: SQL Playlist, TrackStat & Dynamic Playlists. Also using SlimServer Version: 6.3.0 - 8148 - Windows Server 2003 - EN - cp1252. When I attempt to rate a song using the remote control, I get the message "TrackStat: No song playing" displayed. I am on the "Now Playing" screen. I can rate songs via the UI, but it would be great to get the remote method working. I've turned on logging, but it doesn't seem to log the attempt at rating as an error. Any ideas? Brilliant plugins by the way, thanks for all the hard work. Cheers, LoZ -- LoZ LoZ's Profile: http://forums.slimdevices.com/member.php?userid=6792 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
Hi Yes I was using tracksta 1.27.2, sorry did'nt notice 1.27.3, just tried it and it works fine. Many thanks Tim -- TimM TimM's Profile: http://forums.slimdevices.com/member.php?userid=1204 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
