An-tonio

Thanks for your info, I’m just migration some static pages and found this plugin. Did you find any other issue ?

Hi Mikko,

I see the problem is not fixed in last relevanssi update. In search.php, on lines 202 to 207 it now have:

SELECT ID FROM $wpdb->posts WHERE 1=1
AND (
SELECT COUNT(1)
FROM $wpdb->term_relationships AS tr
WHERE tr.term_taxonomy_id IN ($and_term_tax_ids)
AND tr.object_id = posts.ID ) = $n

and on line 202 it should be changed to:

SELECT ID FROM $wpdb->posts AS posts WHERE 1=1

to work ok or change line 207 to:

AND tr.object_id = $wpdb->posts.ID ) = $n

but not both.

Thanks!

Hi Jose Conti,

sorry, it was a quick test about web access.

I have checked in firefox and chrome under linux with last versions and the same problem.

In chrome console I get this error:

Uncaught TypeError: Cannot read property ‘0’ of undefined on
jquery.wijmo.raphael.min.js?ver=1.5.6:14

It seem that the domain https://rest.wangguard.com/ is not operative…

is wangguard continue working ?

Yes, it work also.

WP Advanced Search pass wp_query to relevanssi_do_query() function:

if ($this->relevanssi) {
include_once( ABSPATH . ‘wp-admin/includes/plugin.php’ );
if (!empty($_REQUEST[‘search_query’]) && is_plugin_active(‘relevanssi/relevanssi.php’)) {
relevanssi_do_query($query);
}
}

and it work really well ??

Well.. I think I have find the problem… It’s a problem with the relevanssi sql queries filtering by taxonomies.

In file lib/search.php in line 202 it rename the post table with another name:

SELECT ID FROM $wpdb->posts AS posts WHERE 1=1

later in line 207 it reference original $wpdb->posts table (usually wp_posts)

AND tr.object_id = $wpdb->posts.ID ) = $n

and mysql fire an error with: “Unknown column ‘wp_posts.ID’ in ‘where clause'”

to solve change line 202 to

SELECT ID FROM $wpdb->posts WHERE 1=1

I don’t know if this append in another conditions.

Thanks for your work Mikko.