• Any idea what’s causing this error on my database and how to fix it?

    [01-Feb-2016 01:44:19 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE active = 0 AND user_login = 'admin' ORDER BY signup_id DESC LIMIT 0, 1' at line 1 for query SELECT * FROM WHERE active = 0 AND user_login = 'admin' 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'), call_user_func_array, kpg_ss_init, kpg_ss_check_white, be_load, kpg_ss_check_white->process, be_load, chkadminlog->process, wp_authenticate, apply_filters('authenticate'), call_user_func_array, bp_core_signup_disable_inactive, BP_Signup::get

Viewing 1 replies (of 1 total)
  • The error is here:

    SELECT * FROM WHERE

    This should be (at a guess):

    SELECT * FROM wp_users WHERE

    As for what’s causing that… that’s a lot harder to diagnose. From the function names, I’d guess that it’s a plugin that has something to do with kpg_ss, so the starting point is to de-activate that plugin if you know it.

    If you don’t know which plugin is causing this, deactivate all (yes all) plugins and re-activate them one-by-one until you see which one is causing the issue.

    Just be aware that it could also be your theme, soyou can also try setting that to one of the default Twenty_* themes to see if that helps.

Viewing 1 replies (of 1 total)
  • The topic ‘MYSQL Database Error’ is closed to new replies.