Bug 2024 - extra missing search results
: extra missing search results
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.2.0
: Macintosh All
: P2 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on: 987
Blocks:
  Show dependency treegraph
 
Reported: 2005-08-25 21:43 UTC by Blackketter Dean
Modified: 2008-09-15 14:36 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Blackketter Dean 2005-08-25 21:43:50 UTC
If i search in my library (this is on tank.home, latest nightly, web ui) for "ken burns jazz" it says there 
are 33 songs matching, but none are listed in the main search page (default ui) or when you click "More 
matches..."

Dan asked for the output of d_sql, so here it is:

2005-08-25 21:41:57.7601 Start and End node: [contributor:contributor]
2005-08-25 21:41:57.7675 Field query. Need additional join. start and End node: 
[contributor:contributor]
2005-08-25 21:41:57.7686 Running SQL query: [SELECT COUNT(*) FROM (SELECT DISTINCT 
contributors.id AS id,contributors.name AS name,contributors.namesort AS 
namesort,contributors.moodlogic_id AS moodlogic_id,contributors.moodlogic_mixable AS 
moodlogic_mixable,contributors.musicmagic_mixable AS musicmagic_mixable FROM contributor_track, 
contributors WHERE contributors.id = contributor_track.contributor  AND ( contributor_track.role IN ( ?, 
?, ?, ?, ? ) ))]
2005-08-25 21:41:57.7688 Bind arguments: [1, 2, 3, 4, 5]

2005-08-25 21:42:03.9827 Start and End node: [contributor:contributor]
2005-08-25 21:42:03.9830 Field query. Need additional join. start and End node: 
[contributor:contributor]
2005-08-25 21:42:03.9833 Start and End node: [contributor:contributor]
2005-08-25 21:42:03.9835 Field query. Need additional join. start and End node: 
[contributor:contributor]
2005-08-25 21:42:03.9850 Running SQL query: [SELECT COUNT(*) FROM (SELECT DISTINCT 
contributors.id AS id,contributors.name AS name,contributors.namesort AS 
namesort,contributors.moodlogic_id AS moodlogic_id,contributors.moodlogic_mixable AS 
moodlogic_mixable,contributors.musicmagic_mixable AS musicmagic_mixable FROM contributor_track, 
contributors WHERE contributors.id = contributor_track.contributor  AND ( contributor_track.role IN ( ?, 
?, ?, ?, ? ) AND ( ( contributors.namesearch LIKE ? ) OR ( contributors.namesearch LIKE ? ) ) ))]
2005-08-25 21:42:03.9852 Bind arguments: [1, 2, 3, 4, 5, KEN BURNS%, % KEN BURNS%]

2005-08-25 21:42:04.3893 Start and End node: [album:album]
2005-08-25 21:42:04.3896 Field query. Need additional join. start and End node: [album:album]
2005-08-25 21:42:04.3909 Running SQL query: [SELECT COUNT(*) FROM (SELECT DISTINCT albums.id 
AS id,albums.title AS title,albums.titlesort AS titlesort,albums.contributor AS 
contributor,albums.compilation AS compilation,albums.year AS year,albums.artwork_path AS 
artwork_path,albums.disc AS disc,albums.discc AS discc,albums.musicmagic_mixable AS 
musicmagic_mixable FROM tracks, albums WHERE albums.id = tracks.album  AND 
( ( ( albums.titlesearch LIKE ? ) OR ( albums.titlesearch LIKE ? ) ) ))]
2005-08-25 21:42:04.3911 Bind arguments: [KEN BURNS%, % KEN BURNS%]

2005-08-25 21:42:04.8161 Start and End node: [album:album]
2005-08-25 21:42:04.8164 Field query. Need additional join. start and End node: [album:album]
2005-08-25 21:42:04.8180 Running SQL query: [SELECT DISTINCT albums.id AS id,albums.title AS 
title,albums.titlesort AS titlesort,albums.contributor AS contributor,albums.compilation AS 
compilation,albums.year AS year,albums.artwork_path AS artwork_path,albums.disc AS 
disc,albums.discc AS discc,albums.musicmagic_mixable AS musicmagic_mixable FROM tracks, albums 
WHERE albums.id = tracks.album  AND ( ( ( albums.titlesearch LIKE ? ) OR ( albums.titlesearch LIKE ? ) ) ) 
LIMIT 10]
2005-08-25 21:42:04.8182 Bind arguments: [KEN BURNS%, % KEN BURNS%]

2005-08-25 21:42:05.2504 Start and End node: [default:default]
2005-08-25 21:42:05.2507 Field query. Need additional join. start and End node: [default:default]
2005-08-25 21:42:05.2519 Running SQL query: [SELECT COUNT(*) FROM (SELECT DISTINCT tracks.id 
AS id,tracks.multialbumsortkey AS multialbumsortkey,tracks.thumb AS thumb,tracks.age AS 
age,tracks.remote AS remote,tracks.ct AS ct,tracks.audio AS audio,tracks.titlesort AS 
titlesort,tracks.album AS album,tracks.tracknum AS tracknum,tracks.url AS url,tracks.tag AS 
tag,tracks.title AS title,tracks.disc AS disc,tracks.fs AS fs FROM tracks  WHERE ( ( ( tracks.titlesearch LIKE 
? ) OR ( tracks.titlesearch LIKE ? ) ) ))]
2005-08-25 21:42:05.2521 Bind arguments: [KEN BURNS%, % KEN BURNS%]

2005-08-25 21:42:05.5689 Start and End node: [default:default]
2005-08-25 21:42:05.5692 Field query. Need additional join. start and End node: [default:default]
2005-08-25 21:42:05.5706 Running SQL query: [SELECT DISTINCT tracks.id AS 
id,tracks.multialbumsortkey AS multialbumsortkey,tracks.thumb AS thumb,tracks.age AS 
age,tracks.remote AS remote,tracks.ct AS ct,tracks.audio AS audio,tracks.titlesort AS 
titlesort,tracks.album AS album,tracks.tracknum AS tracknum,tracks.url AS url,tracks.tag AS 
tag,tracks.title AS title,tracks.disc AS disc,tracks.fs AS fs FROM tracks  WHERE ( ( ( tracks.titlesearch LIKE 
? ) OR ( tracks.titlesearch LIKE ? ) ) ) LIMIT 10]
2005-08-25 21:42:05.5709 Bind arguments: [KEN BURNS%, % KEN BURNS%]

2005-08-25 21:42:05.6823 Start and End node: [contributor:contributor]
2005-08-25 21:42:05.6826 Field query. Need additional join. start and End node: 
[contributor:contributor]
2005-08-25 21:42:05.6830 Start and End node: [contributor:contributor]
2005-08-25 21:42:05.6831 Field query. Need additional join. start and End node: 
[contributor:contributor]
2005-08-25 21:42:05.6846 Running SQL query: [SELECT COUNT(*) FROM (SELECT DISTINCT 
contributors.id AS id,contributors.name AS name,contributors.namesort AS 
namesort,contributors.moodlogic_id AS moodlogic_id,contributors.moodlogic_mixable AS 
moodlogic_mixable,contributors.musicmagic_mixable AS musicmagic_mixable FROM contributor_track, 
contributors WHERE contributors.id = contributor_track.contributor  AND ( contributor_track.role IN ( ?, 
?, ?, ?, ? ) AND ( ( contributors.namesearch LIKE ? ) OR ( contributors.namesearch LIKE ? ) ) ))]
2005-08-25 21:42:05.6848 Bind arguments: [1, 2, 3, 4, 5, KEN BURNS JAZZ%, % KEN BURNS JAZZ%]

2005-08-25 21:42:06.0906 Start and End node: [album:album]
2005-08-25 21:42:06.0909 Field query. Need additional join. start and End node: [album:album]
2005-08-25 21:42:06.0922 Running SQL query: [SELECT COUNT(*) FROM (SELECT DISTINCT albums.id 
AS id,albums.title AS title,albums.titlesort AS titlesort,albums.contributor AS 
contributor,albums.compilation AS compilation,albums.year AS year,albums.artwork_path AS 
artwork_path,albums.disc AS disc,albums.discc AS discc,albums.musicmagic_mixable AS 
musicmagic_mixable FROM tracks, albums WHERE albums.id = tracks.album  AND 
( ( ( albums.titlesearch LIKE ? ) OR ( albums.titlesearch LIKE ? ) ) ))]
2005-08-25 21:42:06.0924 Bind arguments: [KEN BURNS JAZZ%, % KEN BURNS JAZZ%]

2005-08-25 21:42:06.5177 Start and End node: [album:album]
2005-08-25 21:42:06.5181 Field query. Need additional join. start and End node: [album:album]
2005-08-25 21:42:06.5196 Running SQL query: [SELECT DISTINCT albums.id AS id,albums.title AS 
title,albums.titlesort AS titlesort,albums.contributor AS contributor,albums.compilation AS 
compilation,albums.year AS year,albums.artwork_path AS artwork_path,albums.disc AS 
disc,albums.discc AS discc,albums.musicmagic_mixable AS musicmagic_mixable FROM tracks, albums 
WHERE albums.id = tracks.album  AND ( ( ( albums.titlesearch LIKE ? ) OR ( albums.titlesearch LIKE ? ) ) ) 
LIMIT 10]
2005-08-25 21:42:06.5198 Bind arguments: [KEN BURNS JAZZ%, % KEN BURNS JAZZ%]

2005-08-25 21:42:06.9473 Start and End node: [default:default]
2005-08-25 21:42:06.9476 Field query. Need additional join. start and End node: [default:default]
2005-08-25 21:42:06.9488 Running SQL query: [SELECT COUNT(*) FROM (SELECT DISTINCT tracks.id 
AS id,tracks.multialbumsortkey AS multialbumsortkey,tracks.thumb AS thumb,tracks.age AS 
age,tracks.remote AS remote,tracks.ct AS ct,tracks.audio AS audio,tracks.titlesort AS 
titlesort,tracks.album AS album,tracks.tracknum AS tracknum,tracks.url AS url,tracks.tag AS 
tag,tracks.title AS title,tracks.disc AS disc,tracks.fs AS fs FROM tracks  WHERE ( ( ( tracks.titlesearch LIKE 
? ) OR ( tracks.titlesearch LIKE ? ) ) ))]
2005-08-25 21:42:06.9490 Bind arguments: [KEN BURNS JAZZ%, % KEN BURNS JAZZ%]

2005-08-25 21:42:07.2662 Start and End node: [default:default]
2005-08-25 21:42:07.2665 Field query. Need additional join. start and End node: [default:default]
2005-08-25 21:42:07.2680 Running SQL query: [SELECT DISTINCT tracks.id AS 
id,tracks.multialbumsortkey AS multialbumsortkey,tracks.thumb AS thumb,tracks.age AS 
age,tracks.remote AS remote,tracks.ct AS ct,tracks.audio AS audio,tracks.titlesort AS 
titlesort,tracks.album AS album,tracks.tracknum AS tracknum,tracks.url AS url,tracks.tag AS 
tag,tracks.title AS title,tracks.disc AS disc,tracks.fs AS fs FROM tracks  WHERE ( ( ( tracks.titlesearch LIKE 
? ) OR ( tracks.titlesearch LIKE ? ) ) ) LIMIT 10]
2005-08-25 21:42:07.2683 Bind arguments: [KEN BURNS JAZZ%, % KEN BURNS JAZZ%]
Comment 1 Dan Sully 2005-09-15 16:41:53 UTC
Fix in subversion change 4307.

The remaining fixes will be part of bug 987.