Hi Erland,
I followed your advice and (grrr... reluctantly) removed all the special
characters from the filenames; so in the future I won't be able to let
iTunes do the organizing.
Guess that's the trade-off in working with Linux and Windows...
Next, I cleared all Trackstat info & tried a new iTunes Import, and I
see that most *but not all of my ratings/statistics are imported*
(argh!).
This is the error in scanner.log; does that ring a bell?
Code:
--------------------
[14-03-14 20:57:01.3313] Slim::Utils::Misc::msg (1304) Warning:
[20:57:01.3310] Use of uninitialized value $added in concatenation (.) or
string at
/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/TrackStat/Storage.pm
line 1166, <ITUNESLIBRARY> chunk 19875.
[14-03-14 20:57:01.3319] 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 (?,'f3101bf39d568d77fc8c2fbb7249b8a3', 1,,1378845500)"]
[14-03-14 20:57:01.3322] 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 803)
frame 4: Plugins::TrackStat::iTunes::Import::sendTrackToStorage
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/TrackStat/iTunes/Import.pm
line 492)
frame 5: Plugins::TrackStat::iTunes::Import::handleTrack
(/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/TrackStat/iTunes/Import.pm
line 627)
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 356)
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
678)
frame 13: main::idle (/usr/sbin/squeezeboxserver line 645)
frame 14: main::main (/usr/sbin/squeezeboxserver line 1158)
[14-03-14 20:57:01.3325] 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 (?,'f3101bf39d568d77fc8c2fbb7249b8a3', 1,,1378845500)"] at
/usr/share/perl5/Slim/Schema/Storage.pm line 126
--------------------
------------------------------------------------------------------------
rlem's Profile: http://forums.slimdevices.com/member.php?userid=46931
View this thread: http://forums.slimdevices.com/showthread.php?t=101126
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
