Skip to:
Content
Pages
Categories
Search
Top
Bottom

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


  • Arunderan
    Participant

    @arunderan

    Hi,

    I’m having a few dozen database error entries in the apache log every day. First i thought the WP Cerber plugin could be the trouble maker. Since this entries are all connected with failed login attempts with wrong user names. Most probably Spambots. But the WP Cerber developer told me that this is a Buddypress issue. See this issue: https://wordpress.org/support/topic/wordpress-database-error-you-have-an-error-in-your-sql-syntax-5/#post-12366843

    So i kindly ask for support here.

    Such a log looks usually like this. A few attempts from always the same non existing user name before it gets locked by WP Cerber:

    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 = ‘AveryZem’ ORDER BY signup_id DESC LIMIT 0, 1′ at line 1 for query SELECT * FROM WHERE active = 0 AND user_login = ‘AveryZem’ 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/

    The page is unfortunately already productive. So i cannot turn off addons wildly anymore.

    Could you please help me to get rid of this errors please? ????

    Kind regards

    Arunderan

  • You must be logged in to reply to this topic.
Skip to toolbar