etellewyn

Hi guys, I just want to jump in (I’m managing this project) to say that we are 100% willing to purchase Relevanssi premium if it makes this easier! So @msaari if you like, it would be great if you could direct how all of this might be accomplished if we were using premium. @kamalpreet11 if it makes it easier to work we can go ahead and purchase now so that you can use that during development.

One other note that I wanted to mention: The client’s wishes are that paid members on the site have one type of search (where they can search for their search term within the the tabbed_content ACF field) BUT unpaid/guest users ONLY search title and excerpt. Another condition is that it only searches within the custom field IF the user has checked the box to include that.

You referenced some Relevanssi settings — does that mean that ALL users will see the same results? Or can we change the parameters of what is searched on the fly?

• This reply was modified 1 year, 7 months ago by etellewyn.

I would like to +1 brettgoodrich’s comment. The admin flyout was the ENTIRE POINT of this plugin. (That and it was also really handy for quickly adding pages). This recent update has totally ruined the plugin for me, and I was about to uninstall from my 100+ websites that I manage. After reading this thread and your promise of a fix, I will also stick it out for a bit, but this recent update really did ruin the plugin. There are multiple other plugins that show a page tree/sitemap upon clicking. The thing that made yours unique and awesome was that it was right there all the time without having to click and leave the current page. PLEASE FIX.

Thank you for your response! We do not care about emoji searches, and I’m glad to hear that this is harmless. Seeing the repeated errors is a little disconcerting, so I will run this past the client that he can upgrade to Premium to block them. Thank you for the quick response, much appreciated.

I have started getting this error on a client site as well. The full text of the error is below. I have no idea about collation or what we use — where do I find that?

[24-May-2021 16:04:27 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation '=' for query SELECT COUNT(DISTINCT(relevanssi.doc)) FROM cars_relevanssi AS relevanssi
			 WHERE  relevanssi.term = '????buy'   made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array('posts_pre_query'), WP_Hook->apply_filters, relevanssi_query, relevanssi_do_query, relevanssi_search, relevanssi_generate_df_counts
[24-May-2021 16:04:27 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like' for query 
			SELECT COUNT(DISTINCT(relevanssi.doc))
				FROM cars_relevanssi AS relevanssi
				 WHERE (relevanssi.term LIKE '????buy%' OR relevanssi.term_reverse LIKE CONCAT(REVERSE('????buy'), '%'))   made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array('posts_pre_query'), WP_Hook->apply_filters, relevanssi_query, relevanssi_do_query, relevanssi_search, relevanssi_generate_df_counts
[24-May-2021 16:04:27 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation '=' for query SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 5 +
	relevanssi.content * 1 + relevanssi.comment * 0.5 +
	relevanssi.tag * 0.75 + relevanssi.link * 0 +
	relevanssi.author + relevanssi.category * 0.75 + relevanssi.excerpt +
	relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf
	FROM cars_relevanssi AS relevanssi  WHERE  relevanssi.term = '????buy'   ORDER BY tf DESC LIMIT 100 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array('posts_pre_query'), WP_Hook->apply_filters, relevanssi_query, relevanssi_do_query, relevanssi_search

Yep IT WORKS! Thank you both for the quick fix!!

• This reply was modified 3 years, 11 months ago by etellewyn.

For what it’s worth however, the main thing I use the plugin for is the flyout menu showing structure of site. I hardly ever create pages using this plugin so it’s not an urgent problem. ??

No unfortunately no difference. Version 2.7.5 still the same. Let me know if you would like admin access to one of the affected sites.

Yes I do! (not a perfect match but very close)

On lines 51-53 of the page source (currently viewing plugins page in wp-admin) I see the following:

<script id=’admin_menu_tree_page_view-js-before’>
const amtpv_l10n = {“Edit”:”Edit”,”View”:”View”,”Add_new_page_here”:”Add new page after”,”Add_new_page_inside”:”Add new page inside”,”Untitled”:”Untitled”,”nonce”:”c68656b0eb”}
</script>

Thank you for looking into this! Strange that you’re not able to replicate it. As far as I can tell, I’m seeing it on all of my sites (have not literally tested them all since I manage about a hundred sites but the handful of random ones I have tested are all seeing the issue)

And actually I just tested one of my sites that is running WP5.6.2 and it is having the same problem there too. So this is not limited to WP5.7.

Here is the line of the script that is highlighted:

var data = {
“action”: ‘admin_menu_tree_page_view_add_page’,
“pageID”: post_id,
“type”: type,
“page_titles”: arr_names,
“post_type”: “page”,
“post_status”: post_status,
“amtpv-nonce”: window.amtpv_l10n.nonce
};

Line 325 is the one that reads
“amtpv-nonce”: window.amtpv_l10n.nonce

Oh wow! I had no idea! That is a bummer. Thanks for the download link. I will grab that.

I also was unable to deactivate this plugin, but as others have mentioned, using the bulk editor works. But I agree it was very troubling to suddenly see this plugin on my site when I never installed it in the first place! Very ironic for a security plugin because I thought I had been hacked. What plugin did you rename that I might have had installed previously?

Hi thanks for responding — no I definitely selected ONLY subscribers and EDD subscribers. I made a point to triple check that setting.

I had people actively using the site so I needed to get a solution quickly, so I got it to work with a different plugin. Thank you for answering though.

Weird! Okay I will talk to my other dev and see where that was added! So sorry to waste your time!

Perfect! Thank you!

Hi, thank you so much for your fast response. The website icon we’d want to use would probably just be fa-home. (I currently have it set to “wordpress”)
Is this plugin on GitHub? I didn’t see it on there but maybe I missed it. I thought I might do a pull request.