[SimonDukes]

Hi Ernest,

Change the option as you noted yesterday and I’ve not got any errors in the last 24hrs.

Thanks again

Simon

[SimonDukes]

Thanks Ernest.

I’ll watch the logs and let you know if anything shows up.

Many thanks Simon

[SimonDukes]

Hi Ernesto, getting a different SQL error now!

[16-Jul-2018 23:25:38 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) OR ())
AND (wp_terms.term_id NOT IN (192,103))
‘ at line 25 for query
SELECT

wp_terms.name as title,
wp_terms.term_id as id,
1 as blogid,
wp_term_taxonomy.description as content,
” as date,
” as author,
wp_term_taxonomy.taxonomy as taxonomy,
‘term’ as content_type,
‘terms’ as g_content_type,
((case when
(wp_terms.name LIKE ‘D%’)
then 20 else 0 end) + (case when
(wp_terms.name LIKE ‘%D%’)
then 10 else 0 end) + (case when
(wp_term_taxonomy.description LIKE ‘%D%’)
then 3 else 0 end)) as relevance
FROM
wp_terms
LEFT JOIN wp_term_taxonomy ON wp_terms.term_id = wp_term_taxonomy.term_id

WHERE
( wp_term_taxonomy.taxonomy IN (‘post_tag’,’product_cat’,’product_type’,’pa_options’) )
AND (() OR ())
AND (wp_terms.term_id NOT IN (192,103))
AND (1)

GROUP BY wp_terms.term_id
ORDER BY relevance DESC, date DESC, wp_terms.name ASC
LIMIT 0 made by do_action(‘wp_ajax_nopriv_ajaxsearchpro_search’), WP_Hook->do_action, WP_Hook->apply_filters, WD_ASP_Search_Handler->handle, ASP_Query->__construct, ASP_Query->get_posts, ASP_Search->search, ASP_Search_TERMS->do_search

The AND (() OR ()) is the problem.

Seen the error in the logs about 50 times in the last week but I’ve not been able to create the error myself so I don’t know why the term and description details seem to be missing.

Any pointer would be gratefully received.

Many thanks Simon

[SimonDukes]

Hi Ernesto, Thanks for the pointer.
All seems to be working, I’ll let you know if I see an more errors in the logs.

Many thanks
Simon

[Author]

Posts