• Resolved Ubed Thaheem

    (@ubed-thaheem)


    I encounter WordPress database error Table in my website, when I checked logs there were many like that, for different tables. here is a snap of code from logs of my website.

    Please note that, the plugin is up-to-date and auto-update enabled.

    [20-Nov-2025 16:56:09 UTC] WordPress database error Table 'databaseName.wp_spbc_firewall__personal_countries' doesn't exist for query (
    SELECT 0 AS is_personal, 1 AS is_ip, status, country_code, network, mask
    FROM wp_spbc_firewall_data_v4
    WHERE network IN (587202560,591396864,592445440,592969728,593035264,593043456,593047552,593049600,593050112,593050176,593050184,593050188,593050190)
    AND network = 593050190 & mask
    AND country_code = "0"
    ) UNION (
    SELECT 1 AS is_personal, 1 AS is_ip, status, 0 AS country_code, network, mask
    FROM wp_spbc_firewall__personal_ips_v4
    WHERE network IN (587202560,591396864,592445440,592969728,593035264,593043456,593047552,593049600,593050112,593050176,593050184,593050188,593050190)
    AND network = 593050190 & mask
    ) UNION (
    SELECT 1 AS is_personal, 0 AS is_ip, tbl_private.status, country_code, network, mask
    FROM wp_spbc_firewall__personal_countries AS tbl_private
    RIGHT JOIN wp_spbc_firewall_data_v4 AS tbl_common USING(country_code)
    WHERE network IN (587202560,591396864,592445440,592969728,593035264,593043456,593047552,593049600,593050112,593050176,593050184,593050188,593050190)
    AND network = 593050190 & mask
    AND tbl_private.status IS NOT NULL
    AND 33343 <> 0
    ) made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, spbc_firewall__check, CleantalkSP\Security\Firewall->run, CleantalkSP\SpbctWP\Firewall\FW->check, CleantalkSP\SpbctWP\Firewall\FW->ipv4GetResultsFromDb, CleantalkSP\SpbctWP\DB->fetchAll
    wp_spbc_firewall__personal_countries
    wp_spbc_firewall_data_v4
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support sergecleantalk

    (@sergecleantalk)

    Hi,

    It appears that some Security plugin’s tables were not created. Please try deactivating the plugin with the “Complete deactivation” option enabled and then activating it. This will clear all current settings and will recreate tables.

    1. Enter the Security by Cleantalk plugin settings. (WordPress Dashboard -> Settings -> Security by Cleantalk -> General Settings tab)
    2. Check the “Complete deactivation” option at the end of the page 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?

    Thread Starter Ubed Thaheem

    (@ubed-thaheem)

    Not yet,

    Deactivated completely as you guided & re-activated it.. Since then, I found 4 logs with same Error & two tables.

    spbc_firewall_data_v4
    spbc_firewall_data_v4_temp
    Plugin Support katereji

    (@katereji)

    Hello @ubed-thaheem

    Could you please reach out to our support team via our private ticket system so we can gather some more information from you concerning this issue?
    Please, paste the link to this topic, so we can identify you quickly.

    Plugin Support eugenecleantalk

    (@eugenecleantalk)

    We have received ticket #51711 from you. Let’s continue our conversation there for now.

    Plugin Support sergecleantalk

    (@sergecleantalk)

    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.

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

The topic ‘CleanTalk Error in code’ is closed to new replies.