Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
Is the Do not repeat tracks within same playlist option checked ? If it isn't there is a risk that tracks are added to the end of the dynamic playlist before the same track that already was in the playlist has been played. Could this be the issue, or does it really add tracks at the end that you know that you have recently played ? A track is not detected as played until you have played it to the end, so I think that if you have skipped a track it could still be added to the end of the playlist. The risk that the same track is added to the end should be pretty low unless the track Dynamic Playlist can choose among that matches the filter it pretty few. Do you have a lot of tracks with genre=alternative with a rating set to 3 or above that hasn't been played the last four weeks ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
yes, the do not repeat option is checked. I'm pretty sure that I have a large number of tracks that are three star or higher and that haven't been played in the last month. The added problem is that I'm also starting to get tracks added to the playlist that aren't tagged as alternative music tracks-i.e.-other genre tracks are being added to the playlist. Is this a bad cache issue perhaps? -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
The repeating tracks problem has returned and now I want to get to the bottom of it. the pattern seems to be: after a track is played it gets re-added to the bottom of my playlist. I have don't repeat tracks selected in my playlist settings. any suggestions for troubleshooting? -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
exile;345989 Wrote: The repeating tracks problem has returned and now I want to get to the bottom of it. the pattern seems to be: after a track is played it gets re-added to the bottom of my playlist. I have don't repeat tracks selected in my playlist settings. any suggestions for troubleshooting? Which Dynamic Playlist are you playing when this happens ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
I built a random song playlist that only plays three star or higher rated alternative music (genre) tracks that haven't been played for at least four weeks. I built it from the latest downloadable templates in SQL playlist. -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
erland- thanks for the info. Working from within the dynamic playlist menu is fine by me. all of your efforts are much appreciated. -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
a follow up erland- by reverting to dynamic playlist 2.4 and with trackstat 2.4 it seems that all is normal again. don't know what the source of the problem was. One request for trackstat: when I select play top rated songs from an album: I get a listing from highest rated to lowest rated. But in my thinking, top rated refers only to the highest rated and not the low rated at all. Is it easy to customize that parameter to only include three star and higher rated songs when selecting that option? thanks for all of your help. -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
exile;344004 Wrote: One request for trackstat: when I select play top rated songs from an album: I get a listing from highest rated to lowest rated. But in my thinking, top rated refers only to the highest rated and not the low rated at all. Is it easy to customize that parameter to only include three star and higher rated songs when selecting that option? It depends... If you launch it from the Dynamic Playlist menu or from the Dynamic Playlist mixer you can create a new playlist in SQLPlaylist of the type Top rated for album, this playlist type has a minimum rating option. If you launch it from the TrackStat pages, there is no way to do it in the current version. In some TrackStat version far in the future my goal is to make it's behavior more configurable and this will include things like this. However, I'm not sure if I'll ever get there due to the limited time I'm able to spend doing plugin development. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
[SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
After upgrading to 7.2 my sql playlist seems to be broken. I can load a pre-built playlist but now I can't create a new playlist or play any previously saved self-made playlists. Attached is the log. and here's my basic info: SqueezeCenter Version: 7.2 - 22900 @ Tue Aug 26 11:08:53 PDT 2008 - Mac OS X 10.5.4 (9E17) - EN - utf8 Server IP address: 192.168.11.5 Perl Version: 5.8.8 darwin-thread-multi-2level MySQL Version: 5.0.22-standard Platform Architecture: ppc Hostname: G4.local Server Port Number: 9000 Total Players Recognized: 5 +---+ |Filename: sql log.doc | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=5868| +---+ -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
What happens ? Don't you see the playlists at all in the interface ? Do you get any error message ? Which SqueezeCenter version were you using before when it worked ? Which SQL Playlist version are you using now when it doesn't work ? Which Dynamic Playlist version are you using now when it doesn't work ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
hey erland- thanks for your response. I can see all of the template playlists and i can step through the whole process of creating a customized playlist but after hitting save and play nothing happens. If i just select a pre-built/default playlist it plays fine. I think there's no error message on my squeezebox. I'll check again though. sql worked fine in 7.1 with all of your latest plugin versions. sql playlist version 2.1 dynamic playlist version 2.5 -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
Does the directory parameters in SqueezeCenter Settings/Plugins/SQL Playlist point to the correct places ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
erland- I was just checking my paths and I see that all of my trackstats got blown out when i upgraded to 7.2. So perhaps after I do a trackstat restore from my backup all will be well with sql. I didn't expect the trackstat blowout to happen since the last upgrade from 7.0 to 7.1 kept all of my trackstat info intact. thanks. -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
Is the playlist successfully created but nothing happens when you play it ? That is, do you see it in the list of available playlists ? If that's the case, restoring TrackStat ratings might work. If you did an upgrade, you might also be affected by the following bug report: http://bugs.slimdevices.com/show_bug.cgi?id=9423 If you are affected by this you should see some warnings from TrackStat at SqueezeCenter startup. I think the consequence of that bug report is that TrackStat ratings won't be shown even though they are in the database. I think a workaround might be to: 1. Make sure you have a TrackStat backup (I'm not sure if you will be able to take a new backup in this situation, so hopefully you already have a fresh one). 2. Shutdown SqueezeCenter 3. Delete the Cache/MySQL directory in the SqueezeCenter installation directory 4. Startup SqueezeCenter 5. Wait for the rescan to finish 6. Restore the TrackStat backup -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
erland- good news. i did a restore of my trackstat ratings and now all is well with sql. thanks for your help and for creating the easy trackstat backup method. btw- I just finished rating my library after two years. Therefore always having a backup is critical to my happiness. -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
one more thing erland- it must be my day for troubleshooting... sql is working again but now I'm running into repeated tracks in my playlist. I have don't repeat tracks selected in my playlist settings but it looks like most tracks are being repeated. any ideas? attached is a screen grab of my current playlist. +---+ |Filename: screen grab.jpg | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=5871| +---+ -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
Is there any errors in the SqueezeCenter log ? Make sure you have sett the SqueezeCenter Settings/Logging parameters to Warning or higher so you don't get all the debug messages. How does the playlist look like ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) 'My download page' (http://erland.isaksson.info/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and Database Query plugins' (http://wiki.erland.isaksson.info/index.php/Category:SlimServer)) erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
Re: [SlimDevices: Plugins] SQL Playlist Problem after upgrading to 7.2
I'll post answers to your questions asap. -- exile exile's Profile: http://forums.slimdevices.com/member.php?userid=4579 View this thread: http://forums.slimdevices.com/showthread.php?t=52684 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins