Max2Play Home › Forums › Max2Play as Squeezebox (Player / Server) › [SOLVED] Problems with Erland Isaksson plugins – Squeezebox Server 7.9
Tagged: LMS plugins; Erland Isaksson
- This topic has 3 replies, 2 voices, and was last updated 7 years, 8 months ago by Mbydeen.
-
16. Februar 2017 at 12:53 #26952
Hi – adding in Erland’s great plugins causes LMS to misbehave severely. Something along these lines
[17-02-16 11:28:05.6187] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db do failed: database is locked [for Statement „CREATE TABLE multilibrary_track (library int(10) not null,track int(10) not null,primary key (library,track));“]
[17-02-16 11:28:05.6207] Slim::Schema::Storage::throw_exception (122) Backtrace:frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1007)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 1401)
frame 3: (eval) (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 1401)
frame 4: Plugins::MultiLibrary::Plugin::executeSQLFile (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 1283)
frame 5: Plugins::MultiLibrary::Plugin::initDatabase (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 857)
frame 6: Plugins::MultiLibrary::Plugin::initPlugin (/usr/share/perl5/Slim/Utils/PluginManager.pm line 383)
frame 7: (eval) (/usr/share/perl5/Slim/Utils/PluginManager.pm line 383)
frame 8: Slim::Utils::PluginManager::load (/usr/sbin/squeezeboxserver line 598)
frame 9: main::init (/usr/sbin/squeezeboxserver line 676)
frame 10: main::main (/usr/sbin/squeezeboxserver line 1214)[17-02-16 11:28:05.6227] Slim::Utils::Misc::msg (1244) Warning: [11:28:05.6215] Couldn’t execute SQL statement: [CREATE TABLE multilibrary_track (library int(10) not null,track int(10) not null,primary key (library,track));] : [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: database is locked [for Statement „CREATE TABLE multilibrary_track (library int(10) not null,track int(10) not null,primary key (library,track));“] at /usr/share/perl5/Slim/Schema/Storage.pm line 126
]
[17-02-16 11:28:09.5127] Slim::Utils::PluginManager::shutdownPlugins (410) Warning: error running Slim::Plugin::UPnP::Plugin->shutdownPlugin: Can’t locate object method „shutdown“ via package „Slim::Plugin::UPnP::MediaServer“ at /usr/share/perl5/Slim/Plugin/UPnP/Plugin.pm line 57, <$fh> line 35.
2017-02-16 11:28:09 squeezeboxserver_safe started.
[17-02-16 11:28:20.9533] main::init (388) Starting Logitech Media Server (v7.9.0, 1487144914, Wed Feb 15 08:29:20 UTC 2017) perl 5.020002 – arm-linux-gnueabihf-thread-multi-64int
[17-02-16 11:28:38.7958] Slim::Utils::Misc::msg (1244) Warning: [11:28:38.7941] DBIx::Class::ResultSet::update_or_create(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/perl5/Slim/Schema.pm line 1877
[17-02-16 11:28:56.7190] Slim::Utils::Misc::msg (1244) Warning: [11:28:56.7173] MultiLibrary: Creating database tables
[17-02-16 11:28:56.7405] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db do failed: table multilibrary_libraries already exists [for Statement „CREATE TABLE multilibrary_libraries (id INTEGER PRIMARY KEY AUTOINCREMENT,libraryid varchar(255) not null,name varchar(255) not null);“]
[17-02-16 11:28:56.7430] Slim::Schema::Storage::throw_exception (122) Backtrace:frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1007)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 1401)
frame 3: (eval) (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 1401)
frame 4: Plugins::MultiLibrary::Plugin::executeSQLFile (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 1283)
frame 5: Plugins::MultiLibrary::Plugin::initDatabase (/var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/MultiLibrary/Plugin.pm line 857)
frame 6: Plugins::MultiLibrary::Plugin::initPlugin (/usr/share/perl5/Slim/Utils/PluginManager.pm line 383)
frame 7: (eval) (/usr/share/perl5/Slim/Utils/PluginManager.pm line 383)
frame 8: Slim::Utils::PluginManager::load (/usr/sbin/squeezeboxserver line 598)
frame 9: main::init (/usr/sbin/squeezeboxserver line 676)
frame 10: main::main (/usr/sbin/squeezeboxserver line 1214)[17-02-16 11:28:56.7456] Slim::Utils::Misc::msg (1244) Warning: [11:28:56.7441] Couldn’t execute SQL statement: [CREATE TABLE multilibrary_libraries (id INTEGER PRIMARY KEY AUTOINCREMENT,libraryid varchar(255) not null,name varchar(255) not null);] : [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: table multilibrary_libraries already exists [for Statement „CREATE TABLE multilibrary_libraries (id INTEGER PRIMARY KEY AUTOINCREMENT,libraryid varchar(255) not null,name varchar(255) not null);“] at /usr/share/perl5/Slim/Schema/Storage.pm line 126
]
2017-02-16 11:34:11 squeezeboxserver_safe stopped.
2017-02-16 11:34:11 squeezeboxserver_safe started.
[17-02-16 11:34:18.2769] main::init (388) Starting Logitech Media Server (v7.9.0, 1487144914, Wed Feb 15 08:29:20 UTC 2017) perl 5.020002 – arm-linux-gnueabihf-thread-multi-64int
[17-02-16 11:34:20.6946] Slim::Utils::Misc::msg (1244) Warning: [11:34:20.6933] DBIx::Class::ResultSet::update_or_create(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/perl5/Slim/Schema.pm line 1877
2017-02-16 11:35:26 squeezeboxserver_safe stopped.
2017-02-16 11:35:26 squeezeboxserver_safe started.
[17-02-16 11:35:33.9145] main::init (388) Starting Logitech Media Server (v7.9.0, 1487144914, Wed Feb 15 08:29:20 UTC 2017) perl 5.020002 – arm-linux-gnueabihf-thread-multi-64int
[17-02-16 11:35:37.4482] Slim::Utils::Misc::msg (1244) Warning: [11:35:37.4468] DBIx::Class::ResultSet::update_or_create(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/perl5/Slim/Schema.pm line 1877#### PERL VERSION ####
v5.20.2latest max2play and latest 7.9 nightly build
16. Februar 2017 at 21:14 #26998Custom browse and multi library. Would like to use trackstat and the associated dynamic playlist, but they are SQL based as well.
20. Februar 2017 at 13:02 #27035Hi snaillybob,
Please make sure that the plugins are up to date and compatible with the latest version of SBS, and if you have any problem, you can contact the developer on:
erland’s Profile: http://forums.slimdevices.com/member.php?userid=3124
Erland Isaksson: http://erland.isaksson.infoRegards,
Mohammad -
You must be logged in to reply to this topic.