1. Home
2. Limit Login Attempts (Spam Protection)
3. 2.3

WP limit failed login attempts 2.3

Does WP limit failed login attempts work with WordPress 5.5.3 and PHP 7.4.8? A smoke test was performed on 2020-11-07 15:57:28 UTC.

Summary

Pages 7

Plugins ‹ Test site — WordPress

CP Plugins

Login Attempts

Login Attempts → Attempts log

Login Attempts → Lockout Log

Test site – Just another WordPress site

Dashboard ‹ Test site — WordPress

Benchmark

URL	Load time			Memory usage
	Inactive	Active	Change	Inactive	Active	Change
/wp-admin/index.php	0.602 s	0.472 s	-0.130 s	2.75 MiB	2.88 MiB	+ 130.09 KiB
/wp-admin/edit.php	0.240 s	0.270 s	+0.030 s	2.8 MiB	2.89 MiB	+ 99.87 KiB
/wp-admin/post-new.php	1.639 s	1.927 s	+0.288 s	4.54 MiB	4.68 MiB	+ 143.41 KiB
/wp-admin/upload.php	0.774 s	0.444 s	-0.330 s	2.63 MiB	2.77 MiB	+ 139.04 KiB
/wp-admin/options-writing.php	0.181 s	0.154 s	-0.027 s	2.64 MiB	2.69 MiB	+ 50.67 KiB
/wp-admin/media-new.php	0.217 s	0.185 s	-0.032 s	2.6 MiB	2.69 MiB	+ 82.93 KiB
/wp-admin/edit-tags.php?taxonomy=category	0.190 s	0.193 s	+0.003 s	2.64 MiB	2.8 MiB	+ 163.84 KiB
/wp-admin/post-new.php?post_type=page	1.611 s	1.465 s	-0.146 s	4.53 MiB	4.67 MiB	+ 139 KiB
/wp-admin/options-discussion.php	0.375 s	0.261 s	-0.114 s	2.61 MiB	2.71 MiB	+ 99.49 KiB
/wp-admin/edit-comments.php	0.227 s	0.221 s	-0.006 s	2.65 MiB	2.81 MiB	+ 162.78 KiB
/	0.312 s	0.212 s	-0.100 s	2.56 MiB	2.64 MiB	+ 85.34 KiB
Average	0.579 s	0.528 s	-0.051 s	3 MiB	3.11 MiB	+ 117.86 KiB

Additions

Things that the plugin adds to the site. This section is not intended to be comprehensive. The test tool only looks for a few specific types of added content.

Options wp_options 1

• wp_limit_failed-login_attempts_notification_bar_active_time

Meta Boxes

{
    "dashboard": {
        "Top_IPs_Blocked": {
            "title": "Top 10 Blocked IPs",
            "context": "normal"
        },
        "Top_Failed_Logins": {
            "title": "Top 10 Failed Logins",
            "context": "normal"
        },
        "Top_Countries_Blocked": {
            "title": "Top 10 Blocked Countries",
            "context": "normal"
        },
        "Recently_Blocked_Attacks": {
            "title": "Recently Blocked Attacks",
            "context": "normal"
        }
    }
}

PHP Error Log 25 lines

[07-Nov-2020 15:57:43 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT ip , country, country_code, count(*) as count FROM wp_WPLFLA_log_block_ip GROUP BY ip ORDER BY 4 DESC limit 10; made by wp_dashboard, do_meta_boxes, dashboard_widget->Top_IPs_Blocked
[07-Nov-2020 15:57:43 UTC] WordPress database error Table 'wordpress.wp_wplfla_login_failed' doesn't exist for query SELECT ip , username, country, country_code, count(*) as count FROM wp_WPLFLA_login_failed GROUP BY username ORDER BY 5 DESC limit 10; made by wp_dashboard, do_meta_boxes, dashboard_widget->Top_Failed_Logins
[07-Nov-2020 15:57:43 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT country, country_code, count(*) as count FROM wp_WPLFLA_log_block_ip GROUP BY country, country_code ORDER BY 3 DESC limit 10; made by wp_dashboard, do_meta_boxes, dashboard_widget->Top_Countries_Blocked
[07-Nov-2020 15:57:43 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT ip , country,username, country_code ,date FROM wp_WPLFLA_log_block_ip  ORDER BY id DESC limit 10  made by wp_dashboard, do_meta_boxes, dashboard_widget->Recently_Blocked_Attacks
[07-Nov-2020 15:57:45 UTC] PHP Notice:  Trying to access array offset on value of type bool in /wp-content/plugins/wp-limit-failed-login-attempts/admin/setting.php on line 99
[07-Nov-2020 15:57:45 UTC] PHP Notice:  Trying to access array offset on value of type bool in /wp-content/plugins/wp-limit-failed-login-attempts/admin/setting.php on line 110
[07-Nov-2020 15:57:45 UTC] PHP Notice:  Trying to access array offset on value of type bool in /wp-content/plugins/wp-limit-failed-login-attempts/admin/setting.php on line 99
[07-Nov-2020 15:57:46 UTC] WordPress database error Table 'wordpress.wp_wplfla_login_failed' doesn't exist for query SELECT count(*) FROM wp_WPLFLA_login_failed  made by do_action('wp_ajax_WPLFLA_get_log_data'), WP_Hook->do_action, WP_Hook->apply_filters, WPLFLA_Attempts_Log->my_ajax_get_log_data
[07-Nov-2020 15:57:46 UTC] WordPress database error Table 'wordpress.wp_wplfla_login_failed' doesn't exist for query SELECT count(*)as allcount FROM wp_WPLFLA_login_failed WHERE 1   made by do_action('wp_ajax_WPLFLA_get_log_data'), WP_Hook->do_action, WP_Hook->apply_filters, WPLFLA_Attempts_Log->my_ajax_get_log_data
[07-Nov-2020 15:57:46 UTC] WordPress database error Table 'wordpress.wp_wplfla_login_failed' doesn't exist for query SELECT * FROM wp_WPLFLA_login_failed  WHERE 1   order by date desc limit 0,20 made by do_action('wp_ajax_WPLFLA_get_log_data'), WP_Hook->do_action, WP_Hook->apply_filters, WPLFLA_Attempts_Log->my_ajax_get_log_data
[07-Nov-2020 15:57:46 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT count(*) FROM wp_WPLFLA_log_block_ip  made by do_action('wp_ajax_WPLFLA_get_log_block_ip_data'), WP_Hook->do_action, WP_Hook->apply_filters, WPLFLA_log_block_ip->my_ajax_get_log_data
[07-Nov-2020 15:57:46 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT count(*)as allcount FROM wp_WPLFLA_log_block_ip WHERE 1   made by do_action('wp_ajax_WPLFLA_get_log_block_ip_data'), WP_Hook->do_action, WP_Hook->apply_filters, WPLFLA_log_block_ip->my_ajax_get_log_data
[07-Nov-2020 15:57:46 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT * FROM wp_WPLFLA_log_block_ip  WHERE 1   order by date desc limit 0,20 made by do_action('wp_ajax_WPLFLA_get_log_block_ip_data'), WP_Hook->do_action, WP_Hook->apply_filters, WPLFLA_log_block_ip->my_ajax_get_log_data
[07-Nov-2020 15:57:47 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT ip , country, country_code, count(*) as count FROM wp_WPLFLA_log_block_ip GROUP BY ip ORDER BY 4 DESC limit 10; made by wp_dashboard, do_meta_boxes, dashboard_widget->Top_IPs_Blocked
[07-Nov-2020 15:57:47 UTC] WordPress database error Table 'wordpress.wp_wplfla_login_failed' doesn't exist for query SELECT ip , username, country, country_code, count(*) as count FROM wp_WPLFLA_login_failed GROUP BY username ORDER BY 5 DESC limit 10; made by wp_dashboard, do_meta_boxes, dashboard_widget->Top_Failed_Logins
[07-Nov-2020 15:57:47 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT country, country_code, count(*) as count FROM wp_WPLFLA_log_block_ip GROUP BY country, country_code ORDER BY 3 DESC limit 10; made by wp_dashboard, do_meta_boxes, dashboard_widget->Top_Countries_Blocked
[07-Nov-2020 15:57:47 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT ip , country,username, country_code ,date FROM wp_WPLFLA_log_block_ip  ORDER BY id DESC limit 10  made by wp_dashboard, do_meta_boxes, dashboard_widget->Recently_Blocked_Attacks
[07-Nov-2020 15:57:54 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT ip , country, country_code, count(*) as count FROM wp_WPLFLA_log_block_ip GROUP BY ip ORDER BY 4 DESC limit 10; made by wp_dashboard, do_meta_boxes, dashboard_widget->Top_IPs_Blocked
[07-Nov-2020 15:57:54 UTC] WordPress database error Table 'wordpress.wp_wplfla_login_failed' doesn't exist for query SELECT ip , username, country, country_code, count(*) as count FROM wp_WPLFLA_login_failed GROUP BY username ORDER BY 5 DESC limit 10; made by wp_dashboard, do_meta_boxes, dashboard_widget->Top_Failed_Logins
[07-Nov-2020 15:57:54 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT country, country_code, count(*) as count FROM wp_WPLFLA_log_block_ip GROUP BY country, country_code ORDER BY 3 DESC limit 10; made by wp_dashboard, do_meta_boxes, dashboard_widget->Top_Countries_Blocked
[07-Nov-2020 15:57:54 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT ip , country,username, country_code ,date FROM wp_WPLFLA_log_block_ip  ORDER BY id DESC limit 10  made by wp_dashboard, do_meta_boxes, dashboard_widget->Recently_Blocked_Attacks
[07-Nov-2020 15:57:54 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT ip , country, country_code, count(*) as count FROM wp_WPLFLA_log_block_ip GROUP BY ip ORDER BY 4 DESC limit 10; made by wp_dashboard, do_meta_boxes, dashboard_widget->Top_IPs_Blocked
[07-Nov-2020 15:57:54 UTC] WordPress database error Table 'wordpress.wp_wplfla_login_failed' doesn't exist for query SELECT ip , username, country, country_code, count(*) as count FROM wp_WPLFLA_login_failed GROUP BY username ORDER BY 5 DESC limit 10; made by wp_dashboard, do_meta_boxes, dashboard_widget->Top_Failed_Logins
[07-Nov-2020 15:57:54 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT country, country_code, count(*) as count FROM wp_WPLFLA_log_block_ip GROUP BY country, country_code ORDER BY 3 DESC limit 10; made by wp_dashboard, do_meta_boxes, dashboard_widget->Top_Countries_Blocked
[07-Nov-2020 15:57:54 UTC] WordPress database error Table 'wordpress.wp_wplfla_log_block_ip' doesn't exist for query SELECT ip , country,username, country_code ,date FROM wp_WPLFLA_log_block_ip  ORDER BY id DESC limit 10  made by wp_dashboard, do_meta_boxes, dashboard_widget->Recently_Blocked_Attacks

---