Relevanssi now not finding any results

Hi there,

I installed Relevanssi a couple of weeks ago along with the search and filter plugin to try to improve search for my WP-Courseware course units now they have added tag & category taxonomies into the plugin. Did a first pass of testing at the time and it all seemed to be working fine but then I had to stop working on this to focus on some other projects (including GDPR compliance). I’ve returned to fine tune the relevanssi/search and filter search stuff today but it’s just not working anymore. Search returns nothing….

I’ve deactivated and reactivated the plugin (and everything is updated to all the latest versions sitewide), added the code snippet to my functions.php to help with the WP Job manager issue and even deleted and reinstalled and I’m still having no joy.

I’m not a developer but I managed to run the debugging tests – have no idea how to read the results though, not really sure what I’m looking at.

When I run the parameters query in search I get the below:

array(68) { [“s”]=> string(5) “music” [“error”]=> string(0) “” [“m”]=> string(0) “” [“p”]=> int(0) [“post_parent”]=> string(0) “” [“subpost”]=> string(0) “” [“subpost_id”]=> string(0) “” [“attachment”]=> string(0) “” [“attachment_id”]=> int(0) [“name”]=> string(0) “” [“static”]=> string(0) “” [“pagename”]=> string(0) “” [“page_id”]=> int(0) [“second”]=> string(0) “” [“minute”]=> string(0) “” [“hour”]=> string(0) “” [“day”]=> int(0) [“monthnum”]=> int(0) [“year”]=> int(0) [“w”]=> int(0) [“category_name”]=> string(0) “” [“tag”]=> string(0) “” [“cat”]=> string(0) “” [“tag_id”]=> string(0) “” [“author”]=> string(0) “” [“author_name”]=> string(0) “” [“feed”]=> string(0) “” [“tb”]=> string(0) “” [“paged”]=> int(0) [“meta_key”]=> string(0) “” [“meta_value”]=> string(0) “” [“preview”]=> string(0) “” [“sentence”]=> string(0) “” [“title”]=> string(0) “” [“fields”]=> string(0) “” [“menu_order”]=> string(0) “” [“embed”]=> string(0) “” [“category__in”]=> array(0) { } [“category__not_in”]=> array(0) { } [“category__and”]=> array(0) { } [“post__in”]=> array(0) { } [“post__not_in”]=> array(29) { [0]=> string(5) “12783” [1]=> string(5) “12808” [2]=> string(5) “12814” [3]=> string(5) “12816” [4]=> string(5) “12818” [5]=> string(5) “12819” [6]=> string(5) “12822” [7]=> string(5) “12881” [8]=> string(5) “12885” [9]=> string(5) “12886” [10]=> string(5) “12890” [11]=> string(5) “23836” [12]=> string(5) “23837” [13]=> string(5) “23838” [14]=> string(4) “6938” [15]=> string(4) “6939” [16]=> string(4) “6940” [17]=> string(4) “6941” [18]=> string(4) “6942” [19]=> string(4) “6943” [20]=> string(4) “6944” [21]=> string(4) “6945” [22]=> string(4) “6946” [23]=> int(256) [24]=> int(251) [25]=> int(252) [26]=> int(253) [27]=> int(254) [28]=> int(255) } [“post_name__in”]=> array(0) { } [“tag__in”]=> array(0) { } [“tag__not_in”]=> array(0) { } [“tag__and”]=> array(0) { } [“tag_slug__in”]=> array(0) { } [“tag_slug__and”]=> array(0) { } [“post_parent__in”]=> array(0) { } [“post_parent__not_in”]=> array(0) { } [“author__in”]=> array(0) { } [“author__not_in”]=> array(0) { } [“taxonomy”]=> string(9) “media_tag” [“post_type”]=> array(5) { [“post”]=> string(4) “post” [“page”]=> string(4) “page” [“attachment”]=> string(10) “attachment” [“job_listing”]=> string(11) “job_listing” [“tribe_events”]=> string(12) “tribe_events” } [“ignore_sticky_posts”]=> bool(false) [“suppress_filters”]=> bool(false) [“cache_results”]=> bool(true) [“update_post_term_cache”]=> bool(true) [“lazy_load_term_meta”]=> bool(true) [“update_post_meta_cache”]=> bool(true) [“posts_per_page”]=> int(10) [“nopaging”]=> bool(false) [“comments_per_page”]=> string(2) “50” [“no_found_rows”]=> bool(false) [“search_terms_count”]=> int(1) [“search_terms”]=> array(1) { [0]=> string(5) “music” } [“search_orderby_title”]=> array(1) { [0]=> string(175) “wp_6z0m29jpsr_posts.post_title LIKE ‘{7b4c02a9c4f112db604e4ac9f79378a2c8b36c3b73180589412b9617a0ff8c96}music{7b4c02a9c4f112db604e4ac9f79378a2c8b36c3b73180589412b9617a0ff8c96}'” } [“order”]=> string(4) “DESC” }

MySQL query

string(1076) “SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 5 + relevanssi.content * 2 + relevanssi.comment * 0.75 + relevanssi.tag * 3 + relevanssi.link * 0 + relevanssi.author + relevanssi.category * 2 + relevanssi.excerpt + relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf FROM wp_6z0m29jpsr_relevanssi AS relevanssi WHERE relevanssi.term = ‘music’ AND relevanssi.doc IN (SELECT DISTINCT(tr.object_id) FROM wp_6z0m29jpsr_term_relationships AS tr WHERE tr.term_taxonomy_id IN (1)) AND relevanssi.doc NOT IN (SELECT DISTINCT(tr.object_id) FROM wp_6z0m29jpsr_term_relationships AS tr WHERE tr.term_taxonomy_id IN (1)) AND relevanssi.doc NOT IN (12783,12808,12814,12816,12818,12819,12822,12881,12885,12886,12890,23836,23837,23838,6938,6939,6940,6941,6942,6943,6944,6945,6946,256,251,252,253,254,255) AND ( relevanssi.doc IN ( SELECT DISTINCT(posts.ID) FROM wp_6z0m29jpsr_posts AS posts WHERE posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘job_listing’, ‘tribe_events’) ) ) ORDER BY tf DESC LIMIT 500”

Look at the results
array(0) { }

I tried to do the final 2 using the lib/search.php file in Relevanssi but I was unable to create local folder on Macintosh HD, not sure why. Not a dev and it’s very late on Friday night so I think I’ve just been trouble-shooting this too long.

Waving the white flag, over to you Mikko! I hope you can help!

The page I need help with: [log in to see the link]