Relevanssi keeps logging SQL errors

  • Checking through my PHP logs, I see a few of the following errors every single day:

    —
    [09-Oct-2014 11:11:32 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 ‘)’ at line 4 for query
    SELECT tt.term_taxonomy_id
    FROM wp_term_taxonomy AS tt
    LEFT JOIN wp_terms AS t ON (tt.term_id=t.term_id)
    WHERE tt.taxonomy = ‘issuem_issue’ AND t.term_id IN () made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array, call_user_func_array, relevanssi_query, relevanssi_do_query, relevanssi_search
    —

    Do you have any idea why this error keeps getting logged? “issuem_issue” is a custom taxonomy.

    Thank you,

    Iulian

    https://www.ads-software.com/plugins/relevanssi/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Mikko Saari

    (@msaari)

    It’s the empty parameter: “AND t.term_id IN ()”

    You feed a tax_query to Relevanssi, but it’s missing parameters.

    Thread Starter iulianionescu

    (@iulianionescu)

    I kind of figured that out, but the problem is: I don’t know who is running this code and from where… I just see it logged in the Error log, but it’s not something I am calling myself. Is there an automated search or anything like that?

    Thanks!

    Plugin Author Mikko Saari

    (@msaari)

    You don’t have a search on your site? Because it’s not any special code, just your regular search, probably, that has a tax_query parameter somehow that Relevanssi can’t digest. I’d investigate your theme functions.php, that’s the most likely place you’ll find it.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Relevanssi keeps logging SQL errors’ is closed to new replies.