Search and Filter Pro and Relevanssi error

Anonymous

#200686

Hi there,

Iam using the Search and Filter Pro plugin with Relevanssi.

Yesterday I noticed an error_log file appeared in my installation.

In the log file there is an SQL error shown.

This only happens if I activate the Relevanssi support inside the Search and Filter options, and Iam search for text.

When I deactivate the Relevanssi support no error gets generated.
So I dont really know if this is a problem of Relevanssi or this filter plugin.
Maybe you guys can help here.

This is the error message:

WordPress-Database-Error Unknown column 'prfx_postmeta.meta_value' in 'order clause' for 
SELECT   prfx_posts.ID FROM prfx_posts  
WHERE 1=1  
AND (((prfx_posts.post_title LIKE '%shirt%') 
OR (prfx_posts.post_excerpt LIKE '%shirt%') 
OR (prfx_posts.post_content LIKE '%shirt%')))  
AND prfx_posts.post_type = 'product' AND ((prfx_posts.post_status = 'publish'))  
ORDER BY prfx_postmeta.meta_value+0 DESC, 
prfx_posts.post_date DESC 
from require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, 
WP_Query->get_posts, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, 
call_user_func_array, WC_Query->pre_get_posts, WC_Query->product_query, 
do_action('woocommerce_product_query'), WP_Hook->do_action, 
WP_Hook->apply_filters, call_user_func_array, Search_Filter->setup_wc_query, 
Search_Filter_Query->setup_wc_query, Search_Filter_Query->filter_pre_get_posts, 
Search_Filter_Query->prep_query, Search_Filter_Cache->filter_query_args, 
Search_Filter_Cache->apply_cached_filters, apply_filters('sf_apply_custom_filter'), 
WP_Hook->apply_filters, call_user_func_array, Search_Filter_Third_Party->relevanssi_add_custom_filter, 
WP_Query->__construct, WP_Query->query, WP_Query->get_posts

Let me know If you need more infos!
Thanks for the great plugin!
-Mo

Trevor

#200691

What hosting are you using (company)?

Anonymous

#200740

Hi Trevor,

Iam using a managed server from a german based company called VC-Server.
https://www.vc-server.de/managed-server/

What do you have in mind?

Trevor

#200749

I was just checking to see if query strings were being truncated (WP Engine does this).

A separate thought. Do you know where/how to find and edit/view the wp-config.php file? Can you look in there to see if the prefix variable is set, and if so, does the prefix contain any uppercase characters?

Anonymous

#200753

Hi Trevor,

yes I know about the wp-config file. I can take a look tomorow inside the file.

Iam using a custom database prefix, but it doesnt contain any uppercase chars. (Prefix is: zdm02sl_)

But I added this prefix with a security plugin, so I will take a look inside the wp-config file to see whats in there. I will get back to you as soon as possible for me.
Thanks

Trevor

#200757

That is odd, as the error message suggest that the prefix is prfx

Anonymous

#200855

This reply has been marked as private.

Trevor

#200859

This reply has been marked as private.

Anonymous

#200865

I just rebuilded the index of relevanssi.

Still the same problem, if I perform a textsearch the posted error appears.

—
I also tried again setting the relevanssi setting “Default order” to “Post Date”.
Still the same.

And I also just tried deactivating “Boost exact matches” in relevanssi settings.
But also still the same.

Trevor

#200869

Is this a live site or a test site?

Are you using the free or Pro version of Relevanssi?

The error suggests that something is wrong with the tables in your database. Search and Filter doesn’t actually do anything (settings related) to Relevanssi. All we do is ask it to do the search and give the results back as a list of IDs.

If you deactivate Search and Filter but leave Relevanssi activated, your standard theme search will then use Relevanssi to do its searches. Does the error still happen using the standard theme search?

[Author]

Posts