Bugzilla – Bug 2024
extra missing search results
Last modified: 2008-09-15 14:36:01 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%]
Fix in subversion change 4307. The remaining fixes will be part of bug 987.