erland;485658 Wrote:
> Could you try to restart SBS and post the server.log after it has
> started. TrackStat tries to fix problems like this at startup so it
> would be interested to if you get any errors at startup.
>
> Did the problem start after a SBS upgrade ? Which SBS version did you
> use previously ?
This seems to be the very first error message of this kind in the
server.log:
Code:
--------------------
[09-11-12 17:53:28.2658] Plugins::MultiLibrary::Plugin::updateCharSet
(1261) Converting multilibrary_track to correct charset=utf8
collate=utf8_swedish_ci
[09-11-12 17:53:31.5471] Plugins::MultiLibrary::Plugin::updateCharSet (1261)
Converting multilibrary_album to correct charset=utf8 collate=utf8_swedish_ci
[09-11-12 17:53:31.8040] Plugins::MultiLibrary::Plugin::updateCharSet (1261)
Converting multilibrary_contributor to correct charset=utf8
collate=utf8_swedish_ci
[09-11-12 17:53:32.3439] Plugins::MultiLibrary::Plugin::updateCharSet (1261)
Converting multilibrary_libraries to correct charset=utf8
collate=utf8_swedish_ci
[09-11-12 17:54:32.6562] Plugins::TrackStat::Storage::init (285) Converting
track_statistics to correct charset=utf8 collate=utf8_swedish_ci
[09-11-12 17:54:54.5314] Plugins::TrackStat::Storage::init (312) Converting
track_history to correct charset=utf8 collate=utf8_swedish_ci
[09-11-12 17:55:31.9024] 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-12 17:55:31.9032] 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-12 17:55:31.9038] Plugins::TrackStat::Storage::refreshTracks (1406)
Database error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and
(utf8_swedish_ci,IMPLICIT) for operation '='
[09-11-12 17:55:45.2043] 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-12 17:55:45.2050] Slim::Schema::Storage::throw_exception (82)
Backtrace:
--------------------
I think I updated from 7.4.2 r29203 to r29220 on 11 November, and then
to r29251 on 13 November. On 11 November, while on r29220 I switched
languages in SBS from Swedish to English and back (to fix a sorting
issue).
I have restarted SBS several times and also restarted the computer
running SBS. Now I tried reinstalling r29251. After that I got the
following in the server.log:
Code:
--------------------
[09-11-15 15:46:36.3908] Plugins::MultiLibrary::Plugin::initPlugin (820)
Startup error: Couldn't rename C:\Documents and Settings\All Users\Application
Data\Squeezebox\Cache\FileCache\MultiLibrary2.4\Templates\a\5\3\r9JyFB0Uyo to
C:\Documents and Settings\All Users\Application
Data\Squeezebox\Cache\FileCache\MultiLibrary2.4\Templates\a\5\3\a538c70b649f9a6f7466c1cd9ba30b72c85ff871:
Permission denied at
/<C:\Program\SQUEEZ~2\server\SQUEEZ~3.EXE>Cache/FileBackend.pm line 580.
[09-11-15 15:48:11.3127] 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-15 15:48:11.3135] 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-15 15:48:11.3141] Plugins::TrackStat::Storage::refreshTracks (1406)
Database error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and
(utf8_swedish_ci,IMPLICIT) for operation '='
[09-11-15 15:48:35.3603] 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-15 15:48:35.3610] 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)
--------------------
Attached is the complete server.log.
+-------------------------------------------------------------------+
|Filename: server.zip |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=8710|
+-------------------------------------------------------------------+
--
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
