Error in Debug Log caused by Spam Logins

Dear @bhadaway

I hope you’re doing great. I noticed that when I have stop spammers running and someone tries to login with a false username, the following error appears in my debug log:

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘WHERE active = 0 AND user_login = ‘backupandhere’ ORDER BY signup_id DESC LIM…’ at line 1 for query SELECT * FROM WHERE active = 0 AND user_login = ‘backupandhere’ ORDER BY signup_id DESC LIMIT 0, 1 made by require(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, ss_init, ss_check_white, be_load, ss_check_white->process, be_load, chkadminlog->process, wp_authenticate, apply_filters(‘authenticate’), WP_Hook->apply_filters, bp_core_signup_disable_inactive, BP_Signup::get

I did the following:

1) I verified that the error is thrown when a false user tries to login by trying to login myself with a false username -> the username matched the one in the debug file

2) I deactivated the Stop Spammers plugin and tried again to login with a false username -> no error was found in the debug log

3) I reactivated Stop Spammers and tried again, using “backupandhere” as my test username -> the error showed up in the debug log again as you can see above.

As such the error is directly related to your plugin if a spam user tries to login. So now I am having A LOT of these errors in my debug log… Would be great if you could look into solving the issue 🙂

Thanks a lot in advance!

Kind regards, Philip