I'm getting the same (Logitech Media Server Version: 8.0.0 - 1601590552
@ Fri Oct 2 01:09:07 CEST 2020).
Here's my scanner log:
[20-10-12 10:49:08.8810] main::main (206) Starting Logitech Media Server
scanner (v8.0.0, 1601590552, Fri Oct 2 01:09:07 CEST 2020) perl
5.024000
[20-10-12 10:49:09.4969] Slim::Schema::forceCommit (2157) Warning:
Trying to commit transactions before DB is initialized!
[20-10-12 10:49:10.7822] Slim::Music::Import::runImporter (577) Starting
Slim::Media::MediaFolderScan scan
[20-10-12 10:49:10.7827] Slim::Utils::Scanner::Local::rescan (179)
Discovering audio files in /volume1/SYN1/Squeezebox Music
[20-10-12 10:49:30.7603] Slim::Utils::Scanner::Local::__ANON__ (191)
Start processing found tracks
[20-10-12 10:49:30.7607] Slim::Utils::Scanner::Local::__ANON__ (199)
Connect do DB
[20-10-12 10:49:30.7609] Slim::Utils::Scanner::Local::__ANON__ (202) Get
latest ID
[20-10-12 10:49:30.7927] Slim::Utils::Scanner::Local::__ANON__ (224)
Delete temporary table if exists
[20-10-12 10:49:30.7930] Slim::Utils::Scanner::Local::__ANON__ (227)
Re-build temporary table
[20-10-12 10:49:31.8612] Slim::Utils::Scanner::Local::__ANON__ (276) Get
deleted tracks count
[20-10-12 10:49:32.2389] Slim::Utils::Scanner::Local::__ANON__ (283) Get
new tracks count
[20-10-12 10:49:32.2396] Slim::Utils::Scanner::Local::__ANON__ (288) Get
changed tracks count
[20-10-12 10:49:32.6191] Slim::Utils::Scanner::Local::deleteTracks (519)
Removing deleted audio files (0)
[20-10-12 10:49:32.6199] Slim::Utils::Scanner::Local::__ANON__ (301)
Scanning new audio files (1)
[20-10-12 10:49:32.7459] Slim::Utils::Scanner::Local::__ANON__ (381)
Rescanning changed audio files (0)
[20-10-12 10:49:32.7464] Slim::Music::Import::endImporter (710)
Completed Slim::Media::MediaFolderScan Scan in 21 seconds.
[20-10-12 10:49:32.7469] Slim::Music::Import::runImporter (577) Starting
Slim::Music::PlaylistFolderScan scan
[20-10-12 10:49:32.7474] Slim::Utils::Scanner::Local::rescan (179)
Discovering audio files in /volume1/SYN1/Squeezebox Playlists
[20-10-12 10:49:32.8377] Slim::Utils::Scanner::Local::__ANON__ (191)
Start processing found tracks
[20-10-12 10:49:32.8382] Slim::Utils::Scanner::Local::__ANON__ (199)
Connect do DB
[20-10-12 10:49:32.8385] Slim::Utils::Scanner::Local::__ANON__ (202) Get
latest ID
[20-10-12 10:49:32.8390] Slim::Utils::Scanner::Local::__ANON__ (224)
Delete temporary table if exists
[20-10-12 10:49:32.8394] Slim::Utils::Scanner::Local::__ANON__ (227)
Re-build temporary table
[20-10-12 10:49:33.0755] Slim::Utils::Scanner::Local::__ANON__ (276) Get
deleted tracks count
[20-10-12 10:49:33.4148] Slim::Utils::Scanner::Local::__ANON__ (283) Get
new tracks count
[20-10-12 10:49:33.4157] Slim::Utils::Scanner::Local::__ANON__ (288) Get
changed tracks count
[20-10-12 10:49:33.4164] Slim::Utils::Scanner::Local::deleteTracks (519)
Removing deleted audio files (0)
[20-10-12 10:49:33.4167] Slim::Utils::Scanner::Local::__ANON__ (301)
Scanning new audio files (0)
[20-10-12 10:49:33.4170] Slim::Utils::Scanner::Local::__ANON__ (381)
Rescanning changed audio files (0)
[20-10-12 10:49:33.4175] Slim::Music::Import::endImporter (710)
Completed Slim::Music::PlaylistFolderScan Scan in 0 seconds.
[20-10-12 10:49:33.4755] Slim::Music::Import::runImporter (577) Starting
Slim::Plugin::ExtendedBrowseModes::Libraries scan
[20-10-12 10:49:33.4759] Slim::Music::Import::runImporter (577) Starting
Slim::Plugin::FullTextSearch::Plugin scan
[20-10-12 10:49:33.4768]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (445) Starting
fulltext index build
[20-10-12 10:49:33.4771]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (449) Initialize
fulltext table
[20-10-12 10:49:34.9133]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (462) Create
fulltext index for tracks
[20-10-12 10:49:42.7180]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (472) Create
fulltext index for albums
[20-10-12 10:49:45.1788]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (481) Create
fulltext index for contributors
[20-10-12 10:49:45.4409]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (491) Create
fulltext index for playlists
[20-10-12 10:49:45.5523] Slim::Schema::Storage::throw_exception (121)
Error: DBI Exception: DBD::SQLite::db do failed: SQL logic error or
missing database
unable to use function MATCH in the requested context [for Statement "
INSERT INTO fulltext (id, type, w10, w5, w3, w1)
-- w10: title, w3: url, w1: track metadata
SELECT playlist_track.playlist, 'playlist', ?, '', ?,
UNIQUE_TOKENS(GROUP_CONCAT(w10 || ' ' || w5 || ' ' || w3 || ' ' || w1))
FROM playlist_track
LEFT JOIN tracks ON tracks.url = playlist_track.track
LEFT JOIN fulltext ON fulltext MATCH
IGNORE_PUNCTUATION(REPLACE(REPLACE(playlist_track.track, '%20', ' '),
'file://', '')) AND type = 'track'
WHERE playlist_track.playlist = ?
"]
[20-10-12 10:49:45.5528] Slim::Schema::Storage::throw_exception (121)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/volume1/@appstore/LmsRepack/Slim/Schema/Storage.pm line 121)
frame 1: Slim::Schema::Storage::throw_exception
(/volume1/@appstore/LmsRepack/CPAN/DBIx/Class/Storage/DBI.pm line 1007)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(/volume1/@appstore/LmsRepack/Slim/Plugin/FullTextSearch/Plugin.pm line
532)
frame 3: Slim::Plugin::FullTextSearch::Plugin::_createPlaylistItem
(/volume1/@appstore/LmsRepack/Slim/Plugin/FullTextSearch/Plugin.pm line
500)
frame 4: Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex
(/volume1/@appstore/LmsRepack/Slim/Plugin/FullTextSearch/Plugin.pm line
158)
frame 5: Slim::Plugin::FullTextSearch::Plugin::startScan
(/volume1/@appstore/LmsRepack/Slim/Music/Import.pm line 579)
frame 6: Slim::Music::Import::runImporter
(/volume1/@appstore/LmsRepack/Slim/Music/Import.pm line 455)
frame 7: Slim::Music::Import::runScanPostProcessing
(/volume1/@appstore/LmsRepack/scanner.pl line 344)
frame 8: (eval) (/volume1/@appstore/LmsRepack/scanner.pl line 344)
frame 9: main::main (/volume1/@appstore/LmsRepack/scanner.pl line
499)
[20-10-12 10:49:45.5532] main::main (348) Error: Failed when running
scan post-process: [Carp::Clan::__ANON__(): DBI Exception:
DBD::SQLite::db do failed: SQL logic error or missing database
unable to use function MATCH in the requested context [for Statement "
INSERT INTO fulltext (id, type, w10, w5, w3, w1)
-- w10: title, w3: url, w1: track metadata
SELECT playlist_track.playlist, 'playlist', ?, '', ?,
UNIQUE_TOKENS(GROUP_CONCAT(w10 || ' ' || w5 || ' ' || w3 || ' ' || w1))
FROM playlist_track
LEFT JOIN tracks ON tracks.url = playlist_track.track
LEFT JOIN fulltext ON fulltext MATCH
IGNORE_PUNCTUATION(REPLACE(REPLACE(playlist_track.track, '%20', ' '),
'file://', '')) AND type = 'track'
WHERE playlist_track.playlist = ?
"] at /volume1/@appstore/LmsRepack/Slim/Schema/Storage.pm line 125
]
[20-10-12 10:49:45.5534] main::main (349) Error: Not updating
lastRescanTime!
Any ideas what may be causing it please?
Thanks,
HB
1 x Duet, 1 x Boom, 3 x Radio, 2 x Touch with iPeng 9 served by Synology
DS2419+ and LMS 8.0.0 (pinkdot)
------------------------------------------------------------------------
HeadBanger's Profile: http://forums.slimdevices.com/member.php?userid=38024
View this thread: http://forums.slimdevices.com/showthread.php?t=113037
_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
