Error database

  • Resolved Jairo Ochoa

    (@jairoochoa)


    2 years, 5 months ago

    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 2 years, 5 months ago by Jairo Ochoa.
    • This topic was modified 2 years, 5 months ago by Jairo Ochoa.
Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Author Stoyan Georgiev

    (@stoyangeorgiev)

    2 years, 4 months ago

    Hey there @jairoochoa,

    Would it be possible to provide a site URL?

    Kind regards,
    Stoyan

    Thread Starter Jairo Ochoa

    (@jairoochoa)

    2 years, 4 months ago

    Hello @stoyangeorgiev

    Yes, sure: ocionorte . com

    Regards

    Plugin Author Ignat Georgiev

    (@ignatggeorgiev)

    2 years, 4 months ago

    Hey @jairoochoa,

    The issue has been addressed, please check on your end to confirm as well

    Kind Regards,
    Ignat Georgiev

    Thread Starter Jairo Ochoa

    (@jairoochoa)

    2 years, 4 months ago

    Thanks

    marias79

    (@marias79)

    2 years, 3 months ago

    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

    (@delyandelov)

    2 years, 3 months ago

    Hello @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

    (@marias79)

    2 years, 3 months ago

    Hi @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

    (@delyandelov)

    2 years, 3 months ago

    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

    (@marias79)

    2 years, 3 months ago

    Hi @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

    (@jairoochoa)

    2 years, 2 months ago

    Hi @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

    (@pdosev)

    2 years, 2 months ago

    Hi @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

    (@jairoochoa)

    2 years, 2 months ago

    Hi @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.