Database table doesn’t exist | WordPress.org

[ad_1]

Howdy, we have a customer whose site is filling up the error log fast – 30GB and counting. All the errors are the same and it’s being written to non-stop.

It appears a database table doesn’t exist for this plugin – what is the best way to create this, or have the plugin create it? Example error is below – have replaced the actual database name with “database-name”:

[27-Mar-2023 16:44:45 UTC] WordPress database error Table 'database-name.edh_icwp_wpsf_ip_rules' doesn't exist for query SELECT ips.ip as ip, ir.id, ir.ip_ref, ir.cidr, ir.is_range, ir.offenses, ir.type, ir.label, ir.last_access_at, ir.blocked_at, ir.unblocked_at, ir.last_unblock_attempt_at, ir.expires_at, ir.updated_at, ir.created_at, ir.deleted_at
                                        FROM edh_icwp_wpsf_ip_rules as ir
                                        INNER JOIN edh_icwp_wpsf_ips as ips
                                                ON ir.ip_ref = ips.id
                                        WHERE (ips.ip=INET6_ATON('15.235.23.65') AND ir.is_range='0') OR (ir.is_range='1')
                                        ORDER BY ir.created_at DESC

                                        ; made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, icwp_wpsf_init, require_once('/plugins/wp-simple-firewall/init.php'), ICWP_WPSF_Shield_Security->start, FernleafSystems\Wordpress\Plugin\Shield\Controller\Controller->boot, FernleafSystems\Wordpress\Plugin\Shield\Rules\RulesController->processRules, FernleafSystems\Wordpress\Plugin\Shield\Rules\RulesController->processRule, FernleafSystems\Wordpress\Plugin\Shield\Rules\Processors\ConditionsProcessor->runAllRuleConditions, FernleafSystems\Wordpress\Plugin\Shield\Rules\Processors\ConditionsProcessor->processConditionGroup, FernleafSystems\Wordpress\Plugin\Shield\Rules\Conditions\Base->run, FernleafSystems\Wordpress\Plugin\Shield\Rules\Conditions\IsIpWhitelisted->execConditionCheck, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\IpRules\IpRuleStatus->isBypass, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\IpRules\IpRuleStatus->getRulesForBypass, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\IpRules\IpRuleStatus->getRules, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\Lib\IpRules\IpRuleStatus->loadRecordsForIP, FernleafSystems\Wordpress\Plugin\Shield\Modules\IPs\DB\IpRules\LoadIpRules->select, FernleafSystems\Wordpress\Plugin\Shield\Modules\Data\DB\Common\BaseLoadRecordsForIPJoins->selectRaw, FernleafSystems\Wordpress\Services\Core\Db->selectCustom

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer