In SBS (7.4.2 r29251) I get these error messages (see below). They seem
related to TrackStat. I have not noticed any problem within SBS, but I
can no longer sync the SBS database with muso, because muso quits with a
similar error message ("Illegal mix of collations
(utf8_general_ci,IMPLICIT) and (utf8_swedish_ci,IMPLICIT) for operation
'='"). Any idea what could cause this and how it can be fixed?
Code:
--------------------
[09-11-13 15:48:35.2189] Slim::Schema::Storage::throw_exception (82) Error:
DBI Exception: DBD::mysql::st execute failed: Illegal mix of collations
(utf8_general_ci,IMPLICIT) and (utf8_swedish_ci,IMPLICIT) for operation '='
[for Statement "UPDATE tracks_persistent,track_statistics set
tracks_persistent.rating=track_statistics.rating where
tracks_persistent.url=track_statistics.url and track_statistics.rating>0 and
(tracks_persistent.rating!=track_statistics.rating or tracks_persistent.rating
is null)"]
[09-11-13 15:48:35.2198] Slim::Schema::Storage::throw_exception (82)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/<C:\Program\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line 82)
frame 1: Slim::Schema::Storage::throw_exception
(/<C:\Program\SQUEEZ~2\server\SQUEEZ~3.EXE>DBIx/Class/Storage/DBI.pm line 957)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (C:\Documents and Settings\All
Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/TrackStat/Storage.pm line 1400)
frame 3: (eval) (C:\Documents and Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/TrackStat/Storage.pm line 1399)
frame 4: Plugins::TrackStat::Storage::refreshTracks (C:\Documents and
Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/TrackStat/Storage.pm line 420)
frame 5: Plugins::TrackStat::Storage::init (C:\Documents and Settings\All
Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/TrackStat/Plugin.pm line 2533)
frame 6: Plugins::TrackStat::Plugin::initPlugin
(/<C:\Program\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Utils/PluginManager.pm line 323)
frame 7: (eval)
(/<C:\Program\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Utils/PluginManager.pm line 323)
frame 8: Slim::Utils::PluginManager::load (slimserver.pl line 501)
frame 9: main::init (slimserver.pl line 572)
frame 10: main::main (slimserver.pl line 98)
frame 11: PerlSvc::Interactive
(/<C:\Program\SQUEEZ~2\server\SQUEEZ~3.EXE>PerlSvc.pm line 99)
frame 12: PerlSvc::_interactive (slimserver.pl line 0)
frame 13: (eval) (slimserver.pl line 0)
[09-11-13 15:48:35.2204] Plugins::TrackStat::Storage::refreshTracks (1406)
Database error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and
(utf8_swedish_ci,IMPLICIT) for operation '='
[09-11-13 15:48:50.8605] Slim::Schema::Storage::throw_exception (82) Error:
DBI Exception: DBD::mysql::st execute failed: Illegal mix of collations
(utf8_general_ci,IMPLICIT) and (utf8_swedish_ci,IMPLICIT) for operation '='
[for Statement "UPDATE tracks_persistent,track_statistics SET
track_statistics.rating=tracks_persistent.rating where
tracks_persistent.url=track_statistics.url and (track_statistics.rating is null
or track_statistics.rating=0) and tracks_persistent.rating>0"]
[09-11-13 15:48:50.8613] Slim::Schema::Storage::throw_exception (82)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/<C:\Program\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line 82)
frame 1: Slim::Schema::Storage::throw_exception
(/<C:\Program\SQUEEZ~2\server\SQUEEZ~3.EXE>DBIx/Class/Storage/DBI.pm line 957)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (C:\Documents and Settings\All
Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/TrackStat/Storage.pm line 1528)
frame 3: (eval) (C:\Documents and Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/TrackStat/Storage.pm line 1527)
frame 4: Plugins::TrackStat::Storage::refreshTracks (C:\Documents and
Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/TrackStat/Storage.pm line 420)
frame 5: Plugins::TrackStat::Storage::init (C:\Documents and Settings\All
Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/TrackStat/Plugin.pm line 2533)
frame 6: Plugins::TrackStat::Plugin::initPlugin
(/<C:\Program\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Utils/PluginManager.pm line 323)
frame 7: (eval)
(/<C:\Program\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Utils/PluginManager.pm line 323)
frame 8: Slim::Utils::PluginManager::load (slimserver.pl line 501)
frame 9: main::init (slimserver.pl line 572)
frame 10: main::main (slimserver.pl line 98)
frame 11: PerlSvc::Interactive
(/<C:\Program\SQUEEZ~2\server\SQUEEZ~3.EXE>PerlSvc.pm line 99)
frame 12: PerlSvc::_interactive (slimserver.pl line 0)
frame 13: (eval) (slimserver.pl line 0)
--------------------
--
vagskal
2 x SB3 (wired), Receiver (wireless), Boom (wireless), Controller, iPeng
on iPod Touch, muso on remote computer running Win XP | 7.4.2 on Win XP
------------------------------------------------------------------------
vagskal's Profile: http://forums.slimdevices.com/member.php?userid=20778
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
