Bugzilla – Bug 3820
DBD::mysql::st execute failed: Table 'slimserver.years' doesn't exist
Last modified: 2008-09-15 14:39:24 UTC
I am seeing the following whenever I start my server: 2006-07-26 22:06:20.6715 DBD::mysql::st execute failed: Table 'slimserver.years' doesn't exist at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 743, <DATA> line 1. 2006-07-26 22:06:20.6716 ERROR: Error executing 'SELECT me.id FROM years me WHERE ( ( me.id = ? ) )': DBD::mysql::st execute failed: Table 'slimserver.years' doesn't exist at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 743, <DATA> line 1. 2006-07-26 22:06:20.6717 ERROR: Backtrace follows: 2006-07-26 22:06:20.6720 Backtrace: frame 0: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 745) frame 1: DBIx::Class::Storage::DBI::_execute (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 798) frame 2: DBIx::Class::Storage::DBI::_select (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 824) frame 3: DBIx::Class::Storage::DBI::select_single (P:\Music\SlimServer\trunk\server/Slim/Schema/Storage.pm line 55) frame 4: Slim::Schema::Storage::select_single (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 485) frame 5: DBIx::Class::ResultSet::single (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 339) frame 6: DBIx::Class::ResultSet::find (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1301) frame 7: DBIx::Class::ResultSet::find_or_create (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 1886) frame 8: Slim::Schema::_postCheckAttributes (P:\Music\SlimServer\trunk\server/Slim/Schema.pm line 609) frame 9: Slim::Schema::updateOrCreate (P:\Music\SlimServer\trunk\server/Slim/Schema/ResultSet/Track.pm line 95) frame 10: Slim::Schema::ResultSet::Track::updateOrCreate (P:/Music/SlimServer/trunk/server/Slim/Music/Info.pm line 240) frame 11: Slim::Music::Info::setContentType (P:\Music\SlimServer\trunk\server/Slim/Formats/HTTP.pm line 146) frame 12: Slim::Formats::HTTP::parseHeaders (P:\Music\SlimServer\trunk\server/Slim/Formats/RemoteStream.pm line 181) frame 13: Slim::Formats::RemoteStream::request (P:\Music\SlimServer\trunk\server/Slim/Formats/RemoteStream.pm line 112) frame 14: Slim::Formats::RemoteStream::open (P:\Music\SlimServer\trunk\server/Slim/Player/Protocols/HTTP.pm line 43) frame 15: Slim::Player::Protocols::HTTP::new (P:\Music\SlimServer\trunk\server\Plugins\SlimScrobbler\SlimScrobbleSupport/Scrobbler/Session.pm line 123) frame 16: Scrobbler::Session::new (P:\Music\SlimServer\trunk\server/Plugins/SlimScrobbler/Plugin.pm line 646) frame 17: Plugins::SlimScrobbler::Plugin::getSessionForUserIDPassword (P:\Music\SlimServer\trunk\server/Plugins/SlimScrobbler/Plugin.pm line 794) frame 18: Plugins::SlimScrobbler::Plugin::hookScrobbler (P:\Music\SlimServer\trunk\server/Plugins/SlimScrobbler/Plugin.pm line 261) frame 19: Plugins::SlimScrobbler::Plugin::initPlugin (P:/Music/SlimServer/trunk/server/Slim/Utils/PluginManager.pm line 258) frame 20: (eval) (P:/Music/SlimServer/trunk/server/Slim/Utils/PluginManager.pm line 258) frame 21: Slim::Utils::PluginManager::addPlugin (P:/Music/SlimServer/trunk/server/Slim/Utils/PluginManager.pm line 148) frame 22: Slim::Utils::PluginManager::initPlugins (P:/Music/SlimServer/trunk/server/Slim/Utils/PluginManager.pm line 55) frame 23: Slim::Utils::PluginManager::init (P:\Music\SlimServer\trunk\server\slimserver.pl line 419) frame 24: main::init (P:\Music\SlimServer\trunk\server\slimserver.pl line 447) frame 25: main::main (P:\Music\SlimServer\trunk\server\slimserver.pl line 1046) 2006-07-26 22:06:20.6723 DBD::mysql::st fetchrow_array failed: fetch() without execute() at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 825, <DATA> line 1. 2006-07-26 22:06:20.6961 Warning: Slim::Music::Info::getCurrentDataStore() is deprecated. Please use Slim::Schema directly. 2006-07-26 22:06:20.6964 Use of uninitialized value in concatenation (.) or string at P:\Music\SlimServer\trunk\server/Plugins/AlarmPlugin.pm line 536, <DATA> line 1.
I see this at startup, but the server doesn't crash. However, if I try to view albums in gallery view, I get the same error and it crashes the server.
Fixed in change 8697