• Can somebody assist me in understanding where this error is coming from?

    
    2020/08/05 04:11:02 [error] 1982#1982: *1777 FastCGI sent in stderr: "PHP message: 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 user_id = 57 AND blog_id = 1' at line 1 for query SELECT COUNT(id) FROM  WHERE user_id = 57 AND blog_id = 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('after_setup_theme'), WP_Hook->do_action, WP_Hook->apply_filters, user_register_display_name, wp_update_user, wp_insert_user, do_action('profile_update'), WP_Hook->do_action, WP_Hook->apply_filters, bp_blogs_add_user_to_blog, bp_blogs_record_blog, BP_Blogs_Blog->save, BP_Blogs_Blog->existsPHP message: 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 '( user_id, blog_id ) VALUES ( 57, 1 )' at line 1 for query INSERT INTO  ( user_id, blog_id ) VALUES ( 57, 1 ) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('after_setup_theme'), WP_Hook->do_action, WP_Hook->apply_filters, user_register_display_name, wp_update_user, wp_insert_user, do_action('profile_update'), WP_Hook->do_action, WP_Hook->apply_filters, bp_blogs_add_user_to_blog, bp_blogs_record_blog, BP_Blogs_Blog->savePHP message: 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 'SET value = 'Guice', last_updated = '2020-08-05 04:11:02' WHERE user_id = 57 AN' at line 1 for query UPDATE  SET value = 'Guice', last_updated = '2020-08-05 04:11:02' WHERE user_id = 57 AND field_id = 1 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('after_setup_theme'), WP_Hook->do_action, WP_Hook->apply_filters, user_register_display_name, wp_update_user, wp_insert_user, do_action('pr
    

    We’re getting this error with every ajax.php call, for logged in users (I’m an admin). I’m having a very, very hard time tracking this down. I don’t understand the WP stack trace.

    The ultimate reason is the table name is missing. I’m trying to track down this (these?) SQL query(ies) so I can identify _why_ the table name is missing.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter guice

    (@guice)

    Looks like I tracked it down, it’s due to BuddyBoss not initializing with user blogs. I found a way to get the table name into there, but the table bp_user_blogs does not exist. :/

    Still trying to figure out why A) it never initialized and B) why we don’t have a bp_user_blogs table.

    You would want to share the issue with BuddyBoss developer team, they can help you with this, I think.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Tracking down an obscure error’ is closed to new replies.