Hi Erland, A kind reminder of the problem above. iTunes ratings are still not updated; I'm still using iTunes 12.1 (not daring to upgrade to 12.2). I would presume these errors provide a hint of where the problem lies:
Code: -------------------- [15-07-07 11:58:58.6810] Plugins::TrackStat::Storage::findTrack (533) findTrack(): URL: file:///music/Muziek/iTunes/iTunes%20Music/Music/Bert%20&%20Ernie/Hiep%20Hiep%20Hoera/01%20Hoe%20heet%20je.mp3 [15-07-07 11:58:58.6817] Plugins::TrackStat::Storage::mergeTrack (1148) Marking as played in storage: 9 [15-07-07 11:58:58.6820] Slim::Utils::Misc::msg (1233) Warning: [11:58:58.6818] Use of uninitialized value $added in concatenation (.) or string at /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/TrackStat/Storage.pm line 1166, <ITUNESLIBRARY> chunk 12400. [15-07-07 11:58:58.6825] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db prepare failed: near ",": syntax error [for Statement "INSERT INTO track_statistics (url,urlmd5,playCount,added,lastPlayed) values (?,'418a77aeed9efbfcdde48e61f09af003', 9,,1419066374)"] [15-07-07 11:58:58.6828] Slim::Schema::Storage::throw_exception (122) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 122) frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1006) frame 2: DBIx::Class::Storage::DBI::__ANON__ (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/TrackStat/Storage.pm line 1178) frame 3: Plugins::TrackStat::Storage::mergeTrack (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/TrackStat/iTunes/Import.pm line 821) frame 4: Plugins::TrackStat::iTunes::Import::sendTrackToStorage (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/TrackStat/iTunes/Import.pm line 499) frame 5: Plugins::TrackStat::iTunes::Import::handleTrack (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/TrackStat/iTunes/Import.pm line 645) frame 6: Plugins::TrackStat::iTunes::Import::handleEndElement (/usr/share/squeezeboxserver/CPAN/XML/Parser/Expat.pm line 617) frame 7: XML::Parser::ExpatNB::parse_more (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/TrackStat/iTunes/Import.pm line 363) frame 8: Plugins::TrackStat::iTunes::Import::scanFunction (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/Scanner.pm line 1904) frame 9: (eval) (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/Scanner.pm line 1904) frame 10: Plugins::CustomScan::Scanner::exitScanTrack (/usr/share/perl5/Slim/Utils/Scheduler.pm line 156) frame 11: (eval) (/usr/share/perl5/Slim/Utils/Scheduler.pm line 156) frame 12: Slim::Utils::Scheduler::run_tasks (/usr/sbin/squeezeboxserver line 728) frame 13: main::idle (/usr/sbin/squeezeboxserver line 695) frame 14: main::main (/usr/sbin/squeezeboxserver line 1232) [15-07-07 11:58:58.6831] Plugins::CustomScan::Scanner::exitScanTrack (1906) CustomScan: Failed to call exitScanTrack on module Plugins::TrackStat::Plugin->itunesimport: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed: near ",": syntax error [for Statement "INSERT INTO track_statistics (url,urlmd5,playCount,added,lastPlayed) values (?,'418a77aeed9efbfcdde48e61f09af003', 9,,1419066374)"] at /usr/share/perl5/Slim/Schema/Storage.pm line 126 [15-07-07 11:58:58.6835] Plugins::CustomScan::Scanner::exitScan (1014) Optimizing SQLite database [15-07-07 11:58:58.6841] Plugins::CustomScan::Scanner::exitScan (1041) Rescan finished [15-07-07 11:58:59.6794] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5074) Entering getRatingDynamicCustomItem [15-07-07 11:58:59.6798] Plugins::TrackStat::Storage::findTrack (533) findTrack(): URL: file:///music/Muziek/iTunes/iTunes%20Music/Music/Suuns%20and%20Jerusalem%20in%20My%20Heart/Suuns%20and%20Jerusalem%20In%20My%20Heart/Suuns%20and%20Jerusalem%20in%20My%20Heart%20-%2001.%202amoutu%20I7tirakan.mp3 [15-07-07 11:58:59.6804] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5090) Exiting getRatingDynamicCustomItem [15-07-07 11:58:59.6831] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5074) Entering getRatingDynamicCustomItem [15-07-07 11:58:59.6834] Plugins::TrackStat::Storage::findTrack (533) findTrack(): URL: file:///music/Muziek/iTunes/iTunes%20Music/Music/Suuns%20and%20Jerusalem%20in%20My%20Heart/Suuns%20and%20Jerusalem%20In%20My%20Heart/Suuns%20and%20Jerusalem%20in%20My%20Heart%20-%2002.%20Metal.mp3 [15-07-07 11:58:59.6841] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5090) Exiting getRatingDynamicCustomItem [15-07-07 11:58:59.6867] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5074) Entering getRatingDynamicCustomItem [15-07-07 11:58:59.6871] Plugins::TrackStat::Storage::findTrack (533) findTrack(): URL: file:///music/Muziek/iTunes/iTunes%20Music/Music/Suuns%20and%20Jerusalem%20in%20My%20Heart/Suuns%20and%20Jerusalem%20In%20My%20Heart/Suuns%20and%20Jerusalem%20in%20My%20Heart%20-%2003.%20Self.mp3 [15-07-07 11:58:59.6878] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5090) Exiting getRatingDynamicCustomItem [15-07-07 11:58:59.6904] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5074) Entering getRatingDynamicCustomItem [15-07-07 11:58:59.6907] Plugins::TrackStat::Storage::findTrack (533) findTrack(): URL: file:///music/Muziek/iTunes/iTunes%20Music/Music/Suuns%20and%20Jerusalem%20in%20My%20Heart/Suuns%20and%20Jerusalem%20In%20My%20Heart/Suuns%20and%20Jerusalem%20in%20My%20Heart%20-%2004.%20In%20Touch.mp3 [15-07-07 11:58:59.6914] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5090) Exiting getRatingDynamicCustomItem [15-07-07 11:58:59.6940] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5074) Entering getRatingDynamicCustomItem [15-07-07 11:58:59.6943] Plugins::TrackStat::Storage::findTrack (533) findTrack(): URL: file:///music/Muziek/iTunes/iTunes%20Music/Music/Suuns%20and%20Jerusalem%20in%20My%20Heart/Suuns%20and%20Jerusalem%20In%20My%20Heart/Suuns%20and%20Jerusalem%20in%20My%20Heart%20-%2005.%20Gazelles%20In%20Flight.mp3 [15-07-07 11:58:59.6950] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5090) Exiting getRatingDynamicCustomItem [15-07-07 11:58:59.6976] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5074) Entering getRatingDynamicCustomItem [15-07-07 11:58:59.6979] Plugins::TrackStat::Storage::findTrack (533) findTrack(): URL: file:///music/Muziek/iTunes/iTunes%20Music/Music/Suuns%20and%20Jerusalem%20in%20My%20Heart/Suuns%20and%20Jerusalem%20In%20My%20Heart/Suuns%20and%20Jerusalem%20in%20My%20Heart%20-%2006.%20Leyla.mp3 [15-07-07 11:58:59.6986] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5090) Exiting getRatingDynamicCustomItem [15-07-07 11:58:59.7012] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5074) Entering getRatingDynamicCustomItem [15-07-07 11:58:59.7015] Plugins::TrackStat::Storage::findTrack (533) findTrack(): URL: file:///music/Muziek/iTunes/iTunes%20Music/Music/Suuns%20and%20Jerusalem%20in%20My%20Heart/Suuns%20and%20Jerusalem%20In%20My%20Heart/Suuns%20and%20Jerusalem%20in%20My%20Heart%20-%2007.%203attam%20Babey.mp3 [15-07-07 11:58:59.7022] Plugins::TrackStat::Plugin::getRatingDynamicCustomItem (5090) Exiting getRatingDynamicCustomItem [15-07-07 12:00:05.4207] Plugins::TrackStat::Storage::findTrack (533) findTrack(): URL: file:///music/Muziek/iTunes/iTunes%20Music/Music/Suuns%20and%20Jerusalem%20in%20My%20Heart/Suuns%20and%20Jerusalem%20In%20My%20Heart/Suuns%20and%20Jerusalem%20in%20My%20Heart%20-%2001.%202amoutu%20I7tirakan.mp3 -------------------- Thanks! Randy 1x Squeezebox Classic / 2x Squeezebox Radio / LMS 7.9.0 - 1403985527 on HP Proliant N54L with Ubuntu 12.04 LTS / OrangeSqueeze http://www.last.fm/user/rndr ------------------------------------------------------------------------ rlem's Profile: http://forums.slimdevices.com/member.php?userid=46931 View this thread: http://forums.slimdevices.com/showthread.php?t=103127 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins