mherger wrote:
>
> > At this time (v38612, updated via SVN just a few minutes ago), search
> > appears to still be broken.
>
> Broken in what way? Anything in the log file?
At the moment:
- The drop-down search fails to find anything.
- The quick search and the Search > Artists/Albums/Songs/Playlists form
only finds artists. All other search categories come up empty.
- Advanced search is fine.
I have 'search within words' enabled, but I've tried partial searches,
start-of-title searches, and exact title searches and all of them fail.
The only thing I see in the server log is from the scheduled new &
changed scan that ran last night:
Code:
--------------------
[14-10-24 04:12:13.1788] Slim::Schema::Storage::throw_exception (122) Error:
DBI Exception: DBD::SQLite::db do failed: no such function:
CONCAT_CONTRIBUTOR_ROLE [for Statement "
INSERT INTO fulltext (id, type, w10, w5, w3, w1)
SELECT tracks.id, 'track',
-- weight 10
IFNULL(tracks.title, '') || ' ' ||
IFNULL(tracks.titlesearch, '') || ' ' || IFNULL(tracks.customsearch, '') || ' '
|| IFNULL(tracks.musicbrainz_id, ''),
-- weight 5
IFNULL(tracks.year, '') || ' ' ||
GROUP_CONCAT(albums.title, ' ') || ' ' || GROUP_CONCAT(albums.titlesearch, ' ')
|| ' ' || GROUP_CONCAT(genres.name, ' ') || ' ' ||
GROUP_CONCAT(genres.namesearch, ' '),
-- IFNULL(tracks.year, '') || ' ' ||
GROUP_CONCAT(contributors.name, ' ') || ' ' ||
GROUP_CONCAT(contributors.namesearch, ' ') || ' ' || GROUP_CONCAT(albums.title,
' ') || ' ' || GROUP_CONCAT(albums.titlesearch, ' ') || ' ' ||
GROUP_CONCAT(genres.name, ' ') || ' ' || GROUP_CONCAT(genres.namesearch, ' '),
-- weight 3 - contributors create multiple hits,
therefore only w3
CONCAT_CONTRIBUTOR_ROLE(tracks.id,
GROUP_CONCAT(contributor_track.contributor, ','), 'contributor_track') || ' '
|| IFNULL(comments.value, '') || ' ' || IFNULL(tracks.lyrics, '') || ' ' ||
IFNULL(tracks.content_type, '') || ' ' || CASE WHEN tracks.channels = 1 THEN
'mono' WHEN tracks.channels = 2 THEN 'stereo' END,
-- weight 1
printf('%i', tracks.bitrate) || ' ' || printf('%ikbps',
tracks.bitrate / 1000) || ' ' || IFNULL(tracks.samplerate, '') || ' ' ||
(round(tracks.samplerate, 0) / 1000) || ' ' || IFNULL(tracks.samplesize, '') ||
' ' || tracks.url
FROM tracks
LEFT JOIN contributor_track ON contributor_track.track
= tracks.id
-- LEFT JOIN contributors ON contributors.id =
contributor_track.contributor
LEFT JOIN albums ON albums.id = tracks.album
LEFT JOIN genre_track ON genre_track.track = tracks.id
LEFT JOIN genres ON genres.id = genre_track.genre
LEFT JOIN comments ON comments.track = tracks.id
GROUP BY tracks.id;
"]
[14-10-24 04:12:13.1795] Slim::Schema::Storage::throw_exception (122)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace (C:/Program Files (x86)/Logitech
Media Server 7.9/server/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception (C:\Program Files
(x86)\Logitech Media Server 7.9\server\CPAN/DBIx/Class/Storage/DBI.pm line 1006)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (C:/Program Files (x86)/Logitech
Media Server 7.9/server/Slim/Plugin/FullTextSearch/Plugin.pm line 190)
frame 3: Slim::Plugin::FullTextSearch::Plugin::_rebuildIndex (C:/Program
Files (x86)/Logitech Media Server
7.9/server/Slim/Plugin/FullTextSearch/Plugin.pm line 170)
frame 4: Slim::Plugin::FullTextSearch::Plugin::_triggerIndexRebuild
(C:/Program Files (x86)/Logitech Media Server 7.9/server/Slim/Utils/Timers.pm
line 266)
frame 5: (eval) (C:/Program Files (x86)/Logitech Media Server
7.9/server/Slim/Utils/Timers.pm line 266)
frame 6: Slim::Utils::Timers::__ANON__ (C:/Program Files (x86)/Logitech Media
Server 7.9/server/Slim/Networking/IO/Select.pm line 168)
frame 7: (eval) (C:/Program Files (x86)/Logitech Media Server
7.9/server/Slim/Networking/IO/Select.pm line 168)
frame 8: Slim::Networking::IO::Select::loop (C:\Program Files (x86)\Logitech
Media Server 7.9\server\slimserver.pl line 715)
frame 9: main::idle (C:\Program Files (x86)\Logitech Media Server
7.9\server\slimserver.pl line 665)
frame 10: main::main (C:\Program Files (x86)\Logitech Media Server
7.9\server\slimserver.pl line 1200)
[14-10-24 04:12:13.1822] Slim::Utils::Timers::__ANON__ (273) Error: Timer
Slim::Plugin::FullTextSearch::Plugin::_triggerIndexRebuild failed:
--------------------
------------------------------------------------------------------------
JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10
View this thread: http://forums.slimdevices.com/showthread.php?t=102347
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
