Many MySQL database errors from plugin in error_log file

  • Resolved pgraf1404

    (@pgraf1404)


    4 years, 3 months ago

    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

    (@katereji)

    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

    (@pgraf1404)

    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/’,
    http_user_agent = ‘Mozilla/5.0 (compatible; BLEXBot/1.0; +https://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/’,
    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

    (@amagsumov)

    Hello, @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.www.ads-software.com/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

    (@pgraf1404)

    Yes, going back to version 2.59.1 solved the problem. Thanks! Paul

    Plugin Support katereji

    (@katereji)

    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.