PDA

View Full Version : Announce: Squeezebox Server 7.4 beta versions of erlands plugins



erland
2009-07-09, 22:12
I've now started the conversion of all my plugins to the SQLite based version of Squeezebox Server(SqueezeCenter) 7.4. I'll be using this thread for announcing new beta versions for 7.4, when the plugins are stable enough I'll go back to the old announcement thread.

To be aware of
==============
If you are willing to participate in beta testing you should be aware of the following:
- I can't promise that the configuration you make in the beta versions will work in the final versions. Hopefully it will, but you might also have to redo the configuration when the final version is released.
- I can't promise that any statistics collected with TrackStat during the beta version will be possible to use in the final version. Hopefully it will, but you might also need to restore a backup from before the beta test start.
- There might be some database table changes in some of the plugins during the beta test period. In the worst case this might result in that you will have to clear the cache directory and perform a full rescan if something goes bad during table changes.
- Some functionality in the beta versions of the plugin might not have been tested at all.

Note!!!
If you have never used my plugins before I would suggest that you use the latest official versions of my plugins instead of these beta versions. The latest official versions still only works with 7.3.3 and earlier.

Feedbacks and comments
=======================
Let me know if you find any bugs or have ideas for new features or changes. You can post your bugs, feature request or change suggestions in this thread or in a separate thread on the 3rd party plugins forum. Remember to mention which plugin and version you are using.

The intention of this beta testing period is to get some help testing the upgraded functionality, so I would appreciate if anyone participating would focus on testing functionality that you know has worked before. I will not add new features at this stage, the main focus will be to make sure everything that has worked before still works with the new Squeezebox Server version.

I've not done any testing at all in larger libraries, so if you have a large library you might get very poor performance. If this is the case, please let me know.

The plugin versions now available that works with 7.4 SQLite based Squeezebox Server(SqueezeCenter) are:

TrackStat 2.9pre1
======================
- Status: Most parts have been tested
- Mostly same functionality as in TrackStat 2.8
- Added support for Mac OSX in TrackStatiTunesUpdate.pl script
- Since TrackStat relies on Custom Scan plugin for all import/export functionality this functionality won't work until a Custom Scan beta is available.
- Since TrackStat relies on Dynamic Playlist plugin for all dynamic playlist functionality this functionality won't work until a Dynamic Playlist beta is available.

To install the new versions you need to setup a new repository in Squeezebox Server Settings/Plugins:

http://erlandplugins.googlecode.com/svn/repository/trunk/testing.xml

If you for some reason still don't want to use the new plugin installer which is a part of Squeezebox Server, you can of course still download the plugins from:
http://erland.isaksson.info/download

Philip Meyer
2009-07-10, 00:38
Will these new versions work with SQLite and MySQL?

pippin
2009-07-10, 01:43
Hm.
I can't get this to work @today's nightly (on a Mac).
I can see it under "plugins" (had to manually uninstall every old instance and then install it about three times before that happened; extension downloader seems to be seriously flawed right now) and I can get into the Settings.
I also see a "TrackStat" menu, and I can select which menus to show but then it doesn'T do anything.
iPeng also doesn't see it (iPeng tests whether the CLI command returns a valid value).

erland
2009-07-10, 06:11
Will these new versions work with SQLite and MySQL?
Yes, that's the plan.

I'm not sure I'll make all Custom Browse menus available through SQLite, it depends on how much the SQL statements need to differ.

tamanaco
2009-07-10, 06:13
Great news!... I was not going to install the SQLite builds of SC until your plugins became available. Thanks

erland
2009-07-10, 06:15
Hm.
I can't get this to work @today's nightly (on a Mac).
I can see it under "plugins" (had to manually uninstall every old instance and then install it about three times before that happened; extension downloader seems to be seriously flawed right now) and I can get into the Settings.
I also see a "TrackStat" menu, and I can select which menus to show but then it doesn'T do anything.

I had similar problems with Extension Downloader, it works sometimes and sometimes not.

Do you get any errors in the log ?



iPeng also doesn't see it (iPeng tests whether the CLI command returns a valid value).

iPeng native seems to crash when I use it against latest 7.4 svn version. I don't think it's TrackStat related because it also crashes in standard browse menus.

It works perfectly towards the MySQL version of 7.4.

pippin
2009-07-10, 07:41
Do you get any errors in the log ?

All over the place.
Like this


[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 url, musicbrainz_id, playCount, added,lastPlayed, rating FROM track_statistics where url = ? or url = ?"]
[09-07-10 16:32:13.4783] 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:32:13.4790] 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
]



iPeng native seems to crash when I use it against latest 7.4 svn version. I don't think it's TrackStat related because it also crashes in standard browse menus.

Oh yes, that's not what I mean. That this:
http://bugs.slimdevices.com/show_bug.cgi?id=12569

I've got a beta that works. But it doesn't see TrackStat.

erland
2009-07-10, 08:19
All over the place.
Like this


[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 ?

[QUOTE=pippin;439481]
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.

pippin
2009-07-10, 08:55
Yes:


[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

mariowing
2009-07-10, 10:06
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!

erland
2009-07-10, 10:53
I quess I should first update Squeezecenter and then install your beta plugin(s)?

Yes



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.



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
2009-07-11, 00:24
Yes:


[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 ?

pippin
2009-07-11, 00:48
Everything else seems to work.

erland
2009-07-13, 01:09
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
2009-07-13, 01:17
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 ?

pippin
2009-07-13, 02:04
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 ~<user>/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

erland
2009-07-13, 02:17
Both are in ~<user>/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
2009-07-13, 02:22
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.

mariowing
2009-07-14, 13:33
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 :-)

erland
2009-07-15, 00:28
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.

pippin
2009-07-15, 02:15
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.

erland
2009-07-18, 00:02
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
2009-07-18, 00:32
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

Philip Meyer
2009-07-18, 01:10
>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.

erland
2009-07-18, 03:10
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.

pippin
2009-07-21, 05:44
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.

snarlydwarf
2009-07-21, 10:21
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?")

Chunkywizard
2009-07-23, 07:40
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
2009-07-24, 02:41
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

erland
2009-07-24, 04:13
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.

Chunkywizard
2009-07-24, 09:34
Hi erland,

server.log is attached ( this was after enabling debug)

HTH

CW

erland
2009-07-24, 09:41
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.

Chunkywizard
2009-07-25, 01:43
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

erland
2009-07-25, 02:59
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:


[09-07-24 17:30:28.8051] Plugins::SQLPlayList::Plugin::executeSQLForPlaylis t (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.

Chunkywizard
2009-07-26, 00:09
My native playlist errors are different. See attached.

HTH

CW

mariowing
2009-07-27, 06:11
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?

erland
2009-07-27, 11:59
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
2009-08-02, 02:48
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.

Chunkywizard
2009-08-02, 09:22
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

erland
2009-08-02, 11:02
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.

pippin
2009-08-02, 11:30
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.

erland
2009-08-02, 11:50
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 ?

pippin
2009-08-02, 14:31
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


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.

Chunkywizard
2009-08-03, 00:21
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
2009-08-03, 00:22
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

erland
2009-08-03, 00:33
All interfaces.
In the Web Interface I get


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
2009-08-03, 00:56
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.

pippin
2009-08-03, 01:03
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.

Chunkywizard
2009-08-03, 01:08
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

erland
2009-08-03, 01:46
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.

Chunkywizard
2009-08-03, 01:52
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

mariowing
2009-08-03, 09:54
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 :-)

MeSue
2009-08-09, 09:01
Custom Scan Rating Tag module takes soooo 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?

erland
2009-08-09, 11:30
Custom Scan Rating Tag module takes soooo 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.



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

MeSue
2009-08-09, 18:55
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.

Edit:

Turns out I already had debug logging enabled for plugin.customscan, so I snipped out the part of the log from this morning at 6:11 AM when custom scan rating scan kicked on, until around 10 PM when I aborted the MusicIP Statistics Export that had been running all day. The Rating scan ended around 12:43 PM.

The attachment is a zip file, but I added the PDF extension to circumvent the forum file size restrictions. Just erase the .pdf extension and you should be able to unzip it.

erland
2009-08-09, 22:07
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.

MeSue
2009-08-10, 08:07
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.

erland
2009-08-10, 10:02
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 ?

MeSue
2009-08-10, 10:11
That's right. Maybe updating SbS made the difference, or it was just a fluke. I'll keep monitoring...

bhaagensen
2009-08-16, 13:23
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

erland
2009-08-16, 13:28
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.

bhaagensen
2009-08-18, 13:42
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).

MeSue
2009-08-20, 10:05
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

BodgeIT
2009-09-01, 07:44
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?

erland
2009-09-01, 09:07
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.

BodgeIT
2009-09-01, 15:42
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?

erland
2009-09-01, 21:14
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

BodgeIT
2009-09-02, 01:45
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.

Quad
2009-09-16, 12:12
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

Chunkywizard
2009-09-18, 14:11
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
2009-09-20, 12:57
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

brucesee
2009-09-22, 11:39
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.

erland
2009-09-24, 16:07
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
2009-09-27, 22:10
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
2009-09-27, 22:12
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.

Chunkywizard
2009-09-28, 01:43
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

erland
2009-09-28, 19:19
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.

Chunkywizard
2009-09-28, 23:36
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
2009-09-29, 00:01
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_proble matic_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_loca tion (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

brucesee
2009-09-29, 10:13
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.

el_jefe
2009-09-30, 03:49
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!

MeSue
2009-09-30, 07:11
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.

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.

el_jefe
2009-09-30, 07:43
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!

MeSue
2009-09-30, 07:49
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.

el_jefe
2009-09-30, 07:56
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!

erland
2009-09-30, 09:13
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.

el_jefe
2009-09-30, 09:24
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!

thing-fish
2009-09-30, 12:35
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 :(

MeSue
2009-09-30, 12:46
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

thing-fish
2009-09-30, 13:22
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?

MeSue
2009-09-30, 13:25
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.

erland
2009-09-30, 13:32
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.

Chunkywizard
2009-10-01, 01:29
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_proble matic_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_loca tion (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

thing-fish
2009-10-06, 11:40
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:


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!

erland
2009-10-06, 13:03
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)

Chunkywizard
2009-10-08, 03:28
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_proble matic_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_loca tion (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

MeSue
2009-10-08, 09:04
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.

erland
2009-10-08, 09:50
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.

diamar
2009-10-10, 11:56
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_randomplaylisttrackslinnjaz z
[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::clearPlayListHis tory (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::getTracksForPlay list (3194) Calling: Plugins::SQLPlayList::Plugin with: sqlplaylist_randomplaylisttrackslinnjazz , 10 , 0
[09-10-10 11:29:04.0463] Plugins::DynamicPlayList::Plugin::getTracksForPlay list (3212) Calling: Plugins::SQLPlayList::Plugin :: getNextDynamicPlayListTracks
[09-10-10 11:29:04.0470] Plugins::SQLPlayList::Plugin::getNextDynamicPlayLi stTracks (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::replaceParametersInS QL (888) Replacing 'PlaylistOffset' with 0
[09-10-10 11:29:04.0504] Plugins::SQLPlayList::Plugin::replaceParametersInS QL (888) Replacing 'PlaylistActiveLibrary' with 0
[09-10-10 11:29:04.0511] Plugins::SQLPlayList::Plugin::replaceParametersInS QL (888) Replacing 'PlaylistPlayer' with '00:04:20:10:08:04'
[09-10-10 11:29:04.0519] Plugins::SQLPlayList::Plugin::replaceParametersInS QL (888) Replacing 'PlaylistLimit' with 10
[09-10-10 11:29:04.0536] Plugins::SQLPlayList::Plugin::executeSQLForPlaylis t (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::executeSQLForPlaylis t (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::commandCallback6 5 (1781) Skipping playlist play dynamicplaylist://sqlplaylist_randomplaylisttrackslinnjazz
[09-10-10 11:29:04.1408] Plugins::DynamicPlayList::Plugin::commandCallback6 5 (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 "Plugins::DynamicPlayList::ProtocolHandler" at /<C:\Program Files\Squeezebox\server\SqueezeSvr.exe>Slim/Player/Song.pm line 698.
]
[09-10-10 11:29:04.8558] Slim::Web::JSONRPC::requestMethod (358) Request failed with error: Bad dispatch!
[09-10-10 11:29:09.3828] Slim::Control::Request::execute (1918) Error: While trying to run function coderef [Slim::Control::Queries::statusQuery]: [Can't locate object method "isRemote" via package "Plugins::DynamicPlayList::ProtocolHandler" at /<C:\Program Files\Squeezebox\server\SqueezeSvr.exe>Slim/Player/Song.pm line 698.
]
[09-10-10 11:29:09.3840] Slim::Web::JSONRPC::requestMethod (358) Request failed with error: Bad dispatch!
[09-10-10 11:29:12.9276] Plugins::DynamicPlayList::Plugin::commandCallback6 5 (1786) received command playlist load_done
[09-10-10 11:29:16.9432] Slim::Control::Request::execute (1918) Error: While trying to run function coderef [Slim::Control::Queries::statusQuery]: [Can't locate object method "isRemote" via package "Plugins::DynamicPlayList::ProtocolHandler" at /<C:\Program Files\Squeezebox\server\SqueezeSvr.exe>Slim/Player/Song.pm line 698.
]
[09-10-10 11:29:16.9443] Slim::Web::JSONRPC::requestMethod (358) Request failed with error: Bad dispatch!

erland
2009-10-11, 00:55
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
2009-10-12, 22:38
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_proble matic_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_loca tion (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 ?

Chunkywizard
2009-10-13, 00:38
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).

[Edit] Yay, it worked!! Fantastic. Does this point to a bug?

Thanks

CW

erland
2009-10-13, 08:53
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.

Chunkywizard
2009-10-13, 09:16
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

diamar
2009-10-17, 08:21
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!