Bug 3820 - DBD::mysql::st execute failed: Table 'slimserver.years' doesn't exist
: DBD::mysql::st execute failed: Table 'slimserver.years' doesn't exist
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.5b1
: PC Windows XP
: P2 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-07-26 14:08 UTC by Philip Meyer
Modified: 2008-09-15 14:39 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Philip Meyer 2006-07-26 14:08:06 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.
Comment 1 Philip Meyer 2006-07-26 14:12:02 UTC
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.
Comment 2 Dan Sully 2006-07-26 16:02:55 UTC
Fixed in change 8697