Seeing the same thing here on a Centos7 based version:

Logitech Media Server Version: 8.0.0 - 1601590552 @ Fri Oct 2 01:01:10
CEST 2020
Hostname: xxxxxx
Server IP Address: xxxxxxx
Server HTTP Port Number: 9000
Operating system: Red Hat - EN - utf8
Platform Architecture: x86_64-linux
Perl Version: 5.16.3 - x86_64-linux-thread-multi
Audio::Scan: 0.95
IO::Socket::SSL: 1.94
Database Version: DBD::SQLite 1.34_01 (sqlite 3.7.7.1)
Total Players Recognized: 2


Saw it when doing a delta-scan after adding new files.  Removed new
files, same occurrence.   I have not downgraded to test yet.

[20-10-12 08:04:33.9229]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (491) Create
fulltext index for playlists
[20-10-12 08:04:35.9696] 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 08:04:35.9699] Slim::Schema::Storage::throw_exception (121)
Backtrace:

frame 0: Slim::Utils::Log::logBacktrace
(/usr/lib64/perl5/Slim/Schema/Storage.pm line 121)
frame 1: Slim::Schema::Storage::throw_exception
(/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(/usr/lib64/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 532)
frame 3: Slim::Plugin::FullTextSearch::Plugin::_createPlaylistItem
(/usr/lib64/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 500)
frame 4: Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex
(/usr/lib64/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 158)
frame 5: Slim::Plugin::FullTextSearch::Plugin::startScan
(/usr/lib64/perl5/Slim/Music/Import.pm line 579)
frame 6: Slim::Music::Import::runImporter
(/usr/lib64/perl5/Slim/Music/Import.pm line 455)
frame 7: Slim::Music::Import::runScanPostProcessing
(/usr/libexec/squeezeboxserver-scanner line 344)
frame 8: (eval) (/usr/libexec/squeezeboxserver-scanner line 344)
frame 9: main::main (/usr/libexec/squeezeboxserver-scanner line 499)

[20-10-12 08:04:35.9703] 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 /usr/lib64/perl5/Slim/Schema/Storage.pm line 125
]


------------------------------------------------------------------------
Matt Drown's Profile: http://forums.slimdevices.com/member.php?userid=69476
View this thread: http://forums.slimdevices.com/showthread.php?t=113037

_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Reply via email to