knister

Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Forum: Plugins
    In reply to: [Relevanssi - A Better Search] No results in media search
    Thread Starter knister

    (@knister)

    4 years, 7 months ago

    Ok that’s a great hint. I have to do some investigation, I assume it’s something with the theme as I already tried deactivating the plugins.
    Thanks a lot and have a great day!

    Forum: Plugins
    In reply to: [Relevanssi - A Better Search] No results in media search
    Thread Starter knister

    (@knister)

    4 years, 7 months ago

    You’re right, awesome. So, unfortunately no results in list view as well although Relevanssi is used. These are the queries (search term “musifest”):

    SELECT COUNT(DISTINCT(relevanssi.doc))
FROM mk_relevanssi AS relevanssi
WHERE relevanssi.term = 'musifest'
AND ( relevanssi.doc IN (
SELECT DISTINCT(posts.ID)
FROM mk_posts AS posts
WHERE posts.post_type IN ('post') ) )
AND ((relevanssi.doc IN (SELECT DISTINCT(posts.ID)
FROM mk_posts AS posts
WHERE posts.post_status IN ('inherit', 'private'))))
    SELECT COUNT(DISTINCT(relevanssi.doc))
FROM mk_relevanssi AS relevanssi
WHERE (relevanssi.term LIKE 'musifest%'
OR relevanssi.term_reverse LIKE CONCAT(REVERSE('musifest'), '%'))
AND ( relevanssi.doc IN (
SELECT DISTINCT(posts.ID)
FROM mk_posts AS posts
WHERE posts.post_type IN ('post') ) )
AND ((relevanssi.doc IN (SELECT DISTINCT(posts.ID)
FROM mk_posts AS posts
WHERE posts.post_status IN ('inherit', 'private'))))
    	SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 5 + relevanssi.content * 1 + relevanssi.comment * 0.75 + relevanssi.tag * 0.75 + relevanssi.link * 0 + relevanssi.author + relevanssi.category * 0.75 + relevanssi.excerpt + relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf
FROM mk_relevanssi AS relevanssi
WHERE relevanssi.term = 'musifest'
AND ( relevanssi.doc IN (
SELECT DISTINCT(posts.ID)
FROM mk_posts AS posts
WHERE posts.post_type IN ('post') ) )
AND ((relevanssi.doc IN (SELECT DISTINCT(posts.ID)
FROM mk_posts AS posts
WHERE posts.post_status IN ('inherit', 'private'))))
ORDER BY tf DESC
LIMIT 500
    SELECT COUNT(DISTINCT(relevanssi.doc))
FROM mk_relevanssi AS relevanssi
WHERE (relevanssi.term LIKE 'musifest%'
OR relevanssi.term_reverse LIKE CONCAT(REVERSE('musifest'), '%'))
AND ( relevanssi.doc IN (
SELECT DISTINCT(posts.ID)
FROM mk_posts AS posts
WHERE posts.post_type IN ('post') ) )
AND ((relevanssi.doc IN (SELECT DISTINCT(posts.ID)
FROM mk_posts AS posts
WHERE posts.post_status IN ('inherit', 'private'))))
    	SELECT COUNT(DISTINCT(relevanssi.doc))
FROM mk_relevanssi AS relevanssi
WHERE (relevanssi.term LIKE 'musifest%'
OR relevanssi.term_reverse LIKE CONCAT(REVERSE('musifest'), '%'))
AND ( relevanssi.doc IN (
SELECT DISTINCT(posts.ID)
FROM mk_posts AS posts
WHERE posts.post_type IN ('post') ) )
AND ((relevanssi.doc IN (SELECT DISTINCT(posts.ID)
FROM mk_posts AS posts
WHERE posts.post_status IN ('inherit', 'private'))))
    SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 5 + relevanssi.content * 1 + relevanssi.comment * 0.75 + relevanssi.tag * 0.75 + relevanssi.link * 0 + relevanssi.author + relevanssi.category * 0.75 + relevanssi.excerpt + relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf
FROM mk_relevanssi AS relevanssi
WHERE (relevanssi.term LIKE 'musifest%'
OR relevanssi.term_reverse LIKE CONCAT(REVERSE('musifest'), '%'))
AND ( relevanssi.doc IN (
SELECT DISTINCT(posts.ID)
FROM mk_posts AS posts
WHERE posts.post_type IN ('post') ) )
AND ((relevanssi.doc IN (SELECT DISTINCT(posts.ID)
FROM mk_posts AS posts
WHERE posts.post_status IN ('inherit', 'private'))))
ORDER BY tf DESC
LIMIT 500
    Forum: Plugins
    In reply to: [Relevanssi - A Better Search] No results in media search
    Thread Starter knister

    (@knister)

    4 years, 7 months ago

    Hi and thanks for your response! So I’m using Relevanssi as admin search of course.
    I installed query monitor but as the media search is an ajax request, I don’t think I can acutally see the query that is made. This is the AJAX request at least:

    
POST

action	"query-attachments"
post_id	"0"
query[orderby]	"date"
query[s]	"musifest"
query[order]	"DESC"
query[posts_per_page]	"40"
query[paged]	"1"
    response 200 OK:
success	true
data	[]

    Is there some way to force WP to use Relevanssi for that media search? Obviously, Relevanssi works correctly as it shows search results on the “admin search” page

Viewing 3 replies - 1 through 3 (of 3 total)