mherger wrote:
> > Where is the pref? I can't find it.
>
> Settings/My Music
>
> >>> Is any of this linked to the Full Text Search plugin (which is
> >>> installed)?
> >>
> >> No. Advanced Search is supposed to give you more control. Therefor
> not
> >> trying to be smart like FTS.
> >>
> > Again I'm being dim, and don't understand. So what is FTS?
>
> Full Text Search.
>
> --
>
> Michael
Thanks Michael, but what does "Full Text Search" mean? What, when ,
where , how? I don't understand what it applies to, what text is being
referred to, what search, etc. Sorry for being so slow.
As to My Music, I never noticed that Search option. It's set to 'within
words' so should work.
A log sample for searching for Artist Beethoven gives:
Code:
--------------------
[18-12-02 11:20:54.5170] Slim::Schema::Debug::query_start (23) SELECT COUNT(
* ) FROM (SELECT me.id FROM tracks me LEFT JOIN contributor_track
contributorTracks ON contributorTracks.track = me.id LEFT JOIN contributors
contributor ON contributor.id = contributorTracks.contributor WHERE ( (
contributor.namesearch = ? AND ( contributorTracks.role = ? OR
contributorTracks.role = ? OR contributorTracks.role = ? OR
contributorTracks.role = ? OR contributorTracks.role = ? ) AND me.audio = ? ) )
GROUP BY me.id) count_subq: '%BEETHOVEN%', '1', '5', '2', '4', '3', '1'
[18-12-02 11:20:55.0204] Slim::Schema::Debug::query_start (23) SELECT me.id,
me.name, me.namesort, me.namesearch, me.musicmagic_mixable FROM genres me ORDER
BY namesort COLLATE en_US :
[18-12-02 11:20:59.6200] Slim::Schema::Debug::query_start (23) SELECT me.id,
me.type, me.name, me.active, me.total, me.done, me.start, me.finish, me.info
FROM progress me WHERE ( type = ? ) ORDER BY start,id: 'importer'
[18-12-02 11:20:59.8829] Slim::Schema::Debug::query_start (23) SELECT me.id,
me.type, me.name, me.active, me.total, me.done, me.start, me.finish, me.info
FROM progress me WHERE ( type = ? ) ORDER BY start,id: 'importer'
[18-12-02 11:21:05.0030] Slim::Schema::Debug::query_start (23) SELECT me.id,
me.type, me.name, me.active, me.total, me.done, me.start, me.finish, me.info
FROM progress me WHERE ( type = ? ) ORDER BY start,id: 'importer'
[18-12-02 11:21:11.0333] Slim::Schema::Debug::query_start (23) SELECT me.id,
me.type, me.name, me.active, me.total, me.done, me.start, me.finish, me.info
FROM progress me WHERE ( type = ? ) ORDER BY start,id: 'importer'
--------------------
And carries on repeating the latter. I know some SQL but I have to say
I don't understand how the ? marks are meant to work in this.
LMS 7.9.2 on VortexBox Midi box, Xubuntu 18.04, FLACs 16->24 bit,
44.1->192kbps. 2 Touchs & EDO.
LMS plugin UPnP/DLNA Bridge to MF M1 CLiC (A308CR amp & ESLs) & Marantz
CR603 UPnP renderers.
Also Minimserver & Upplay to same & to upmpdcli/mpd PC renderers.
Squeezelite to Meridian USB Explorer DAC to PC speakers/headphones.
Wireless Xubuntu 18.04 laptop firefox/upplay or Android 'phone with
Squeeze-Commander/BubbleUPnP controls LMS/Minimserver.
------------------------------------------------------------------------
PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642
View this thread: http://forums.slimdevices.com/showthread.php?t=109825
_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
