hamzinho

I activated debugging as you recommended. I could figure out where I was wrong, thanks!

Performing the first debug step it seems that the parameters are correct.

Entering this code in the function.php:

add_filter (  'relevanssi_query_filter' ,  'rlv_check_mysql'  ) ; 
add_filter( 'relevanssi_query_filter', 'rlv_check_mysql' );
function rlv_check_mysql( $query ) {
    var_dump( $query );
    exit();
}

Results:
string(460) "SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 5 + relevanssi.content * 1 + relevanssi.comment * 0.75 + relevanssi.tag * 1 + relevanssi.link * 0 + relevanssi.author + relevanssi.category * 1 + relevanssi.excerpt + relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf FROM wp_relevanssi AS relevanssi WHERE (relevanssi.term LIKE 'wms%' OR relevanssi.term_reverse LIKE CONCAT(REVERSE('wms'), '%')) "

I don’t see the sql restrictions here, I don’t know if it’s right or wrong.

Entering this code in the function.php:

add_filter( 'relevanssi_results', 'rlv_check_results' );
function rlv_check_results( $results ) {
    var_dump( $results );
    exit();
}

Running this code prints a lot of numbers when I only expected a result as I only have a course that matches the search parameters.

Where am I wrong?

• This reply was modified 6 years, 10 months ago by hamzinho.
• This reply was modified 6 years, 10 months ago by hamzinho.