subject:"\[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.secs60
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


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


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.secs60
   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


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;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.secs60
  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.secs60
  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.secs60
  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


What I noticed from testing the code you provided was this: All of them
worked as expected =except= for the ones using the lineor
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;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 lineor
 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


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


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


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

2006-12-30 Thread Yannzola


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

2006-12-22 Thread Pale Blue Ego


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

2006-12-20 Thread erland


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

2006-11-25 Thread erland


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

2006-11-23 Thread erland


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

2006-11-23 Thread erland


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

2006-11-18 Thread erland


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

2006-11-17 Thread erland


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


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
23 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

2006-11-16 Thread erland


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


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,
ITUNESLIBRARY 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

2006-11-16 Thread erland


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: The path to iTunes music on the iTunes
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. 

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


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: The path to iTunes music on the iTunes
 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


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

2006-11-14 Thread gsalton


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

2006-11-14 Thread erland

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

2006-11-12 Thread erland


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

2006-11-02 Thread erland


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

2006-11-02 Thread dSw


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

2006-11-01 Thread dSw


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

2006-10-27 Thread erland


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

2006-10-27 Thread Yannzola


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


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

Re: [SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL

2006-10-26 Thread kdf



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


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

[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:\wherever you keep it\SlimServer\server\slim.exe --logfile
c:\slimlog.txt or whereever you want the file to live.  

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

2006-10-26 Thread kdf


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

2006-10-26 Thread erland


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


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

2006-10-21 Thread erland


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

2006-10-15 Thread erland


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

2006-10-12 Thread erland


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

2006-10-12 Thread wiped


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


Hello

I've been using 6.3.0 with trackstat, sqlplaylist and
dynamicplaylists.
Yesterday i've upgraded to 6.5.1 (06-10-10).
I made a backup of the trackstat data.
I uninstalled and deleted the slimserver directory.
Then i installed 6.5.1
I then installed the latest version of the  plug-ins.
Then i restored the trackstat data from file.

Now i can see that the trackstat data is included when playing songs
(have added TRACKSTATRATINGMNUMBER).

However the problem is that none of my sql playlists works, and also i
cannot browse e.g. top rated songs in trackstat..
For the playlists, just NOTHING happens when selecting to play the
playlist.

For the trackstat browsing, when i e.g. select trop rated songs,
nothing is displayed below the navigation menu.. No matter what i
select.

I then tried with 6.5.0 also and had the same problem...
Now i'm back to 6.5.1 and hope that it's just some setting that i've
missed???


-- 
wiped

Squeezebox 3 - SS 6.3 - Core Duo T2500 - 2Gb ram - 25000 Songs - 1750
Albums (Mp3 and soon also FLAC)

wiped's Profile: http://forums.slimdevices.com/member.php?userid=1542
View this thread: http://forums.slimdevices.com/showthread.php?t=20533

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins

[SlimDevices: Plugins] Re: 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

2006-10-11 Thread Yannzola


I may be missing something... but is it currently possible to use a
combination of Random Playlist, Dynamic Playlists, and Trackstat to
create a playlist of random songs filtered by rating? In particular,
I'd love to be able to have the ability to play a random list of
unrated tracks + tracks rated 2/3/4/5 or higher. Or the ability to
exclude low rated tracks from randomplay. Make sense?

y.


-- 
Yannzola

Yannzola's Profile: http://forums.slimdevices.com/member.php?userid=874
View this thread: http://forums.slimdevices.com/showthread.php?t=20533

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins

[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL


Yannzola;145418 Wrote: 
 I may be missing something... but is it currently possible to use a
 combination of Random Playlist, Dynamic Playlists, and Trackstat to
 create a playlist of random songs filtered by rating? In particular,
 I'd love to be able to have the ability to play a random list of
 unrated tracks + tracks rated 2/3/4/5 or higher. Or the ability to
 exclude low rated tracks from randomplay. Make sense?
 You will have to use the SQLPlayList plugin for this, there is wizards
available for it to create a playlist with only top rated tracks.


-- 
erland

Erland Isaksson
'My homepage' (http://erland.homeip.net) 'My download page'
(http://erland.homeip.net/download)
(Developer of 'TrackStat'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat)
, 'SQLPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist)
, 'DynamicPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist),
'Custom Browse'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse)
and 'RandomPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist)
plugins)

erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=20533

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins

[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL

2006-10-11 Thread socialxray


wiped;145234 Wrote: 
 
 For the playlists, just NOTHING happens when selecting to play the
 playlist.
 
 

I am having the same problem.  Upgraded to 6.5 and my playlists do not
work anymore.  When editing them via the web interface no tracks are
displayed.  When attempting to play them the web interface shows zero
files, even though the files do contain information.  I also have the
same plugins installed for 6.5.

Any ideas anyone?


-- 
socialxray

socialxray's Profile: http://forums.slimdevices.com/member.php?userid=2996
View this thread: http://forums.slimdevices.com/showthread.php?t=20533

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins

[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL


erland;145399 Wrote: 
 Unless you have been using mysql together with 6.3.0, the SQLPlayList
 plugin playlists need to be modified. In 6.3.0 the contained something
 like order by random() in 6.5.0 this has to be changed to order by
 rand(). For newly created playlist this will be done automatically but
 for old playlist you will have to change this yourself. 

Ok, I'll changed that but it does not help

erland;145399 Wrote: 
 
 Could you enable debugging in the TrackStat settings page and see if
 you see some error message in the log ?
 

Ok i'll try that, where is the log located?
i enabled debugging but i don't find any log.

erland;145399 Wrote: 
 
 This looks like some sort of character encoding problem. Are you using
 Windows or Linux for slimserver and for the computer where you access
 the web interface ?
 Is everything else working correctly in slimserver ?


Running on a Windows 2003 server (my only machine so i'm browsing there
also), no changes made since 6.3
Everything else seems to be working fine so far.


-- 
wiped

Squeezebox 3 - SS 6.5.1 - Core Duo T2500 - 2Gb ram - 25000 Songs - 1912
Albums (FLAC and MP3) - 324Gb Music Folder

wiped's Profile: http://forums.slimdevices.com/member.php?userid=1542
View this thread: http://forums.slimdevices.com/showthread.php?t=20533

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins

[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL


socialxray;145428 Wrote: 
 I am having the same problem.  Upgraded to 6.5 and my playlists do not
 work anymore.  When editing them via the web interface no tracks are
 displayed.  When attempting to play them the web interface shows zero
 files, even though the files do contain information.  I also have the
 same plugins installed for 6.5.
 
 Any ideas anyone?See my previous message a few minutes before yours regarding 
 changing
random() to rand(). Make sure you have the latest versions of the
plugins. If that doesn't work turn on the debugging parameter in the
settings page for TrackStat/SQLPlayList and look for error messages in
the log.


-- 
erland

Erland Isaksson
'My homepage' (http://erland.homeip.net) 'My download page'
(http://erland.homeip.net/download)
(Developer of 'TrackStat'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-trackstat)
, 'SQLPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-sqlplaylist)
, 'DynamicPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-dynamicplaylist),
'Custom Browse'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-custombrowse)
and 'RandomPlayList'
(http://erland.homeip.net/download/do/viewapplication?name=slimserver-randomplaylist)
plugins)

erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=20533

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins

[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL


erland;145467 Wrote: 
 I'm not sure if its stored to a file by default, but you should be able
 to open a command prompt window and run slim.exe --logfile C:\log.txt
 manually and then you will get the log in C:\log.txt

Ok, here is the log.
Started slimserver.
Opened the webpage
Opened trackstat
Selected - top rated - top rated songs
Next i switched to dynamic playlist and tried to play one of them 4-5
selected artist

next i switched to sqlplaylist and choose to edit 4-5 selected artist
and the pressed test (with rand())

Here is the output.
061011 22:51:51  InnoDB: Started; log sequence number 0 331678118
061011 22:51:51 [Note]
C:\PROGRA~1\SLIMSE~1\server\Bin\MSWIN3~1\mysqld.exe: ready for
connections.
Version: '5.0.22-community-nt'  socket: ''  port: 9092  MySQL Community
Edition (GPL)
2006-10-11 22:51:55.8281 TrackStat: initialising
2006-10-11 22:51:55.8285 TrackStat: Hook activated.
2006-10-11 22:51:55.8286 TrackStat::Storage: Checking if
track_statistics database table exists
2006-10-11 22:51:55.8306 TrackStat::Storage: Checking if track_history
database table exists
2006-10-11 22:51:55.8746 TrackStat::Storage: Checking charsets on
tables
2006-10-11 22:51:56.6562 TrackStat::Storage: Got tracks charset = utf8
2006-10-11 22:51:56.6571 TrackStat::Storage: Got track_statistics
charset = utf8
2006-10-11 22:51:56.7631 TrackStat::Storage: Got track_history charset
= utf8
2006-10-11 22:51:56.7634 TrackStat::Storage: Checking if indexes is
needed for track_statistics
2006-10-11 22:51:56.7689 TrackStat::Storage: Checking if indexes is
needed for track_history
2006-10-11 22:51:56.7972 TrackStat::Storage: Checking if additional
indexes are needed for tracks
2006-10-11 22:51:57.2969 TrackStat::Storage: Starting to analyze
indexes
2006-10-11 22:51:57.8281 TrackStat::Storage: Finished analyzing indexes
: It took 1.030966 seconds
2006-10-11 22:51:57.8283 TrackStat::Storage: Starting to update urls in
statistic data based on musicbrainz ids
2006-10-11 22:51:57.8297 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8299 TrackStat::Storage: Finished updating urls in
statistic data based on musicbrainz ids, updated 0 items : It took
0.001582 seconds
2006-10-11 22:51:57.8300 TrackStat::Storage: Starting to update
musicbrainz id's in statistic data based on urls
2006-10-11 22:51:57.8305 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8306 TrackStat::Storage: Finished updating
musicbrainz id's in statistic data based on urls, updated 0 items : It
took 0.000583 seconds
2006-10-11 22:51:57.8307 TrackStat::Storage: Starting to update ratings
in standard slimserver database based on urls
2006-10-11 22:51:57.8311 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8313 TrackStat::Storage: Finished updating ratings
in standard slimserver database based on urls, updated 0 items : It
took 0.000529 seconds
2006-10-11 22:51:57.8314 TrackStat::Storage: Starting to update added
times in statistic data based on urls
2006-10-11 22:51:57.8318 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8319 TrackStat::Storage: Finished updating added
times in statistic data based on urls, updated 0 items : It took
0.000529 seconds
2006-10-11 22:51:57.8320 TrackStat::Storage: Starting to add tracks
without added times in statistic data based on urls
2006-10-11 22:51:57.8329 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8331 TrackStat::Storage: Finished adding tracks
without added times in statistic data based on urls, added 0 items : It
took 0.00104 seconds
2006-10-11 22:51:57.8332 TrackStat::Storage: Starting to update ratings
in statistic data based on urls
2006-10-11 22:51:57.8336 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8337 TrackStat::Storage: Finished updating ratings
in statistic data based on urls, updated 0 items : It took 0.000551
seconds
2006-10-11 22:51:57.8338 TrackStat::Storage: Starting to update urls in
track_history based on musicbrainz ids
2006-10-11 22:51:57.8346 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11 22:51:57.8348 TrackStat::Storage: Finished updating urls in
track_history based on musicbrainz ids, updated 0 items : It took
0.000906 seconds
2006-10-11 22:51:57.8350 TrackStat::Storage: Starting to update
musicbrainz id's in track_history based on urls
2006-10-11 22:51:57.8354 Database error: Illegal mix of collations
(utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation
'='
2006-10-11

[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL


FYI, not sure if it matters but..:
Searching for utf8_unicode_ci returns these txt files under
slimserver:
schema_1_up.sql
schema_2_up.sql

Searching for utf8_general_ci returns these txt files under
slimserver:
system.sql

---
Also searched the web for the error message and found a similar one,
it's swedish originally.
It's not 100% the same but perhaps it can mean someting to someone who
knows SQL...

llegal mix of collations (swe7_swedish_ci,IMPLICIT) and
(latin1_swedish_ci,COERCIBLE) for operation '=' 
Det betyder att databasen/tabellen/fälten har collation swe7_swe...
och din anslutning till mysql har latin1, kolla om du kan ändra ngn av
dem..
Translation
It means that the database/table/field has collation swe7_swe ... and
the connection to mysql has latin1, check if you can change one of
them


-- 
wiped

Squeezebox 3 - SS 6.5.1 - Core Duo T2500 - 2Gb ram - 25000 Songs - 1912
Albums (FLAC and MP3) - 324Gb Music Folder

wiped's Profile: http://forums.slimdevices.com/member.php?userid=1542
View this thread: http://forums.slimdevices.com/showthread.php?t=20533

___
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/lists/listinfo/plugins

[SlimDevices: Plugins] Re: Announce: Plugins for rating and smart playlists using SQL