Re: [SlimDevices: SqueezeCenter] Advanced Search: Artist (composer) does not contain comma

2019-03-06 Thread dolodobendan 


mherger wrote: 
> > ',%', '% ,%', '2', '1'
> 
> I guess you configured LMS to only search at the beginning of words, but
> 
> not in words. Thus only "lastname, firstname" would not match, as it's 
> looking for "lastname ,firstname" (see the space?). You'd have to tell 
> LMS to search in words, too (Settings/My Music).
> 

You're right, it was configured to only search at the beginning of
words. I never changed anything here, so I guess this is the default.

Do I have to rescan the database for the "within words" setting to
work?

I also tried a search for albums that does not contain " ". I expected
all one word albums like "Echoes" to pop up. Instead I got no results.



QLMS 7.9.2@2.04 x64 (digimaster) with perl 5.28 dedicated to me. :D /
QNAP 469L QTS 4.3.4

dolodobendan's Profile: http://forums.slimdevices.com/member.php?userid=67663
View this thread: http://forums.slimdevices.com/showthread.php?t=110280

___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Re: [SlimDevices: SqueezeCenter] Advanced Search: Artist (composer) does not contain comma

2019-03-06 Thread Michael Herger 

',%', '% ,%', '2', '1'


I guess you configured LMS to only search at the beginning of words, but 
not in words. Thus only "lastname, firstname" would not match, as it's 
looking for "lastname ,firstname" (see the space?). You'd have to tell 
LMS to search in words, too (Settings/My Music).


--

Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Re: [SlimDevices: SqueezeCenter] Advanced Search: Artist (composer) does not contain comma

2019-03-06 Thread dolodobendan 


mherger wrote: 
> > Instead of some albums, I get a lot albums, maybe even all, that
> don't
> > match the search parameters. What am I missing here?
> 
> Enable the database.sql logging to see what SQL results from your
> search.
> 
> -- 
> 
> Michael

This is the search:


Code:


  [19-03-06 12:09:25.6292] Slim::Control::Queries::_getTagDataForTracks (5568) 
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN 
(5725)  / []
  [19-03-06 12:09:28.5524] Slim::Schema::Debug::query_start (23) SELECT COUNT( 
* ) FROM albums me WHERE ( id IN ( SELECT me.album 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 NOT LIKE ? AND contributor.namesearch NOT 
LIKE ? ) AND contributorTracks.role = ? AND me.audio = ? ) ) GROUP BY me.id ) 
): ',%', '% ,%', '2', '1'
  [19-03-06 12:09:29.3913] Slim::Schema::Debug::query_start (23) SELECT me.id, 
me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, 
me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, 
me.replay_peak, me.musicbrainz_id, me.title FROM albums me WHERE ( id IN ( 
SELECT me.album 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 NOT LIKE ? AND contributor.namesearch NOT LIKE ? ) AND 
contributorTracks.role = ? AND me.audio = ? ) ) GROUP BY me.id ) ) ORDER BY 
me.disc, me.titlesort COLLATE en_US  LIMIT 50: ',%', '% ,%', '2', '1'
  [19-03-06 12:09:30.3434] 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 : 
  [19-03-06 12:09:30.9298] Slim::Control::Queries::_getTagDataForTracks (5568) 
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN 
(5725)  / []
  [19-03-06 12:09:30.9424] Slim::Control::Queries::_getTagDataForTracks (5568) 
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN 
(5725)  / []
  [19-03-06 12:09:35.9838] Slim::Control::Queries::_getTagDataForTracks (5568) 
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN 
(5725)  / []
  [19-03-06 12:09:36.0877] Slim::Control::Queries::_getTagDataForTracks (5568) 
_getTagDataForTracks query: SELECT tracks.id AS 'tracks.id', tracks.title AS 
'tracks.title', tracks.url AS 'tracks.url' FROM tracks WHERE tracks.id IN 
(5725)  / []
  




QLMS 7.9.2@2.04 x64 (digimaster) with perl 5.28 dedicated to me. :D /
QNAP 469L QTS 4.3.4

dolodobendan's Profile: http://forums.slimdevices.com/member.php?userid=67663
View this thread: http://forums.slimdevices.com/showthread.php?t=110280

___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter

Re: [SlimDevices: SqueezeCenter] Advanced Search: Artist (composer) does not contain comma

2019-03-05 Thread Michael Herger 

Instead of some albums, I get a lot albums, maybe even all, that don't
match the search parameters. What am I missing here?


Enable the database.sql logging to see what SQL results from your search.

--

Michael
___
Squeezecenter mailing list
Squeezecenter@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/squeezecenter