• Resolved dlmerriam

    (@dlmerriam)


    I was looking through my error.log for something else and saw this error. Any idea what it means? Sucuri shows my site as clean, but of course that doesn’t prove anything, just that it’s not something obvious.

    WordPress database error Column ‘role’ cannot be null for query INSERT INTO lp4_bpspro_login_security (status, user_id, username, public_name, email, role, human_time, login_time, lockout_time, failed_logins, ip_address, hostname, request_uri) VALUES (‘Not Locked’, 19, ‘graciela8856’, ‘graciela8856’, ‘[email protected]’, NULL, ‘2016-09-14 17:56:17’, ‘1473893777’, ‘1473897377’, ‘1’, ‘107.150.80.149’, ‘107.150.80.149.dynamic.nationinternet.net’, ‘/wp-login.php’) made by wp_signon, wp_authenticate, apply_filters(‘authenticate’), call_user_func_array, bpspro_wp_authenticate_username_password

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author AITpro

    (@aitpro)

    How old is this error? ie what is the date/timestamp? Are you seeing other errors of this same type? If this is just a one-time error then this is nothing to worry about and is not really worth trying to figure out. If these errors are occurring for every single login/failed login attempt then I have some ideas for why that is happening. So first let me know if this is just a “one-time” error and all other login handling/processing is ok.

    Thread Starter dlmerriam

    (@dlmerriam)

    It’s come up twice more today:
    [15-Sep-2016 18:00:59 UTC] WordPress database error Column ‘role’ cannot be null for query INSERT INTO lp4_bpspro_login_security (status, user_id, username, public_name, email, role, human_time, login_time, lockout_time, failed_logins, ip_address, hostname, request_uri) VALUES (‘Not Locked’, 19, ‘graciela8856’, ‘graciela8856’, ‘[email protected]’, NULL, ‘2016-09-15 13:00:59’, ‘1473962459’, ‘1473966059’, ‘1’, ‘104.160.225.195’, ‘104.160.225.195’, ‘/wp-login.php’) made by wp_signon, wp_authenticate, apply_filters(‘authenticate’), call_user_func_array, bpspro_wp_authenticate_username_password

    and

    [15-Sep-2016 18:52:14 UTC] WordPress database error Column ‘role’ cannot be null for query INSERT INTO lp4_bpspro_login_security (status, user_id, username, public_name, email, role, human_time, login_time, lockout_time, failed_logins, ip_address, hostname, request_uri) VALUES (‘Not Locked’, 19, ‘graciela8856’, ‘graciela8856’, ‘[email protected]’, NULL, ‘2016-09-15 13:52:14’, ‘1473965534’, ‘1473969134’, ‘1’, ‘104.160.228.38’, ‘104.160.228.38’, ‘/wp-login.php’) made by wp_signon, wp_authenticate, apply_filters(‘authenticate’), call_user_func_array, bpspro_wp_authenticate_username_password

    I just noticed it for the first time yesterday. I’m keeping a closer eye on the error log file right now because of problems with updating a theme that I had on a couple hundred demo sites that was throwing errors on all of them.

    But I’ve gotten two emails in the last two days sent (ostensibly) from my domain telling me to click to add “users” in emails that weren’t from anything I have installed. Needless to say, I didn’t click, but it made this error from BPS jump out at me.

    I’ll continue to keep an eye on it.

    Plugin Author AITpro

    (@aitpro)

    Ok so the errors are for the same user account. Is this a legitimate user account: graciela8856 on your website? When I google the users email address + spam this is a known spammer email address. Ironically spammers use spamavert to hide their real email addresses or just in general for spamming. This link: https://cleantalk.org/blacklists/[email protected] was one of the google search results that were returned. So however this spammer is trying to authenticate to your site is triggering the error. If you are not seeing this error for any other legitimate user logins then you can just ignore the error.

    Plugin Author AITpro

    (@aitpro)

    Oh left out one important detail, which is that 99% of all spamming and hacking is automated with bots. So probably when the spambot tries to auto-register or auto-login to your site then I assume the spambot script is fubar, which is then generating the error. πŸ˜‰

    Thread Starter dlmerriam

    (@dlmerriam)

    No, this address is not anywhere legitimately in my site and there’s nothing automated about registering. I have to approve them πŸ™‚

    So the script she (he, whatever) is external then, not a problem with my site or the plugin.

    Great and thanks.

    Plugin Author AITpro

    (@aitpro)

    Yep, this is an automated spambot login attack so nothing to worry about.

    Plugin Author AITpro

    (@aitpro)

    …since the spammers script is fubar and is probably either being blocked or just broken so it cannot hurt your site in any way.

    • This reply was modified 9 years, 8 months ago by AITpro.
    Plugin Author AITpro

    (@aitpro)

    Assuming all questions have been answered – the thread has been resolved. If the issue/problem is not resolved or you have additional questions about this specific thread topic then you can post them at any time. We still receive email notifications when threads have been resolved.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘WordPress database error Column ‘role’ cannot be null …’ is closed to new replies.