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
