PasTim wrote: > I thought I should just take at look at the log to make sure all was OK, > and I found this: > > Code: -------------------- > > > 2017-07-23 19:33:30 squeezeboxserver_safe started. > [17-07-23 19:33:39.4383] main::init (387) Starting Logitech Media Server (v7.9.1, 1499900819, Thu Jul 13 04:20:16 UTC 2017) perl 5.024001 - x86_64-linux-gnu-thread-multi > [17-07-23 19:33:51.1364] Plugins::CustomScan::Scanner::initDatabase (114) CustomScan: Creating database tables > [17-07-23 19:33:51.1502] Plugins::CustomScan::Scanner::initDatabase (119) CustomScan: Upgrading database adding table column valuesort, please wait... > [17-07-23 19:33:51.1521] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn't open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_valuesort.sql : No such file or directory > [17-07-23 19:33:51.1541] Plugins::CustomScan::Scanner::initDatabase (125) CustomScan: Upgrading database adding table column extravalue, please wait... > [17-07-23 19:33:51.1602] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn't open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_extravalue.sql : No such file or directory > [17-07-23 19:33:51.1621] Plugins::CustomScan::Scanner::initDatabase (131) CustomScan: Upgrading database adding table column valuetype, please wait... > [17-07-23 19:33:51.1642] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn't open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_valuetype.sql : No such file or directory > -------------------- > > > The SQLite directory only contains dbcreate.sql and dbindex.sql. My > customscan_track_attributes table contains the 3 extra columns (and > has done for many a year). > > My system is running OK, and has had a complete rescan, but I haven't > started from a completely empty cache directory. Is this something to > be concerned about? I added a warning message to Scanner.pm to find out what was going wrong. The $@ message on the eval checking for the valuesort column is:
Code: -------------------- [17-08-03 22:08:31.9477] Plugins::CustomScan::Scanner::initDatabase (119) DBIx::Class::Storage::DBI::__ANON__(): DBI Exception: DBD::SQLite::db do failed: attempt to prepare on inactive database handle [for Statement "select valuesort from customscan_track_attributes limit 1;"] at /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/Scanner.pm line 117 -------------------- Now I know almost no perl at all (I spent a while finding out what $@ meant), but I guess this means something like the database hasn't been opened. It would be nice to clean up the log, but I realise it's very low priority. LMS 7.9.1 on VortexBox Midi box, Xubuntu 17.04, FLACs 16->24 bit, 44.1->192kbps. Touch & EDO. 2nd Touch standard. LMS plugin UPnP/DLNA Bridge to MF M1 CLiC (to A308CR amp & ESLs) & Marantz CR603 UPnP renderers. Alternatively Minimserver & Upplay to same & to upmpdcli/mpd PC renderers. Squeezelite to Meridian USB Explorer DAC to PC speakers/headphones. Wireless Xubuntu 17.04 laptop firefox/upplay or Android 'phone with Squeeze-Commander/BubbleUPnP controls LMS/Minimserver. ------------------------------------------------------------------------ PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=107707 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins