First Last Prev Next    This bug is not in your last search results.
Bug 3878 - SlimServer_v2006-08-06.exe fails on startup
: SlimServer_v2006-08-06.exe fails on startup
Status: RESOLVED INVALID
Product: Logitech Media Server
Classification: Unclassified
Component: CLI
: 6.5b1
: PC Windows XP
: P1 critical (vote)
: ---
Assigned To: Chris Owens
:
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2006-08-06 12:13 UTC by Jordan Hirsch
Modified: 2006-08-06 17:22 UTC (History)
0 users

See Also:
Category: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jordan Hirsch 2006-08-06 12:13:08 UTC 
Using the latest nightly SlimServer build (8-6-2006) and connecting to MySQL, I get the following output when I run slim.exe from the command line:

C:\Program Files\SlimServer\server>slim.exe
2006-08-06 15:01:50.5156 Unquoted string "personal" may clash with future reserved word at C:\Program Files\SlimServer\server/Plugins/LastFM/Plugin.pm line 1176.
2006-08-06 15:01:50.6747 "my" variable $play masks earlier declaration in same scope at C:\Program Files\SlimServer\server/Plugins/XMRadio/Plugin.pm line 283.
2006-08-06 15:01:50.7068 Scalar value @genreList[$j] better written as $genreList[$j] at C:\Program Files\SlimServer\server/Plugins/XMRadio/Plugin.pm line 1597.

2006-08-06 15:01:51.3998 ERROR: Slim::Control::Command::setExecuteCallback() has been deprecated!
2006-08-06 15:01:51.4036 ERROR: Please use Slim::Control::Request::subscribe() instead!
2006-08-06 15:01:51.4077 ERROR: Documentation is available in Slim::Control::Request.pm

2006-08-06 15:01:51.4136 Slim::Web::Pages::addLinks() has been deprecated in favor of
             Slim::Web::Pages->addPageLinks. Please update your calls!
2006-08-06 15:01:51.4195 Backtrace:

   frame 0: Slim::Web::Pages::addLinks (C:\Program Files\SlimServer\server/Plugins/XMRadio/Plugin.pm line 1326)
   frame 1: Plugins::XMRadio::Plugin::webPages (/PerlApp/Slim/Utils/PluginManager.pm line 382)
   frame 2: (eval) (/PerlApp/Slim/Utils/PluginManager.pm line 382)
   frame 3: Slim::Utils::PluginManager::addWebPages (/PerlApp/Slim/Utils/PluginManager.pm line 157)
   frame 4: Slim::Utils::PluginManager::initPlugins (/PerlApp/Slim/Utils/PluginManager.pm line 55)
   frame 5: Slim::Utils::PluginManager::init (slimserver.pl line 416)
   frame 6: main::init (slimserver.pl line 444)
   frame 7: main::main (slimserver.pl line 56)
   frame 8: PerlSvc::Interactive (perlsvc.pl line 1486)
   frame 9: PerlSvc::_interactive (slimserver.pl line 0)
   frame 10: (eval) (slimserver.pl line 0)

2006-08-06 15:01:51.7447 DBD::mysql::st execute failed: Unknown column 'me.name' in 'field list' at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 743, <DATA> line 1.
2006-08-06 15:01:51.7505 ERROR: Error executing 'SELECT me.name, me.value FROM metainformation me WHERE ( name = ? )': DBD::mysql::st execute failed: Unknown column 'me.name' in 'field list' at C:\Program Files\SlimServer\server\CPAN/DBIx/C
lass/Storage/DBI.pm line 743, <DATA> line 1.

2006-08-06 15:01:51.7597 ERROR: Backtrace follows:

2006-08-06 15:01:51.7638 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 745)
   frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 798)
   frame 2: DBIx::Class::Storage::DBI::_select (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 824)
   frame 3: DBIx::Class::Storage::DBI::select_single (C:\Program Files\SlimServer\server/Slim/Schema/Storage.pm line 55)
   frame 4: Slim::Schema::Storage::select_single (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 485)
   frame 5: DBIx::Class::ResultSet::single (/PerlApp/Slim/Schema.pm line 275)
   frame 6: Slim::Schema::single (/PerlApp/Slim/Music/Import.pm line 296)
   frame 7: Slim::Music::Import::stillScanning (/PerlApp/Slim/Control/Commands.pm line 1636)
   frame 8: Slim::Control::Commands::rescanCommand (/PerlApp/Slim/Control/Request.pm line 1405)
   frame 9: (eval) (/PerlApp/Slim/Control/Request.pm line 1405)
   frame 10: Slim::Control::Request::execute (/PerlApp/Slim/Control/Request.pm line 731)
   frame 11: Slim::Control::Request::executeRequest (slimserver.pl line 929)
   frame 12: main::checkDataSource (slimserver.pl line 419)
   frame 13: main::init (slimserver.pl line 444)
   frame 14: main::main (slimserver.pl line 56)
   frame 15: PerlSvc::Interactive (perlsvc.pl line 1486)
   frame 16: PerlSvc::_interactive (slimserver.pl line 0)
   frame 17: (eval) (slimserver.pl line 0)

2006-08-06 15:01:51.8210 DBD::mysql::st fetchrow_array failed: fetch() without execute() at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 825, <DATA> line 1.
2006-08-06 15:01:51.8593 ERROR: Request: Error when trying to run function coderef: [DBD::mysql::st fetchrow_array failed: fetch() without execute() at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 825, <DATA> line 1.]

2006-08-06 15:01:51.8710 Request: Command [rescan] (Bad dispatch!)

2006-08-06 15:04:26.0300 DBD::mysql::st execute failed: Unknown column 'me.name' in 'field list' at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 743.
2006-08-06 15:04:26.0305 ERROR: Error executing 'SELECT me.name, me.value FROM metainformation me WHERE ( name = ? )': DBD::mysql::st execute failed: Unknown column 'me.name' in 'field list' at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 743.

2006-08-06 15:04:26.0307 ERROR: Backtrace follows:

2006-08-06 15:04:26.0313 Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 745)
   frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 798)
   frame 2: DBIx::Class::Storage::DBI::_select (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 824)
   frame 3: DBIx::Class::Storage::DBI::select_single (C:\Program Files\SlimServer\server/Slim/Schema/Storage.pm line 55)
   frame 4: Slim::Schema::Storage::select_single (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 485)
   frame 5: DBIx::Class::ResultSet::single (/PerlApp/Slim/Schema.pm line 275)
   frame 6: Slim::Schema::single (/PerlApp/Slim/Music/Import.pm line 296)
   frame 7: Slim::Music::Import::stillScanning (/PerlApp/Slim/Web/Pages.pm line 108)
   frame 8: Slim::Web::Pages::addLibraryStats (/PerlApp/Slim/Web/Pages/Home.pm line 101)
   frame 9: Slim::Web::Pages::Home::home (/PerlApp/Slim/Web/Pages/Home.pm line 19)
   frame 10: Slim::Web::Pages::Home::__ANON__ (/PerlApp/Slim/Web/HTTP.pm line 793)
   frame 11: Slim::Web::HTTP::generateHTTPResponse (/PerlApp/Slim/Web/HTTP.pm line 667)
   frame 12: Slim::Web::HTTP::processURL (/PerlApp/Slim/Web/HTTP.pm line 517)
   frame 13: Slim::Web::HTTP::processHTTP (/PerlApp/Slim/Networking/Select.pm line 170)
   frame 14: Slim::Networking::Select::select (slimserver.pl line 493)
   frame 15: main::idle (slimserver.pl line 446)
   frame 16: main::main (slimserver.pl line 56)
   frame 17: PerlSvc::Interactive (perlsvc.pl line 1486)
   frame 18: PerlSvc::_interactive (slimserver.pl line 0)
   frame 19: (eval) (slimserver.pl line 0)

2006-08-06 15:04:26.0329 DBD::mysql::st fetchrow_array failed: fetch() without execute() at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 825.
2006-08-06 15:04:26.0339 DBD::mysql::st fetchrow_array failed: fetch() without execute() at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 825.
Comment 1 KDF 2006-08-06 14:34:13 UTC 
please don't preset targets.  undef is to flag for review
Comment 2 Fred 2006-08-06 16:33:13 UTC 
What I see happening here are old plugins triggering a lot of warnings and harmless errors, followed by an SQL query problem in querying FROM metainformation. Such queries are used when checking for a rescan in progress, which the rescan/wipecache do before starting a new rescan. In this particular case, the rescan is triggered by routine checkDataSource() in main.

My gut feeling is that for some reason, the metainformation table is not present in this user DB, or not properly defined. I don't see any CLI or command mechanism problem.

HTH
Comment 3 Jordan Hirsch 2006-08-06 17:01:39 UTC 
Thank you - has the schema changed in the past month or so?  I see a SQL/mysql/Upgrades folder, but I'm not sure what to run in there.  Sorry if this isn't really a bug and if it's just user error.
Comment 4 Jordan Hirsch 2006-08-06 17:22:43 UTC 
I rebuilt the MySQL schema based on the latest .sql files in the distribution and it seems to be working fine now.  Sorry for the false alarm.
First Last Prev Next    This bug is not in your last search results.