Erland, I'm wondering if you can give me a pointer. I have several playlists that I created with Playlist Generator that takes songs from a Library plus a TrackStat rating plus a timestamp to generate a playlist. I have CustomScan generate the playlists every night. About a month ago I noticed that the same songs would keep showing up in a playlist even though I had played that song the day before, which means that it shouldn't be in the playlist. I made some changes about a month ago to my configuration, including applying some Mac OS updates, but other than the OS updates, I couldn't tell you what I changed to my LMS settings (sadly, no version control).
When I run TrackStat for my nightly backup, it runs without errors and generates a nightly backup file as well as keeps a running tally of last played songs. When I run TrackStat to show me the last played songs, it knows what songs were last played. This tells me that TrackStat is not likely the source of the problem. When I run CustomScan for my tags, it sees everything and makes the correct libraries without any errors. When I run CustomScan to generate my Playlist Generator playlists, it generates the playlists without errors. I've run all of the above in Debug mode and I don't see anything strange in the logs. Through a script on my Mac I update iTunes with TrackStatHist.txt. This updates play count, ratings, and last played settings in iTunes. Using iTunes' Smart Playlist option, I generate a playlist that should be equivalent to what is produced from Playlist Generator. Prior to about a month ago it used to be the same, but now it's not. For instance, for songs rated 8 or higher and not played in the last 90 days, I get the following: iTunes: 1041 songs. Playlist Generator: 2471 songs. That's a significant difference. Do you have any thoughts on where I should look? Latest versions of: Multi Library TrackStat Playlist Generator Dynamic Playlists Custom Scan Logitech Media Server Version: 7.7.3 - r33949 @ Tue May 1 02:01:18 PDT 2012 OS: Mac OS X 10.6.8 - EN - utf8 (although my Date/Time is set to German locale so that the script that updates iTunes runs properly -- this setting is not new) Platform: x86_64 Perl Version: 5.10.0 - darwin-thread-multi-2level Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1) This is the SQL for the playlist in Playlist Generator "Rated 8+ 90 days" wrote: > > select tracks.id from tracks > join multilibrary_track on > tracks.id=multilibrary_track.track and > multilibrary_track.library=3 > join track_statistics on > tracks.url=track_statistics.url > where > audio=1 > and (track_statistics.rating>=80) > and > ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-7776000) > group by tracks.id > order by random() > limit 5000 > Yes, I know the 5000 limit is high, but my system can handle it. ------------------------------------------------------------------------ prabbit's Profile: http://forums.slimdevices.com/member.php?userid=11142 View this thread: http://forums.slimdevices.com/showthread.php?t=49483 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
