Title: Many MySQL database errors from plugin in error_log file Last modified: December 9, 2020 --- # Many MySQL database errors from plugin in error_log file * Resolved [pgraf1404](https://wordpress.org/support/users/pgraf1404/) * (@pgraf1404) * [5 years, 5 months ago](https://wordpress.org/support/topic/many-mysql-database-errors-from-plugin-in-error_log-file/) * Attempted solutions: Deactivated then deleted plugin and all ‘spbc_****’ DB tables, reinstalled plugin. Errors are still being generated. I can send full error_log file with all posted errors if that would help. One of errors in log file: [ 08-Dec-2020 18:12:34 UTC] WordPress database error Table ‘paajdknv_prod.paa_spbc_firewall_data’ doesn’t exist for query ( SELECT 0 AS is_personal, 1 AS is_ip, status, country_code, network, mask FROM paa_spbc_firewall_data WHERE network IN (1140850688,1157627904,1166016512,1168113664,1168244736,1168261120,1168269312,1168273408,1168275456,1168276480,1168276608,1168276672,1168276704,1168276712,1168276713) AND network = 1168276713 & mask AND country_code = “0” ) UNION ( SELECT 1 AS is_personal, 1 AS is_ip, status, 0 AS country_code, network, mask FROM paa_spbc_firewall__personal_ips WHERE network IN (1140850688,1157627904,1166016512,1168113664,1168244736,1168261120,1168269312,1168273408,1168275456,1168276480,1168276608,1168276672,1168276704,1168276712,1168276713) AND network = 1168276713 & mask ) UNION ( SELECT 1 AS is_personal, 0 AS is_ip, tbl_private.status, country_code, network, mask FROM paa_spbc_firewall__personal_countries AS tbl_private RIGHT JOIN paa_spbc_firewall_data AS tbl_common USING(country_code) WHERE network IN (1140850688,1157627904,1166016512,1168113664,1168244736,1168261120,1168269312,1168273408,1168275456,1168276480,1168276608,1168276672,1168276704,1168276712,1168276713) AND network = 1168276713 & 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-> run, CleantalkSP\SpbctWP\Firewall\FW->check, CleantalkSP\SpbctWP\DB->fetch_all Viewing 5 replies - 1 through 5 (of 5 total) * Plugin Support [katereji](https://wordpress.org/support/users/katereji/) * (@katereji) * [5 years, 5 months ago](https://wordpress.org/support/topic/many-mysql-database-errors-from-plugin-in-error_log-file/#post-13762808) * Hello, * Please, deactivate the plugin with the “Complete deactivation” setting enabled and then activate it again. * 1. Entrer to the Security by Cleantalk plugin settings. (Wordrpess Dashboard - > Settings -> Security by Cleantalk -> General Settings) 2. Check 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.) 7. Press button “Get key automatically” * Did it help? * Thread Starter [pgraf1404](https://wordpress.org/support/users/pgraf1404/) * (@pgraf1404) * [5 years, 5 months ago](https://wordpress.org/support/topic/many-mysql-database-errors-from-plugin-in-error_log-file/#post-13766873) * No, that did not help. Numerous DB SQL syntax errors are occurring during the malware scan, WordPress database error You have an error in your SQL syntax to use near ‘), mask = IF(” = ”, NULL, - ), * country_code …’ at line 12 for query INSERT INTO paa_spbc_firewall_logs SET entry_id = ‘70310292320181e1395fc1455d8a8799’, ip_entry = ”, entry_timestamp = 1607532293, status = ‘PASS’, pattern = IF(” = ”, NULL, ”), requests = 1, page_url = ‘[https://paajaf.org/volunteering/’](https://paajaf.org/volunteering/’);, http_user_agent = ‘Mozilla/5.0 (compatible; BLEXBot/1.0; +http://webmeup-crawler. com/)’, request_method = ‘GET’, x_forwarded_for = IF(‘162.158.88.180’ = ”, NULL,‘ 162.158.88.180’), network = IF(” = ”, NULL, ), mask = IF(” = ”, NULL, ), country_code = IF(” = ”, NULL, ”), is_personal = ON DUPLICATE KEY UPDATE ip_entry = ip_entry, entry_timestamp = 1607532293, status = ‘PASS’, pattern = IF(” = ”, NULL, ”), requests = requests + 1, page_url = ‘[https://paajaf.org/volunteering/’](https://paajaf.org/volunteering/’);, http_user_agent = http_user_agent, request_method = ‘GET’, x_forwarded_for = IF(‘162.158.88.180’ = ”, NULL, ‘162.158.88.180’), network = IF(” = ”, NULL, ), mask = IF(” = ”, NULL, ), country_code = IF(” = ”, NULL, ”), is_personal = 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\Security\FireWall\FireWall->update_logs, CleantalkSP\SpbctWp\ FireWall\FireWall_database->fw_logs_insert_data * Plugin Support [amagsumov](https://wordpress.org/support/users/amagsumov/) * (@amagsumov) * [5 years, 5 months ago](https://wordpress.org/support/topic/many-mysql-database-errors-from-plugin-in-error_log-file/#post-13767163) * Hello, [@pgraf1404](https://wordpress.org/support/users/pgraf1404/) * Please, do the following: * 1. Go to the WordPress Administrator Panel —> Plugins. 2. Find the plugin “Security& Malware scan by CleanTalk” —> Deactivate. 3. After the automatic page refreshing find the plugin again “Security & Malware scan by CleanTalk” —> Delete. Confirm“ Yes, delete these files”. * If you don’t have an access to the admin panel, delete the plugin folder “security- malware-firewall”. * Perform these steps: * Log in to your Hosting Account. Locate the folder of your website. Delete the Security Plugin’s folder here: /wp-content/plugins/security-malware-firewall * Then install the 2.59.1 version using this guide: * 1. Download the plugin archive from here: [https://downloads.wordpress.org/plugin/security-malware-firewall.2.59.1.zip](https://downloads.wordpress.org/plugin/security-malware-firewall.2.59.1.zip) 2. Go to Plugins —> Add New —> Upload Plugin. 3. Choose the downloaded archive and press “Install Now”. * Did it help? * Thread Starter [pgraf1404](https://wordpress.org/support/users/pgraf1404/) * (@pgraf1404) * [5 years, 5 months ago](https://wordpress.org/support/topic/many-mysql-database-errors-from-plugin-in-error_log-file/#post-13773386) * Yes, going back to version 2.59.1 solved the problem. Thanks! Paul * Plugin Support [katereji](https://wordpress.org/support/users/katereji/) * (@katereji) * [5 years, 5 months ago](https://wordpress.org/support/topic/many-mysql-database-errors-from-plugin-in-error_log-file/#post-13774666) * Hello. Happy to know that. You are always welcome. Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘Many MySQL database errors from plugin in error_log file’ 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/) ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [error_log](https://wordpress.org/support/topic-tag/error_log/) * [sql](https://wordpress.org/support/topic-tag/sql/) * 5 replies * 3 participants * Last reply from: [katereji](https://wordpress.org/support/users/katereji/) * Last activity: [5 years, 5 months ago](https://wordpress.org/support/topic/many-mysql-database-errors-from-plugin-in-error_log-file/#post-13774666) * Status: resolved