WordPress database error You have an error in your SQL syntax;

  • Resolved Arunderan

    (@arunderan)


    6 years, 4 months ago

    Hi,

    I get some error messages in the apache log with my new wordpress page. Every time a spambot tries to register i get a php warning. I tried to nail it down. And this seems to be connected with wp cerber. The login page was changed from wp-login to bfa-login.

    An example error entry looks like this:

    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 = 'bennie16m05658' ORDER BY signup_id DESC LIMIT' at line 1 for query SELECT * FROM WHERE active = 0 AND user_login = 'bennie16m05658' ORDER BY signup_id DESC LIMIT 0, 1 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, {closure}, cerber_wp_login_page, require('wp-login.php'), wp_signon, wp_authenticate, apply_filters('authenticate'), WP_Hook->apply_filters, bp_core_signup_disable_inactive, BP_Signup::get, referer: https://bforartists.de/bfa-login/

    Does somebody have an idea how to fix this please? Any help is appreciated.

    Kind regards

    Arunderan

    The page I need help with: [log in to see the link]

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

    (@gioni)

    6 years, 4 months ago

    Hi! These SQL query and error have nothing to do with WP Cerber. Ask a BuddyPress community for help.

    Thread Starter Arunderan

    (@arunderan)

    6 years, 4 months ago

    Hm. It’s the exact names of the locked out users that tries to log in with non existing user names. And every attempt throws such an error. These users are not registered, but blocked by WP Cerber. That’s before they can even reach Buddypress.

    But i will have a look to post the problem in the Buddypress section too. Thanks for advice.

    Thread Starter Arunderan

    (@arunderan)

    6 years, 3 months ago

    Just to note, this is not resolved. The entries in question happens in the cerber_log table. It’s login attempts with wrong user names. Beforehand there is always a denied register request, blocked by wp cerber. This issue here is caused by wp cerber for sure. Not Buddypress.

    How do i turn off this log? It saves also IP adresses and allows to connect the IP with user names. Which is not allowed anymore by the gdpr.

    Kind regards

    Arunderan

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

The topic ‘WordPress database error You have an error in your SQL syntax;’ is closed to new replies.