Hi Erland-- I can no longer rate songs from iPeng. It doesn't matter which version of iPeng I try (I have from iPeng 8 on a iPad Mini all the way back to iPeng 1.4.5 on an original iPhone). Based on my log file it looks like TrackStat is what is really having the issue. I should explain that I can update the rating using a web browser. I can also update the rating if I use the stars in iPeng. The problem occurs when I try to update a rating through the Song Info menu (not to be confused with your Song Info plugin), which I get to by press and holding a track for one second. This used to work. I don't know when it stopped, but my guess is that it was several months ago (late spring or early summer).
I made some changes to my system around that time. I uninstalled plugins that I didn't use. Is there a particular plugin that is required in addition to TrackStat to save ratings from the Song Info menu? What about any setting within TrackStat itself? LogFile wrote: > [14-10-22 21:17:14.6617] Slim::Control::Request::execute (1888) Error: > While trying to run function coderef > [Plugins::TrackStat::Plugin::setCLIRating]: [Carp::Clan::__ANON__(): DBI > Exception: DBD::SQLite::db prepare failed: near ":1": syntax error [for > Statement "UPDATE track_statistics set rating=useContextMenu:1 where url > = ? or url = ?"] at > /Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm > line 126 > ] > [14-10-22 21:17:14.8502] Slim::Schema::Storage::throw_exception (122) > Error: DBI Exception: DBD::SQLite::db prepare failed: near ":1": syntax > error [for Statement "UPDATE track_statistics set > rating=useContextMenu:1 where url = ? or url = ?"] > [14-10-22 21:17:14.8507] Slim::Schema::Storage::throw_exception (122) > Backtrace: > > frame 0: Slim::Utils::Log::logBacktrace > (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm > line 122) > frame 1: Slim::Schema::Storage::throw_exception > (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm > line 1006) > frame 2: DBIx::Class::Storage::DBI::__ANON__ > (/Users/prabbit/Library/Caches/Squeezebox/InstalledPlugins/Plugins/TrackStat/Storage.pm > line 707) > frame 3: Plugins::TrackStat::Storage::saveRating > (/Users/prabbit/Library/Caches/Squeezebox/InstalledPlugins/Plugins/TrackStat/Plugin.pm > line 4635) > frame 4: Plugins::TrackStat::Plugin::rateSong > (/Users/prabbit/Library/Caches/Squeezebox/InstalledPlugins/Plugins/TrackStat/Plugin.pm > line 4822) > frame 5: Plugins::TrackStat::Plugin::setCLIRating > (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Control/Request.pm > line 1883) > frame 6: (eval) > (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Control/Request.pm > line 1883) > frame 7: Slim::Control::Request::execute > (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Web/Cometd.pm > line 871) > frame 8: Slim::Web::Cometd::handleRequest > (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Web/Cometd.pm > line 534) > frame 9: Slim::Web::Cometd::handler > (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Web/Cometd.pm > line 113) > frame 10: Slim::Web::Cometd::webHandler > (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Web/HTTP.pm > line 486) > frame 11: Slim::Web::HTTP::processHTTP > (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Networking/IO/Select.pm > line 139) > frame 12: (eval) > (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Networking/IO/Select.pm > line 123) > frame 13: Slim::Networking::IO::Select::__ANON__ > (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Networking/IO/Select.pm > line 184) > frame 14: (eval) > (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Networking/IO/Select.pm > line 184) > frame 15: Slim::Networking::IO::Select::loop (./slimserver.pl line > 709) > frame 16: main::idle (./slimserver.pl line 659) > frame 17: main::main (./slimserver.pl line 1193) Server details: Logitech Media Server Version: 7.8.0 - 1391011014 @ Wed Jan 29 19:01:13 PST 2014 OS: Mac OS X 10.6.8 - EN - utf8 Perl Version: 5.10.0 - darwin-thread-multi-2level Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1) TrackStat v3.2.3945 ------------------------------------------------------------------------ prabbit's Profile: http://forums.slimdevices.com/member.php?userid=11142 View this thread: http://forums.slimdevices.com/showthread.php?t=49483 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
