Hi All
Apologies if this has come up before but I couldn't find an answer. I've
got a peculiar problem with artist search. When I do a quick search and
advanced search the results are returned as expected. But when I do
search I get the same odd results no matter what I put in. See
screenshots below:
30079
Any ideas what might be causing it? I've attached a log that I hope is
helpful but let me know if there is something else I should be looking
at
Code:
--------------------
[20-04-15 12:30:08.1442] Slim::Menu::BrowseLibrary::_topLevel (749)
params=>mode=search
[20-04-15 12:30:08.1449] Slim::Menu::BrowseLibrary::_generic (921) artists
(0, 1): tags ->search:john, tags:EQsZZ
[20-04-15 12:30:08.1455]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (208) Fulltext search
query (contributor): CREATE TEMPORARY TABLE artistsSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:contributor john*'
[20-04-15 12:30:08.2373] Slim::Menu::BrowseLibrary::__ANON__ (880) artists
(0, 53): tags ->search:john, tags:EQs
[20-04-15 12:30:08.2376]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (208) Fulltext search
query (contributor): CREATE TEMPORARY TABLE artistsSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:contributor john*'
[20-04-15 12:30:08.2389] Slim::Control::Queries::artistsQuery (1101) Artists
query: SELECT contributors.id, contributors.name, contributors.namesort,
contributors.extid FROM artistsSearch, contributors LEFT JOIN contributor_album
ON contributor_album.contributor = contributors.id WHERE (contributors.id =
artistsSearch.id AND (contributor_album.role IN (5,1,4,2,3,6) OR
contributors.id = ? ) ) OR (contributors.extid IS NOT NULL AND
contributors.extid != '') GROUP BY contributors.id ORDER BY
artistsSearch.fulltextweight DESC, LENGTH(contributors.name),
contributors.namesort COLLATE en_US LIMIT ?,? / [6, 0, 53]
[20-04-15 12:30:08.3320] Slim::Menu::BrowseLibrary::_topLevel (749)
params=>mode=search
[20-04-15 12:30:08.3324] Slim::Menu::BrowseLibrary::_generic (921) artists
(0, 1): tags ->search:john, tags:EQsZZ
[20-04-15 12:30:08.3327]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (208) Fulltext search
query (contributor): CREATE TEMPORARY TABLE artistsSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:contributor john*'
[20-04-15 12:30:08.4195] Slim::Menu::BrowseLibrary::__ANON__ (880) artists
(0, 53): tags ->search:john, tags:EQs
[20-04-15 12:30:08.4199]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (208) Fulltext search
query (contributor): CREATE TEMPORARY TABLE artistsSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:contributor john*'
[20-04-15 12:30:08.4211] Slim::Control::Queries::artistsQuery (1101) Artists
query: SELECT contributors.id, contributors.name, contributors.namesort,
contributors.extid FROM artistsSearch, contributors LEFT JOIN contributor_album
ON contributor_album.contributor = contributors.id WHERE (contributors.id =
artistsSearch.id AND (contributor_album.role IN (5,1,4,2,3,6) OR
contributors.id = ? ) ) OR (contributors.extid IS NOT NULL AND
contributors.extid != '') GROUP BY contributors.id ORDER BY
artistsSearch.fulltextweight DESC, LENGTH(contributors.name),
contributors.namesort COLLATE en_US LIMIT ?,? / [6, 0, 53]
[20-04-15 12:30:08.5205] Slim::Menu::BrowseLibrary::_topLevel (749)
params=>mode=search
[20-04-15 12:30:08.5208] Slim::Menu::BrowseLibrary::__ANON__ (880) playlists
(0, 10): tags ->tags:sux, search:john
[20-04-15 12:30:08.5211]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (208) Fulltext search
query (playlist): CREATE TEMPORARY TABLE playlistSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:playlist john*'
[20-04-15 12:30:08.5222] Slim::Schema::Debug::query_start (22) SELECT COUNT(
* ) FROM tracks me WHERE ( id IN (SELECT tracks.id FROM playlistSearch, tracks
WHERE tracks.id = playlistSearch.id AND tracks.content_type IN ('ssp') ) ):
[20-04-15 12:30:08.5257] Slim::Menu::BrowseLibrary::_topLevel (749)
params=>mode=search
[20-04-15 12:30:08.5260] Slim::Menu::BrowseLibrary::__ANON__ (880) titles (0,
10): tags ->tags:dtuxgaAsSliqyorfcJK, menuStyle:album, search:john
[20-04-15 12:30:08.5263]
Slim::Plugin::FullTextSearch::Plugin::createHelperTable (208) Fulltext search
query (track): CREATE TEMPORARY TABLE tracksSearch AS SELECT id,
FULLTEXTWEIGHT(matchinfo(fulltext)) AS fulltextweight FROM fulltext WHERE
fulltext MATCH 'type:track john*' ORDER BY fulltextweight
[20-04-15 12:30:08.5308] Slim::Control::Queries::_getTagDataForTracks (5582)
Titles totals query: SELECT COUNT(1) FROM (SELECT albums.artwork AS
'albums.artwork', albums.discc AS 'albums.discc', albums.title AS
'albums.title', contributors.id AS 'contributors.id', contributors.name AS
'contributors.name', genres.name AS 'genres.name', tracks.bitrate AS
'tracks.bitrate', tracks.content_type AS 'tracks.content_type', tracks.coverid
AS 'tracks.coverid', tracks.disc AS 'tracks.disc', tracks.filesize AS
'tracks.filesize', tracks.id AS 'tracks.id', tracks.remote AS 'tracks.remote',
tracks.secs AS 'tracks.secs', tracks.title AS 'tracks.title', tracks.tracknum
AS 'tracks.tracknum', tracks.url AS 'tracks.url', tracks.vbr_scale AS
'tracks.vbr_scale', tracks.year AS 'tracks.year' FROM tracksSearch, tracks JOIN
genre_track ON genre_track.track = tracks.id JOIN genres ON genres.id =
genre_track.genre JOIN contributor_track ON contributor_track.track = tracks.id
JOIN contributors ON cont
ributors.id = contributor_track.contributor JOIN albums ON albums.id =
tracks.album WHERE tracks.id = tracksSearch.id AND (tracks.content_type !=
"cpl" AND tracks.content_type != "src" AND tracks.content_type != "ssp" AND
tracks.content_type != "dir") AND contributor_track.role IN (?, ?, ?, ?, ?, ?)
GROUP BY tracks.id ORDER BY tracksSearch.fulltextweight DESC, tracks.titlesort
COLLATE en_US ) / [5, 1, 4, 2, 3, 6]
[20-04-15 12:30:08.8975] Slim::Control::Queries::_getTagDataForTracks (5606)
_getTagDataForTracks query: SELECT albums.artwork AS 'albums.artwork',
albums.discc AS 'albums.discc', albums.title AS 'albums.title', contributors.id
AS 'contributors.id', contributors.name AS 'contributors.name', genres.name AS
'genres.name', tracks.bitrate AS 'tracks.bitrate', tracks.content_type AS
'tracks.content_type', tracks.coverid AS 'tracks.coverid', tracks.disc AS
'tracks.disc', tracks.filesize AS 'tracks.filesize', tracks.id AS 'tracks.id',
tracks.remote AS 'tracks.remote', tracks.secs AS 'tracks.secs', tracks.title AS
'tracks.title', tracks.tracknum AS 'tracks.tracknum', tracks.url AS
'tracks.url', tracks.vbr_scale AS 'tracks.vbr_scale', tracks.year AS
'tracks.year' FROM tracksSearch, tracks JOIN genre_track ON genre_track.track =
tracks.id JOIN genres ON genres.id = genre_track.genre JOIN contributor_track
ON contributor_track.track = tracks.id JOIN contributors ON contributors.id = c
ontributor_track.contributor JOIN albums ON albums.id = tracks.album WHERE
tracks.id = tracksSearch.id AND (tracks.content_type != "cpl" AND
tracks.content_type != "src" AND tracks.content_type != "ssp" AND
tracks.content_type != "dir") AND contributor_track.role IN (?, ?, ?, ?, ?, ?)
GROUP BY tracks.id ORDER BY tracksSearch.fulltextweight DESC, tracks.titlesort
COLLATE en_US LIMIT 0, 10 / [5, 1, 4, 2, 3, 6]
[20-04-15 12:30:09.2678] Slim::Control::Queries::_getTagDataForTracks (5661)
Tag A/S (contributor) query:
SELECT contributors.id, contributors.name,
contributor_track.track, contributor_track.role
FROM contributor_track
JOIN contributors ON contributors.id =
contributor_track.contributor
WHERE contributor_track.track IN
(12009,12038,12052,2462,3705,3738,3598,3596,3600,3599)
ORDER BY contributor_track.role DESC
--------------------
+-------------------------------------------------------------------+
|Filename: LMS1 - Copy.JPG |
|Download: http://forums.slimdevices.com/attachment.php?attachmentid=30079|
+-------------------------------------------------------------------+
------------------------------------------------------------------------
BertieFilibuster's Profile:
http://forums.slimdevices.com/member.php?userid=70081
View this thread: http://forums.slimdevices.com/showthread.php?t=112016
_______________________________________________
Squeezecenter mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/squeezecenter
