PDA

View Full Version : Squeezebox server now won't start



mknappe
2010-10-07, 20:55
All of a sudden, after over a year of working flawlessly, my squeezebox server running on Mac OSX 10.6 on an iMac has stopped working. When i try to restart the server, i get the following log message below - anyone know why i'm suddenly getting this problem? Where's the 'me.audio' column coming from? Thanks, Mike:


[10-10-07 20:47:53.0333] Slim::Schema::Storage::throw_exception (82) Error: Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.audio' in 'where clause' [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.audio = ? )"] at /Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm line 86
[10-10-07 20:47:53.0335] Slim::Schema::Storage::throw_exception (82) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm line 82)
frame 1: Slim::Schema::Storage::throw_exception (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 562)
frame 2: DBIx::Class::Storage:BI::dbh_do (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 101)
frame 3: DBIx::Class::Storage:BI::Cursor::next (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/ResultSetColumn.pm line 128)
frame 4: DBIx::Class::ResultSetColumn::next (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/ResultSet.pm line 1181)
frame 5: DBIx::Class::ResultSet::count (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/ResultSet.pm line 1164)
frame 6: DBIx::Class::ResultSet::count (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema.pm line 599)
frame 7: Slim::Schema::count (./slimserver.pl line 972)
frame 8: main::checkDataSource (./slimserver.pl line 522)
frame 9: main::init (./slimserver.pl line 578)
frame 10: main::main (./slimserver.pl line 1072)

[10-10-07 20:47:53.0338] Carp::Clan::__ANON__ (214) Warning: Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.audio' in 'where clause' [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.audio = ? )"] at /Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm line 86

mknappe
2010-10-07, 21:02
There's actually more to the error trace, these messages precede those in my earlier post:

[10-10-07 20:47:40.0082] main::init (323) Starting Squeezebox Server (v7.5.1, r30836, Tue Jun 1 05:56:14 PDT 2010) perl 5.010000
[10-10-07 20:47:48.1870] main::init (323) Starting Squeezebox Server (v7.5.1, r30836, Tue Jun 1 05:56:14 PDT 2010) perl 5.010000
[10-10-07 20:47:53.0324] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.audio' in 'where clause' [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.audio = ? )"]
[10-10-07 20:47:53.0328] Slim::Schema::Storage::throw_exception (82) Backtrace:

mknappe
2010-10-07, 21:04
plus the following:


frame 0: Slim::Utils::Log::logBacktrace (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm line 82)
frame 1: Slim::Schema::Storage::throw_exception (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 957)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 1217)
frame 3: DBIx::Class::Storage::DBI::_dbh_execute (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 532)

mknappe
2010-10-07, 21:04
frame 4: DBIx::Class::Storage::DBI::dbh_do (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 1227)
frame 5: DBIx::Class::Storage::DBI::_execute (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 1451)
frame 6: DBIx::Class::Storage::DBI::_select (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 82)

mknappe
2010-10-07, 21:05
frame 7: DBIx::Class::Storage::DBI::Cursor::_dbh_next (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 547)
frame 8: (eval) (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm line 540)
frame 9: DBIx::Class::Storage::DBI::dbh_do (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 101)
frame 10: DBIx::Class::Storage::DBI::Cursor::next (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/ResultSetColumn.pm line 128)
frame 11: DBIx::Class::ResultSetColumn::next (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/ResultSet.pm line 1181)
frame 12: DBIx::Class::ResultSet::count (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/ResultSet.pm line 1164)
frame 13: DBIx::Class::ResultSet::count (/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema.pm line 599)
frame 14: Slim::Schema::count (./slimserver.pl line 972)
frame 15: main::checkDataSource (./slimserver.pl line 522)
frame 16: main::init (./slimserver.pl line 578)
frame 17: main::main (./slimserver.pl line 1072)

Phil Leigh
2010-10-07, 21:47
new/updated plugin?

mknappe
2010-10-07, 22:21
No new plug ins that i know of, although i did turn on 'Ping' in itunes about a week before...

Phil Leigh
2010-10-07, 22:29
repair osx preferences...

mknappe
2010-10-08, 04:11
So i even went in and deleted the entire squeezebox pref pane, reinstalled squeezebox server, and it still won't start, getting the same basic messages as above, ending with the following:

[10-10-08 04:06:17.8201] Carp::Clan::__ANON__ (214) Warning: Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.content_type' in 'where clause' [for Statement "SELECT COUNT( * ) FROM tracks me WHERE ( me.content_type = ? )"] at /Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm line 86
[10-10-08 04:06:20.5422] Slim::Schema::forceCommit (1622) Warning: Trying to commit transactions before DB is initialized!

mknappe
2010-10-08, 04:19
OK, i think i fixed it. I went in to squeezebox preferences, Advanced tab, and selected both cleanup of preferences and the cache (i had only tried preferences before). Cleaning up the cache appears to have fixed the problem.

Mike