Title: Error database Last modified: November 25, 2021 --- # Error database * Resolved [Jairo Ochoa](https://wordpress.org/support/users/jairoochoa/) * (@jairoochoa) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-database-13/) * Hi, * debug.log is getting bigger because of these warning. * > [25-Nov-2021 09:58:38 UTC] Error Table ‘dbzackwihiyakd.lmj_2_sgs_log_visitors’ > doesn’t exist de la base de datos de WordPress para la consulta SELECTipFROMlmj_2_sgs_log_visitors > > WHERE block = 1 AND user_id = 0 ; realizada por 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, SG_Security\Block_Service\ > Block_Service->block_user_by_ip * > [25-Nov-2021 09:57:26 UTC] Error Table ‘dbzackwihiyakd.lmj_2_sgs_log_visitors’ > doesn’t exist de la base de datos de WordPress para la consulta SELECT ip FROM > lmj_2_sgs_log_visitors > WHERE block = 1 AND user_id = 0 ; realizada por 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, SG_Security\Block_Service\Block_Service->block_user_by_ip * In this case it’s a WP multisite. * Thanks - This topic was modified 4 years, 6 months ago by [Jairo Ochoa](https://wordpress.org/support/users/jairoochoa/). - This topic was modified 4 years, 6 months ago by [Jairo Ochoa](https://wordpress.org/support/users/jairoochoa/). Viewing 12 replies - 1 through 12 (of 12 total) * Plugin Author [Stoyan Georgiev](https://wordpress.org/support/users/stoyangeorgiev/) * (@stoyangeorgiev) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-database-13/#post-15105623) * Hey there [@jairoochoa](https://wordpress.org/support/users/jairoochoa/), * Would it be possible to provide a site URL? * Kind regards, Stoyan * Thread Starter [Jairo Ochoa](https://wordpress.org/support/users/jairoochoa/) * (@jairoochoa) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-database-13/#post-15109381) * Hello [@stoyangeorgiev](https://wordpress.org/support/users/stoyangeorgiev/) * Yes, sure: ocionorte . com * Regards * Plugin Author [Ignat Georgiev](https://wordpress.org/support/users/ignatggeorgiev/) * (@ignatggeorgiev) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-database-13/#post-15113194) * Hey [@jairoochoa](https://wordpress.org/support/users/jairoochoa/), * The issue has been addressed, please check on your end to confirm as well * Kind Regards, Ignat Georgiev * Thread Starter [Jairo Ochoa](https://wordpress.org/support/users/jairoochoa/) * (@jairoochoa) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-database-13/#post-15115114) * Thanks * [marias79](https://wordpress.org/support/users/marias79/) * (@marias79) * [4 years, 4 months ago](https://wordpress.org/support/topic/error-database-13/#post-15281347) * Hi, I don’t know if I’m in the right place but I have the same problem with your plugin on my site. This is my php_errorlog: * [23-Jan-2022 12:09:35 UTC] WordPress database error Table ‘dbakgu3gxssuy0.zqq_2_sgs_log_visitors’ doesn’t exist for query SELECT `ip` FROM `zqq_2_sgs_log_visitors` WHERE `block` = 1 AND `user_id` = 0 ; made by 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, SG_Security\Block_Service\Block_Service->block_user_by_ip * It’a a WordPress Multisite on Keysbano.com * Can you help me solve it please? Best regards, Maria. * Plugin Support [Delyan Delov](https://wordpress.org/support/users/delyandelov/) * (@delyandelov) * [4 years, 4 months ago](https://wordpress.org/support/topic/error-database-13/#post-15281421) * Hello [@marias79](https://wordpress.org/support/users/marias79/), * The error basically means that the `zqq_2_sgs_log_visitors` database table is not yet created for your subsite. I can see that the site is currently under Maintenance mode which is preventing our plugin to detect any visitors and create the missing tables. * I would suggest temporarily disabling the Maintenance mode, then accessing your subsite via a different browser or Incognito tab and enabling the Maintenance mode again. This way the missing tables should be recreated. * If the issue still persists after that, please let us know. * Best Regards, Delyan Delov * [marias79](https://wordpress.org/support/users/marias79/) * (@marias79) * [4 years, 4 months ago](https://wordpress.org/support/topic/error-database-13/#post-15281490) * Hi [@delyandelov](https://wordpress.org/support/users/delyandelov/), thanks for your quick reply. I followed your instructions and checked the database but no folder is created on the subsite. Do you have any other suggestions? * Thanks, Maria. * Plugin Support [Delyan Delov](https://wordpress.org/support/users/delyandelov/) * (@delyandelov) * [4 years, 4 months ago](https://wordpress.org/support/topic/error-database-13/#post-15281830) * In that case, what you can do is deactivate the SG Security plugin through the Network Admin and then activated it directly through the dashboards of the main and the subsite. * Regards, Delyan Delov * [marias79](https://wordpress.org/support/users/marias79/) * (@marias79) * [4 years, 4 months ago](https://wordpress.org/support/topic/error-database-13/#post-15282904) * Hi [@delyandelov](https://wordpress.org/support/users/delyandelov/), problem fixed and folders created in the database. Thank you very much for your quick and invaluable assistance. * Best Regards, Maria * Thread Starter [Jairo Ochoa](https://wordpress.org/support/users/jairoochoa/) * (@jairoochoa) * [4 years, 4 months ago](https://wordpress.org/support/topic/error-database-13/#post-15286061) * Hi [@delyandelov](https://wordpress.org/support/users/delyandelov/) * I cannot understand why a site under Maintenance mode causes this issue. At least Admin users are login and also can exists attempts of login by bots or hackers. So, I think that this table should be created after plugin activation. * Besides we develop applications using WP as a framework and they are closed to public, and only registered user can access. Google sees that site is under Maintenance mode, even gets a 500, but users can work on it. * An also, long term developments (months working on a site) with debug mode on generates a debug.log tooo big. * So, from my point of view, the easiest is that plugin creates the tables just after plugin activation. * Regards * Plugin Support [Pavel Dosev](https://wordpress.org/support/users/pdosev/) * (@pdosev) * [4 years, 4 months ago](https://wordpress.org/support/topic/error-database-13/#post-15286778) * Hi [@jairoochoa](https://wordpress.org/support/users/jairoochoa/), * The plugin should create those tables for all subsites when it’s activated. We are aware that it currently doesn’t add them. We are already working on a fix that we will deploy with one of the following versions of the plugin that will address that. * In the meantime, you can follow the workaround we described in the previous reply to add those database tables for your subsites. * Thread Starter [Jairo Ochoa](https://wordpress.org/support/users/jairoochoa/) * (@jairoochoa) * [4 years, 4 months ago](https://wordpress.org/support/topic/error-database-13/#post-15288495) * Hi [@pdosev](https://wordpress.org/support/users/pdosev/) * Great to know that you’re working on an update of the plugin. It’s OK to do it as a temporary fix for this issue. I’d understand that it should be the “normal” procedure. Thanks Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘Error database’ is closed to new replies. * ![](https://ps.w.org/sg-security/assets/icon-256x256.gif?rev=2971855) * [Security Optimizer - The All-In-One Protection Plugin](https://wordpress.org/plugins/sg-security/) * [Support Threads](https://wordpress.org/support/plugin/sg-security/) * [Active Topics](https://wordpress.org/support/plugin/sg-security/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/sg-security/unresolved/) * [Reviews](https://wordpress.org/support/plugin/sg-security/reviews/) * 12 replies * 6 participants * Last reply from: [Jairo Ochoa](https://wordpress.org/support/users/jairoochoa/) * Last activity: [4 years, 4 months ago](https://wordpress.org/support/topic/error-database-13/#post-15288495) * Status: resolved