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