Title: website database error
Last modified: June 18, 2024

---

# website database error

 *  Resolved [faheemkhilji](https://wordpress.org/support/users/faheemkhilji/)
 * (@faheemkhilji)
 * [1 year, 11 months ago](https://wordpress.org/support/topic/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.
 *     ```wp-block-code
       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->fetchAllIt 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fwebsite-database-error%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Support [sergecleantalk](https://wordpress.org/support/users/sergecleantalk/)
 * (@sergecleantalk)
 * [1 year, 11 months ago](https://wordpress.org/support/topic/website-database-error/#post-17832444)
 * Hello,
 * Please, deactivate the plugin with the “Complete deactivation” option enabled
   and then activate it again.
    1. Enter the Security by Cleantalk plugin settings. (WordPress Dashboard -> Settings-
       > Security by Cleantalk -> General settings tab)
    2. Check the last settings “Complete deactivation” and save changes.
    3. Deactivate the plugin on the “Plugins” page in WordPress Dashboard.
    4. Then activate it.
    5. Proceed to the plugin’s settings. (See item 1.)
 * Did it help?
 *  Plugin Support [sergecleantalk](https://wordpress.org/support/users/sergecleantalk/)
 * (@sergecleantalk)
 * [1 year, 11 months ago](https://wordpress.org/support/topic/website-database-error/#post-17844096)
 * Hello.
   We haven’t heard back from you in a few days, so I’m going to mark this
   topic as “resolved”.If you have any further questions, you can start a new topic
   or contact us via our private Ticket System: [https://cleantalk.org/my/support/open](https://cleantalk.org/my/support/open).

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘website database error’ is closed to new replies.

 * ![](https://ps.w.org/security-malware-firewall/assets/icon-256x256.gif?rev=3518712)
 * [Security Plugin, Firewall & Malware Scanner with Auto Removal](https://wordpress.org/plugins/security-malware-firewall/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/security-malware-firewall/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/security-malware-firewall/)
 * [Active Topics](https://wordpress.org/support/plugin/security-malware-firewall/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/security-malware-firewall/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/security-malware-firewall/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [sergecleantalk](https://wordpress.org/support/users/sergecleantalk/)
 * Last activity: [1 year, 11 months ago](https://wordpress.org/support/topic/website-database-error/#post-17844096)
 * Status: resolved