Hi Erland,

Longtime happy user of the Custom Scan, Trackstat & iTunes import/export
here. The main use is the synchronisation of new ratings.
But since a few weeks, I'm not able to get my new ratings from iTunes
into LMS with the Custom Scan iTunes import.
This happens in the log after manually triggering an iTunes import in
Custom Scan:


Code:
--------------------
    
  [15-02-06 10:24:38.9436] Slim::Utils::Misc::msg (1343) Warning: 
[10:24:38.9434] Use of uninitialized value $added in concatenation (.) or 
string at 
/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/TrackStat/Storage.pm 
line 1166, <ITUNESLIBRARY> chunk 24800.
  
  [15-02-06 10:24:38.9441] 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,,1419069974)"]
  [15-02-06 10:24:38.9444] 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 
698)
  frame 13: main::idle (/usr/sbin/squeezeboxserver line 665)
  frame 14: main::main (/usr/sbin/squeezeboxserver line 1200)
  
  
  [15-02-06 10:24:38.9447] 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,,1419069974)"] at 
/usr/share/perl5/Slim/Schema/Storage.pm line 126
  
  [15-02-06 10:24:38.9450] Plugins::CustomScan::Scanner::exitScan (1014) 
Optimizing SQLite database
  [15-02-06 10:24:38.9456] Plugins::CustomScan::Scanner::exitScan (1041) Rescan 
finished of Plugins::TrackStat::Plugin->itunesimport
  [15-02-06 10:25:33.2376] Plugins::TrackStat::Storage::findTrack (533) 
findTrack(): URL: 
file:///music/Muziek/iTunes/iTunes%20Music/Music/Sam%20Cooke/Sam%20Cooke%20The%20Man%20Who%20Invented%20Soul/Disc%201/01%20You%20Send%20Me.mp3
  
--------------------


Any ideas?

To be sure: I'm using a fairly recent version of LMS 7.9 and the latest
iTunes (12.1).

Thank you,
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

Reply via email to