PHP Errors: WordPress database error Illegal mix of collations

  • Resolved carinlockhart

    (@carinlockhart)


    4 years ago

    I am getting TONS of PHP errors like the one below. I am unsure how to resolve it. Help appreciated!
    [23-Nov-2020 00:46:58 UTC] WordPress database error Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’ for query (
    SELECT 0 AS is_personal, 1 AS is_ip, status, country_code
    FROM 85d_spbc_firewall_data
    WHERE
    network IN (754974720,763363328,763494400,763502592,763506688,763508736,763509760,763509792,763509808,763509816,763509820)
    AND network = 763509820 & mask
    AND country_code = “0”
    ) UNION (
    SELECT 1 AS is_personal, 1 AS is_ip, status, 0 AS country_code
    FROM 85d_spbc_firewall__personal_ips
    WHERE
    network IN (754974720,763363328,763494400,763502592,763506688,763508736,763509760,763509792,763509808,763509816,763509820)
    AND network = 763509820 & mask
    ) UNION (
    SELECT 1 AS is_personal, 0 AS is_ip, tbl_private.status, country_code
    FROM 85d_spbc_firewall__personal_countries AS tbl_private
    RIGHT JOIN 85d_spbc_firewall_data AS tbl_common USING(country_code)
    WHERE
    network IN (754974720,763363328,763494400,763502592,763506688,763508736,763509760,763509792,763509808,763509816,763509820)
    AND network = 763509820 & mask
    AND tbl_private.status IS NOT NULL
    ) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/mu-plugins/0security-malware-firewall-mu.php’), require_once(‘/plugins/security-malware-firewall/security-malware-firewall.php’), spbc_firewall__check, CleantalkSP\Security\FireWall\FireWall->run, CleantalkSP\SpbctWp\FireWall\ClassSecFW_WP->check

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter carinlockhart

    (@carinlockhart)

    I figured this out – at least I think so. I had both Anti-Spam by Cleantlk and Cleantalk Security active. I deactivated Cleantalk security and the errors seem to have stopped.

    Plugin Support katereji

    (@katereji)

    Hello.

    To fix errors completely I recommend uninstalling both CleanTalk plugins with the “Complete deactivation” option enabled. You can find this option in the Anti-Spam plugin settings at the end of the list of all options and in the Security plugin General Settings tab at the end of the list of all options.

    Please, install the latest versions of plugins from the WordPress catalog.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘PHP Errors: WordPress database error Illegal mix of collations’ is closed to new replies.