• Resolved bouncern

    (@bouncern)


    Hi,

    We noticed that php_errorlog was quickly growing in size (to > 2GB), and all the errors seemed to be related to this plugin – and as soon as we Network Disabled the Plugin the errors stopped.

    Below is a small extract (site, DB & IP info. removed) from the php_errorlog – every site on our WP Multisite was displaying a similar error.

    Many thanks,
    Nick

    ——————————————
    [16-Dec-2021 23:16:25 UTC] WordPress database error Table 'xxxxxxxx_wpnnn.wp_nn_sgs_log_visitors' doesn't exist for query SELECTipFROMwp_nn_sgs_log_visitors`
    WHERE block = 1
    AND user_id = 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, SG_Security\Block_Service\Block_Service->block_user_by_ip
    [16-Dec-2021 23:16:25 UTC] WordPress database error Table ‘xxxxxxxx_wpnnn.wp_nn_sgs_log_visitors’ doesn’t exist for query SELECT ID FROM wp_nn_sgs_log_visitors
    WHERE ip = ‘192.n.nnn.nn’
    AND user_id = 0
    ; made by SG_Security\Activity_Log\Activity_Log_Unknown->log_visit, SG_Security\Activity_Log\Activity_Log_Helper->get_visitor_by_ip
    [16-Dec-2021 23:16:25 UTC] WordPress database error Table ‘xxxxxxxx_wpnnn.wp_nn_sgs_log_visitors’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_nn_sgs_log_visitors made by SG_Security\Activity_Log\Activity_Log_Unknown->log_visit, SG_Security\Activity_Log\Activity_Log_Helper->get_visitor_by_ip
    [16-Dec-2021 23:16:25 UTC] WordPress database error Table ‘xxxxxxxx_wpnnn.wp_nn_sgs_log_events’ doesn’t exist for query SELECT id FROM wp_nn_sgs_log_events
    WHERE visitor_id = ”
    AND ts = ‘nnnnnnnnnn’
    AND activity = ‘/’
    AND description = ‘/’
    AND ip = ‘192.n.nnn.nn’
    AND hostname = ‘192.n.nnn.nn’
    AND code = ‘nnn’
    AND object_id = ‘0’
    AND type = ‘unknown’
    AND action = ‘visit’
    AND visitor_type = ‘Human’
    ; made by SG_Security\Activity_Log\Activity_Log_Unknown->log_visit, SG_Security\Activity_Log\Activity_Log_Helper->insert, SG_Security\Activity_Log\Activity_Log_Helper->check_for_duplicates
    [16-Dec-2021 23:16:25 UTC] WordPress database error Table ‘xxxxxxxx_wpnnn.wp_nn_sgs_log_events’ doesn’t exist for query SHOW FULL COLUMNS FROM wp_nn_sgs_log_events made by SG_Security\Activity_Log\Activity_Log_Unknown->log_visit, SG_Security\Activity_Log\Activity_Log_Helper->insert`

    ————————————–

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Stoyan Georgiev

    (@stoyangeorgiev)

    Hey there @bouncern,

    Thanks for the report! We will fix this issue in the upcoming versions of the plugin.

    Kind regards,
    Stoyan

    Thread Starter bouncern

    (@bouncern)

    Many thanks for your quick response Stoyan.

    Just let me know if you need any more data.

    Rgds,

    Nick

    Hi,

    It looks like the same issue was reported almost a month ago here, with it somehow being fixed (remotely probably).
    There have been no plugin updates for 3 months.
    Any chance to get this fixed soon?
    Thank you.
    P.S. Also a multisite environment.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘php_errorlog > 2GB due to SG Security Errors’ is closed to new replies.