{"id":14233761,"date":"2021-03-25T12:58:05","date_gmt":"2021-03-25T12:58:05","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-errors-in-logs\/"},"modified":"2021-03-25T12:58:05","modified_gmt":"2021-03-25T12:58:05","slug":"sql-errors-in-logs","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-errors-in-logs\/","title":{"rendered":"SQL errors in logs"},"content":{"rendered":"<p>Running latest version as of this writing (4.12.5)&#8211; started getting a ton of errors in our php-errors.log since we updated to this version on the 16th.  5,000 errors in the last 9 days.<\/p>\n<pre><code>SELECT COUNT(DISTINCT(relevanssi.doc)) FROM wprefix_relevanssi AS relevanssi\n\t\t\t\t WHERE (relevanssi.term LIKE &#039;\ud83c\udf93www%&#039; OR relevanssi.term_reverse LIKE CONCAT(REVERSE(&#039;\ud83c\udf93www&#039;), &#039;%&#039;))   AND ((relevanssi.doc IN (SELECT DISTINCT(posts.ID) FROM wprefix_posts AS posts\n\t\t\tWHERE posts.post_type NOT IN (&#039;revision&#039;, &#039;nav_menu_item&#039;, &#039;custom_css&#039;, &#039;customize_changeset&#039;, &#039;oembed_cache&#039;, &#039;user_request&#039;, &#039;wp_block&#039;, &#039;wpforms&#039;, &#039;iwp_log&#039;))) OR (doc = -1)) made by require(&#039;wp-blog-header.php&#039;), wp, WP-&gt;main, WP-&gt;query_posts, WP_Query-&gt;query, WP_Query-&gt;get_posts, apply_filters_ref_array(&#039;posts_pre_query&#039;), WP_Hook-&gt;apply_filters, relevanssi_query, relevanssi_do_query, relevanssi_search<\/code><\/pre>\n<pre><code>SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 5 +\n\t\t\t\trelevanssi.content * 1 + relevanssi.comment * 0.75 +\n\t\t\t\trelevanssi.tag * 0.75 + relevanssi.link * 0 +\n\t\t\t\trelevanssi.author + relevanssi.category * 0.75 + relevanssi.excerpt +\n\t\t\t\trelevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf\n\t\t\t\tFROM wprefix_relevanssi AS relevanssi  WHERE (relevanssi.term LIKE &#039;\ud83c\udf93www%&#039; OR relevanssi.term_reverse LIKE CONCAT(REVERSE(&#039;\ud83c\udf93www&#039;), &#039;%&#039;))   AND ((relevanssi.doc IN (SELECT DISTINCT(posts.ID) FROM wprefix_posts AS posts\n\t\t\tWHERE posts.post_type NOT IN (&#039;revision&#039;, &#039;nav_menu_item&#039;, &#039;custom_css&#039;, &#039;customize_changeset&#039;, &#039;oembed_cache&#039;, &#039;user_request&#039;, &#039;wp_block&#039;, &#039;wpforms&#039;, &#039;iwp_log&#039;))) OR (doc = -1)) made by require(&#039;wp-blog-header.php&#039;), wp, WP-&gt;main, WP-&gt;query_posts, WP_Query-&gt;query, WP_Query-&gt;get_posts, apply_filters_ref_array(&#039;posts_pre_query&#039;), WP_Hook-&gt;apply_filters, relevanssi_query, relevanssi_do_query, relevanssi_search<\/code><\/pre>\n<p>In all of the errors there are weird characters in the term it&#8217;s searching for.  Not sure if these will come through in the post: <\/p>\n<p>\u2600\ufe0f\ud83d\udcee%<\/p>\n<p>And: <\/p>\n<p>\u272f\ud83c\udf3d\ud83d\udccf%<\/p>\n<p>and: <\/p>\n<p>\u2687\ud83d\ude8d%<\/p>\n","protected":false},"template":"","class_list":["post-14233761","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14233761","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14233761\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=14233761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}