• Hello!

    I’m seeing a lot of entries from Relevanssi in my error_log (below is a small sample).

    Any idea of why this is happening and how can I avoid it?

    Thanks!
    ángel.-

    ***

    [04-Dec-2021 22:43:39 UTC] Error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation ‘=’ de la base de datos de WordPress para la consulta SELECT COUNT(DISTINCT(relevanssi.doc)) FROM wp_relevanssi AS relevanssi
    WHERE relevanssi.term = ‘???acheter’ realizada por require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array(‘posts_pre_query’), WP_Hook->apply_filters, relevanssi_query, relevanssi_do_query, relevanssi_search, relevanssi_generate_df_counts
    [04-Dec-2021 22:43:39 UTC] Error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation ‘like’ de la base de datos de WordPress para la consulta
    SELECT COUNT(DISTINCT(relevanssi.doc))
    FROM wp_relevanssi AS relevanssi
    WHERE (relevanssi.term LIKE ‘???acheter%’ OR relevanssi.term_reverse LIKE CONCAT(REVERSE(‘???acheter’), ‘%’)) realizada por require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array(‘posts_pre_query’), WP_Hook->apply_filters, relevanssi_query, relevanssi_do_query, relevanssi_search, relevanssi_generate_df_counts
    [04-Dec-2021 22:43:39 UTC] Error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation ‘=’ de la base de datos de WordPress para la consulta SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 5 +
    relevanssi.content * 1 + relevanssi.comment * 0.75 +
    relevanssi.tag * 0.75 + relevanssi.link * 0 +
    relevanssi.author + relevanssi.category * 0.75 + relevanssi.excerpt +
    relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf
    FROM wp_relevanssi AS relevanssi WHERE relevanssi.term = ‘???acheter’ ORDER BY tf DESC LIMIT 500 realizada por require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array(‘posts_pre_query’), WP_Hook->apply_filters, relevanssi_query, relevanssi_do_query, relevanssi_search
    [04-Dec-2021 22:43:49 UTC] Error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation ‘=’ de la base de datos de WordPress para la consulta SELECT li.*, CONCAT(“https://viviralmaximo.net”,”/”,li.slug) AS pretty_url
    FROM wp_prli_links AS li
    WHERE slug=’search/ ?? Buy Ivermectin 3mg Canada ?? https://www.Ivermectin-Stromectol.com ?? Ivermectin 3mg Canada ?? Order Stromectol 3mg Uk , Order Stromectol 3mg Usa/feed/rss2′

    AND link_status=’enabled’
    realizada por require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PrliAppController->redirect, PrliLink->is_pretty_link, PrliLink->is_pretty_link_slug, PrliLink->getOneFromSlug, PrliLink->get_one_by
    [04-Dec-2021 22:43:55 UTC] Error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation ‘=’ de la base de datos de WordPress para la consulta SELECT li.*, CONCAT(“https://viviralmaximo.net”,”/”,li.slug) AS pretty_url
    FROM wp_prli_links AS li
    WHERE slug=’search/? Buy Ivermectin from $2.85 per pill ?? https://www.PillShipment.store ?? – Uses and Dosage ?Ivermectin For Sale Canada – Ivermectin Tablets For Sale Uk – Buy Ivermectin For Humans Canada – Ivermectin Without A Prescription/feed/rss2′

    AND link_status=’enabled’
    realizada por require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PrliAppController->redirect, PrliLink->is_pretty_link, PrliLink->is_pretty_link_slug, PrliLink->getOneFromSlug, PrliLink->get_one_by
    [04-Dec-2021 22:44:01 UTC] Error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation ‘=’ de la base de datos de WordPress para la consulta SELECT li.*, CONCAT(“https://viviralmaximo.net”,”/”,li.slug) AS pretty_url
    FROM wp_prli_links AS li
    WHERE slug=’search/?? Kaufen Ivermectin 12mg – ?? https://www.LowCostPill.com ?? : Rezeptfrei Apotheke ??Ivermectin Tabletten Ohne Rezept Zu Kaufen.. Kaufen Ivermectin 1 Creme. Ivermectin Kaufen ?sterreich/feed/rss2′

    AND link_status=’enabled’
    realizada por require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, PrliAppController->redirect, PrliLink->is_pretty_link, PrliLink->is_pretty_link_slug, PrliLink->getOneFromSlug, PrliLink->get_one_by`

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

    (@msaari)

    You’re being spammed with queries that contain emoji, and that’s something your database doesn’t like.

    On the positive side, this does not affect any actual user queries, only the spammers.

    If you want to get rid of the errors, there are a couple of solutions:

    – Fix the database collations in the wp_relevanssi database table. You’re using utf8_general_ci now, I think, and should use utf8mb4_unicode_ci.
    – Block the spam. Relevanssi Premium comes with a spam block feature that can block all queries with emoji, and it’s possible to come up with something similar in the free version as well.

    Thread Starter angeliti

    (@angeliti)

    Thanks for your answer, @msaari! I will write my hosting provider and ask them to fix the database collations for wp_relevanssi as you suggest.

    In any case: what do I need to do to block all queries with emoji in the free version of the plugin?

    Thanks,
    ángel.-

    Plugin Author Mikko Saari

    (@msaari)

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Lots of entrys from Relevanssi in error_log’ is closed to new replies.