Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;470417 Wrote: > Is this on Squeezebox Server 7.4.* ? > > If it is, the SQL looks like the old one used for 7.3.* and earlier. I > this case try to re-create the SQL Playlist playlist and see if it works > better. Yes, that was the problem. I refreshed the playlists and all is good. Thanks! -- diamar diamar's Profile: http://forums.slimdevices.com/member.php?userid=15809 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;471655 Wrote: > No, just misconfiguration and possibly unclear documentation. > > I'm guessing your Squeezebox Server music folder is set to > "\\TheMACServer\Music\Music" ? > It would probably have worked if that was set to the same place as > iTunes was, which means "\\TheMACServer\Music" which matches "Z:\" on > the iTunes computer. > > If the Squeezebox Server "Music Folder" doesn't match the iTunes music > folder you will always have to specify something in the "Music path in > Squeezebox Server" parameter to the "iTunes Statistics Import" scanning > module. Yes, my Squeezebox Server music folder is set to "\\TheMACServer\Music\Music". I do this because I didn't want Audiobook scanned which sit in "\\TheMACServer\Music\Audiobooks". Z:\ is indeed set to \\TheMACServer\Music (as I want the Audiobooks in iTunes). I understand now, thanks for the clarification and for fixing my issue! Cheers CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4.0 for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Chunkywizard;471463 Wrote: > > Does this point to a bug? > No, just misconfiguration and possibly unclear documentation. I'm guessing your Squeezebox Server music folder is set to "\\TheMACServer\Music\Music" ? It would probably have worked if that was set to the same place as iTunes was, which means "\\TheMACServer\Music" which matches "Z:\" on the iTunes computer. If the Squeezebox Server "Music Folder" doesn't match the iTunes music folder you will always have to specify something in the "Music path in Squeezebox Server" parameter to the "iTunes Statistics Import" scanning module. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;471423 Wrote: > How is the Custom Scan "iTunes Statistics Import" scanning module > configured ? > Specifically, what's the "Music path in Squeezebox Server" parameter > set to ? > > If you have left it empty or set it to "\\TheMACServer\Music\Music", > try to instead set it to "\\TheMACServer\Music". > > Does that solve your problems ? Hi erland, thanks for coming back. The Music path was empty. I have now configured it to \\TheMACServer\Music as suggested and will let you know how I get on. I just started a scan and it's taking a while which I think is a good sign (before it only took a minute). Thanks CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4.0 for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Chunkywizard;462331 Wrote: > I'm afraid it doesn't work. Server and scanner log attached, but I think > this is the problem: > > [09-09-29 07:49:12.5429] > Plugins::TrackStat::iTunes::Import::replace_problematic_url_chars (700) > original url was > file:TheMACServer/Music/Music/Music/The%20Script/The%20Script/05%20Breakeven.mp3 > [09-09-29 07:49:12.5434] > Plugins::TrackStat::iTunes::Import::normalize_location (690) normalized > file://localhost/Z:/Music/The%20Script/The%20Script/05%20Breakeven.mp3 > to > file:TheMACServer/Music/Music/Music/The%20Script/The%20Script/05%20Breakeven.mp3 > > [09-09-29 07:49:12.5464] > Plugins::TrackStat::iTunes::Import::handleTrack (424) file not found: > \\TheMACServer\Music\Music\Music\The Script\The Script\05 Breakeven.mp3 > > The path for my music is \\TheMACServer\Music\Music\Artist\Album\Song > > I have one too many musics in there! Looking at Basic Settings I have > set the Music Folder as \\TheMACServer\Music\Music which is correct. Is > this where Custom Scan gets the Music Folder from? Do you think it's the > double music that's causing the issue? I have this because my WHS has a > default Music directory and I have migrated to the new iTunes structure > (File:Library:Organise Library) which seperates out Music, Audiobooks > etc into new directories. > > Any help would be appreciated > > How is the Custom Scan "iTunes Statistics Import" scanning module configured ? Specifically, what's the "Music path in Squeezebox Server" parameter set to ? If you have left it empty or set it to "\\TheMACServer\Music\Music", try to instead set it to "\\TheMACServer\Music". Does that solve your problems ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
diamar;470256 Wrote: > I'm also having trouble getting SQL Playlists to play random tracks from > a static playlist. I tried the "test" suggestion quoted above, and > nothing showed up in the playlist. Here's the relevant debug information > from the log if it helps > Is this on Squeezebox Server 7.4.* ? If it is, the SQL looks like the old one used for 7.3.* and earlier. I this case try to re-create the SQL Playlist playlist and see if it works better. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;469195 Wrote: > Try goto the playlist in the SQL Playlist menu, select "Customize SQL", > hit the "Save" and then the "Test" button. Does it show any tracks or > errors when you hit "Test" ? > > Immediately after you have hit the "Test" button you can use the back > button in the web browser to get back to the previous page without > actually saving anything. I'm also having trouble getting SQL Playlists to play random tracks from a static playlist. I tried the "test" suggestion quoted above, and nothing showed up in the playlist. Here's the relevant debug information from the log if it helps: [09-10-10 11:29:03.9853] Plugins::DynamicPlayList::Plugin::cliPlayPlaylist (3651) Entering cliPlayPlaylist [09-10-10 11:29:03.9862] Plugins::DynamicPlayList::Plugin::cliPlayPlaylist (3689) Got: playlistid=sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:03.9869] Plugins::DynamicPlayList::Plugin::playRandom (402) playRandom called with type sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:03.9876] Plugins::DynamicPlayList::Plugin::getPlayList (793) Get playlist: sqlplaylist_after2005 [09-10-10 11:29:03.9892] Plugins::DynamicPlayList::Plugin::clearPlayListHistory (3993) Deleteting playlist history for player: WMT Transporter [09-10-10 11:29:04.0289] Plugins::DynamicPlayList::Plugin::getPlayList (793) Get playlist: sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:04.0297] Plugins::DynamicPlayList::Plugin::playRandom (448) Executing action: cli, customskip clearsecondaryfilter [09-10-10 11:29:04.0310] Plugins::DynamicPlayList::Plugin::playRandom (463) 0 songs remaining, songIndex = 0 [09-10-10 11:29:04.0317] Plugins::DynamicPlayList::Plugin::getPlayList (793) Get playlist: sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:04.0439] Plugins::DynamicPlayList::Plugin::findAndAdd (329) Starting random selection of 10 items for type: sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:04.0447] Plugins::DynamicPlayList::Plugin::getPlayList (793) Get playlist: sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:04.0455] Plugins::DynamicPlayList::Plugin::getTracksForPlaylist (3194) Calling: Plugins::SQLPlayList::Plugin with: sqlplaylist_randomplaylisttrackslinnjazz , 10 , 0 [09-10-10 11:29:04.0463] Plugins::DynamicPlayList::Plugin::getTracksForPlaylist (3212) Calling: Plugins::SQLPlayList::Plugin :: getNextDynamicPlayListTracks [09-10-10 11:29:04.0470] Plugins::SQLPlayList::Plugin::getNextDynamicPlayListTracks (1201) Getting tracks for: randomplaylisttrackslinnjazz [09-10-10 11:29:04.0477] Plugins::SQLPlayList::Plugin::getPlayList (143) Get playlist: randomplaylisttrackslinnjazz [09-10-10 11:29:04.0496] Plugins::SQLPlayList::Plugin::replaceParametersInSQL (888) Replacing 'PlaylistOffset' with 0 [09-10-10 11:29:04.0504] Plugins::SQLPlayList::Plugin::replaceParametersInSQL (888) Replacing 'PlaylistActiveLibrary' with 0 [09-10-10 11:29:04.0511] Plugins::SQLPlayList::Plugin::replaceParametersInSQL (888) Replacing 'PlaylistPlayer' with '00:04:20:10:08:04' [09-10-10 11:29:04.0519] Plugins::SQLPlayList::Plugin::replaceParametersInSQL (888) Replacing 'PlaylistLimit' with 10 [09-10-10 11:29:04.0536] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1004) Executing: select tracks.url from tracks join playlist_track on tracks.id=playlist_track.track and playlist_track.playlist=(select max(playlist) from playlist_track,tracks where playlist_track.playlist=tracks.id and tracks.title='Linn Jazz' group by playlist_track.playlist) left join track_statistics on tracks.url=track_statistics.url where audio=1 and ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-3600) group by tracks.id order by rand() limit 10; [09-10-10 11:29:04.1108] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1011) Executing and collecting: select tracks.url from tracks join playlist_track on tracks.id=playlist_track.track and playlist_track.playlist=(select max(playlist) from playlist_track,tracks where playlist_track.playlist=tracks.id and tracks.title='Linn Jazz' group by playlist_track.playlist) left join track_statistics on tracks.url=track_statistics.url where audio=1 and ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-3600) group by tracks.id order by rand() limit 10; [09-10-10 11:29:04.1115] Plugins::DynamicPlayList::Plugin::playRandom (605) Executing action: cli, customskip clearsecondaryfilter [09-10-10 11:29:04.1128] Plugins::DynamicPlayList::Plugin::cliPlayPlaylist (3696) Exiting cliPlayPlaylist [09-10-10 11:29:04.1353] Plugins::DynamicPlayList::Plugin::commandCallback65 (1781) Skipping playlist play dynamicplaylist://sqlplaylist_randomplaylisttrackslinnjazz [09-10-10 11:29:04.1408] Plugins::DynamicPlayList::Plugin::commandCallback65 (1786) received command dynamicplaylist playlist play [09-10-10 11:29:04.8552] Slim::Control::Request::execute (1918) Error: While trying to run function coderef [Slim::Control::Queries::statusQuery]: [Can't locate object method "isRemote" via package "Plugi
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
MeSue;469174 Wrote: > I can't get any dynamic playlists that are based on static playlists to > work anymore. For instance, I have a static playlist called Fast > Favorites. When I attempt to play this as a random dynamic playlist, > either from the Dynamic Playlists menu, or SQL Playlists menu, I just > get a "failed" message. I turned on logging for dynamic playlists and > sql playlists, but the only thing logged is that it received the command > for it to play. The failure does nto seem to be logged. I have tried > starting it from the WebUI, from a squeezeplay based player, and from > the classic player UI, and it fails every which way. > Try goto the playlist in the SQL Playlist menu, select "Customize SQL", hit the "Save" and then the "Test" button. Does it show any tracks or errors when you hit "Test" ? Immediately after you have hit the "Test" button you can use the back button in the web browser to get back to the previous page without actually saving anything. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
I can't get any dynamic playlists that are based on static playlists to work anymore. For instance, I have a static playlist called Fast Favorites. When I attempt to play this as a random dynamic playlist, either from the Dynamic Playlists menu, or SQL Playlists menu, I just get a "failed" message. I turned on logging for dynamic playlists and sql playlists, but the only thing logged is that it received the command for it to play. The failure does nto seem to be logged. I have tried starting it from the WebUI, from a squeezeplay based player, and from the classic player UI, and it fails every which way. -- MeSue SUE 1 Duet | 2 Booms | 1 Radio (beta) | 1 Touch (beta) | 1 SB2 HP MediaSmart EX470 | Squeezebox Server 7.4 Find me on 'Last.FM' (http://www.last.fm/user/MeSue) | 'Twitter' (http://twitter.com/suechastain) MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Chunkywizard;462331 Wrote: > I'm afraid it doesn't work. Server and scanner log attached, but I think > this is the problem: > > [09-09-29 07:49:12.5429] > Plugins::TrackStat::iTunes::Import::replace_problematic_url_chars (700) > original url was > file:TheMACServer/Music/Music/Music/The%20Script/The%20Script/05%20Breakeven.mp3 > [09-09-29 07:49:12.5434] > Plugins::TrackStat::iTunes::Import::normalize_location (690) normalized > file://localhost/Z:/Music/The%20Script/The%20Script/05%20Breakeven.mp3 > to > file:TheMACServer/Music/Music/Music/The%20Script/The%20Script/05%20Breakeven.mp3 > > [09-09-29 07:49:12.5464] > Plugins::TrackStat::iTunes::Import::handleTrack (424) file not found: > \\TheMACServer\Music\Music\Music\The Script\The Script\05 Breakeven.mp3 > > The path for my music is \\TheMACServer\Music\Music\Artist\Album\Song > > I have one too many musics in there! Looking at Basic Settings I have > set the Music Folder as \\TheMACServer\Music\Music which is correct. Is > this where Custom Scan gets the Music Folder from? Do you think it's the > double music that's causing the issue? I have this because my WHS has a > default Music directory and I have migrated to the new iTunes structure > (File:Library:Organise Library) which seperates out Music, Audiobooks > etc into new directories. > > Any help would be appreciated > > CW Hi erland, I have upgraded to Trackstat 2.9.1 and I'm still seeing this. My server.log is attached but basically all of my new music has the path incorrectly specified and so is being missed by the scan. By the way, there is one slight change and that is existing ratings are now not wiped and survive the Custom Scan scan. Any other tests you want me to run? By the way, I continued the conversation in this thread, is that o.k. or do you want me to move it to the up to date TrackStat thread? Cheers CW +---+ |Filename: server.log | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=8372| +---+ -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4.0 for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
thing-fish;467866 Wrote: > > I have a question on a different plugin though Erland: in 7.4, Database > Query is not letting me create new queries. That is to say, there is a > list of queries, but no means to make new ones. I do note that in the > plugin settings dialog for Database Query, there is a value for Data > queries directory but no value for Data queries templates directory. > What should go there, and is that the problem with not being able to > make new queries? Not that when I copy 7.3 files (which I backed up) > into the data queries directly, they do show up in the query list, but > there's no way to do it through the web interface. > That's a bug, thanks for reporting. To temporary solve it you can create a new query in the "Classic" skin, for example by temporary open the browser towards: http://localhost:9000/classic/ (assuming Squeezebox Server was installed on the local computer, else change the "localhost" to the IP-adress or computer name where, it's installed) -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;463759 Wrote: > Yes, make sure you've taken a backup of the TrackStat data from inside > TrackStat settings page in SqueezeCenter 7.3 before you upgrade. I think > the backup has always worked, but just to be sure you can open the > backup file in a text editor to verify that it seems to contain data. > > After the upgrade you just point the "Backup file" parameter in > TrackStat settings to the full path to your backup file and hit the > "Restore from file" button. Look in the server.log file, you will get > one message when it starts the restore and a second message when it has > finished. The restore runs in background and can take some time, in my > small 3000 tracks library it took a few minutes. Thank you for this! One additional tip to anyone making the plunge: if you have to rescan your library for 7.4, import your trackstats AFTER the rescan. Like Erland I'm running Ubuntu and completely purged 7.3 before I upgraded, so I had to rescan my tracks. When I imported my trackstat file first it ran really slow and was filling the log with: Code: Plugins::TrackStat::Storage::saveTrack (977) No matching alternative path found for file:(my file path) I restarted the server, let the rescan finish, THEN imported my trackstat, and it was great. I have a question on a different plugin though Erland: in 7.4, Database Query is not letting me create new queries. That is to say, there is a list of queries, but no means to make new ones. I do note that in the plugin settings dialog for Database Query, there is a value for Data queries directory but no value for Data queries templates directory. What should go there, and is that the problem with not being able to make new queries? Not that when I copy 7.3 files (which I backed up) into the data queries directly, they do show up in the query list, but there's no way to do it through the web interface. Thanks again! -- thing-fish ' Most Recent Tracks' (http://www.last.fm/user/thing-fish/?chartstyle=basicrt10) thing-fish's Profile: http://forums.slimdevices.com/member.php?userid=5288 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Chunkywizard;462331 Wrote: > I'm afraid it doesn't work. Server and scanner log attached, but I think > this is the problem: > > [09-09-29 07:49:12.5429] > Plugins::TrackStat::iTunes::Import::replace_problematic_url_chars (700) > original url was > file:TheMACServer/Music/Music/Music/The%20Script/The%20Script/05%20Breakeven.mp3 > [09-09-29 07:49:12.5434] > Plugins::TrackStat::iTunes::Import::normalize_location (690) normalized > file://localhost/Z:/Music/The%20Script/The%20Script/05%20Breakeven.mp3 > to > file:TheMACServer/Music/Music/Music/The%20Script/The%20Script/05%20Breakeven.mp3 > > [09-09-29 07:49:12.5464] > Plugins::TrackStat::iTunes::Import::handleTrack (424) file not found: > \\TheMACServer\Music\Music\Music\The Script\The Script\05 Breakeven.mp3 > > The path for my music is \\TheMACServer\Music\Music\Artist\Album\Song > > I have one too many musics in there! Looking at Basic Settings I have > set the Music Folder as \\TheMACServer\Music\Music which is correct. Is > this where Custom Scan gets the Music Folder from? Do you think it's the > double music that's causing the issue? I have this because my WHS has a > default Music directory and I have migrated to the new iTunes structure > (File:Library:Organise Library) which seperates out Music, Audiobooks > etc into new directories. > > Any help would be appreciated > > CW Hi erland, did you get anywhere with this? I have now got ratings back using a backup but I would like to sync iTunes and TrackStat every night to import new music ratings. If you need any further information or have any ideas of things to try let me know CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4.0 for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
thing-fish;463743 Wrote: > Well, that is awesome and thank you for the quick reply! I assume that > we just use the trackstat export functions from the old version and > then, after 7.4 is configured, import them back in? > Yes, make sure you've taken a backup of the TrackStat data from inside TrackStat settings page in SqueezeCenter 7.3 before you upgrade. I think the backup has always worked, but just to be sure you can open the backup file in a text editor to verify that it seems to contain data. After the upgrade you just point the "Backup file" parameter in TrackStat settings to the full path to your backup file and hit the "Restore from file" button. Look in the server.log file, you will get one message when it starts the restore and a second message when it has finished. The restore runs in background and can take some time, in my small 3000 tracks library it took a few minutes. Also, please note that depending on how good the Squeezebox Server upgrade works it may not even discard your old TrackStat data. However, in my case on Ubuntu linux, I lost all settings and the database contents in the automatic upgrade. It didn't delete the files, so I was able to copy all old setting files manually to restore my settings. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
thing-fish;463743 Wrote: > Well, that is awesome and thank you for the quick reply! I assume that > we just use the trackstat export functions from the old version and > then, after 7.4 is configured, import them back in? As far as I know. I can't remember if I had to restore from backup or not. I converted to 7.4 long ago. -- MeSue SUE 1 Duet | 2 Booms | 1 Radio (beta) | 1 Touch (beta) | 1 SB2 HP MediaSmart EX470 | Squeezebox Server 7.4 Find me on 'Last.FM' (http://www.last.fm/user/MeSue) | 'Twitter' (http://twitter.com/suechastain) MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
MeSue;463709 Wrote: > He announced non-beta versions yesterday. See > http://forums.slimdevices.com/showpost.php?p=462304&postcount=281 Well, that is awesome and thank you for the quick reply! I assume that we just use the trackstat export functions from the old version and then, after 7.4 is configured, import them back in? -- thing-fish ' Most Recent Tracks' (http://www.last.fm/user/thing-fish/?chartstyle=basicrt10) thing-fish's Profile: http://forums.slimdevices.com/member.php?userid=5288 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
thing-fish;463695 Wrote: > > And that means, until Erland's plugins are out of beta for 7.4 and > there's rock-solid instructions on how to maintain the track statistics > between versions, there is NO WAY I am upgrading to 7.4. He announced non-beta versions yesterday. See http://forums.slimdevices.com/showpost.php?p=462304&postcount=281 -- MeSue SUE 1 Duet | 2 Booms | 1 Radio (beta) | 1 Touch (beta) | 1 SB2 HP MediaSmart EX470 | Squeezebox Server 7.4 Find me on 'Last.FM' (http://www.last.fm/user/MeSue) | 'Twitter' (http://twitter.com/suechastain) MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
So I normally upgrade to new versions of "the server" as soon as they're released, but a while back I installed SQL Playlist and am having so much fun with it that it has become essential to my daily listening (I stream to Softsqueeze or Squeezeplay from home to work, all day). Using SQL Playlist I wrote a SQL query that would play me every song in my collection with no repeats, then using Database Query wrote a query that let me know I'm 63% of the way through my collection with 6242 songs left, and that it would take 19.42 days of continuous playing to get through them. This is FUN hearing every single song, and seeing the progress. And that means, until Erland's plugins are out of beta for 7.4 and there's rock-solid instructions on how to maintain the track statistics between versions, there is NO WAY I am upgrading to 7.4. It has also caused me to send a donation to Erland just now, because I'm not sure if I've done so before and I wanted to show my appreciation. Also: I recently tweaked my SQL playlist (and added a cron job) to include a five minute NPR news update every two hours and The Onion Radio News once a day. I was hoping to spiff those up and release them back to the community; now I'll wait until I find out if SQL Lite has equivalent XML handling as mySQL. I didn't know they were changing databases :( -- thing-fish ' Most Recent Tracks' (http://www.last.fm/user/thing-fish/?chartstyle=basicrt10) thing-fish's Profile: http://forums.slimdevices.com/member.php?userid=5288 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;463498 Wrote: > You will need to specify the full path to the file you like to restore > in the TrackStat settings page MeSue refers to and then click the > restore button. The restore runs in background, you will see an entry in > the server.log file when it's finished. It took a few minutes in my 3000 > track library so in a larger library it might take a while. Thanks erland! I was doing everything right, but I didn't estimate the time it takes to restore correctly :-) I thought it would take 1-2 minutes, but for my library (over 11000 tracks) it took awhile :-) So I thought it was hanging It eventually worked out beautifully! Great job with that built-in backup! Thank you! -- el_jefe el_jefe's Profile: http://forums.slimdevices.com/member.php?userid=32427 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
el_jefe;463424 Wrote: > O > However, I can't restore them somehow I'll keep trying. > You will need to specify the full path to the file you like to restore in the TrackStat settings page MeSue refers to and then click the restore button. The restore runs in background, you will see an entry in the server.log file when it's finished. It took a few minutes in my 3000 track library so in a larger library it might take a while. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
OK - this was a stupid question, sorry. Turns out I did have automatic backup enabled and I do have 20-30 XML backup files! YAY!!! However, I can't restore them somehow I'll keep trying. Thanks for the help! -- el_jefe el_jefe's Profile: http://forums.slimdevices.com/member.php?userid=32427 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
el_jefe;463407 Wrote: > Where would those backups be? How would they look like (names, > extensions)? > It's in the Trackstat settings under Backup/Restore/Clear. You would have had to set the location and time for the backups. Then they are saved daily as an XML wherever you specify. Mine are called trackstat_scheduled_backup_20090930.xml and so on. -- MeSue SUE 1 Duet | 2 Booms | 1 Radio (beta) | 1 Touch (beta) | 1 SB2 HP MediaSmart EX470 | Squeezebox Server 7.4 Find me on 'Last.FM' (http://www.last.fm/user/MeSue) | 'Twitter' (http://twitter.com/suechastain) MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
MeSue;463377 Wrote: > Are you sure you never configured the automatic Trackstat backups? If > not, I would think you're out of luck, but Erland would know better. > > Oh, one other idea... If you ever used the iTunes or MusicIP stats > export, you might be able to import it back from there. It might not > have all the historical info, but it would be better than nothing. Thank you for the quick reply! I don't remember doing it, but it's one of those things I would have definitely done if I saw it somewhere in the menus... Where would those backups be? How would they look like (names, extensions)? Thanks for the help! -- el_jefe el_jefe's Profile: http://forums.slimdevices.com/member.php?userid=32427 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
el_jefe;463215 Wrote: > Hi guys! > > > I have a quick question. I looked around the forum and I didn't find a > better place to post it, so please excuse me if it is the wrong > place... > > I just did something stupid. I had no idea that I had to backup my > trackstat data before upgrading from 7.3.3 to 7.4 and I just installed > 7.4. Needless to say, I lost all my data. > > My question is: is there any way to bring back the data (e.g. ratings, > last played stats etc.). I tried reinstalling 7.3.3 in its old folder > and rescanning, but it didn't work :( > > > Thanks! Are you sure you never configured the automatic Trackstat backups? If not, I would think you're out of luck, but Erland would know better. -- MeSue SUE 1 Duet | 2 Booms | 1 Radio (beta) | 1 Touch (beta) | 1 SB2 HP MediaSmart EX470 | Squeezebox Server 7.4 Find me on 'Last.FM' (http://www.last.fm/user/MeSue) | 'Twitter' (http://twitter.com/suechastain) MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Hi guys! I have a quick question. I looked around the forum and I didn't find a better place to post it, so please excuse me if it is the wrong place... I just did something stupid. I had no idea that I had to backup my trackstat data before upgrading from 7.3.3 to 7.4 and I just installed 7.4. Needless to say, I lost all my data. My question is: is there any way to bring back the data (e.g. ratings, last played stats etc.). I tried reinstalling 7.3.3 in its old folder and rescanning, but it didn't work :( Thanks! -- el_jefe el_jefe's Profile: http://forums.slimdevices.com/member.php?userid=32427 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;461969 Wrote: > Correction, there is a template available. Just goto SQL Playlist and > create a new playlist of the type "Random songs" and specify the library > with the "Library" parameter in the settings for this playlist. Thanks for getting back to me. I actually managed to get each library to play shuffled songs simply by using the "shuffle song" command already present in the settings function of my Controller, as well as the web browser interface. I will, however, check out the other plug-ins you mentioned. -- brucesee brucesee's Profile: http://forums.slimdevices.com/member.php?userid=10260 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
I'm afraid it doesn't work. Server and scanner log attached, but I think this is the problem: [09-09-29 07:49:12.5429] Plugins::TrackStat::iTunes::Import::replace_problematic_url_chars (700) original url was file:TheMACServer/Music/Music/Music/The%20Script/The%20Script/05%20Breakeven.mp3 [09-09-29 07:49:12.5434] Plugins::TrackStat::iTunes::Import::normalize_location (690) normalized file://localhost/Z:/Music/The%20Script/The%20Script/05%20Breakeven.mp3 to file:TheMACServer/Music/Music/Music/The%20Script/The%20Script/05%20Breakeven.mp3 [09-09-29 07:49:12.5464] Plugins::TrackStat::iTunes::Import::handleTrack (424) file not found: \\TheMACServer\Music\Music\Music\The Script\The Script\05 Breakeven.mp3 The path for my music is \\TheMACServer\Music\Music\Artist\Album\Song I have one too many musics in there! Looking at Basic Settings I have set the Music Folder as \\TheMACServer\Music\Music which is correct. Is this where Custom Scan gets the Music Folder from? Do you think it's the double music that's causing the issue? I have this because my WHS has a default Music directory and I have migrated to the new iTunes structure (File:Library:Organise Library) which seperates out Music, Audiobooks etc into new directories. Any help would be appreciated CW +---+ |Filename: server.log | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=8218| +---+ -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-28xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Hi erland, just updating to 7.4.0 and the new releases of your plug ins then I'll get you some debug (or hopefully report it all works now!) CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-28xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Chunkywizard;462016 Wrote: > > thanks for looking at this for me. I've attached the a snippet of my > library. If you need any more let me know and I'll upload my library to > the area of my WHS you have access to. > Could you try to enable logging on "plugin.trackstat" and then run an import and post the Squeezebox Server server.log file ? If you see some suspect errors in the log, it's enough if you copy the error message and 100 rows before and after it. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;461970 Wrote: > It would be great if you could mail me your iTunes Library.xml file or > if it's large just mail me the first 100 rows or something similar. Hi erland, thanks for looking at this for me. I've attached the a snippet of my library. If you need any more let me know and I'll upload my library to the area of my WHS you have access to. Cheers CW +---+ |Filename: iTunes Library snippet.txt | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=8213| +---+ -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-28xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Chunkywizard;459978 Wrote: > Further to my last message I have revised my theory! I went back to an > old 7.4 and it didn't fix the issues. What I think now is my move to > iTunes9 stopped customscan working. It wasn't immediately obvious as I > think the imported ratings were cached until the new database in a > recent 7.4 cleared my ratings. Does that sound feasible? If so, can you > add in support for iTunes9? If you need any info from my iTunes Library > just shout. > > It would be great if you could mail me your iTunes Library.xml file or if it's large just mail me the first 100 rows or something similar. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;461128 Wrote: > > brucesee;460445 Wrote: > > Hi Erland: > > > > I'm using your multi-library plug in (7.4 beta version) to create > > separate libraries, 1 of my music, 1 of my wife's. I've also installed > > the 7.4 beta version of custom browse. Is it possible to shuffle or use > > random play w/in each separate library? If so, how? Thanks. > > > > > > You will need SQL Playlist and Dynamic Playlist plugins to do this. > However, I don't think there is a predefined template available yet, > so you may have to customize the SQL from a suitable playlist to > accomplish it. > Correction, there is a template available. Just goto SQL Playlist and create a new playlist of the type "Random songs" and specify the library with the "Library" parameter in the settings for this playlist. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
brucesee;460445 Wrote: > Hi Erland: > > I'm using your multi-library plug in (7.4 beta version) to create > separate libraries, 1 of my music, 1 of my wife's. I've also installed > the 7.4 beta version of custom browse. Is it possible to shuffle or use > random play w/in each separate library? If so, how? Thanks. > You will need SQL Playlist and Dynamic Playlist plugins to do this. However, I don't think there is a predefined template available yet, so you may have to customize the SQL from a suitable playlist to accomplish it. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Hi Erland: I'm using your multi-library plug in (7.4 beta version) to create separate libraries, 1 of my music, 1 of my wife's. I've also installed the 7.4 beta version of custom browse. Is it possible to shuffle or use random play w/in each separate library? If so, how? Thanks. -- brucesee brucesee's Profile: http://forums.slimdevices.com/member.php?userid=10260 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Further to my last message I have revised my theory! I went back to an old 7.4 and it didn't fix the issues. What I think now is my move to iTunes9 stopped customscan working. It wasn't immediately obvious as I think the imported ratings were cached until the new database in a recent 7.4 cleared my ratings. Does that sound feasible? If so, can you add in support for iTunes9? If you need any info from my iTunes Library just shout. Cheers CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-28xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Hi Erland, it seems the last couple of 7.4 builds seem to have broken the latest custom scan. I think I remember someone saying the scan has changed in the last couple of builds which is probably the reason. If you need any debug info just let me know. Also one of my dynamic playlists seems to have stopped working (I get a failed message). I'll dig up some debug for that as well. Cheers CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-28xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Sorry, this is very pedantic. But this letter is not recognized by CustomBrowse: http://en.wikipedia.org/wiki/%C5%BB The polish composer Grażyna Bacewicz is displayed as Grażyna Bacewic. I have not experienced other issues with non-ascii characters. cheers Quad -- Quad CD => EAC => FLAC => SC 7.3.4 => SB Duet => DacMagic => Quad gear Quad's Profile: http://forums.slimdevices.com/member.php?userid=20234 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Hi Erland, > Is comment sub tags used by any standard tagging software Yes and no.. I'm using Picard QT to tag mostly MP3 with MusicBrainz tags. I also use MusicIP to create PUIDs. Picard has some plugins, one of them bringing in data from LastFM. This includes categories, grouping, occasions, country & decades. I've started to tag my music with ID3.2 2.4 so that I can start using moods and occasions.natively. I'll PM you a file. Although I'm not sure how common this method of custom tagging is. I'm still fairly new to the whole tagging thing and still trying to wade through all the different versions/types. -- BodgeIT Whether you think you can or you think you can't, either way you are right! *SS*(7.4 - r28304) on *WHS SP2*(VMWare 1.8 Device(No Sound Card)) *Slimp3*(FW 2.3), *Receiver*(FW 65) & *Controller*(7.4.0 r7307). BodgeIT's Profile: http://forums.slimdevices.com/member.php?userid=17100 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
BodgeIT;453924 Wrote: > T > I've assumed the custom tag module can scan Comment Subvalues. > > I've added a Tag-To Be-Scanned as comment:Songs-DB_Custom1 > The actual Tag Frame is COMM:Songs-DB_Custom1 > > I've added a Tag Mapping as ORIGYEAR=comment:Songs-DB_Custom1 > > If my assumption is correct, is this how it's intended to work? > No, I don't think it works with comment sub values. It does work with TXXX custom tags, which is created by most tagging softwares if you enter a custom tag name that's not it predefined list of available tags. I assume you are taking about MP3 files ? Is comment sub tags used by any standard tagging software or is this a tagging scheme you have made up yourself ? If it's a standard way of tagging which many people use it might be worth to consider adding support for it in Custom Scan, but in that case I need a file to look at so I can see how the comment tags look like. There are some setup examples in the Custom Scan wiki page referred from step 4 in the installation section, but you have probably already seen these: http://wiki.slimdevices.com/index.php/Custom_Scan_plugin -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Erland Wrote: > I'll add it to the list, but I can't promise it will be added anytime > soon. Thanks for that Erland, happy to wait...may even try and dig in myself when things die down a bit here. I'm also working on the new Custom Scan. I've made an assumption, can you please confirm it for me? I've assumed the custom tag module can scan Comment Subvalues. I've added a Tag-To Be-Scanned as comment:Songs-DB_Custom1 The actual Tag Frame is COMM:Songs-DB_Custom1 I've added a Tag Mapping as ORIGYEAR=comment:Songs-DB_Custom1 If my assumption is correct, is this how it's intended to work? -- BodgeIT Whether you think you can or you think you can't, either way you are right! *SS*(7.4 - r28304) on *WHS SP2*(VMWare 1.8 Device(No Sound Card)) *Slimp3*(FW 2.3), *Receiver*(FW 65) & *Controller*(7.4.0 r7307). BodgeIT's Profile: http://forums.slimdevices.com/member.php?userid=17100 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
BodgeIT;453731 Wrote: > Hi Erland, > Feature request for the database query plugin: > Can you provide a scroll bar at the bottom of the results view to > enable scrolling left/right? > I'll add it to the list, but I can't promise it will be added anytime soon. However, if you don't want to wait you can use the Classic or Fishbone skin which a believe already provides the scrollbar. I'm not sure if it's a bug in the plugin or in the SqueezeCenter skin code for the Default skin. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Hi Erland, Feature request for the database query plugin: Can you provide a scroll bar at the bottom of the results view to enable scrolling left/right? -- BodgeIT Whether you think you can or you think you can't, either way you are right! *SS*(7.4 - r28304) on *WHS SP2*(VMWare 1.8 Device(No Sound Card)) *Slimp3*(FW 2.3), *Receiver*(FW 65) & *Controller*(7.4.0 r7307). BodgeIT's Profile: http://forums.slimdevices.com/member.php?userid=17100 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Erland-- you may already know, but the new context menu behavior of the Controller does not work in Custom Browse menus. I can still do add next since they haven't changed the long hold on + behavior, and I can play (replacing playlist), but currently I don't see any way to add to the end of a playlist from a custom browse menu. Controller r7158 Server 7.4 - r28225 -- MeSue Sue http://www.last.fm/user/MeSue MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;448934 Wrote: > > The ones in the beta repository mentioned in the initial post in this > thread should work with 7.4, there are still some bugs though. The beta > repository has to be configured manually in the "Plugins" tab. Thanks, works fine for me. Although I only use the Multi-library functionality (based on paths). -- bhaagensen bhaagensen's Profile: http://forums.slimdevices.com/member.php?userid=7418 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Do you want errors here or as a bug report? I post it here now, please let me know if I should file a bug instead. I have some playlists created with SQL Playlists that does not work: Error: FUNCTION slimserver.random does not exist Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: FUNCTION slimserver.random does not exist [for Statement "select tracks.url from tracks join track_statistics on tracks.url=track_statistics.url join genre_track on tracks.id=genre_track.track join genres on genre_track.genre=genres.id and genre_track.genre=16 left join dynamicplaylist_history on tracks.id=dynamicplaylist_history.id and dynamicplaylist_history.client='80:00:60:0f:e8:00' where audio=1 and dynamicplaylist_history.id is null and (track_statistics.rating>=60) group by tracks.id order by random() limit 10;"] at /Slim/Schema/Storage.pm line 86 The playlist should play unrated tracks from a specific genre not played last week. -- mariowing SqueezeCenter on Windows Home Server. Duet in living rom, Boom in bathroom and home office, Classic v3 in hometheater. SqueezePlay at work, connected through Hamachi VPN. iTunes integration through Erlands Custom Scan. mariowing's Profile: http://forums.slimdevices.com/member.php?userid=22779 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
bhaagensen;448933 Wrote: > erland, > > since the sqlite-changes where backed out from 7.4, does any of your > plugins (multi-library in particular) work with the current nightly > debian builds of 7.4? Which? Are they available through the > extension-downloader? > The ones in the officially Extension Downloader repository only works with 7.3. The ones in the beta repository mentioned in the initial post in this thread should work with 7.4, there are still some bugs though. The beta repository has to be configured manually in the "Plugins" tab. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland, since the sqlite-changes where backed out from 7.4, does any of your plugins (multi-library in particular) work with the current nightly debian builds of 7.4? Which? Are they available through the extension-downloader? Thanks, Bjørn -- bhaagensen bhaagensen's Profile: http://forums.slimdevices.com/member.php?userid=7418 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
That's right. Maybe updating SbS made the difference, or it was just a fluke. I'll keep monitoring... -- MeSue Sue http://www.last.fm/user/MeSue MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
MeSue;447378 Wrote: > > Yesterday, I changed my scheduled Squeezebox server scan to run at 5 AM > instead of 6. The custom scan finished at about 8:15 according to the > log, and MusicIP Statistics Export was not still running when I got to > the computer about 10. So that is more reasonable. > So the slow scan times are not reproducible ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
No, I don't think I was playing music yesterday while the rating scan was running. I did play music later when the rating scan had finished but the MusicIP export was still running. Yesterday, I changed my scheduled Squeezebox server scan to run at 5 AM instead of 6. The custom scan finished at about 8:15 according to the log, and MusicIP Statistics Export was not still running when I got to the computer about 10. So that is more reasonable. -- MeSue Sue http://www.last.fm/user/MeSue MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
MeSue;447277 Wrote: > I tend to think it is something in the recently nightlies, because it > was running fine before I updated SC from 26558 to 28091 and I've had a > lot of performance issues in general with the builds since they switched > back to mySQL. I'm real close to reverting again. > > Custom Rating Scan did finally finish at around 1 PM this afternoon, > but MusicIP Statistics Export has been running all day. It still shows > running at almost 10 PM now, and it has been like that all day. I have > it set to dynamically update, but I don't think it used to show as > "running" all the time in the manage scanning screen of custom scan. > Did you play music during the scanning ? If you did, has that also been the case before ? I'm asking since I know the Custom Scan scanning can get a lot slower if the server is doing something else during the time. Custom Scan tries to hand over the control to the server to let it stream music between each scanned track to avoid interrupting the playback during the scanning. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
I tend to think it is something in the recently nightlies, because it was running fine before I updated SC from 26558 to 28091 and I've had a lot of performance issues in general with the builds since they switched back to mySQL. I'm real close to reverting again. Custom Rating Scan did finally finish at around 1 PM this afternoon, but MusicIP Statistics Export has been running all day. It still shows running at almost 10 PM now, and it has been like that all day. I have it set to dynamically update, but I don't think it used to show as "running" all the time in the manage scanning screen of custom scan. I'll enable the logging and see how it does tomorrow. -- MeSue Sue http://www.last.fm/user/MeSue MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
MeSue;447183 Wrote: > Custom Scan Rating Tag module takes s long now (7.4-28091). My > nightly scan for new and changed happens at 6 AM every day. That > triggers a custom scan for ratings. I'm not sure when it started, but it > is almost noon and it's still going. > Could you enable debugging on plugin.customscan and see in the server.log if it seems to process files or if it's stuck somewhere before it has started to process files or after it has processed all files. It's strange if it has gotten slower because if I remember correctly I haven't done any big changes in the beta versions related to the scanning logic. MeSue;447183 Wrote: > > Is there any way a rating tag scan can be set to only look at new and > changed files? > Not at the moment, it requires this enhancement request to make it possible to implement a reliable solution: https://bugs.slimdevices.com/show_bug.cgi?id=6023 -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Custom Scan Rating Tag module takes s long now (7.4-28091). My nightly scan for new and changed happens at 6 AM every day. That triggers a custom scan for ratings. I'm not sure when it started, but it is almost noon and it's still going. Is there any way a rating tag scan can be set to only look at new and changed files? -- MeSue Sue http://www.last.fm/user/MeSue MeSue's Profile: http://forums.slimdevices.com/member.php?userid=985 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;443720 Wrote: > I suspect it was caused by a bug I corrected yesterday. I'll try to > release a new version with the latest corrections during the next day or > two. It works in 2.7 pre3 - GREAT :-) -- mariowing SqueezeCenter on Windows Home Server. Squeezebox Duet in living rom, Squeezebox Boom in bathroom and home office. SqueezePlay at work, connected through Hamachi VPN. iTunes integration through Erlands Custom Scan. mariowing's Profile: http://forums.slimdevices.com/member.php?userid=22779 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Just to confirm, I upgraded SQLPlaylist, then installed 28002 and rebooted after that was installed. So it sounds like there is a bug somewhere! Thanks for the clarification, CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-27xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 | SettingsManager 2.1.12 | SyncOptions 2.1.24 | AutoDimDisplay 2.1.7 | Biography 2.7.0 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Chunkywizard;445309 Wrote: > Maybe this refresh can be done automatically in future releases to avoid > problems? > It's supposed to happen automatically when you restart SqueezeCenter the first time after you've installed a new version of SQLPlaylist. I guess there is bug somewhere that's waiting to be corrected if this doesn't work. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Hi erland, thanks for the help. I didn't edit the SQL manual (just through Extras)and I do have MySQL installed correctly. Your suggest of refreshing the playlists under the Extras menu did the trick, they now work perfectly. Thanks! Maybe this refresh can be done automatically in future releases to avoid problems? Anyway, just my 'missing track ratings for songs with single quotes in' bug to go ;-D Thanks for all your help CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-27xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 | SettingsManager 2.1.12 | SyncOptions 2.1.24 | AutoDimDisplay 2.1.7 | Biography 2.7.0 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;445298 Wrote: > Thanks, the important part here is the last row: "no such function: > if". > > It will be fixed in next version and it will also be fixed when you > switch to MySQL as MySQL has an if function. Ah. It's been a while since I learned SQL and actually the only time I used it in recent years was with MySQL. -- pippin --- see iPeng, the Squeezebox iPhone remote, at penguinlovesmusic.com pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Chunkywizard;445295 Wrote: > Hi erland, > > I also tried my Dynamic Playlists in the hope that they were fixed, but > they still failed. Server.log with debug is attached > Have you customized the playlist and edited the SQL manually ? If you have, you will need to replace random() with rand(), or alternatively re-create the playlist from the template and this will happen automatically. If you haven't customized the playlist and when you select to edit the playlist you see the different options where you can select genres and the other options and not raw SQL, this is strange. In that case, I'd like you to: 1. Restart Squeezebox Server unless you have already done so and see if it solves the problem. 2. Look in the "Information" tab in Squeezebox Server Settings and see if it lists a MySQL version under the section "Squeezebox Server Status". If doesn't list a MySQL version there is something wrong with your installation, I'm then suspecting it still uses SQLite. 3. Goto "Extras/SQL Playlist" and hit the "Refresh playlists" link at the bottom and see if it solves the problem. Please report back if anyone of these steps solved your problem. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
pippin;445218 Wrote: > All interfaces. > In the Web Interface I get > > Code: > > > Error: > Running: select albums.id,if(albums.year=0,' ',concat('(',albums.year,')')) from tracks join albums on albums.id=tracks.album left join track_statistics on tracks.url=track_statistics.url where tracks.audio=1 group by albums.id order by max(track_statistics.added) desc got error: > no such function: if > > > > That's for "New Albums" from the default menu list. > Thanks, the important part here is the last row: "no such function: if". It will be fixed in next version and it will also be fixed when you switch to MySQL as MySQL has an if function. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Hi erland, I also tried my Dynamic Playlists in the hope that they were fixed, but they still failed. Server.log with debug is attached HTH CW +---+ |Filename: server.log | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=7903| +---+ -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-27xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 | SettingsManager 2.1.12 | SyncOptions 2.1.24 | AutoDimDisplay 2.1.7 | Biography 2.7.0 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;445172 Wrote: > I'm not completely sure but I don't think this correction is the > solution to your problem. > The corrected problem was caused by a change introduced in the SQLite > version of SqueezeCenter 7.4 and it was merged back to the MySQL version > a few days ago. Hi erland. I got the itch and upgraded to 7.4-28002 and the latest versions of your plug ins. I can confirm my bug is still present. Sorry CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-27xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 | SettingsManager 2.1.12 | SyncOptions 2.1.24 | AutoDimDisplay 2.1.7 | Biography 2.7.0 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;445186 Wrote: > Is it just in iPeng or also in web interface and the other user > interfaces ? > Do you get any errors in the server.log file when you enter a menu that > doesn't work ? All interfaces. In the Web Interface I get Code: Error: Running: select albums.id,if(albums.year=0,' ',concat('(',albums.year,')')) from tracks join albums on albums.id=tracks.album left join track_statistics on tracks.url=track_statistics.url where tracks.audio=1 group by albums.id order by max(track_statistics.added) desc got error: no such function: if That's for "New Albums" from the default menu list. -- pippin --- see iPeng, the Squeezebox iPhone remote, at penguinlovesmusic.com pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
pippin;445179 Wrote: > Erland, > > most of my menus still don't work. Predefined as well as own ones. > Is it just in iPeng or also in web interface and the other user interfaces ? Do you get any errors in the server.log file when you enter a menu that doesn't work ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Erland, most of my menus still don't work. Predefined as well as own ones. I'm now about to switch back to MySQL so let's see what happens then. -- pippin --- see iPeng, the Squeezebox iPhone remote, at penguinlovesmusic.com pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Chunkywizard;445143 Wrote: > Ooh, is that 'my' (http://forums.slimdevices.com/showthread.php?t=61055) > bug you are talking about? I would load up straight away but I'm still a > bit fearful of the 7.4 switch back to MySQL which seems to be a bit > flaky at the mo. If someone can convince me the latest 7.4 nightly > actually works I'll test these ASAP. > I'm not completely sure but I don't think this correction is the solution to your problem. The corrected problem was caused by a change introduced in the SQLite version of SqueezeCenter 7.4 and it was merged back to the MySQL version a few days ago. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Ooh, is that 'my' (http://forums.slimdevices.com/showthread.php?t=61055) bug you are talking about? I would load up straight away but I'm still a bit fearful of the 7.4 switch back to MySQL which seems to be a bit flaky at the mo. If someone can convince me the latest 7.4 nightly actually works I'll test these ASAP. Cheers CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-27xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 | SettingsManager 2.1.12 | SyncOptions 2.1.24 | AutoDimDisplay 2.1.7 | Biography 2.7.0 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
New beta versions are now available for all my plugins for latest 7.4 beta version. See description in Plugins tab for more information. They are only available in the beta repository yet, so you will need to setup that according to the initial post in this thread. Several of the plugins had a bug that caused problem when non ascii characters were used in tags. I would appreciate help testing this on different platforms since I only run Linux myself. If you like to use the latest 7.4 version of Squeezebox Server you will need to use this version of the plugins. The versions available in the official non testing repository has been marked with maxVersion 7.3.* since they no longer work with the latest version of 7.4. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
mariowing;443631 Wrote: > > I have enabled continously write history for iTunes in CustomScan, but > it does not write the file. If I make a complete export I get a file. Is > this a know limitation of the current beta? > I suspect it was caused by a bug I corrected yesterday. I'll try to release a new version with the latest corrections during the next day or two. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Thanks for taking the time to update your great plugins - really appreciate it :-) I have enabled continously write history for iTunes in CustomScan, but it does not write the file. If I make a complete export I get a file. Is this a know limitation of the current beta? -- mariowing SqueezeCenter on Windows Home Server. Squeezebox Duet in living rom, Squeezebox Boom in bathroom and home office. SqueezePlay at work, connected through Hamachi VPN. iTunes integration through Erlands Custom Scan. mariowing's Profile: http://forums.slimdevices.com/member.php?userid=22779 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
My native playlist errors are different. See attached. HTH CW +---+ |Filename: server.log | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=7875| +---+ -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-27xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 | SettingsManager 2.1.12 | SyncOptions 2.1.24 | AutoDimDisplay 2.1.7 | Biography 2.7.0 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Chunkywizard;443234 Wrote: > Great, thanks. Would this fix the native playlists as well as user > defined ones or do I need to run debug on the native ones (as they fail > in a different way)? > The problem in the log looked like this: Code: [09-07-24 17:30:28.8051] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (1026) Database error: no such function: unix_timestamp This means that the unix_timestamp function doesn't exist in SQLite while it exists in MySQL. I did a quick look through the playlist templates and it seems to be used in some of the TrackStat and SQLPlaylist based templates. If you have problems with standard saved playlists that's probably something different, so in that case I'd prefer if you post a log. You can look in the log and see if you only see the unix_timestamp error, if you do it's probably related. If I remember correctly, you will see these errors in the log even if you don't have debug logging enabled. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Great, thanks. Would this fix the native playlists as well as user defined ones or do I need to run debug on the native ones (as they fail in a different way)? CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-27xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 | SettingsManager 2.1.12 | SyncOptions 2.1.24 | AutoDimDisplay 2.1.7 | Biography 2.7.0 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Chunkywizard;443094 Wrote: > > server.log is attached ( this was after enabling debug) > Thanks, it's caused by a difference between MySQL and SQLite, will try to fix it for next release of SQL Playlist and potentially also TrackStat and Playlist Generator plugins which contains the same problem. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Hi erland, server.log is attached ( this was after enabling debug) HTH CW +---+ |Filename: server.log | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=7869| +---+ -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-27xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 | SettingsManager 2.1.12 | SyncOptions 2.1.24 | AutoDimDisplay 2.1.7 | Biography 2.7.0 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Chunkywizard;442979 Wrote: > > Dynamic Playlists aren't working for me. I have some custom playlists > which don't work (my Boom says 'Failed') but also some of the built in > ones eg Top Song (by Artist) don't work either (no failed message, just > nothing seems to happen when you select them). I can provide some debug > if you let me know how to enable it. > Check if you get any errors in the server.log file produced by Squeezebox Server, it's found under Settings/Advanced/Logging. If you don't get any errors, enable "debug" level logging on "plugin.dynamicplaylist" and look in the log again after a playlist has failed. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Hi erland, Dynamic Playlists aren't working for me. I have some custom playlists which don't work (my Boom says 'Failed') but also some of the built in ones eg Top Song (by Artist) don't work either (no failed message, just nothing seems to happen when you select them). I can provide some debug if you let me know how to enable it. Cheers CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-27xxx for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.8 | SQL Playlist 2.5 | Music Information Screen 4.42 | Custom Scan 2.7 | TrackStat 2.9 | SettingsManager 2.1.12 | SyncOptions 2.1.24 | AutoDimDisplay 2.1.7 | Biography 2.7.0 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Hi erland, thanks for the 7.4 versions of your plug ins, most appreciated. I just tried Custom Scan with the latest nightly and I still have my old issue (detailed 'here' (http://forums.slimdevices.com/showthread.php?t=61055)). Any chance of having a look at this for me? Best Regards CW -- Chunkywizard *Squeezebox:* Boom x2 (Lounge and Kitchen) *Squeezecenter:* 7.4-26010 for Windows Home Server (HP EX-475 MediaSmart Server with 2GB RAM upgrade) *Plugins:* Dynamic Playlists 2.7 | SQL Playlist 2.4 | Music Information Screen 4.37 | Custom Scan 2.6 | TrackStat 2.8 | SettingsManager 2.1.12 | SyncOptions 2.1.24 | AutoDimDisplay 2.1.7 | Biography 2.7.0 *Remote:* iPod Touch Gen. 1 running 'iPeng' (http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/) Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Oh, my, I take a vacation and come back to this. My wife will be -very- happy to have this back. ("Why the heck is Harry Partch playing as the alarm clock?") -- snarlydwarf snarlydwarf's Profile: http://forums.slimdevices.com/member.php?userid=1179 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
OK, I tried TrackStat, DP, SQLP and CB on my Ubuntu server and while it slowed down the server dramatically during startup (I'll send you a log, took 15min or so to start - without scanning) after that everything seems to work fine. The log file is full of ridiculous comments (not only from your plugins), e.g. on "no space available". Since that's not true I assume some permission conflict. But starts to look real good. -- pippin --- see iPeng, the Squeezebox iPhone remote, at penguinlovesmusic.com pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
A number of new beta versions are now available SQL PLAYLIST 2.5PRE2 *=* - Corrected some playlist templates with random sorting - Repackaged with correct zip structure for manual installation - *Note!* This version does not work in "trunk" MySQL based version of Squeezebox Server 7.4 due to non database related changes, it will work towards the MySQL based version as soon as the SQLite changes are merged back to trunk DYNAMIC PLAYLIST 2.8PRE2 *=* - Corrected an unitialized value debug log message - Repackaged with correct zip structure for manual installation TRACKSTAT 2.9PRE4 *=* - Correction of a Custom Browse menu template - Repackaged with correct zip structure for manual installation CUSTOM SCAN 2.7PRE2 ** - Corrected some Custom Browse menu templates that contained random sorting - Repackaged with correct zip structure for manual installation CUSTOM BROWSE 2.9PRE2 ** - Corrected several menu templates that contains random sorting - Repackaged with correct zip structure for manual installation - *Note!* This version does not work in "trunk" MySQL based version of Squeezebox Server 7.4 due to non database related changes, it will work towards the MySQL based version as soon as the SQLite changes are merged back to trunk MULTI LIBRARY 2.4PRE1 ** - Initial support for SQLite version of Squeezebox Server 7.4 - *Note!* This version does not work in "trunk" MySQL based version of Squeezebox Server 7.4 due to non database related changes, it will work towards the MySQL based version as soon as the SQLite changes are merged back to trunk DATABASE QUERY 2.2PRE1 ** - Initial support for SQLite version of Squeezebox Server 7.4 - *Note!* This version does not work in "trunk" MySQL based version of Squeezebox Server 7.4 due to non database related changes, it will work towards the MySQL based version as soon as the SQLite changes are merged back to trunk PLAYLIST GENERATOR 1.1PRE1 ** - Initial support for SQLite version of Squeezebox Server 7.4 - *Note!* This version does not work in "trunk" MySQL based version of Squeezebox Server 7.4 due to non database related changes, it will work towards the MySQL based version as soon as the SQLite changes are merged back to trunk See 'initial post in this thread' (http://forums.slimdevices.com/showthread.php?p=439372#post439372 ) for warnings and installation instructions for these beta versions. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
>See 'initial post in this thread' >(http://forums.slimdevices.com/showthread.php?p=439372#post439372 ) for >warnings and installation instructions for these beta versions. The zip files don't have the plugin containing folder, so if extracting for manual installation, a folder needs to be created to contain the files. ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;441542 Wrote: > CUSTOM SCAN 2.7PRE1 > ** > - Initial version with support for SQLite based Squeezebox Server 7.4 > I forgot to mention that there is a limitation with this Custom Scan version. It will never perform a rescan automatically after a standard Squeezebox Server rescan. The reason is that Squeezebox Server now triggers a rescan at startup and you definitely don't want Custom Scan to run a full rescan at every startup. There has been some indication that the following enhancement request will be implemented and this should make it better as soon as the corresponding changes has been made to Custom Scan. http://bugs.slimdevices.com/show_bug.cgi?id=6023 -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
A number of new beta versions are now available TRACKSTAT 2.9PRE3 *=* - Optimized startup sequence with SQLite - Corrected Dynamic Playlist integration so they can be launched from TrackStat pages - Corrected database indices CUSTOM SCAN 2.7PRE1 ** - Initial version with support for SQLite based Squeezebox Server 7.4 CUSTOM BROWSE 2.9PRE1 ** - Initial version with support for SQLite based Squeezebox Server 7.4 - *Note!* This version does not work in "trunk" MySQL based version of Squeezebox Server 7.4 due to non database related changes, it will work towards the MySQL based version as soon as the SQLite changes are merged back to trunk See 'initial post in this thread' (http://forums.slimdevices.com/showthread.php?p=439372#post439372 ) for warnings and installation instructions for these beta versions. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
OK, I just created a nice, big log file. Will send it to you per mail. Hope this helps, next step is to completely remove and re-install SC. -- pippin --- see iPeng, the Squeezebox iPhone remote, at penguinlovesmusic.com pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
mariowing;440645 Wrote: > > My previous setup did do a automatically nightly backup of the > Trackstat's and it seems that your plugin might have restored that from > the latest backup automatically?!? I love the fact that it did that :-) > It doesn't restore anything automatically. What happens is probably this: 1. SqueezeCenter upgrades its statistics 2. TrackStat tries to recreate its statistics based on the SqueezeCenter statistics. The result is that the current ratings, play counts and last played times will be correct, at least as long as you aren't using MusicIP or iTunes scanning mechanism and MusicIP or iTunes contains incorrect rating or play count values. The missing part is the history statistics which is used in most "... recently played" TrackStat menus. Make sure to keep the old scheduled backup file, you might want to use it when the real non beta version of TrackStat is released. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;439556 Wrote: > Yes > > > TrackStat statistics is destroyed, Squeezebox Server statistics is > supposed to survive but it didn't in my setup. > > > If you like to keep TrackStat statistics you should take a TrackStat > backup in 7.3.3 or in the MySQL version of 7.4 before you upgrade. Make > sure to store this TrackStat backup file in a safe place, because you > might need it again when the final version of TrackStat supporting 7.4 > is released. I have now installed the 7.4 - r27438 version of Squeezecenter. It did a lengthy rescan and all my music reappeared. I then installed the Trackstat beta plugin and after restarting SC it did an even longer rescan. And to my great surprise (and joy of course) all the statistics from TrackStat's previous installation was there :-). My previous setup did do a automatically nightly backup of the Trackstat's and it seems that your plugin might have restored that from the latest backup automatically?!? I love the fact that it did that :-) -- mariowing SqueezeCenter on Windows Home Server. Squeezebox Duet in living rom, Squeezebox Boom in bathroom and home office. SqueezePlay at work, connected through Hamachi VPN. iTunes integration through Erlands Custom Scan. mariowing's Profile: http://forums.slimdevices.com/member.php?userid=22779 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
For anyone that want to help testing, it would be great if you could help verifying that all playlist templates in SQL Playlist works with SQLite. Try creating some different playlist variants of each playlist template type available and try to use it and verify that you don't get any errors in the log when you start to play the playlist. If you get any error, specify which playlist template you used and post the complete error message. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
pippin;440160 Wrote: > Both are in ~/Library/Caches/Squeezebox Server/ > Could you try to enable some more debug logging ? I'm guessing it would be a good idea to enable debug logging on database sections, scanner sections, server sections and plugin.trackstat. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;440151 Wrote: > > It feels like there is some timing issue or that some files are write > protected. Could you try and find if the following files exists and > where they are stored ? > squeezecenter.db > squeezecenter-persistent.db > Both are in ~/Library/Caches/Squeezebox Server/ > > I did a clean installation, I've never had SqueezeCenter on the machine > before. Did you a clean installation or an upgrade ? Maybe something is > different when you upgrade ? No, I did an upgrade. Just tried a clean install on another machine but that's 10.6 and SC doesn't seem to work there -- pippin --- see iPeng, the Squeezebox iPhone remote, at penguinlovesmusic.com pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
pippin;439701 Wrote: > Everything else seems to work. > Strange, I installed the latest nightly on my Macbook and it worked perfectly besides some "uninitialized" messages in the server log. Is there something special with your installation or is it a standard installation of a nightly release ? It feels like there is some timing issue or that some files are write protected. Could you try and find if the following files exists and where they are stored ? squeezecenter.db squeezecenter-persistent.db TrackStat tries to create tables in the squeezecenter-persistent.db file so if that doesn't exist that might be the reason. However, if it doesn't exist it's a bit strange that SqueezeCenter works at all. I did a clean installation, I've never had SqueezeCenter on the machine before. Did you a clean installation or an upgrade ? Maybe something is different when you upgrade ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
A number of new beta versions are now available TRACKSTAT 2.8PRE2 *=* - Corrected some uninitialized messagess in server log - Added support for SQL Playlist 2.5pre1 and later DYNAMIC PLAYLIST 2.8PRE1 ** - Initial version with support for SQLite based Squeezebox Server 7.4 SQL PLAYLIST 2.5PRE1 ** - Initial version with support for SQLite based Squeezebox Server 7.4 - *Note!* This version does not work in "trunk" MySQL based version of Squeezebox Server 7.4 due to non database related changes, it will work towards the MySQL based version as soon as the SQLite changes are merged back to trunk See 'initial post in this thread' (http://forums.slimdevices.com/showthread.php?p=439372#post439372 ) for warnings and installation instructions for these beta versions. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Everything else seems to work. -- pippin --- see iPeng, the Squeezebox iPhone remote, at penguinlovesmusic.com pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
pippin;439526 Wrote: > Yes: > > Code: > > > [09-07-10 17:43:53.2625] main::init (321) Starting Squeezebox Server (v7.4, r27423, Mon Jul 6 04:01:36 PDT 2009) perl 5.008008 > [09-07-10 17:43:58.5892] main::init (321) Starting Squeezebox Server (v7.4, r27423, Mon Jul 6 04:01:36 PDT 2009) perl 5.008008 > ... > [09-07-10 17:44:05.1515] Slim::Utils::PluginManager::load (312) Warning: Couldn't call Plugins::TrackStat::Plugin->initPlugin: Can't call method "dbh" on an undefined value at Plugins/TrackStat/Storage.pm line 67. > > > That's strange, it looks like TrackStat can't get access to the database handle. Does Squeezebox Server work besides TrackStat ? For example the browse menus which need database access ? Does anyone else see the same behavior as pippin ? -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
mariowing;439547 Wrote: > > I quess I should first update Squeezecenter and then install your beta > plugin(s)? > Yes mariowing;439547 Wrote: > > Is TrackStat statistics destroyed after an Squeezecenter upgrade to > 7.4? > TrackStat statistics is destroyed, Squeezebox Server statistics is supposed to survive but it didn't in my setup. mariowing;439547 Wrote: > > If it is; would it be possible to import an pre-7.4 backup to the new > 7.4 SC when CustomScan for 7.4 is released? > If you like to keep TrackStat statistics you should take a TrackStat backup in 7.3.3 or in the MySQL version of 7.4 before you upgrade. Make sure to store this TrackStat backup file in a safe place, because you might need it again when the final version of TrackStat supporting 7.4 is released. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
I would love to help you test the plugins, but I have a few questions I hope you could answer. I quess I should first update Squeezecenter and then install your beta plugin(s)? Is TrackStat statistics destroyed after an Squeezecenter upgrade to 7.4? If it is; would it be possible to import an pre-7.4 backup to the new 7.4 SC when CustomScan for 7.4 is released? Thank you for taking the time to update your plugins - I really appreciate it! -- mariowing SqueezeCenter on Windows Home Server. Squeezebox Duet in living rom, Squeezebox Boom in bathroom and home office. SqueezePlay at work, connected through Hamachi VPN. iTunes integration through Erlands Custom Scan. mariowing's Profile: http://forums.slimdevices.com/member.php?userid=22779 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
Yes: Code: [09-07-10 17:43:53.2625] main::init (321) Starting Squeezebox Server (v7.4, r27423, Mon Jul 6 04:01:36 PDT 2009) perl 5.008008 [09-07-10 17:43:58.5892] main::init (321) Starting Squeezebox Server (v7.4, r27423, Mon Jul 6 04:01:36 PDT 2009) perl 5.008008 ... [09-07-10 17:44:05.1515] Slim::Utils::PluginManager::load (312) Warning: Couldn't call Plugins::TrackStat::Plugin->initPlugin: Can't call method "dbh" on an undefined value at Plugins/TrackStat/Storage.pm line 67. ... [09-07-10 17:44:14.7448] Slim::Utils::Scanner::Local::__ANON__ (139) Removing deleted files (81) [09-07-10 17:44:14.8094] Slim::Utils::Scanner::Local::__ANON__ (190) Scanning new files (1) [09-07-10 17:44:14.8753] Slim::Utils::Scanner::Local::__ANON__ (241) Rescanning changed files (0) ... [09-07-10 17:44:14.9623] Slim::Utils::Scanner::Local::__ANON__ (388) ERROR SCANNING /Users/.../The Fugees - Manifest-Outro.mp3: Unable to read tags from file [09-07-10 17:44:19.5950] Slim::Schema::Storage::throw_exception (87) Error: DBI Exception: DBD::SQLite::db prepare failed: no such table: track_statistics [for Statement "UPDATE track_statistics SET url=(select tracks.url from tracks where tracks.musicbrainz_id is not null and tracks.musicbrainz_id=track_statistics.musicbrainz_id and track_statistics.url!=tracks.url and length(tracks.url)<512) where exists (select tracks.url from tracks where tracks.musicbrainz_id is not null and tracks.musicbrainz_id=track_statistics.musicbrainz_id and track_statistics.url!=tracks.url and length(tracks.url)<512)"] [09-07-10 17:44:19.5955] Slim::Schema::Storage::throw_exception (87) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Schema/Storage.pm line 87) frame 1: Slim::Schema::Storage::throw_exception (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 722) frame 2: DBIx::Class::Storage::DBI::__ANON__ (Plugins/TrackStat/Storage.pm line 1244) frame 3: Plugins::TrackStat::Storage::refreshTracks (Plugins/TrackStat/Plugin.pm line 3724) frame 4: Plugins::TrackStat::Plugin::commandCallback65 (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Control/Request.pm line 2078) frame 5: (eval) (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Control/Request.pm line 2078) frame 6: Slim::Control::Request::notify (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Control/Request.pm line 852) frame 7: Slim::Control::Request::checkNotifications (./slimserver.pl line 593) frame 8: main::idle (./slimserver.pl line 569) frame 9: main::main (./slimserver.pl line 1056) [09-07-10 17:44:19.5961] Slim::Control::Request::notify (2081) Error: Failed notify: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such table: track_statistics [for Statement "UPDATE track_statistics SET url=(select tracks.url from tracks where tracks.musicbrainz_id is not null and tracks.musicbrainz_id=track_statistics.musicbrainz_id and track_statistics.url!=tracks.url and length(tracks.url)<512) where exists (select tracks.url from tracks where tracks.musicbrainz_id is not null and tracks.musicbrainz_id=track_statistics.musicbrainz_id and track_statistics.url!=tracks.url and length(tracks.url)<512)"] at /Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Schema/Storage.pm line 91 [09-07-10 17:44:35.0043] Slim::Utils::Misc::msg (1160) Warning: [17:44:35.0040] Use of uninitialized value in concatenation (.) or string at /Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/HTML/Default/settings/header.html line 71. [09-07-10 17:44:37.0011] Slim::Utils::Update::getUpdateInstaller (263) Reading update installer path from /Users/.../Caches/Squeezebox Server/updates/server.version [09-07-10 17:44:37.0018] Slim::Utils::Update::getUpdateInstaller (284) Found update installer path: '/Users/.../Caches/Squeezebox Server/updates/SqueezeboxServer-7.4-27455.dmg' [09-07-10 17:44:37.0024] Slim::Utils::Update::checkVersion (57) Checking version in 52782.0068130493 seconds -- pippin --- see iPeng, the Squeezebox iPhone remote, at penguinlovesmusic.com pippin's Profile: http://forums.slimdevices.com/member.php?userid=13777 View this thread: http://forums.slimdevices.com/showthread.php?t=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
pippin;439481 Wrote: > All over the place. > Like this > > Code: > > > [09-07-10 16:25:46.4247] Slim::Control::Request::execute (1895) Error: While trying to run function coderef [Plugins::TrackStat::Plugin::getCLIRating]: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such table: track_statistics > > > > Seems like it fails to create the tables. > Could you see if you get any errors directly after Squeezebox Server > has started ? > > > pippin;439481 Wrote: > > > > I've got a beta that works. But it doesn't see TrackStat. > > > > > The above errors will probably results in that TrackStat doesn't work > at all, so that's probably the explanation why iPeng can't use the > trackstat CLI/JSON commands. -- erland Erland Isaksson 'My homepage' (http://erland.isaksson.info) (Install my plugins through Extension Downloader) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library, Title Switcher 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=65439 ___ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
Re: [SlimDevices: Plugins] Announce: Squeezebox Server 7.4 beta versions of erlands plugins
erland;439453 Wrote: > > Do you get any errors in the log ? > All over the place. Like this Code: [09-07-10 16:25:46.4247] Slim::Control::Request::execute (1895) Error: While trying to run function coderef [Plugins::TrackStat::Plugin::getCLIRating]: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such table: track_statistics [for Statement "SELECT url, musicbrainz_id, playCount, added,lastPlayed, rating FROM track_statistics where url = ? or url = ?"] at /Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Schema/Storage.pm line 91 ] [09-07-10 16:26:48.3991] Slim::Schema::Storage::throw_exception (87) Error: DBI Exception: DBD::SQLite::db prepare failed: no such table: track_statistics [for Statement "SELECT url, musicbrainz_id, playCount, added,lastPlayed, rating FROM track_statistics where url = ? or url = ?"] [09-07-10 16:26:48.4158] Slim::Schema::Storage::throw_exception (87) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Schema/Storage.pm line 87) frame 1: Slim::Schema::Storage::throw_exception (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 722) frame 2: DBIx::Class::Storage::DBI::__ANON__ (Plugins/TrackStat/Storage.pm line 519) frame 3: Plugins::TrackStat::Storage::findTrack (Plugins/TrackStat/Plugin.pm line 4278) frame 4: Plugins::TrackStat::Plugin::getCLIRating (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Control/Request.pm line 1891) frame 5: (eval) (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Control/Request.pm line 1891) frame 6: Slim::Control::Request::execute (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Web/Cometd.pm line 787) frame 7: Slim::Web::Cometd::handleRequest (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Web/Cometd.pm line 548) frame 8: Slim::Web::Cometd::handler (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Web/Cometd.pm line 108) frame 9: Slim::Web::Cometd::webHandler (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Web/HTTP.pm line 484) frame 10: Slim::Web::HTTP::processHTTP (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Networking/IO/Select.pm line 119) frame 11: (eval) (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Networking/IO/Select.pm line 119) frame 12: Slim::Networking::IO::Select::__ANON__ (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Networking/IO/Select.pm line 162) frame 13: (eval) (/Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Networking/IO/Select.pm line 162) frame 14: Slim::Networking::IO::Select::loop (./slimserver.pl line 600) frame 15: main::idle (./slimserver.pl line 569) frame 16: main::main (./slimserver.pl line 1056) [09-07-10 16:26:48.4168] Slim::Control::Request::execute (1895) Error: While trying to run function coderef [Plugins::TrackStat::Plugin::getCLIRating]: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: no such table: track_statistics [for Statement "SELECT url, musicbrainz_id, playCount, added,lastPlayed, rating FROM track_statistics where url = ? or url = ?"] at /Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Schema/Storage.pm line 91 ] [09-07-10 16:26:58.5485] Slim::Utils::Misc::msg (1160) Warning: [16:26:58.5481] Use of uninitialized value in concatenation (.) or string at /Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Control/Queries.pm line 744. [09-07-10 16:26:58.6285] Slim::Utils::Misc::msg (1160) Warning: [16:26:58.6281] Use of uninitialized value in concatenation (.) or string at /Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Control/Queries.pm line 744. [09-07-10 16:27:04.5679] Slim::Utils::Misc::msg (1160) Warning: [16:27:04.5675] Use of uninitialized value in concatenation (.) or string at /Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Control/Queries.pm line 358. [09-07-10 16:27:05.3467] Slim::Utils::Misc::msg (1160) Warning: [16:27:05.3463] Use of uninitialized value in concatenation (.) or string at /Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Control/Queries.pm line 358. [09-07-10 16:27:16.5781] Slim::Utils::Misc::msg (1160) Warning: [16:27:16.5775] Use of uninitialized value in concatenation (.) or string at /Library/PreferencePanes/Squeezebox Server.prefPane/Contents/server/Slim/Control/Queries.pm line 1391. [09-07-10 16:32:13.4777] Slim::Schema::Storage::throw_exception (87) Error: DBI Exception: DBD::SQLite::db prepare failed: no such table: track_statistics [for Statement "SELECT ur