website database error

Hello,

i have noted my website was working very slow and giving error – unable to establish connection with database server.

when i opened ticket with hostpapa (hosting provider) and they said as per log the cleantalk security is giving issues.

website is working well after disabling the plugin.

but disabling is not safe option.

please check their response below and tell me what should i do with plugin so it works without giving issues to my website.

Thank you for reaching out to HostPapa support. Sorry to know that you are experiencing issues with your website. I'll be glad to assist you with your concern. 

Per the error logs, it looks like the issue is being caused by your plugin security-malware-firewall as shown on the log below.

[18-Jun-2024 08:57:41 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' for query (
                                SELECT 0 AS is_personal, 1 AS is_ip, status, country_code, network, mask
                                FROM wp_vcdf0tb4xs_spbc_firewall_data_v4
                                WHERE network IN (2550136832,2552233984,2553282560,2553806848,2553937920,2554003456,2554007552,2554009600,2554010624,2554010880,2554011008,2554011040,2554011048,2554011050)
                                        AND network = 2554011050 & mask
                                        AND country_code = "0"
                        ) UNION (
                                SELECT 1 AS is_personal, 1 AS is_ip, status, 0 AS country_code, network, mask
                                FROM wp_vcdf0tb4xs_spbc_firewall__personal_ips_v4
                                WHERE network IN (2550136832,2552233984,2553282560,2553806848,2553937920,2554003456,2554007552,2554009600,2554010624,2554010880,2554011008,2554011040,2554011048,2554011050)
                                        AND network = 2554011050 & mask
                        ) UNION (
                                SELECT 1 AS is_personal, 0 AS is_ip, tbl_private.status, country_code, network, mask
                                FROM wp_vcdf0tb4xs_spbc_firewall__personal_countries AS tbl_private
                                RIGHT JOIN wp_vcdf0tb4xs_spbc_firewall_data_v4 AS tbl_common USING(country_code)
                                WHERE network IN (2550136832,2552233984,2553282560,2553806848,2553937920,2554003456,2554007552,2554009600,2554010624,2554010880,2554011008,2554011040,2554011048,2554011050)
                                        AND network = 2554011050 & mask
                                        AND tbl_private.status IS NOT NULL
                                        AND 47679 <> 0
                        ) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/security-malware-firewall/security-malware-firewall.php'), spbc_firewall__check, CleantalkSP\Security\Firewall->run, CleantalkSP\SpbctWP\Firewall\FW->check, CleantalkSP\SpbctWP\Firewall\FW->ipv4GetResultsFromDb, CleantalkSP\SpbctWP\DB->fetchAll

It would be best to correct the issue with the plugin or disable it in order for it not to cause issues with the website.

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