Code:
--------------------
[20-09-25 18:29:07.5107]
Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (479) Create fulltext index
for playlists
[20-09-25 18:29:10.5696] Slim::Schema::Storage::throw_exception (121) Error:
DBI Exception: DBD::SQLite::db do failed: malformed MATCH expression:
[file:///Volumes/Ade_iTunes/iTunes/iTunes Media/Music/Metz/Metz/11 --))--.m4a]
[for Statement "
INSERT INTO fulltext (id, type, w10, w5, w3, w1)
SELECT playlist_track.playlist, 'playlist', ?, '', ?,
GROUP_CONCAT(w10 || ' ' || w5 || ' ' || w3 || ' ' || w1)
FROM playlist_track
LEFT JOIN tracks ON tracks.url = playlist_track.track
LEFT JOIN fulltext ON fulltext MATCH
REPLACE(playlist_track.track, '%20', ' ') AND type = 'track'
WHERE playlist_track.playlist = ?
"]
[20-09-25 18:29:10.5700] Slim::Schema::Storage::throw_exception (121)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm
line 121)
frame 1: Slim::Schema::Storage::throw_exception
(/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/CPAN/DBIx/Class/Storage/DBI.pm
line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__
(/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Plugin/FullTextSearch/Plugin.pm
line 520)
frame 3: Slim::Plugin::FullTextSearch::Plugin::_createPlaylistItem
(/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Plugin/FullTextSearch/Plugin.pm
line 488)
frame 4: Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex
(/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Plugin/FullTextSearch/Plugin.pm
line 157)
frame 5: Slim::Plugin::FullTextSearch::Plugin::startScan
(/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Music/Import.pm
line 579)
frame 6: Slim::Music::Import::runImporter
(/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Music/Import.pm
line 455)
frame 7: Slim::Music::Import::runScanPostProcessing
(/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/scanner.pl line
344)
frame 8: (eval)
(/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/scanner.pl line
344)
frame 9: main::main
(/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/scanner.pl line
499)
[20-09-25 18:29:10.5724] main::main (348) Error: Failed when running scan
post-process: [Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db do
failed: malformed MATCH expression: [file:///Volumes/Ade_iTunes/iTunes/iTunes
Media/Music/Metz/Metz/11 --))--.m4a] [for Statement "
INSERT INTO fulltext (id, type, w10, w5, w3, w1)
SELECT playlist_track.playlist, 'playlist', ?, '', ?,
GROUP_CONCAT(w10 || ' ' || w5 || ' ' || w3 || ' ' || w1)
FROM playlist_track
LEFT JOIN tracks ON tracks.url = playlist_track.track
LEFT JOIN fulltext ON fulltext MATCH
REPLACE(playlist_track.track, '%20', ' ') AND type = 'track'
WHERE playlist_track.playlist = ?
"] at
/Library/PreferencePanes/Squeezebox.prefPane/Contents/server/Slim/Schema/Storage.pm
line 125
]
[20-09-25 18:29:10.5726] main::main (349) Error: Not updating lastRescanTime!
--------------------
------------------------------------------------------------------------
Ade_AV's Profile: http://forums.slimdevices.com/member.php?userid=69532
View this thread: http://forums.slimdevices.com/showthread.php?t=112920
_______________________________________________
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
