Earlier today I copied some new audio files to my QNAP 219P under the Squeezebox shares and successfully ran 'rescan' to update LMS.
I then noticed that my tags where not quite right for the newly copied album as it had 'Various Artists' in the 'Album Artist' field which I absolutely hate so I put in the actual album artist using the latest version of MP3TAG 2.83, the original tags were written with 2.77 of the same program. However whenever I try re-scan the library for changes it stops with ''Create library views (1 of 2) Complete 00:00:14 Media scan terminated unexpectedly (Scanning Progress) Total Time: 00:08:10 (Sunday, August 6, 2017 / 2:03 PM)" I took this as an opportunity to upgrade to the latest nightly of 7.9 from the '14900335303' version to ''1501791870'. I hoped this might kill two birds with one stone but it hasn't made a difference it is still failing at the same point. Here is an extract from the scanner log: Code: -------------------- 0444: [17-08-06 14:02:52.2124] main::main (342) Error: Not updating lastRescanTime! 0443: ] 0442: "] at /share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Schema/Storage.pm line 126 0441: WHERE ts.rating IS NULL 0440: JOIN track_statistics ts ON ts.url = tracks.url 0439: FROM tracks 0438: SELECT '5443755c', tracks.id 0437: INSERT OR IGNORE INTO library_track (library, track) 0436: [17-08-06 14:02:52.2095] main::main (341) Error: Failed when running scan post-process: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: no such table: track_statistics [for Statement " 0435: 0434: frame 8: main::main (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/scanner.pl line 495) 0433: frame 7: (eval) (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/scanner.pl line 337) 0432: frame 6: Slim::Music::Import::runScanPostProcessing (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/scanner.pl line 337) 0431: frame 5: Slim::Music::Import::runImporter (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Music/Import.pm line 411) 0430: frame 4: Slim::Music::VirtualLibraries::startScan (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Music/Import.pm line 513) 0429: frame 3: Slim::Music::VirtualLibraries::rebuild (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Music/VirtualLibraries.pm line 270) 0428: frame 2: DBIx::Class::Storage::DBI::__ANON__ (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Music/VirtualLibraries.pm line 323) 0427: frame 1: Slim::Schema::Storage::throw_exception (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/CPAN/DBIx/Class/Storage/DBI.pm line 1006) 0426: frame 0: Slim::Utils::Log::logBacktrace (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Schema/Storage.pm line 122) 0425: 0424: [17-08-06 14:02:52.1788] Slim::Schema::Storage::throw_exception (122) Backtrace: 0423: "] 0422: WHERE ts.rating IS NULL 0421: JOIN track_statistics ts ON ts.url = tracks.url 0420: FROM tracks 0419: SELECT '5443755c', tracks.id 0418: INSERT OR IGNORE INTO library_track (library, track) 0417: [17-08-06 14:02:52.1742] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db do failed: no such table: track_statistics [for Statement " 0416: [17-08-06 14:02:51.8096] Slim::Music::Import::runImporter (511) Starting Slim::Music::VirtualLibraries scan 0415: [17-08-06 14:02:51.7825] Slim::Music::Import::endImporter (643) Completed Slim::Plugin::FullTextSearch::Plugin Scan in 133 seconds. 0414: [17-08-06 14:02:51.7794] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (485) Fulltext index build done! 0413: [17-08-06 14:02:47.6338] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (470) Optimize fulltext index 0412: [17-08-06 14:02:12.2446] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (435) Create fulltext index for playlists 0411: [17-08-06 14:02:11.3172] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (425) Create fulltext index for contributors 0410: [17-08-06 14:01:40.8853] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (416) Create fulltext index for albums 0409: [17-08-06 14:00:40.8712] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (406) Create fulltext index for tracks 0408: [17-08-06 14:00:38.3831] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (400) Initialize fulltext table 0407: [17-08-06 14:00:38.3803] Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (396) Starting fulltext index build 0406: [17-08-06 14:00:38.3742] Slim::Music::Import::runImporter (511) Starting Slim::Plugin::FullTextSearch::Plugin scan -------------------- My SBS details are as follows: Logitech Media Server Status Logitech Media Server Version: 7.9.1 - 1501791870 @ Fri Aug 4 04:11:59 UTC 2017 Hostname: PetersNAS Server IP Address: 192.168.1.6 Server HTTP Port Number: 9001 Operating system: Linux - EN - utf8 Platform Architecture: armv5tel-linux Perl Version: 5.10.0 - armv5tel-linux-thread-multi Audio::Scan: 0.93 Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1) Total Players Recognized: 1 I've dug earlier in the day for before the upgrade and the same error is showing: Code: -------------------- 0029: [17-08-06 13:54:34.5645] Slim::Utils::Scanner::Local::rescan (181) Discovering audio files in /share/Qmultimedia/Music 0028: [17-08-06 13:54:34.5607] Slim::Music::Import::runImporter (511) Starting Slim::Media::MediaFolderScan scan 0027: "] at /share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Schema/Storage.pm line 126 0026: WHERE ts.rating IS NULL 0025: JOIN track_statistics ts ON ts.url = tracks.url 0024: FROM tracks 0023: SELECT '5443755c', tracks.id 0022: INSERT OR IGNORE INTO library_track (library, track) 0021: [17-08-06 13:54:33.9270] Slim::Utils::PluginManager::load (393) Warning: Couldn't call Plugins::PhilsLibraries::Plugin->initPlugin: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do failed: no such table: track_statistics [for Statement " 0020: 0019: frame 7: main::main (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/scanner.pl line 495) 0018: frame 6: Slim::Utils::PluginManager::load (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/scanner.pl line 273) 0017: frame 5: (eval) (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Utils/PluginManager.pm line 391) 0016: frame 4: Plugins::PhilsLibraries::Plugin::initPlugin (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Utils/PluginManager.pm line 391) 0015: frame 3: Slim::Music::VirtualLibraries::rebuild (/opt/ssods4/var/home/SqueezeboxServer/Cache/InstalledPlugins/Plugins/PhilsLibraries/Plugin.pm line 35) 0014: frame 2: DBIx::Class::Storage::DBI::__ANON__ (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Music/VirtualLibraries.pm line 323) 0013: frame 1: Slim::Schema::Storage::throw_exception (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/CPAN/DBIx/Class/Storage/DBI.pm line 1006) 0012: frame 0: Slim::Utils::Log::logBacktrace (/share/HDA_DATA/.qpkg/LogitechMediaServer/var/home/SqueezeboxServer/Slim/Schema/Storage.pm line 122) 0011: 0010: [17-08-06 13:54:33.9236] Slim::Schema::Storage::throw_exception (122) Backtrace: 0009: "] 0008: WHERE ts.rating IS NULL 0007: JOIN track_statistics ts ON ts.url = tracks.url 0006: FROM tracks 0005: SELECT '5443755c', tracks.id 0004: INSERT OR IGNORE INTO library_track (library, track) 0003: [17-08-06 13:54:33.9199] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db do failed: no such table: track_statistics [for Statement " 0002: [17-08-06 13:54:26.0723] Slim::Schema::forceCommit (2149) Warning: Trying to commit transactions before DB is initialized! 0001: [17-08-06 13:54:21.5066] main::main (205) Starting Logitech Media Server scanner (v7.9.1, 1501791870, Fri Aug 4 04:11:59 UTC 2017) perl 5.010000 -------------------- Does anyone know what is wrong, and what I can do to fix it? For the moment I just updated the offending album by using 'Music Folder' and playing the album and it now appears as the first entry under 'New Music' I doubt the following info will be useful but I will include it just in case. I am on the QNAP firmware 4.3.3.0262 Build 20170727. Should I try clearing the entire library and starting from scratch? ------------------------------------------------------------------------ Stone Free's Profile: http://forums.slimdevices.com/member.php?userid=31773 View this thread: http://forums.slimdevices.com/showthread.php?t=107825 _______________________________________________ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta